private DatabaseHandler()
{
DBServer = Props["db_server"].DefaultValue.ToString();
DBTest = Props["db_test"].DefaultValue.ToString();
DBLogin = Props["db_login"].DefaultValue.ToString();
DBPW = Props["db_pw"].DefaultValue.ToString();
CPDB = new CheckPlusDB();
CPDBConn = "" +
"Data Source=" + DBServer + ";" +
"Initial Catalog=" + DBTest + ";" +
"User Id=" + DBLogin + ";" +
"Password="******";" +
"MultipleActiveResultSets=True"
;
//CPDBConn = "Data Source=.; Initial Catalog=CheckPlus; Integrated Security=True; MultipleActiveResultSets=True";
CPDB.Database.Connection.ConnectionString = CPDBConn;
AccSQL = new AccountSQLer(CPDB);
Acct_chkSQL = new Acct_checkSQLer(CPDB);
BankSQL = new BankSQLer(CPDB);
UserSQL = new UserSQLer(CPDB);
ClientSQL = new ClientSQLer(CPDB);
}
public ClientSQLer(CheckPlusDB in_cpdb)
{
cpdb = in_cpdb;
}
public UserSQLer(CheckPlusDB in_cpdb)
{
cpdb = in_cpdb;
}
public BankSQLer(CheckPlusDB in_cpdb)
{
cpdb = in_cpdb;
}
public Acct_checkSQLer(CheckPlusDB in_cpdb)
{
cpdb = in_cpdb;
}
public AccountSQLer(CheckPlusDB in_cpdb)
{
cpdb = in_cpdb;
}