/// <summary> /// Thiết lập thông tin cho Entity FrameWorks /// </summary> /// <returns></returns> public TrainingCenterEntities getTrainingCenterInfo() { string providerName = "System.Data.SqlClient"; ConnectionEntity objEntity = getConnEntityInfo(); 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://*/CMSModels.csdl|res://*/CMSModels.ssdl|res://*/CMSModels.msl"; EntityConnection objConnection = new EntityConnection(objEcsb.ToString()); TrainingCenterEntities objTraining = new TrainingCenterEntities(objEcsb.ToString()); return(objTraining); }
public ConnectionEntity getConnEntityInfo() { if (mAccount.isOnline == false) { 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(); if (mAccount.sLocation.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); } }
public ConnectionEntity getConnEntityWebIMICInfo() { ConnectionEntity obj = new ConnectionEntity(); obj.serverName = DecryptInfo("" + ConfigurationManager.AppSettings["WebIMIC_Server"]); obj.databaseName = DecryptInfo("" + ConfigurationManager.AppSettings["WebIMIC_DBName"]); obj.userName = DecryptInfo("" + ConfigurationManager.AppSettings["WebIMIC_UserName"]); obj.password = DecryptInfo("" + ConfigurationManager.AppSettings["WebIMIC_PassWord"]); return(obj); }
public ConnectionEntity getConnEntityOnlineInfo() { 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); }