using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections;

namespace LYB.CS
{
    /// <summary>
    /// Summary description for Utilities
    /// </summary>
    public static class Utilities
    {
        public static bool Authenticate(string userID, string password)
        {
            return false;
        }
    public static string GetConnectionString(string environment)
    {
            // Get the database ConnectionStrings collection in web.config.
            string connString = "";               // database connection string from web.config
            ConnectionStringSettingsCollection connections =
                ConfigurationManager.ConnectionStrings;
            // Determine which connection string to use - production, production test, system test or development database
            IEnumerator conEnum =
                connections.GetEnumerator();
            int i = 0;
            while (conEnum.MoveNext())
            {
                string name = connections[i].Name.ToLower();
                string connectionString = connections[name].ConnectionString;
                string provider = connections[name].ProviderName;
                switch (environment)
                {
                    case "P":       // production
                        if (name.Contains("s10520554connectionstring"))
                            connString = connectionString;
                        break;
                    case "D":       // development
                        if (name.Contains("mylocalsqlserver"))
                            connString = connectionString;
                        break;
                }
                i++;
            }
            return connString;
        }
    }
}