public IHttpActionResult PostCCTC_BANG_LUONG(CCTC_BANG_LUONG cCTC_BANG_LUONG) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.CCTC_BANG_LUONG.Add(cCTC_BANG_LUONG); try { db.SaveChanges(); } catch (DbUpdateException) { if (CCTC_BANG_LUONGExists(cCTC_BANG_LUONG.THANG_LUONG)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = cCTC_BANG_LUONG.THANG_LUONG }, cCTC_BANG_LUONG)); }
public IHttpActionResult PutCCTC_BANG_LUONG(string id, CCTC_BANG_LUONG cCTC_BANG_LUONG) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != cCTC_BANG_LUONG.THANG_LUONG) { return(BadRequest()); } db.Entry(cCTC_BANG_LUONG).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CCTC_BANG_LUONGExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetCCTC_BANG_LUONG() { CCTC_BANG_LUONG cCTC_BANG_LUONG = db.CCTC_BANG_LUONG.Find(); if (cCTC_BANG_LUONG == null) { return(NotFound()); } return(Ok(cCTC_BANG_LUONG)); }
public IHttpActionResult DeleteCCTC_BANG_LUONG(string id) { CCTC_BANG_LUONG cCTC_BANG_LUONG = db.CCTC_BANG_LUONG.Find(id); if (cCTC_BANG_LUONG == null) { return(NotFound()); } db.CCTC_BANG_LUONG.Remove(cCTC_BANG_LUONG); db.SaveChanges(); return(Ok(cCTC_BANG_LUONG)); }
public ActionResult Index(FormCollection formCollection) { try { if (Request != null) { HttpPostedFileBase file = Request.Files["UploadedFile"]; if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName)) { string fileName = file.FileName; string fileContentType = file.ContentType; byte[] fileBytes = new byte[file.ContentLength]; var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength)); //var usersList = new List<Users>(); using (var package = new ExcelPackage(file.InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfCol = workSheet.Dimension.End.Column; var noOfRow = workSheet.Dimension.End.Row; for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++) { CCTC_BANG_LUONG bl = new CCTC_BANG_LUONG(); bl.THANG_LUONG = workSheet.Cells[rowIterator, 15].Value.ToString(); bl.USERNAME = workSheet.Cells[rowIterator, 3].Value.ToString(); bl.LUONG_CO_BAN = Convert.ToDecimal(workSheet.Cells[rowIterator, 4].Value); bl.LUONG_BAO_HIEM = Convert.ToDecimal(workSheet.Cells[rowIterator, 5].Value); bl.PHU_CAP_AN_TRUA = Convert.ToDecimal(workSheet.Cells[rowIterator, 13].Value); db.CCTC_BANG_LUONG.Add(bl); db.SaveChanges(); so_dong_thanh_cong++; dong = rowIterator; } } } } } catch (Exception Ex) { ViewBag.Error = " Đã xảy ra lỗi, Liên hệ ngay với admin. " + Environment.NewLine + " Thông tin chi tiết về lỗi:" + Environment.NewLine + Ex; ViewBag.Information = "Lỗi tại dòng thứ: " + dong; } finally { ViewBag.Message = "Đã import thành công " + so_dong_thanh_cong + " dòng"; } return(View()); }
public String TinhLuong(string thangchamcong) { var query = db.CCTC_BANG_CHAM_CONG.Where(x => x.THANG_CHAM_CONG == thangchamcong).ToList(); if (query != null) { foreach (var item in query) { CCTC_BANG_LUONG bangluong = new CCTC_BANG_LUONG(); var querytinhluong = db.NV_TINH_LUONG.Where(x => x.USERNAME == item.USERNAME).FirstOrDefault(); if (querytinhluong != null) { bangluong.USERNAME = item.USERNAME; bangluong.THANG_LUONG = thangchamcong; bangluong.LUONG_CO_BAN = querytinhluong.LUONG_CO_BAN; bangluong.LUONG_BAO_HIEM = querytinhluong.LUONG_BAO_HIEM; bangluong.PHU_CAP_AN_TRUA = querytinhluong.PHU_CAP_AN_TRUA; bangluong.PHU_CAP_DI_LAI_DIEN_THOAI = querytinhluong.PHU_CAP_DI_LAI_DIEN_THOAI; bangluong.PHU_CAP_THUONG_DOANH_SO = 0; bangluong.PHU_CAP_TRACH_NHIEM = querytinhluong.PHU_CAP_TRACH_NHIEM; bangluong.CONG_CO_BAN = item.NGAY_CHUAN; bangluong.LUONG_CO_BAN_NGAY = (querytinhluong.LUONG_CO_BAN / item.NGAY_CHUAN); bangluong.LUONG_CO_BAN_GIO = (bangluong.LUONG_CO_BAN_NGAY / 8); bangluong.BAO_HIEM_CONG_TY_DONG = (querytinhluong.LUONG_BAO_HIEM * Convert.ToDecimal(0.22)); bangluong.BAO_HIEM_NHAN_VIEN_DONG = (querytinhluong.LUONG_BAO_HIEM * Convert.ToDecimal(0.105)); bangluong.LUONG_THUC_TE_CONG_LAM_THUC = item.CONG_THUC_TE; bangluong.LUONG_THUC_TE_SO_TIEN = (Convert.ToDecimal(item.CONG_THUC_TE) * bangluong.LUONG_CO_BAN_NGAY); bangluong.LUONG_LAM_THEM_CONG_NGAY_THUONG = item.TANG_CA_NGAY_THUONG; bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_THUONG = bangluong.LUONG_CO_BAN_GIO * Convert.ToDecimal(bangluong.LUONG_LAM_THEM_CONG_NGAY_THUONG * 1.5); bangluong.LUONG_LAM_THEM_CONG_NGAY_NGHI = 0; bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_NGHI = bangluong.LUONG_CO_BAN_GIO * Convert.ToDecimal(bangluong.LUONG_LAM_THEM_CONG_NGAY_NGHI * 2); bangluong.LUONG_LAM_THEM_CONG_NGAY_LE = item.TANG_CA_NGAY_LE; bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_LE = bangluong.LUONG_CO_BAN_GIO * Convert.ToDecimal(bangluong.LUONG_LAM_THEM_CONG_NGAY_LE * 3); bangluong.TONG_THU_NHAP = bangluong.PHU_CAP_AN_TRUA + bangluong.PHU_CAP_DI_LAI_DIEN_THOAI + bangluong.PHU_CAP_THUONG_DOANH_SO + bangluong.PHU_CAP_TRACH_NHIEM + bangluong.LUONG_THUC_TE_SO_TIEN + bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_THUONG + bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_NGHI + bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_LE; bangluong.TAM_UNG = item.UNG_LUONG; bangluong.VAY_TIN_DUNG = item.VAY_TIN_DUNG; bangluong.GIO_DI_TRE = (item.GIO_DI_MUON * 3) + item.GIO_VE_SOM; bangluong.PHAT_DI_TRE = Convert.ToDecimal(bangluong.GIO_DI_TRE) * bangluong.LUONG_CO_BAN_GIO; bangluong.PHAT_QUEN_DONG_PHUC = Convert.ToDecimal(item.SO_LAN_QUEN_DONG_PHUC) * 100000; bangluong.PHAT_QUEN_DEO_THE = Convert.ToDecimal(item.SO_LAN_QUEN_DEO_THE) * 100000; bangluong.PHU_CAP_THEM = item.PHU_CAP_THEM; bangluong.CONG_DOAN = querytinhluong.LUONG_CO_BAN * Convert.ToDecimal(0.02); bangluong.LUONG_LAO_CONG = querytinhluong.LUONG_LAO_CONG; bangluong.THUC_LINH = (bangluong.PHU_CAP_AN_TRUA + bangluong.PHU_CAP_DI_LAI_DIEN_THOAI + bangluong.PHU_CAP_THUONG_DOANH_SO + bangluong.PHU_CAP_TRACH_NHIEM + bangluong.LUONG_THUC_TE_SO_TIEN + bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_THUONG + bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_NGHI + bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_LE + bangluong.PHU_CAP_THEM) - (bangluong.TAM_UNG + bangluong.VAY_TIN_DUNG + bangluong.PHAT_DI_TRE + bangluong.CONG_DOAN + bangluong.LUONG_LAO_CONG + bangluong.BAO_HIEM_NHAN_VIEN_DONG + bangluong.PHAT_QUEN_DEO_THE + bangluong.PHAT_QUEN_DONG_PHUC); db.CCTC_BANG_LUONG.Add(bangluong); db.SaveChanges(); i++; } else { ketqua = ketqua + ", " + item.USERNAME; } } } else { ketqua = "Không tìm thấy bảng chấm công phù hợp"; } var thongbao = "Số dòng thành công: " + i + "<br />" + "Danh sách nhân viên chưa tính được lương: " + ketqua; return(thongbao); }
public ActionResult Import_Bangchamcong(FormCollection formCollection) { try { if (Request != null) { HttpPostedFileBase file = Request.Files["UploadedFile"]; if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName)) { string fileName = file.FileName; string fileContentType = file.ContentType; byte[] fileBytes = new byte[file.ContentLength]; var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength)); //var usersList = new List<Users>(); using (var package = new ExcelPackage(file.InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfCol = workSheet.Dimension.End.Column; var noOfRow = workSheet.Dimension.End.Row; for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++) { thangchamcong = workSheet.Cells[rowIterator, 15].Value.ToString(); username = workSheet.Cells[rowIterator, 3].Value.ToString(); ngaychuan = Convert.ToInt32(workSheet.Cells[rowIterator, 4].Value); if (workSheet.Cells[rowIterator, 5].Value != null) { giodimuon = Convert.ToDouble(workSheet.Cells[rowIterator, 5].Value); } else { giodimuon = 0; } if (workSheet.Cells[rowIterator, 6].Value != null) { giovesom = Convert.ToDouble(workSheet.Cells[rowIterator, 6].Value); } else { giovesom = 0; } if (workSheet.Cells[rowIterator, 7].Value != null) { tangcangaythuong = Convert.ToDouble(workSheet.Cells[rowIterator, 7].Value); } else { tangcangaythuong = 0; } if (workSheet.Cells[rowIterator, 8].Value != null) { tangcangayle = Convert.ToDouble(workSheet.Cells[rowIterator, 8].Value); } else { tangcangayle = 0; } if (workSheet.Cells[rowIterator, 9].Value != null) { solanquencham = Convert.ToDouble(workSheet.Cells[rowIterator, 9].Value); } else { solanquencham = 0; } if (workSheet.Cells[rowIterator, 10].Value != null) { solanviphamdongphuc = Convert.ToInt32(workSheet.Cells[rowIterator, 10].Value); } else { solanviphamdongphuc = 0; } if (workSheet.Cells[rowIterator, 11].Value != null) { solanquendeothe = Convert.ToInt32(workSheet.Cells[rowIterator, 11].Value); } else { solanquendeothe = 0; } if (workSheet.Cells[rowIterator, 12].Value != null) { songaynghi = Convert.ToDouble(workSheet.Cells[rowIterator, 12].Value); } else { songaynghi = 0; } if (workSheet.Cells[rowIterator, 13].Value != null) { congthucte = Convert.ToDouble(workSheet.Cells[rowIterator, 13].Value); } else { congthucte = 0; } if (workSheet.Cells[rowIterator, 14].Value != null) { vaytindung = Convert.ToDecimal(workSheet.Cells[rowIterator, 14].Value); } else { vaytindung = 0; } if (workSheet.Cells[rowIterator, 15].Value != null) { ungluong = Convert.ToDecimal(workSheet.Cells[rowIterator, 15].Value); } else { ungluong = 0; } if (workSheet.Cells[rowIterator, 16].Value != null) { ghichu = workSheet.Cells[rowIterator, 16].Value.ToString(); } if (workSheet.Cells[rowIterator, 15].Value != null) { phucapthem = Convert.ToDecimal(workSheet.Cells[rowIterator, 16].Value); } else { ungluong = 0; } CCTC_BANG_CHAM_CONG bcc = new CCTC_BANG_CHAM_CONG(); bcc.THANG_CHAM_CONG = thangchamcong; bcc.USERNAME = username; bcc.NGAY_CHUAN = ngaychuan; bcc.GIO_DI_MUON = giodimuon; bcc.GIO_VE_SOM = giovesom; bcc.TANG_CA_NGAY_THUONG = tangcangaythuong; bcc.TANG_CA_NGAY_LE = tangcangayle; bcc.SO_LAN_QUEN_CHAM = solanquencham; bcc.SO_NGAY_NGHI = songaynghi; bcc.CONG_THUC_TE = congthucte; bcc.VAY_TIN_DUNG = vaytindung; bcc.UNG_LUONG = ungluong; bcc.GHI_CHU = ghichu; bcc.SO_LAN_QUEN_DONG_PHUC = solanviphamdongphuc; bcc.SO_LAN_QUEN_DEO_THE = solanquendeothe; bcc.PHU_CAP_THEM = phucapthem; CCTC_BANG_LUONG bangluong = new CCTC_BANG_LUONG(); var querytinhluong = db.NV_TINH_LUONG.Where(x => x.USERNAME == username).FirstOrDefault(); if (querytinhluong != null) { bangluong.USERNAME = username; bangluong.THANG_LUONG = thangchamcong; bangluong.LUONG_CO_BAN = querytinhluong.LUONG_CO_BAN; bangluong.LUONG_BAO_HIEM = querytinhluong.LUONG_BAO_HIEM; bangluong.PHU_CAP_AN_TRUA = querytinhluong.PHU_CAP_AN_TRUA; bangluong.PHU_CAP_DI_LAI_DIEN_THOAI = querytinhluong.PHU_CAP_DI_LAI_DIEN_THOAI; bangluong.PHU_CAP_THUONG_DOANH_SO = 0; bangluong.PHU_CAP_TRACH_NHIEM = querytinhluong.PHU_CAP_TRACH_NHIEM; bangluong.CONG_CO_BAN = ngaychuan; bangluong.LUONG_CO_BAN_NGAY = (querytinhluong.LUONG_CO_BAN / ngaychuan); bangluong.LUONG_CO_BAN_GIO = (bangluong.LUONG_CO_BAN_NGAY / 8); bangluong.BAO_HIEM_CONG_TY_DONG = (querytinhluong.LUONG_BAO_HIEM * Convert.ToDecimal(0.22)); bangluong.BAO_HIEM_NHAN_VIEN_DONG = (querytinhluong.LUONG_BAO_HIEM * Convert.ToDecimal(0.105)); bangluong.LUONG_THUC_TE_CONG_LAM_THUC = congthucte; bangluong.LUONG_THUC_TE_SO_TIEN = (Convert.ToDecimal(congthucte) * bangluong.LUONG_CO_BAN_NGAY); bangluong.LUONG_LAM_THEM_CONG_NGAY_THUONG = tangcangaythuong; bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_THUONG = bangluong.LUONG_CO_BAN_GIO * Convert.ToDecimal(bangluong.LUONG_LAM_THEM_CONG_NGAY_THUONG * 1.5); bangluong.LUONG_LAM_THEM_CONG_NGAY_NGHI = 0; bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_NGHI = bangluong.LUONG_CO_BAN_GIO * Convert.ToDecimal(bangluong.LUONG_LAM_THEM_CONG_NGAY_NGHI * 2); bangluong.LUONG_LAM_THEM_CONG_NGAY_LE = tangcangayle; bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_LE = bangluong.LUONG_CO_BAN_GIO * Convert.ToDecimal(bangluong.LUONG_LAM_THEM_CONG_NGAY_LE * 3); bangluong.TONG_THU_NHAP = bangluong.PHU_CAP_AN_TRUA + bangluong.PHU_CAP_DI_LAI_DIEN_THOAI + bangluong.PHU_CAP_THUONG_DOANH_SO + bangluong.PHU_CAP_TRACH_NHIEM + bangluong.LUONG_THUC_TE_SO_TIEN + bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_THUONG + bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_NGHI + bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_LE; bangluong.TAM_UNG = ungluong; bangluong.VAY_TIN_DUNG = vaytindung; bangluong.GIO_DI_TRE = (giodimuon * 3) + giovesom; bangluong.PHAT_DI_TRE = Convert.ToDecimal(bangluong.GIO_DI_TRE) * bangluong.LUONG_CO_BAN_GIO; bangluong.PHAT_QUEN_DONG_PHUC = Convert.ToDecimal(solanviphamdongphuc) * 20000; bangluong.PHAT_QUEN_DEO_THE = Convert.ToDecimal(solanquendeothe) * 20000; bangluong.PHU_CAP_THEM = phucapthem; bangluong.CONG_DOAN = querytinhluong.LUONG_CO_BAN * Convert.ToDecimal(0.02); bangluong.LUONG_LAO_CONG = querytinhluong.LUONG_LAO_CONG; bangluong.THUC_LINH = (bangluong.PHU_CAP_AN_TRUA + bangluong.PHU_CAP_DI_LAI_DIEN_THOAI + bangluong.PHU_CAP_THUONG_DOANH_SO + bangluong.PHU_CAP_TRACH_NHIEM + bangluong.LUONG_THUC_TE_SO_TIEN + bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_THUONG + bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_NGHI + bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_LE + phucapthem) - (bangluong.TAM_UNG + bangluong.VAY_TIN_DUNG + bangluong.PHAT_DI_TRE + bangluong.CONG_DOAN + bangluong.LUONG_LAO_CONG + bangluong.BAO_HIEM_NHAN_VIEN_DONG + bangluong.PHAT_QUEN_DEO_THE + bangluong.PHAT_QUEN_DONG_PHUC); db.CCTC_BANG_LUONG.Add(bangluong); } db.CCTC_BANG_CHAM_CONG.Add(bcc); db.SaveChanges(); so_dong_thanh_cong++; dong = rowIterator; } } } } } catch (Exception Ex) { ViewBag.Error = " Đã xảy ra lỗi, Liên hệ ngay với admin. " + Environment.NewLine + " Thông tin chi tiết về lỗi:" + Environment.NewLine + Ex; ViewBag.Information = "Lỗi tại dòng thứ: " + dong; } finally { ViewBag.Message = "Đã import thành công " + so_dong_thanh_cong + " dòng"; } return(View("Import_Bangchamcong")); }
public ActionResult Index(FormCollection formCollection) { try { if (Request != null) { HttpPostedFileBase file = Request.Files["UploadedFile"]; if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName)) { string fileName = file.FileName; string fileContentType = file.ContentType; byte[] fileBytes = new byte[file.ContentLength]; var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength)); //var usersList = new List<Users>(); using (var package = new ExcelPackage(file.InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfCol = workSheet.Dimension.End.Column; var noOfRow = workSheet.Dimension.End.Row; for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++) { if (workSheet.Cells[rowIterator, 3].Value.ToString() != "") { username = workSheet.Cells[rowIterator, 3].Value.ToString(); } else { username = null; } if (workSheet.Cells[rowIterator, 4].Value.ToString() != "") { luongcoban = Convert.ToDecimal(workSheet.Cells[rowIterator, 4].Value); } else { luongcoban = 0; } if (workSheet.Cells[rowIterator, 5].Value.ToString() != "") { luongbaohiem = Convert.ToDecimal(workSheet.Cells[rowIterator, 5].Value); } else { luongbaohiem = 0; } if (workSheet.Cells[rowIterator, 6].Value.ToString() != "") { phucapantrua = Convert.ToDecimal(workSheet.Cells[rowIterator, 6].Value); } else { phucapantrua = 0; } if (workSheet.Cells[rowIterator, 7].Value.ToString() != "") { phucapdilaidienthoai = Convert.ToDecimal(workSheet.Cells[rowIterator, 7].Value); } else { phucapdilaidienthoai = 0; } if (workSheet.Cells[rowIterator, 8].Value.ToString() != "") { phucapthuongdoanhso = Convert.ToDecimal(workSheet.Cells[rowIterator, 8].Value); } else { phucapthuongdoanhso = 0; } if (workSheet.Cells[rowIterator, 9].Value.ToString() != "") { phucaptrachnhiem = Convert.ToDecimal(workSheet.Cells[rowIterator, 9].Value); } else { phucaptrachnhiem = 0; } if (workSheet.Cells[rowIterator, 10].Value.ToString() != "") { congcoban = Convert.ToDouble(workSheet.Cells[rowIterator, 10].Value); } else { congcoban = 0; } if (workSheet.Cells[rowIterator, 11].Value.ToString() != "") { luongcobanngay = Convert.ToDecimal(workSheet.Cells[rowIterator, 11].Value); } else { luongcobanngay = 0; } if (workSheet.Cells[rowIterator, 12].Value.ToString() != "") { luongcobangio = Convert.ToDecimal(workSheet.Cells[rowIterator, 12].Value); } else { luongcobangio = 0; } if (workSheet.Cells[rowIterator, 13].Value.ToString() != "") { bhcty = Convert.ToDecimal(workSheet.Cells[rowIterator, 13].Value); } else { bhcty = 0; } if (workSheet.Cells[rowIterator, 14].Value.ToString() != "") { bhnvien = Convert.ToDecimal(workSheet.Cells[rowIterator, 14].Value); } else { bhnvien = 0; } if (workSheet.Cells[rowIterator, 15].Value.ToString() != "") { conglamthuc = Convert.ToDouble(workSheet.Cells[rowIterator, 15].Value); } else { conglamthuc = 0; } if (workSheet.Cells[rowIterator, 16].Value.ToString() != "") { luonglamthucte = Convert.ToDecimal(workSheet.Cells[rowIterator, 16].Value); } else { luonglamthucte = 0; } if (workSheet.Cells[rowIterator, 17].Value.ToString() != "") { conglamthemngaythuong = Convert.ToDouble(workSheet.Cells[rowIterator, 17].Value); } else { conglamthemngaythuong = 0; } if (workSheet.Cells[rowIterator, 18].Value.ToString() != "") { luonglamthemngaythuong = Convert.ToDecimal(workSheet.Cells[rowIterator, 18].Value); } else { luonglamthemngaythuong = 0; } if (workSheet.Cells[rowIterator, 19].Value.ToString() != "") { conglamthemngaynghi = Convert.ToDouble(workSheet.Cells[rowIterator, 19].Value); } else { conglamthemngaynghi = 0; } if (workSheet.Cells[rowIterator, 20].Value.ToString() != "") { luonglamthemngaynghi = Convert.ToDecimal(workSheet.Cells[rowIterator, 20].Value); } else { luonglamthemngaynghi = 0; } if (workSheet.Cells[rowIterator, 21].Value.ToString() != "") { conglamthemngayle = Convert.ToDouble(workSheet.Cells[rowIterator, 21].Value); } else { conglamthemngayle = 0; } if (workSheet.Cells[rowIterator, 22].Value.ToString() != "") { luonglamthemngayle = Convert.ToDecimal(workSheet.Cells[rowIterator, 22].Value); } else { luonglamthemngayle = 0; } if (workSheet.Cells[rowIterator, 23].Value.ToString() != "") { tongtiencong = Convert.ToDecimal(workSheet.Cells[rowIterator, 23].Value); } else { tongtiencong = 0; } if (workSheet.Cells[rowIterator, 24].Value != null) { tamung = Convert.ToDecimal(workSheet.Cells[rowIterator, 24].Value); } else { tamung = 0; } if (workSheet.Cells[rowIterator, 25].Value != null) { vaytindung = Convert.ToDecimal(workSheet.Cells[rowIterator, 25].Value); } else { vaytindung = 0; } if (workSheet.Cells[rowIterator, 26].Value != null) { phatquendongphuc = Convert.ToDecimal(workSheet.Cells[rowIterator, 26].Value); } else { phatquendongphuc = 0; } if (workSheet.Cells[rowIterator, 27].Value != null) { phatquenthe = Convert.ToDecimal(workSheet.Cells[rowIterator, 27].Value); } else { phatquenthe = 0; } if (workSheet.Cells[rowIterator, 28].Value != null) { gioditre = Convert.ToDouble(workSheet.Cells[rowIterator, 28].Value); } else { gioditre = 0; } if (workSheet.Cells[rowIterator, 29].Value != null) { phatditre = Convert.ToDecimal(workSheet.Cells[rowIterator, 29].Value); } else { phatditre = 0; } if (workSheet.Cells[rowIterator, 30].Value != null) { congdoan = Convert.ToDecimal(workSheet.Cells[rowIterator, 30].Value); } else { congdoan = 0; } if (workSheet.Cells[rowIterator, 31].Value != null) { luonglaocong = Convert.ToDecimal(workSheet.Cells[rowIterator, 31].Value); } else { luonglaocong = 0; } if (workSheet.Cells[rowIterator, 32].Value != null) { thuclinh = Convert.ToDecimal(workSheet.Cells[rowIterator, 32].Value); } else { thuclinh = 0; } if (workSheet.Cells[rowIterator, 33].Value != null) { thanglinhluong = workSheet.Cells[rowIterator, 33].Value.ToString(); } else { thanglinhluong = null; } if (workSheet.Cells[rowIterator, 34].Value != null) { phucapthem = Convert.ToDecimal(workSheet.Cells[rowIterator, 34].Value); } else { phucapthem = 0; } CCTC_BANG_LUONG bangluong = new CCTC_BANG_LUONG(); bangluong.USERNAME = username; bangluong.THANG_LUONG = thanglinhluong; bangluong.LUONG_CO_BAN = luongcoban; bangluong.LUONG_BAO_HIEM = luongbaohiem; bangluong.PHU_CAP_AN_TRUA = phucapantrua; bangluong.PHU_CAP_DI_LAI_DIEN_THOAI = phucapdilaidienthoai; bangluong.PHU_CAP_THUONG_DOANH_SO = phucapthuongdoanhso; bangluong.PHU_CAP_TRACH_NHIEM = phucaptrachnhiem; bangluong.CONG_CO_BAN = congcoban; bangluong.LUONG_CO_BAN_NGAY = luongcobanngay; bangluong.LUONG_CO_BAN_GIO = luongcobangio; bangluong.BAO_HIEM_CONG_TY_DONG = bhcty; bangluong.BAO_HIEM_NHAN_VIEN_DONG = bhnvien; bangluong.LUONG_THUC_TE_CONG_LAM_THUC = conglamthuc; bangluong.LUONG_THUC_TE_SO_TIEN = luonglamthucte; bangluong.LUONG_LAM_THEM_CONG_NGAY_THUONG = conglamthemngaythuong; bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_THUONG = luonglamthemngaythuong; bangluong.LUONG_LAM_THEM_CONG_NGAY_NGHI = conglamthemngaynghi; bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_NGHI = luonglamthemngaynghi; bangluong.LUONG_LAM_THEM_CONG_NGAY_LE = conglamthemngayle; bangluong.LUONG_LAM_THEM_TIEN_CONG_NGAY_LE = luonglamthemngayle; bangluong.TONG_THU_NHAP = tongtiencong; bangluong.TAM_UNG = tamung; bangluong.VAY_TIN_DUNG = vaytindung; bangluong.GIO_DI_TRE = gioditre; bangluong.PHAT_DI_TRE = phatditre; bangluong.PHAT_QUEN_DONG_PHUC = phatquendongphuc; bangluong.PHAT_QUEN_DEO_THE = phatquenthe; bangluong.PHU_CAP_THEM = phucapthem; bangluong.CONG_DOAN = congdoan; bangluong.LUONG_LAO_CONG = luonglaocong; bangluong.THUC_LINH = thuclinh; db.CCTC_BANG_LUONG.Add(bangluong); db.SaveChanges(); so_dong_thanh_cong++; dong = rowIterator; } } } } } catch (Exception Ex) { ViewBag.Error = " Đã xảy ra lỗi, Liên hệ ngay với admin. " + Environment.NewLine + " Thông tin chi tiết về lỗi:" + Environment.NewLine + Ex; ViewBag.Information = "Lỗi tại dòng thứ: " + dong; } finally { ViewBag.Message = "Đã import thành công " + so_dong_thanh_cong + " dòng"; } return(View()); }