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