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