public ResponseResult ThemLop(LopModel model) { ResponseResult res = null; try { model.NguoiTao = AccountUtils.CurrentUsername(); res = LopDA.ThemLop(model); } catch (Exception ex) { throw ex; } return(res); }
public ResponseResult ThemCongTacKhac(CongTacKhacModel model) { ResponseResult res = null; try { model.NguoiTao = AccountUtils.CurrentUsername(); res = CongTacKhacDA.ThemCongTacKhac(model); } catch (Exception ex) { throw ex; } return(res); }
public ResponseResult ThemPhanCongGiangVien(PhanCongGiangVienModel model) { ResponseResult res = null; try { model.NguoiTao = AccountUtils.CurrentUsername(); res = PhanCongGiangVienDA.ThemPhanCongGiangVien(model); } catch (Exception ex) { throw ex; } return(res); }
public ResponseResult ThemHocPhanTheoCTDT(HocPhanTheoCTDTModel model) { ResponseResult res = null; try { model.NguoiTao = AccountUtils.CurrentUsername(); res = HocPhanTheoCTDT_DA.ThemHocPhanTheoCTDT(model); } catch (Exception ex) { throw ex; } return(res); }
public ResponseResult Import(HttpPostedFileBase file, int CTDTID) { ResponseResult res = null; string s = ""; try { List <HocPhanTheoCTDTModel> dt = new List <HocPhanTheoCTDTModel>(); file.InputStream.Position = 0; var memoryStream = new MemoryStream(); file.InputStream.CopyTo(memoryStream); using (XLWorkbook workBook = new XLWorkbook(memoryStream)) { //Read the first Sheet from Excel file. IXLWorksheet workSheet = workBook.Worksheet(1); foreach (IXLRow row in workSheet.Rows()) { int i = 0; string check = row.Cell(3).Value.ToString(); if (!String.IsNullOrEmpty(check) && int.TryParse(check, out i) && int.Parse(check) > 0) { var a = new HocPhanTheoCTDTModel(); a.ChuongTrinhDaoTaoID = CTDTID; a.MaHP = row.Cell(3).Value.ToString(); a.HocKi = ""; if (!String.IsNullOrEmpty(row.Cell(5).Value.ToString())) { a.HocKi += "1,"; } if (!String.IsNullOrEmpty(row.Cell(6).Value.ToString())) { a.HocKi += "2,"; } if (!String.IsNullOrEmpty(row.Cell(7).Value.ToString())) { a.HocKi += "3,"; } if (!String.IsNullOrEmpty(row.Cell(8).Value.ToString())) { a.HocKi += "4,"; } if (!String.IsNullOrEmpty(row.Cell(9).Value.ToString())) { a.HocKi += "5,"; } if (!String.IsNullOrEmpty(row.Cell(10).Value.ToString())) { a.HocKi += "6,"; } if (!String.IsNullOrEmpty(row.Cell(11).Value.ToString())) { a.HocKi += "7,"; } if (!String.IsNullOrEmpty(row.Cell(12).Value.ToString())) { a.HocKi += "8,"; } if (!String.IsNullOrEmpty(row.Cell(13).Value.ToString())) { a.HocKi += "9,"; } if (a.HocKi != "") { a.HocKi = a.HocKi.Remove(a.HocKi.LastIndexOf(',')); } a.NguoiTao = AccountUtils.CurrentUsername(); if (dt.Where(x => x.MaHP == a.MaHP) != null) { dt.Add(a); } foreach (var item in dt) { if (dt.Where(x => x.MaHP == a.MaHP) != null) { item.HocKi = a.HocKi; break; } } } } } foreach (var item in dt) { res = HocPhanTheoCTDT_DA.ThemHocPhanTheoCTDT(item); if (res.ResponseMessage != null) { s += res.ResponseMessage + ", "; } else if (res == null && dt.Count > 0) { break; } } if (s != "") { s = s.Remove(s.LastIndexOf(',')); if (res != null) { res.ResponseMessage = s; } } } catch (Exception ex) { throw ex; } return(res); }