private bool CheckInputData(Vlu_MonHoc obj)
{
try
{
if (obj.MaMonHoc.Trim() == string.Empty)
{
return(false);
}
if (obj.TenMonHoc.Trim() == string.Empty)
{
return(false);
}
int iCheck = Convert.ToInt32(obj.DVHT);
iCheck = Convert.ToInt32(obj.TS);
iCheck = Convert.ToInt32(obj.LT);
iCheck = Convert.ToInt32(obj.BT);
iCheck = Convert.ToInt32(obj.TH);
iCheck = Convert.ToInt32(obj.BTL);
iCheck = Convert.ToInt32(obj.DA);
iCheck = Convert.ToInt32(obj.LA);
return(true);
}
catch
{
return(false);
}
}
public int ImportListTraining(List <ImportTraining> listImport)
{
//Check timeout import
int result = 0;
foreach (var item in listImport)
{
Vlu_MonHoc objMH = ObjectContext.Vlu_MonHoc.FirstOrDefault(c => c.MonHocID == item.MonHocID);
Vlu_Khoa objKhoa = ObjectContext.Vlu_Khoa.FirstOrDefault(c => c.KhoaID == item.KhoaID);
Vlu_LopHoc objLop = ObjectContext.Vlu_LopHoc.FirstOrDefault(c => c.LopID == item.LopID);
if (objMH != null && objKhoa != null && objLop != null)
{
Vlu_ChuongTrinhDT obj = new Vlu_ChuongTrinhDT();
obj.ID = -1;
obj.Vlu_MonHoc = objMH;
obj.Vlu_Khoa = objKhoa;
obj.Vlu_LopHoc = objLop;
obj.NamHoc = item.NamHoc;
obj.HocKy = item.HocKy;
obj.NgayTao = DateTime.Now;
obj.NguoiTao = ServiceContext.User.Identity.Name;
obj.NgayCapNhat = DateTime.Now;
obj.NguoiCapNhat = ServiceContext.User.Identity.Name;
result++;
ObjectContext.AddToVlu_ChuongTrinhDT(obj);
}
}
if (result > 0)
{
ObjectContext.SaveChanges();
}
return(result);
}
public void SaveSubjectAsync(Vlu_MonHoc obj)
{
if (obj.MonHocID == -1)
{
Model.Vlu_MonHocs.Add(obj);
}
PerformSubmitChanged(SaveSubjectComplete);
}
public override void Cleanup()
{
if (_modelTrain != null)
{
_modelTrain.GetListSubjectComplete -= new EventHandler <EntityResultsArgs <Vlu_MonHoc> >(_modelTrain_GetListSubjectComplete);
_modelTrain = null;
}
_listData = null;
_selectedItem = null;
if (DialogSended != null)
{
DialogSended = null;
}
base.Cleanup();
}
public override void Cleanup()
{
if (_modelTrain != null)
{
_modelTrain.GetListAuthenticationFormComplete -= new EventHandler <ComplexResultsArgs <Authentication> >(_model_GetListAuthenticationFormComplete);
_modelTrain.GetListSubjectComplete -= new EventHandler <EntityResultsArgs <Vlu_MonHoc> >(_modelTrain_GetListSubjectComplete);
_modelTrain.DeleteSubjectComplete -= new EventHandler <SubmitOperationEventArgs>(_modelTrain_DeleteSubjectComplete);
_modelTrain = null;
}
_listData = null;
_selectedItem = null;
if (DialogSended != null)
{
DialogSended = null;
}
base.Cleanup();
}
public void GetSubjectAsync(int id)
{
if (id == -1)
{
Vlu_MonHoc obj = new Vlu_MonHoc();
obj.MonHocID = id;
obj.MaMonHoc = string.Empty;
obj.TenMonHoc = string.Empty;
obj.NgayTao = DateTime.Now;
obj.NguoiTao = SystemConfig.UserName;
List <Vlu_MonHoc> lst = new List <Vlu_MonHoc>();
lst.Add(obj);
GetSubjectComplete(this, new EntityResultsArgs <Vlu_MonHoc>(lst.ToArray()));
}
else
{
var query = from c in Model.GetVlu_MonHocQuery()
where c.MonHocID == id
select c;
PerformQuery(query, GetSubjectComplete, false);
}
}
public void ImportSubjectAsync(List <Vlu_MonHoc> lstData, List <Vlu_MonHoc> lstImport)
{
foreach (var item in lstImport)
{
Vlu_MonHoc obj = lstData.FirstOrDefault(c => c.MaMonHoc == item.MaMonHoc);
if (obj == null)
{
obj = new Vlu_MonHoc();
obj.MonHocID = -1;
obj.NgayTao = DateTime.Now;
obj.NguoiTao = SystemConfig.UserName;
obj.TinhTrang = 0;
obj.Duyet = true;
}
else
{
obj.NgayCapNhat = DateTime.Now;
obj.NguoiCapNhat = SystemConfig.UserName;
}
obj.MaMonHoc = item.MaMonHoc;
obj.TenMonHoc = item.TenMonHoc;
obj.DVHT = item.DVHT;
obj.TS = item.TS;
obj.LT = item.LT;
obj.BT = item.BT;
obj.TH = item.TH;
obj.BTL = item.BTL;
obj.DA = item.DA;
obj.LA = item.LA;
obj.ThuocNhom = item.ThuocNhom;
if (obj.MonHocID == -1)
{
Model.Vlu_MonHocs.Add(obj);
}
}
PerformSubmitChanged(ImportSubjectComplete);
}
private bool CheckInputData(ImportTraining obj)
{
try
{
if (obj.MaMonHoc.Trim() == string.Empty)
{
return(false);
}
if (obj.MaLop.Trim() == string.Empty)
{
return(false);
}
if (obj.MaKhoa.Trim() == string.Empty)
{
return(false);
}
if (obj.TenNamHoc.Trim() == string.Empty)
{
return(false);
}
if (obj.TenHocKy.Trim() == string.Empty)
{
return(false);
}
try
{
obj.NamHoc = Convert.ToInt32(obj.TenNamHoc);
obj.HocKy = Convert.ToInt32(obj.TenHocKy);
}
catch
{
return(false);
}
Vlu_Khoa objKhoa = _listKhoa.FirstOrDefault(c => c.MaKhoa == obj.MaKhoa);
if (objKhoa != null)
{
obj.KhoaID = objKhoa.KhoaID;
obj.TenKhoa = objKhoa.TenKhoa;
}
else
{
return(false);
}
Vlu_LopHoc objLop = _listLop.FirstOrDefault(c => c.MaLop == obj.MaLop);
if (objLop != null)
{
obj.LopID = objLop.LopID;
obj.TenLop = objLop.TenLop;
}
else
{
return(false);
}
Vlu_MonHoc objMonHoc = _listMonHoc.FirstOrDefault(c => c.MaMonHoc == obj.MaMonHoc);
if (objMonHoc != null)
{
obj.MonHocID = objMonHoc.MonHocID;
obj.TenMonHoc = objMonHoc.TenMonHoc;
obj.ThuocNhom = objMonHoc.ThuocNhom;
}
else
{
return(false);
}
return(true);
}
catch
{
return(false);
}
}
public void OnGetFileClickComplete(FileInfo fileOpen)
{
try
{
Stream s = fileOpen.OpenRead();
StreamReader reader = new StreamReader(s);
var xml = reader.ReadToEnd();
s.Close();
var doc = XDocument.Parse(xml);
List <string> listColName = doc.Descendants().Where(c => c.Name.LocalName == "Row").First().Descendants().
Where(c => c.Name.LocalName == "Data").Select(c => c.Value).ToList();
List <Vlu_MonHoc> lst = new List <Vlu_MonHoc>();
if (CheckColumns(listColName))
{
int indexRow = 0;
string strError = string.Empty;
foreach (var row in doc.Descendants().Where(c => c.Name.LocalName == "Row"))
{
if (indexRow > 0)
{
List <string> lstData = row.Descendants().Where(c => c.Name.LocalName == "Data").Select(c => c.Value).ToList();
if (lstData.Count > 0)
{
bool checkDaiCuong = true;
if (lstData.Count > listColName.IndexOf("DaiCuong"))
{
try
{
int i = Convert.ToInt32(lstData[listColName.IndexOf("DaiCuong")]);
}
catch
{
checkDaiCuong = false;
}
}
else
{
checkDaiCuong = false;
}
if (checkDaiCuong)
{
Vlu_MonHoc obj = new Vlu_MonHoc
{
MaMonHoc = (lstData.Count > listColName.IndexOf("MaMH")) ? lstData[listColName.IndexOf("MaMH")].Trim() : string.Empty,
TenMonHoc = (lstData.Count > listColName.IndexOf("TenMH")) ? lstData[listColName.IndexOf("TenMH")].Trim() : string.Empty,
DVHT = (lstData.Count > listColName.IndexOf("DVHT")) ? lstData[listColName.IndexOf("DVHT")].Trim() : string.Empty,
TS = (lstData.Count > listColName.IndexOf("TS")) ? lstData[listColName.IndexOf("TS")].Trim() : string.Empty,
LT = (lstData.Count > listColName.IndexOf("LT")) ? lstData[listColName.IndexOf("LT")].Trim() : string.Empty,
BT = (lstData.Count > listColName.IndexOf("BT")) ? lstData[listColName.IndexOf("BT")].Trim() : string.Empty,
TH = (lstData.Count > listColName.IndexOf("TH")) ? lstData[listColName.IndexOf("TH")].Trim() : string.Empty,
BTL = (lstData.Count > listColName.IndexOf("BTL")) ? lstData[listColName.IndexOf("BTL")].Trim() : string.Empty,
DA = (lstData.Count > listColName.IndexOf("DA")) ? lstData[listColName.IndexOf("DA")].Trim() : string.Empty,
LA = (lstData.Count > listColName.IndexOf("LA")) ? lstData[listColName.IndexOf("LA")].Trim() : string.Empty,
ThuocNhom = (lstData.Count > listColName.IndexOf("DaiCuong")) ? Convert.ToInt32(lstData[listColName.IndexOf("DaiCuong")]) : 0
};
if (CheckInputData(obj))
{
lst.Add(obj);
}
else
{
strError += (indexRow + 1).ToString() + ", ";
}
}
else
{
strError += (indexRow + 1).ToString() + ", ";
}
}
}
indexRow++;
}
if (strError == string.Empty)
{
ListData = lst;
TotalRecord = "Tổng: " + lst.Count.ToString();
}
else
{
MessageCustomize.Show("Kiểm tra dòng " + strError.Substring(0, strError.Length - 2));
}
}
}
catch (Exception ex)
{
MessageCustomize.Show(ex.Message);
}
}
public void DeleteSubjectAsync(Vlu_MonHoc obj)
{
Model.Vlu_MonHocs.Remove(obj);
PerformSubmitChanged(DeleteSubjectComplete);
}
