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 WEBIMICDBEntities getWebImic() { Common objCommon = new Common(); WEBIMICDBEntities objTraining = objCommon.getWebIMICInfo(); return(objTraining); }
public List <StudentObject> GetListFromWebIMIC() { List <StudentObject> listStudentFromWeb = new List <StudentObject>(); ConnectionEntities objConEn = new ConnectionEntities(); WEBIMICDBEntities objStudenWeb = objConEn.getWebImic(); var listTempOffline = objStudenWeb.WEB_IMIC_SP_RegisterDetail_GetForEtraining(); foreach (var item in listTempOffline) { string[] Chuoi_Tach = item.FullName.Split(' '); string FirstName = Chuoi_Tach[Chuoi_Tach.Length - 1]; string LastName = ""; bool flag = true; for (int i = 0; i < Chuoi_Tach.Length - 1; i++) { if (flag) { LastName += Chuoi_Tach[i]; flag = false; } else { LastName += " " + Chuoi_Tach[i]; } } string Description = "[From Web]" + item.Message; int id = 0; StudentObject objS = new StudentObject(id, FirstName, LastName, item.FullName, 0, item.CreatedTime, item.Phone, item.Email, item.Address, item.CreatedTime, item.CreatedTime, Description, 41, 1, 1); listStudentFromWeb.Add(objS); objStudenWeb.WEB_IMIC_SP_RegisterDetail_UpdateIsSeen(item.RegisterDetailId); } return(listStudentFromWeb); }