public eTrainingOnlineEntities getTrainingOnlineCenterInfo()
{
string providerName = "System.Data.SqlClient";
ConnectionEntity objEntity = getConnEntityOnlineInfo();
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://*/eTrainingOnlineModel.csdl|res://*/eTrainingOnlineModel.ssdl|res://*/eTrainingOnlineModel.msl";
EntityConnection objConnection = new EntityConnection(objEcsb.ToString());
//TrainingCenterOfflineEntities objTraining = new TrainingCenterOfflineEntities(objConnection.ToString());
eTrainingOnlineEntities objTraining = new eTrainingOnlineEntities(objEcsb.ToString());
return(objTraining);
}
public List <StudentObject> getDataOnline()
{
List <StudentObject> listStudentSycOnline = new List <StudentObject>();
ConnectionEntities objConEn = new ConnectionEntities();
eTrainingOnlineEntities objConnEntitiesOn = objConEn.getTrainingCenterOn();
//ConnectionEntities objConEn = new ConnectionEntities();
//TrainingCenterEntities objConnEntities = objConEn.getTrainingCenter();
//IQueryable<Student> lstStudent = objConnEntities.Students;
//var listTempOnline = objConnEntitiesOn.Students.Where(p => p.DateCreate < DateTime.Now)
// .AsEnumerable()
// .Where(p => p.DateCreate > DateTime.Now.AddDays(-3));
//var listTempOnline = objConnEntitiesOn.Students.Where(i => i.DateCreate > DateTime.Now.AddDays(-7)).ToList();
var listTempOnline = objConnEntitiesOn.SP_Student_GetOnlineStudentFromLast3days();
foreach (var item in listTempOnline)
{
StudentObject objS = new StudentObject(item.Id, item.FirstName,
item.LastName, item.FullName, item.Sex, item.DateBirthday,
item.Mobile, item.Email, item.Address, item.DateCreate,
item.DateLastUpdate, item.Description, item.CourseId,
item.StatusId, item.UserId);
listStudentSycOnline.Add(objS);
}
return(listStudentSycOnline);
}
//public TrainingCenterEntities getTrainingCenter()
//{
// Common objCommon = new Common();
// TrainingCenterEntities objTraining = objCommon.getTrainingCenterInfo();
// return objTraining;
//}
public eTrainingOnlineEntities getTrainingCenterOn()
{
Common objCommon = new Common();
eTrainingOnlineEntities objTraining = objCommon.getTrainingOnlineCenterInfo();
return(objTraining);
}
