public static WebIMICEntities getWebIMICOnline(Account oAccount) { Commons objCommon = new Commons(oAccount); WebIMICEntities objWebIMIC = objCommon.getWebIMICEntitiesInfo(); return(objWebIMIC); }
public override List <OnlineStudentRegisters> getElements() { WebIMICEntities oEntities = ConnectionEntities.getWebIMICOnline(mAcount); var oData = oEntities.WEB_IMIC_SP_RegisterDetail_GetForEtraining().ToList(); List <OnlineStudentRegisters> oLisOnlineStudentRegisters; if (oData != null) { oLisOnlineStudentRegisters = new List <OnlineStudentRegisters>(); Commons oCommons = new Commons(mAcount); foreach (var o in oData) { OnlineStudentRegisters oOnlineRegister = new OnlineStudentRegisters(); oOnlineRegister.FullName = o.FullName; oOnlineRegister.Phone = o.Phone; oOnlineRegister.Email = o.Email; oOnlineRegister.Message = o.Message; oOnlineRegister.Address = o.Address; oOnlineRegister.CreatedTime = (DateTime)o.CreatedTime; oOnlineRegister.RegisterDetailId = o.RegisterDetailId; oLisOnlineStudentRegisters.Add(oOnlineRegister); } } else { return(null); } return(oLisOnlineStudentRegisters == null ? null : oLisOnlineStudentRegisters); }
public override bool UpdateElement(OnlineStudentRegisters oT) { WebIMICEntities oEntities = ConnectionEntities.getWebIMICOnline(mAcount); oEntities.SP_IMIC_RegisterDetail_Update_IsSeen(); return(true); }
public WebIMICEntities getWebIMICEntitiesInfo() { 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://*/WebIMICModels.csdl|res://*/WebIMICModels.ssdl|res://*/WebIMICModels.msl"; EntityConnection objConnection = new EntityConnection(objEcsb.ToString()); WebIMICEntities objWebIMIC = new WebIMICEntities(objEcsb.ToString()); return(objWebIMIC); }