public IHttpActionResult PostCCTC_BANG_CHAM_CONG(CCTC_BANG_CHAM_CONG cCTC_BANG_CHAM_CONG)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.CCTC_BANG_CHAM_CONG.Add(cCTC_BANG_CHAM_CONG);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (CCTC_BANG_CHAM_CONGExists(cCTC_BANG_CHAM_CONG.THANG_CHAM_CONG))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = cCTC_BANG_CHAM_CONG.THANG_CHAM_CONG }, cCTC_BANG_CHAM_CONG));
}
public IHttpActionResult PutCCTC_BANG_CHAM_CONG(string id, CCTC_BANG_CHAM_CONG cCTC_BANG_CHAM_CONG)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != cCTC_BANG_CHAM_CONG.THANG_CHAM_CONG)
{
return(BadRequest());
}
db.Entry(cCTC_BANG_CHAM_CONG).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CCTC_BANG_CHAM_CONGExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetCCTC_BANG_CHAM_CONG()
{
CCTC_BANG_CHAM_CONG cCTC_BANG_CHAM_CONG = db.CCTC_BANG_CHAM_CONG.Find();
if (cCTC_BANG_CHAM_CONG == null)
{
return(NotFound());
}
return(Ok(cCTC_BANG_CHAM_CONG));
}
public IHttpActionResult DeleteCCTC_BANG_CHAM_CONG(string id)
{
CCTC_BANG_CHAM_CONG cCTC_BANG_CHAM_CONG = db.CCTC_BANG_CHAM_CONG.Find(id);
if (cCTC_BANG_CHAM_CONG == null)
{
return(NotFound());
}
db.CCTC_BANG_CHAM_CONG.Remove(cCTC_BANG_CHAM_CONG);
db.SaveChanges();
return(Ok(cCTC_BANG_CHAM_CONG));
}
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, 17].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, 18].Value != null)
{
phucapthem = Convert.ToDecimal(workSheet.Cells[rowIterator, 18].Value);
}
else
{
phucapthem = 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) * 100000;
// bangluong.PHAT_QUEN_DEO_THE = Convert.ToDecimal(solanquendeothe) * 100000;
// 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"));
}
