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