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);
}
