public WEBIMICDBEntities getWebIMICInfo()
{
string providerName = "System.Data.SqlClient";
ConnectionEntity objEntity = getConnEntityWebIMICInfo();
SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder();
sqlBuilder.DataSource = objEntity.serverName;
sqlBuilder.InitialCatalog = objEntity.databaseName;
sqlBuilder.UserID = objEntity.userName;
sqlBuilder.Password = objEntity.password;
sqlBuilder.MultipleActiveResultSets = true;
string providerString = sqlBuilder.ToString();
EntityConnectionStringBuilder objEcsb = new EntityConnectionStringBuilder();
objEcsb.Provider = providerName;
objEcsb.ProviderConnectionString = providerString;
//objEcsb.Metadata = @"res://*/eCenterTrainning.csdl|res://*/eCenterTrainningOffline.ssdl|res://*/eCenterTrainningOffline.msl";
objEcsb.Metadata = @"res://*/WebIMICModel.csdl|res://*/WebIMICModel.ssdl|res://*/WebIMICModel.msl";
EntityConnection objConnection = new EntityConnection(objEcsb.ToString());
//TrainingCenterOfflineEntities objTraining = new TrainingCenterOfflineEntities(objConnection.ToString());
WEBIMICDBEntities objTraining = new WEBIMICDBEntities(objEcsb.ToString());
return(objTraining);
}
public ConnectionEntity getConnEntityWebIMICInfo()
{
ConnectionEntity obj = new ConnectionEntity();
obj.serverName = DecryptInfo("" + ConfigurationManager.AppSettings["WebServer"]);
obj.databaseName = DecryptInfo("" + ConfigurationManager.AppSettings["WebDatabase"]);
obj.userName = DecryptInfo("" + ConfigurationManager.AppSettings["WebUser"]);
obj.password = DecryptInfo("" + ConfigurationManager.AppSettings["WebPass"]);
return(obj);
}
/// <summary>
/// Lấy thông tin tài khoản DB và giải mã thông tin
/// </summary>
/// <returns></returns>
//public ConnectionEntity getConnEntityInfo()
//{
// ConnectionEntity obj = new ConnectionEntity();
// obj.serverName = DecryptInfo("" + ConfigurationManager.AppSettings["iMICServer"]);
// obj.databaseName = DecryptInfo("" + ConfigurationManager.AppSettings["iMICDatabase"]);
// obj.userName = DecryptInfo("" + ConfigurationManager.AppSettings["iMICUser"]);
// obj.password = DecryptInfo("" + ConfigurationManager.AppSettings["iMICPass"]);
// return obj;
//}
//public ConnectionEntity getConnEntityInfo()
//{
// if (ConnectServer.Type == true)
// {
// ConnectionEntity obj = new ConnectionEntity();
// obj.serverName = DecryptInfo("" + ConfigurationManager.AppSettings["iMICServerOffline"]);
// obj.databaseName = DecryptInfo("" + ConfigurationManager.AppSettings["iMICDatabaseOffline"]);
// obj.userName = DecryptInfo("" + ConfigurationManager.AppSettings["iMICUserOffline"]);
// obj.password = DecryptInfo("" + ConfigurationManager.AppSettings["iMICPassOffline"]);
// return obj;
// }
// else
// {
// ConnectionEntity obj = new ConnectionEntity();
// obj.serverName = DecryptInfo("" + ConfigurationManager.AppSettings["iMICServer"]);
// obj.databaseName = DecryptInfo("" + ConfigurationManager.AppSettings["iMICDatabase"]);
// obj.userName = DecryptInfo("" + ConfigurationManager.AppSettings["iMICUser"]);
// obj.password = DecryptInfo("" + ConfigurationManager.AppSettings["iMICPass"]);
// return obj;
// }
//}
public ConnectionEntity getConnEntityOfflineInfo()
{
ConnectionEntity obj = new ConnectionEntity();
obj.serverName = DecryptInfo("" + ConfigurationManager.AppSettings["iMICServerOffline"]);
obj.databaseName = DecryptInfo("" + ConfigurationManager.AppSettings["iMICDatabaseOffline"]);
obj.userName = DecryptInfo("" + ConfigurationManager.AppSettings["iMICUserOffline"]);
obj.password = DecryptInfo("" + ConfigurationManager.AppSettings["iMICPassOffline"]);
return(obj);
}
public ConnectionEntity getConnEntityOnlineInfo()
{
ConnectionEntity obj = new ConnectionEntity();
if (mConfigs.IMICLocation.Equals("HaNoi"))
{
obj.serverName = DecryptInfo("" + ConfigurationManager.AppSettings["IMICHN"]);
}
else
{
obj.serverName = DecryptInfo("" + ConfigurationManager.AppSettings["IMICHCM"]);
}
obj.databaseName = DecryptInfo("" + ConfigurationManager.AppSettings["IMICDatabaseName"]);
obj.userName = DecryptInfo("" + ConfigurationManager.AppSettings["IMICUserName"]);
obj.password = DecryptInfo("" + ConfigurationManager.AppSettings["IMICPassWord"]);
return(obj);
}
