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 <CustomizeClass> lst = new List <CustomizeClass>();
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)
{
CustomizeClass obj = new CustomizeClass
{
MaLop = (lstData.Count > listColName.IndexOf("MaLop")) ? lstData[listColName.IndexOf("MaLop")].Trim() : string.Empty,
TenLop = (lstData.Count > listColName.IndexOf("TenLop")) ? lstData[listColName.IndexOf("TenLop")].Trim() : string.Empty,
MaKhoa = (lstData.Count > listColName.IndexOf("MaKhoa")) ? lstData[listColName.IndexOf("MaKhoa")].Trim() : string.Empty,
ParentKey = (lstData.Count > listColName.IndexOf("Parent")) ? lstData[listColName.IndexOf("Parent")].Trim() : string.Empty
};
if (CheckInputData(obj))
{
lst.Add(obj);
}
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);
}
}
private bool CheckInputData(CustomizeClass obj)
{
try
{
if (obj.MaLop.Trim() == string.Empty)
{
return(false);
}
if (obj.TenLop.Trim() == string.Empty)
{
return(false);
}
if (obj.MaKhoa.Trim() == string.Empty)
{
return(false);
}
Vlu_Khoa objKhoa = _listType.FirstOrDefault(c => c.MaKhoa == obj.MaKhoa);
if (objKhoa != null)
{
obj.KhoaID = objKhoa.KhoaID;
obj.TenKhoa = objKhoa.TenKhoa;
}
if (obj.ParentKey.Trim() != string.Empty)
{
Vlu_LopHoc objLop = _listLopHoc.FirstOrDefault(c => c.MaLop == obj.ParentKey);
if (objLop != null)
{
obj.ParentID = objLop.LopID;
obj.ParentName = objLop.TenLop;
}
else
{
return(false);
}
}
return(true);
}
catch
{
return(false);
}
}
private bool CheckInputData(CustomizeClass obj)
{
try
{
if (obj.MaLop.Trim() == string.Empty)
return false;
if (obj.TenLop.Trim() == string.Empty)
return false;
if (obj.MaKhoa.Trim() == string.Empty)
return false;
Vlu_Khoa objKhoa = _listType.FirstOrDefault(c => c.MaKhoa == obj.MaKhoa);
if (objKhoa != null)
{
obj.KhoaID = objKhoa.KhoaID;
obj.TenKhoa = objKhoa.TenKhoa;
}
if (obj.ParentKey.Trim() != string.Empty)
{
Vlu_LopHoc objLop = _listLopHoc.FirstOrDefault(c => c.MaLop == obj.ParentKey);
if (objLop != null)
{
obj.ParentID = objLop.LopID;
obj.ParentName = objLop.TenLop;
}
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<CustomizeClass> lst = new List<CustomizeClass>();
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)
{
CustomizeClass obj = new CustomizeClass
{
MaLop = (lstData.Count > listColName.IndexOf("MaLop")) ? lstData[listColName.IndexOf("MaLop")].Trim() : string.Empty,
TenLop = (lstData.Count > listColName.IndexOf("TenLop")) ? lstData[listColName.IndexOf("TenLop")].Trim() : string.Empty,
MaKhoa = (lstData.Count > listColName.IndexOf("MaKhoa")) ? lstData[listColName.IndexOf("MaKhoa")].Trim() : string.Empty,
ParentKey = (lstData.Count > listColName.IndexOf("Parent")) ? lstData[listColName.IndexOf("Parent")].Trim() : string.Empty
};
if (CheckInputData(obj))
{
lst.Add(obj);
}
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);
}
}
