public IHttpActionResult PostKHO_NHAP_KHOMH(NhapKhoMH kho_NhapKhoMH)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//Lưu thông tin nhập kho
KHO_NHAP_KHO nk = new KHO_NHAP_KHO();
nk.NGAY_CHUNG_TU = GeneralFunction.ConvertToTime(kho_NhapKhoMH.NGAY_CHUNG_TU);
nk.NGAY_HACH_TOAN = GeneralFunction.ConvertToTime(kho_NhapKhoMH.NGAY_HACH_TOAN);
nk.SO_CHUNG_TU = GeneralChungTu();
nk.NGUOI_LAP_PHIEU = kho_NhapKhoMH.NGUOI_LAP_PHIEU;
nk.MA_DOI_TUONG = kho_NhapKhoMH.MA_DOI_TUONG;
nk.NHAN_VIEN_MUA_HANG = kho_NhapKhoMH.NHAN_VIEN_MUA_HANG;
nk.DIEN_GIAI = kho_NhapKhoMH.DIEN_GIAI;
nk.TRUC_THUOC = "HOPLONG";
nk.LOAI_NHAP_KHO = kho_NhapKhoMH.LOAI_NHAP_KHO;
db.KHO_NHAP_KHO.Add(nk);
//Lưu thông tin tham chiếu
if (kho_NhapKhoMH.ThamChieu.Count > 0)
{
foreach (ThamChieu item in kho_NhapKhoMH.ThamChieu)
{
XL_THAM_CHIEU_CHUNG_TU newItem = new XL_THAM_CHIEU_CHUNG_TU();
newItem.SO_CHUNG_TU_GOC = nk.SO_CHUNG_TU;
newItem.SO_CHUNG_TU_THAM_CHIEU = item.SO_CHUNG_TU;
db.XL_THAM_CHIEU_CHUNG_TU.Add(newItem);
}
}
//Lưu chi tiết
decimal tongtien = 0;
//HHTONKHOViewModels HHTon = new HHTONKHOViewModels();
//NhomHangViewModels NhomHang = new NhomHangViewModels();
if (kho_NhapKhoMH.ChiTiet != null && kho_NhapKhoMH.ChiTiet.Count > 0)
{
foreach (ChiTietNhapKhoMH item in kho_NhapKhoMH.ChiTiet)
{
KHO_CT_NHAP_KHO newItem = new KHO_CT_NHAP_KHO();
newItem.SO_CHUNG_TU = nk.SO_CHUNG_TU;
newItem.MA_HANG = item.MA_HANG;
newItem.MA_KHO_CON = item.MA_KHO_CON;
newItem.TK_CO = item.TK_CO;
newItem.TK_NO = item.TK_NO;
newItem.DVT = item.DVT;
newItem.DON_GIA = Convert.ToDecimal(item.DON_GIA_CHUA_VAT);
newItem.SO_LUONG = Convert.ToInt32(item.SL);
newItem.THANH_TIEN = Convert.ToDecimal(item.THANH_TIEN_CHUA_VAT);
tongtien += newItem.THANH_TIEN;
newItem.TK_KHO = item.TK_KHO;
db.KHO_CT_NHAP_KHO.Add(newItem);
//Cập nhật hàng tồn
var newkhogiu = db.KHO_HANG_CAN_GIU.Where(x => x.MA_HANG == item.MA_HANG).ToList();
soluongcon = newItem.SO_LUONG;
foreach (var abc in newkhogiu)
{
if (newItem.SO_LUONG > abc.SL_CAN_GIU)
{
TONKHO_HOPLONG newhanggiu = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG && x.MA_KHO_CON == "IVHOPLONG05").FirstOrDefault();
if (newhanggiu != null)
{
newhanggiu.SL_HOPLONG += abc.SL_CAN_GIU;
}
var quezzzry = db.KHO_GIU_HANG.Where(x => x.ID_CT_PO == abc.ID_PO_BAN).FirstOrDefault();
if (quezzzry != null)
{
quezzzry.SL_GIU = abc.SL_CAN_GIU + quezzzry.SL_GIU;
}
abc.SL_CAN_GIU = 0;
newItem.SO_LUONG = newItem.SO_LUONG - abc.SL_CAN_GIU;
TONKHO_HOPLONG newHangTon = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG && x.MA_KHO_CON == item.MA_KHO_CON).FirstOrDefault();
if (newHangTon == null)
{
newHangTon = new TONKHO_HOPLONG();
newHangTon.MA_HANG = item.MA_HANG;
newHangTon.MA_KHO_CON = item.MA_KHO_CON;
newHangTon.SL_HOPLONG = newItem.SO_LUONG;
db.TONKHO_HOPLONG.Add(newHangTon);
}
else
{
newHangTon.SL_HOPLONG += newItem.SO_LUONG;
}
}
if (newItem.SO_LUONG < abc.SL_CAN_GIU)
{
TONKHO_HOPLONG newhanggiu = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG && x.MA_KHO_CON == "IVHOPLONG05").FirstOrDefault();
if (newhanggiu != null)
{
newhanggiu.SL_HOPLONG += abc.SL_CAN_GIU;
}
var quezzzry = db.KHO_GIU_HANG.Where(x => x.ID_CT_PO == abc.ID_PO_BAN).FirstOrDefault();
if (quezzzry != null)
{
quezzzry.SL_GIU = abc.SL_CAN_GIU + quezzzry.SL_GIU;
}
abc.SL_CAN_GIU = abc.SL_CAN_GIU - newItem.SO_LUONG;
newItem.SO_LUONG = 0;
TONKHO_HOPLONG newHangTon = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG && x.MA_KHO_CON == item.MA_KHO_CON).FirstOrDefault();
if (newHangTon == null)
{
newHangTon = new TONKHO_HOPLONG();
newHangTon.MA_HANG = item.MA_HANG;
newHangTon.MA_KHO_CON = item.MA_KHO_CON;
newHangTon.SL_HOPLONG = newItem.SO_LUONG;
db.TONKHO_HOPLONG.Add(newHangTon);
}
else
{
newHangTon.SL_HOPLONG += newItem.SO_LUONG;
}
}
if (newItem.SO_LUONG == abc.SL_CAN_GIU)
{
TONKHO_HOPLONG newhanggiu = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG && x.MA_KHO_CON == "IVHOPLONG05").FirstOrDefault();
if (newhanggiu != null)
{
newhanggiu.SL_HOPLONG += abc.SL_CAN_GIU;
}
var quezzzry = db.KHO_GIU_HANG.Where(x => x.ID_CT_PO == abc.ID_PO_BAN).FirstOrDefault();
if (quezzzry != null)
{
quezzzry.SL_GIU = abc.SL_CAN_GIU + quezzzry.SL_GIU;
}
abc.SL_CAN_GIU = 0;
newItem.SO_LUONG = 0;
TONKHO_HOPLONG newHangTon = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG && x.MA_KHO_CON == item.MA_KHO_CON).FirstOrDefault();
if (newHangTon == null)
{
newHangTon = new TONKHO_HOPLONG();
newHangTon.MA_HANG = item.MA_HANG;
newHangTon.MA_KHO_CON = item.MA_KHO_CON;
newHangTon.SL_HOPLONG = newItem.SO_LUONG;
db.TONKHO_HOPLONG.Add(newHangTon);
}
else
{
newHangTon.SL_HOPLONG += newItem.SO_LUONG;
}
}
}
var query = db.MH_CT_DE_NGHI_NHAP_KHO.Where(x => x.MA_HANG == newItem.MA_HANG && x.MA_SO_DN == kho_NhapKhoMH.MA_SO_DN).FirstOrDefault();
if (query != null)
{
IDDeNghi = query.ID;
}
;
MH_DE_NGHI_JOIN_PO_MH dnmh = db.MH_DE_NGHI_JOIN_PO_MH.Where(x => x.ID_DE_NGHI == IDDeNghi).FirstOrDefault();
MH_PO_CT_MUA_HANG pomh = db.MH_PO_CT_MUA_HANG.Where(x => x.ID == dnmh.ID_PO_DAT_HANG).FirstOrDefault();
if ((pomh.SL - pomh.SL_DA_VE) >= newItem.SO_LUONG)
{
pomh.SL_DA_VE += Convert.ToInt32(newItem.SO_LUONG);
}
else
{
return(Ok("Hàng đã được nhập vào kho rồi!"));
}
var query1 = db.MH_DE_NGHI_NHAP_KHO.Where(x => x.MA_SO_DN == kho_NhapKhoMH.MA_SO_DN).FirstOrDefault();
if (query1 != null)
{
query1.DA_NHAP_KHO = true;
query1.PHIEU_NHAP_KHO = newItem.SO_CHUNG_TU;
}
// Lưu Nhật ký
KT_SO_NHAT_KY_CHUNG sonhatky = new KT_SO_NHAT_KY_CHUNG();
sonhatky.SO_CHUNG_TU = newItem.SO_CHUNG_TU;
sonhatky.NGAY_CHUNG_TU = nk.NGAY_CHUNG_TU;
sonhatky.NGAY_HACH_TOAN = nk.NGAY_HACH_TOAN;
if (nk.NHAN_VIEN_MUA_HANG == null)
{
sonhatky.DOI_TUONG = nk.NHAN_VIEN_MUA_HANG;
}
else
{
sonhatky.DOI_TUONG = nk.NHAN_VIEN_MUA_HANG;
}
sonhatky.TRUC_THUOC = "HOPLONG";
sonhatky.DIEN_GIAI_CHUNG = nk.DIEN_GIAI;
sonhatky.DIEN_GIAI_CHI_TIET = nk.DIEN_GIAI;
sonhatky.TAI_KHOAN_HACH_TOAN = newItem.TK_NO;
sonhatky.TAI_KHOAN_DOI_UNG = newItem.TK_CO;
sonhatky.PHAT_SINH_NO = tongtien;
sonhatky.PHAT_SINH_CO = 0;
db.KT_SO_NHAT_KY_CHUNG.Add(sonhatky);
KT_SO_NHAT_KY_CHUNG sonhatky1 = new KT_SO_NHAT_KY_CHUNG();
sonhatky1.SO_CHUNG_TU = newItem.SO_CHUNG_TU;
sonhatky1.NGAY_CHUNG_TU = nk.NGAY_CHUNG_TU;
sonhatky1.NGAY_HACH_TOAN = nk.NGAY_HACH_TOAN;
if (nk.NHAN_VIEN_MUA_HANG == null)
{
sonhatky1.DOI_TUONG = nk.NHAN_VIEN_MUA_HANG;
}
else
{
sonhatky1.DOI_TUONG = nk.NHAN_VIEN_MUA_HANG;
}
sonhatky1.TRUC_THUOC = "HOPLONG";
sonhatky1.DIEN_GIAI_CHUNG = nk.DIEN_GIAI;
sonhatky1.DIEN_GIAI_CHI_TIET = nk.DIEN_GIAI;
sonhatky1.TAI_KHOAN_HACH_TOAN = newItem.TK_CO;
sonhatky1.TAI_KHOAN_DOI_UNG = newItem.TK_NO;
sonhatky1.PHAT_SINH_NO = 0;
sonhatky1.PHAT_SINH_CO = tongtien;
db.KT_SO_NHAT_KY_CHUNG.Add(sonhatky1);
}
}
nk.TONG_TIEN = tongtien;
//Cập nhật Hàng tồn kho
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (KHO_NHAP_KHOExists(kho_NhapKhoMH.SO_CHUNG_TU))
{
return(Conflict());
}
else
{
throw;
}
}
return(Ok(nk.SO_CHUNG_TU));
}
public IHttpActionResult PostNH_UNC(ChiNganHang chi_nganhang)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//Lưu thông tin nhập kho
NH_UNC unc = new NH_UNC();
unc.NGAY_CHUNG_TU = GeneralFunction.ConvertToTime(chi_nganhang.NGAY_CHUNG_TU);
unc.NGAY_HACH_TOAN = GeneralFunction.ConvertToTime(chi_nganhang.NGAY_HACH_TOAN);
unc.SO_CHUNG_TU = AutoMA_DU_KIEN();
unc.TAI_KHOAN_CHI = chi_nganhang.TAI_KHOAN_CHI;
unc.MA_DOI_TUONG = chi_nganhang.MA_DOI_TUONG;
unc.NOI_DUNG_THANH_TOAN = chi_nganhang.NOI_DUNG_THANH_TOAN;
unc.DIEN_GIAI_NOI_DUNG_THANH_TOAN = chi_nganhang.DIEN_GIAI_NOI_DUNG_THANH_TOAN;
unc.TAI_KHOAN_NHAN = chi_nganhang.TAI_KHOAN_NHAN;
unc.NHAN_VIEN_CHUYEN_KHOAN = chi_nganhang.NHAN_VIEN_CHUYEN_KHOAN;
unc.NGUOI_LAP_BIEU = chi_nganhang.NGUOI_LAP_BIEU;
unc.TRUC_THUOC = "HOPLONG";
db.NH_UNC.Add(unc);
//Lưu thông tin tham chiếu
if (chi_nganhang.ThamChieu.Count > 0)
{
foreach (ThamChieu item in chi_nganhang.ThamChieu)
{
XL_THAM_CHIEU_CHUNG_TU newItem = new XL_THAM_CHIEU_CHUNG_TU();
newItem.SO_CHUNG_TU_GOC = unc.SO_CHUNG_TU;
newItem.SO_CHUNG_TU_THAM_CHIEU = item.SO_CHUNG_TU;
db.XL_THAM_CHIEU_CHUNG_TU.Add(newItem);
}
}
//Lưu chi tiết
decimal tongtien = 0;
//TONKHO_HOPLONG HHTon = new TONKHO_HOPLONG();
//HH_NHOM_VTHH NhomHang = new HH_NHOM_VTHH();
if (chi_nganhang.ChiTietHachToan != null && chi_nganhang.ChiTietHachToan.Count > 0)
{
foreach (ChiTietHachToanPhieuChi item in chi_nganhang.ChiTietHachToan)
{
NH_CT_UNC newItem = new NH_CT_UNC();
newItem.SO_CHUNG_TU = unc.SO_CHUNG_TU;
newItem.DIEN_GIAI = item.DIEN_GIAI;
newItem.LOAI_TIEN = item.LOAI_TIEN;
newItem.TK_CO = item.TK_CO;
newItem.TK_NO = item.TK_NO;
newItem.SO_TIEN = Convert.ToDecimal(item.SO_TIEN);
newItem.TY_GIA = Convert.ToInt32(item.TY_GIA);
newItem.QUY_DOI = newItem.SO_TIEN * newItem.TY_GIA;
tongtien += newItem.QUY_DOI;
newItem.MA_DOI_TUONG = unc.MA_DOI_TUONG;
newItem.DON_VI = item.DON_VI;
if (chi_nganhang.ChiTietThue != null && chi_nganhang.ChiTietThue.Count > 0)
{
var thue = chi_nganhang.ChiTietThue.Where(x => x.MA_NHA_CUNG_CAP == unc.MA_DOI_TUONG).FirstOrDefault();
newItem.DIEN_GIAI_THUE = thue.DIEN_GIAI_THUE;
newItem.TK_THUE_GTGT = thue.TK_THUE_GTGT;
newItem.TIEN_THUE_GTGT = thue.TIEN_THUE_GTGT;
newItem.CK_THUE_GTGT = thue.CK_THUE_GTGT;
newItem.GIA_TRI_HHDV_CHUA_THUE = thue.GIA_TRI_HHDV_CHUA_THUE;
newItem.NGAY_HD = Convert.ToDateTime(thue.NGAY_HD);
newItem.SO_HD = thue.SO_HD;
newItem.MAU_SO_HD = thue.MAU_SO_HD;
newItem.KY_HIEU_HD = thue.KY_HIEU_HD;
newItem.MA_NHA_CUNG_CAP = thue.MA_NHA_CUNG_CAP;
}
db.NH_CT_UNC.Add(newItem);
// Lưu Nhật ký
KT_SO_NHAT_KY_CHUNG sonhatky = new KT_SO_NHAT_KY_CHUNG();
sonhatky.SO_CHUNG_TU = newItem.SO_CHUNG_TU;
sonhatky.NGAY_CHUNG_TU = unc.NGAY_CHUNG_TU;
sonhatky.NGAY_HACH_TOAN = unc.NGAY_HACH_TOAN;
sonhatky.DOI_TUONG = unc.MA_DOI_TUONG;
sonhatky.TRUC_THUOC = "HOPLONG";
sonhatky.DIEN_GIAI_CHUNG = unc.NOI_DUNG_THANH_TOAN;
sonhatky.DIEN_GIAI_CHI_TIET = newItem.DIEN_GIAI;
sonhatky.TAI_KHOAN_HACH_TOAN = newItem.TK_NO;
sonhatky.TAI_KHOAN_DOI_UNG = newItem.TK_CO;
sonhatky.PHAT_SINH_NO = tongtien;
sonhatky.PHAT_SINH_CO = 0;
db.KT_SO_NHAT_KY_CHUNG.Add(sonhatky);
KT_SO_NHAT_KY_CHUNG sonhatky1 = new KT_SO_NHAT_KY_CHUNG();
sonhatky1.SO_CHUNG_TU = newItem.SO_CHUNG_TU;
sonhatky1.NGAY_CHUNG_TU = unc.NGAY_CHUNG_TU;
sonhatky1.NGAY_HACH_TOAN = unc.NGAY_HACH_TOAN;
sonhatky1.DOI_TUONG = unc.MA_DOI_TUONG;
sonhatky1.TRUC_THUOC = "HOPLONG";
sonhatky1.DIEN_GIAI_CHUNG = unc.NOI_DUNG_THANH_TOAN;
sonhatky1.DIEN_GIAI_CHI_TIET = newItem.DIEN_GIAI;
sonhatky1.TAI_KHOAN_HACH_TOAN = newItem.TK_CO;
sonhatky1.TAI_KHOAN_DOI_UNG = newItem.TK_NO;
sonhatky1.PHAT_SINH_NO = 0;
sonhatky1.PHAT_SINH_CO = tongtien;
db.KT_SO_NHAT_KY_CHUNG.Add(sonhatky1);
if (newItem.TK_THUE_GTGT != null)
{
KT_SO_NHAT_KY_CHUNG sonhatky3 = new KT_SO_NHAT_KY_CHUNG();
sonhatky3.SO_CHUNG_TU = newItem.SO_CHUNG_TU;
sonhatky3.NGAY_CHUNG_TU = unc.NGAY_CHUNG_TU;
sonhatky3.NGAY_HACH_TOAN = unc.NGAY_HACH_TOAN;
sonhatky3.DOI_TUONG = unc.MA_DOI_TUONG;
sonhatky3.TRUC_THUOC = "HOPLONG";
sonhatky3.DIEN_GIAI_CHUNG = unc.NOI_DUNG_THANH_TOAN;
sonhatky3.DIEN_GIAI_CHI_TIET = newItem.DIEN_GIAI;
sonhatky3.TAI_KHOAN_HACH_TOAN = newItem.TK_THUE_GTGT;
sonhatky3.TAI_KHOAN_DOI_UNG = newItem.TK_NO;
sonhatky3.PHAT_SINH_NO = Convert.ToDecimal(newItem.TIEN_THUE_GTGT);
sonhatky3.PHAT_SINH_CO = 0;
db.KT_SO_NHAT_KY_CHUNG.Add(sonhatky3);
KT_SO_NHAT_KY_CHUNG sonhatky4 = new KT_SO_NHAT_KY_CHUNG();
sonhatky4.SO_CHUNG_TU = newItem.SO_CHUNG_TU;
sonhatky4.NGAY_CHUNG_TU = unc.NGAY_CHUNG_TU;
sonhatky4.NGAY_HACH_TOAN = unc.NGAY_HACH_TOAN;
sonhatky4.DOI_TUONG = unc.MA_DOI_TUONG;
sonhatky4.TRUC_THUOC = "HOPLONG";
sonhatky4.DIEN_GIAI_CHUNG = unc.NOI_DUNG_THANH_TOAN;
sonhatky4.DIEN_GIAI_CHI_TIET = newItem.DIEN_GIAI;
sonhatky4.TAI_KHOAN_HACH_TOAN = newItem.TK_NO;
sonhatky4.TAI_KHOAN_DOI_UNG = newItem.TK_THUE_GTGT;
sonhatky4.PHAT_SINH_NO = 0;
sonhatky4.PHAT_SINH_CO = Convert.ToDecimal(newItem.TIEN_THUE_GTGT);
db.KT_SO_NHAT_KY_CHUNG.Add(sonhatky4);
db.SaveChanges();
}
}
}
unc.TONG_TIEN = tongtien;
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (NH_UNCExists(chi_nganhang.SO_CHUNG_TU))
{
return(Conflict());
}
else
{
throw;
}
}
return(Ok(unc.SO_CHUNG_TU));
}
public IHttpActionResult PostKHO_NHAP_KHO(NhapKho kho_NhapKho)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//Lưu thông tin nhập kho
KHO_NHAP_KHO nk = new KHO_NHAP_KHO();
nk.NGAY_CHUNG_TU = GeneralFunction.ConvertToTime(kho_NhapKho.NGAY_CHUNG_TU);
nk.NGAY_HACH_TOAN = GeneralFunction.ConvertToTime(kho_NhapKho.NGAY_HACH_TOAN);
nk.SO_CHUNG_TU = GeneralChungTu();
nk.NGUOI_GIAO_HANG = kho_NhapKho.NGUOI_GIAO_HANG;
nk.NGUOI_LAP_PHIEU = kho_NhapKho.NGUOI_LAP_PHIEU;
nk.MA_DOI_TUONG = kho_NhapKho.MA_DOI_TUONG;
nk.DIEN_GIAI = kho_NhapKho.DIEN_GIAI;
nk.TRUC_THUOC = "HOPLONG";
nk.LOAI_NHAP_KHO = kho_NhapKho.LOAI_NHAP_KHO;
db.KHO_NHAP_KHO.Add(nk);
//Lưu thông tin tham chiếu
if (kho_NhapKho.ThamChieu.Count > 0)
{
foreach (ThamChieu item in kho_NhapKho.ThamChieu)
{
XL_THAM_CHIEU_CHUNG_TU newItem = new XL_THAM_CHIEU_CHUNG_TU();
newItem.SO_CHUNG_TU_GOC = nk.SO_CHUNG_TU;
newItem.SO_CHUNG_TU_THAM_CHIEU = item.SO_CHUNG_TU;
db.XL_THAM_CHIEU_CHUNG_TU.Add(newItem);
}
}
//Lưu chi tiết
decimal tongtien = 0;
//HHTONKHOViewModels HHTon = new HHTONKHOViewModels();
//NhomHangViewModels NhomHang = new NhomHangViewModels();
if (kho_NhapKho.ChiTiet != null && kho_NhapKho.ChiTiet.Count > 0)
{
foreach (ChiTietNhapKho item in kho_NhapKho.ChiTiet)
{
KHO_CT_NHAP_KHO newItem = new KHO_CT_NHAP_KHO();
newItem.SO_CHUNG_TU = nk.SO_CHUNG_TU;
newItem.MA_HANG = item.MA_HANG;
newItem.MA_KHO_CON = item.MA_KHO;
newItem.TK_CO = item.TK_CO;
newItem.TK_NO = item.TK_NO;
newItem.DVT = item.DVT;
newItem.DON_GIA = Convert.ToDecimal(item.DON_GIA);
newItem.SO_LUONG = Convert.ToInt32(item.SO_LUONG);
newItem.THANH_TIEN = newItem.DON_GIA * newItem.SO_LUONG;
tongtien += newItem.THANH_TIEN;
newItem.TK_KHO = item.TK_KHO;
db.KHO_CT_NHAP_KHO.Add(newItem);
//Cập nhật hàng tồn
TONKHO_HOPLONG newHangTon = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG && x.MA_KHO_CON == item.MA_KHO).FirstOrDefault();
if (newHangTon == null)
{
newHangTon = new TONKHO_HOPLONG();
newHangTon.MA_HANG = item.MA_HANG;
newHangTon.MA_KHO_CON = item.MA_KHO;
newHangTon.SL_HOPLONG = Convert.ToInt32(item.SO_LUONG);
db.TONKHO_HOPLONG.Add(newHangTon);
}
else
{
newHangTon.SL_HOPLONG += Convert.ToInt32(item.SO_LUONG);
}
// Lưu Nhật ký
KT_SO_NHAT_KY_CHUNG sonhatky = new KT_SO_NHAT_KY_CHUNG();
sonhatky.SO_CHUNG_TU = newItem.SO_CHUNG_TU;
sonhatky.NGAY_CHUNG_TU = nk.NGAY_CHUNG_TU;
sonhatky.NGAY_HACH_TOAN = nk.NGAY_HACH_TOAN;
if (nk.MA_DOI_TUONG == null)
{
sonhatky.DOI_TUONG = nk.NGUOI_GIAO_HANG;
}
else
{
sonhatky.DOI_TUONG = nk.MA_DOI_TUONG;
}
sonhatky.TRUC_THUOC = "HOPLONG";
sonhatky.DIEN_GIAI_CHUNG = nk.DIEN_GIAI;
sonhatky.DIEN_GIAI_CHI_TIET = nk.DIEN_GIAI;
sonhatky.TAI_KHOAN_HACH_TOAN = newItem.TK_NO;
sonhatky.TAI_KHOAN_DOI_UNG = newItem.TK_CO;
sonhatky.PHAT_SINH_NO = tongtien;
sonhatky.PHAT_SINH_CO = 0;
db.KT_SO_NHAT_KY_CHUNG.Add(sonhatky);
KT_SO_NHAT_KY_CHUNG sonhatky1 = new KT_SO_NHAT_KY_CHUNG();
sonhatky1.SO_CHUNG_TU = newItem.SO_CHUNG_TU;
sonhatky1.NGAY_CHUNG_TU = nk.NGAY_CHUNG_TU;
sonhatky1.NGAY_HACH_TOAN = nk.NGAY_HACH_TOAN;
if (nk.MA_DOI_TUONG == null)
{
sonhatky1.DOI_TUONG = nk.NGUOI_GIAO_HANG;
}
else
{
sonhatky1.DOI_TUONG = nk.MA_DOI_TUONG;
}
sonhatky1.TRUC_THUOC = "HOPLONG";
sonhatky1.DIEN_GIAI_CHUNG = nk.DIEN_GIAI;
sonhatky1.DIEN_GIAI_CHI_TIET = nk.DIEN_GIAI;
sonhatky1.TAI_KHOAN_HACH_TOAN = newItem.TK_CO;
sonhatky1.TAI_KHOAN_DOI_UNG = newItem.TK_NO;
sonhatky1.PHAT_SINH_NO = 0;
sonhatky1.PHAT_SINH_CO = tongtien;
db.KT_SO_NHAT_KY_CHUNG.Add(sonhatky1);
}
}
nk.TONG_TIEN = tongtien;
//Cập nhật Hàng tồn kho
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (KHO_NHAP_KHOExists(kho_NhapKho.SO_CHUNG_TU))
{
return(Conflict());
}
else
{
throw;
}
}
return(Ok(nk.SO_CHUNG_TU));
}
public IHttpActionResult PostKNH_NTTK(ThuNganHang chi_nganhang)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//Lưu thông tin nhập kho
NH_NTTK nhnttk = new NH_NTTK();
nhnttk.NGAY_CHUNG_TU = GeneralFunction.ConvertToTime(chi_nganhang.NGAY_CHUNG_TU);
nhnttk.NGAY_HACH_TOAN = GeneralFunction.ConvertToTime(chi_nganhang.NGAY_HACH_TOAN);
nhnttk.SO_CHUNG_TU = AutoMA_DU_KIEN();
nhnttk.MA_DOI_TUONG = chi_nganhang.MA_DOI_TUONG;
nhnttk.NOP_VAO_TAI_KHOAN = chi_nganhang.NOP_VAO_TAI_KHOAN;
nhnttk.LY_DO_THU = chi_nganhang.LY_DO_THU;
nhnttk.DIEN_GIAI_LY_DO_THU = chi_nganhang.DIEN_GIAI_LY_DO_THU;
nhnttk.NHAN_VIEN_THU = chi_nganhang.NHAN_VIEN_THU;
nhnttk.NGUOI_LAP_BIEU = chi_nganhang.NGUOI_LAP_BIEU;
nhnttk.TRUC_THUOC = "HOPLONG";
db.NH_NTTK.Add(nhnttk);
//Lưu thông tin tham chiếu
if (chi_nganhang.ThamChieu.Count > 0)
{
foreach (ThamChieu item in chi_nganhang.ThamChieu)
{
XL_THAM_CHIEU_CHUNG_TU newItem = new XL_THAM_CHIEU_CHUNG_TU();
newItem.SO_CHUNG_TU_GOC = nhnttk.SO_CHUNG_TU;
newItem.SO_CHUNG_TU_THAM_CHIEU = item.SO_CHUNG_TU;
db.XL_THAM_CHIEU_CHUNG_TU.Add(newItem);
}
}
//Lưu chi tiết
decimal tongtien = 0;
//TONKHO_HOPLONG HHTon = new TONKHO_HOPLONG();
//HH_NHOM_VTHH NhomHang = new HH_NHOM_VTHH();
if (chi_nganhang.ChiTietPTNH != null && chi_nganhang.ChiTietPTNH.Count > 0)
{
foreach (ChiTietPhieuThuNH item in chi_nganhang.ChiTietPTNH)
{
NH_CT_NTTK newItem = new NH_CT_NTTK();
newItem.SO_CHUNG_TU = nhnttk.SO_CHUNG_TU;
newItem.DIEN_GIAI = item.DIEN_GIAI;
newItem.LOAI_TIEN = item.LOAI_TIEN;
newItem.TK_CO = item.TK_CO;
newItem.TK_NO = item.TK_NO;
newItem.SO_TIEN = Convert.ToDecimal(item.SO_TIEN);
newItem.TY_GIA = Convert.ToInt32(item.TY_GIA);
newItem.QUY_DOI = newItem.SO_TIEN * newItem.TY_GIA;
tongtien += newItem.QUY_DOI;
newItem.MA_DOI_TUONG = nhnttk.MA_DOI_TUONG;
newItem.DON_VI = item.DON_VI;
db.NH_CT_NTTK.Add(newItem);
}
}
//Lưu nhật ký chung
if (chi_nganhang.ChiTietPTNH != null && chi_nganhang.ChiTietPTNH.Count > 0)
{
foreach (ChiTietPhieuThuNH item in chi_nganhang.ChiTietPTNH)
{
KT_SO_NHAT_KY_CHUNG newitem = new KT_SO_NHAT_KY_CHUNG();
newitem.SO_CHUNG_TU = nhnttk.SO_CHUNG_TU;
newitem.NGAY_CHUNG_TU = nhnttk.NGAY_CHUNG_TU;
newitem.NGAY_HACH_TOAN = nhnttk.NGAY_HACH_TOAN;
newitem.DOI_TUONG = nhnttk.MA_DOI_TUONG;
newitem.TRUC_THUOC = "HOPLONG";
newitem.DIEN_GIAI_CHUNG = nhnttk.DIEN_GIAI_LY_DO_THU;
newitem.DIEN_GIAI_CHI_TIET = item.DIEN_GIAI;
newitem.TAI_KHOAN_HACH_TOAN = item.TK_NO;
newitem.TAI_KHOAN_DOI_UNG = item.TK_CO;
newitem.PHAT_SINH_NO = tongtien;
newitem.PHAT_SINH_CO = 0;
db.KT_SO_NHAT_KY_CHUNG.Add(newitem);
KT_SO_NHAT_KY_CHUNG newitem1 = new KT_SO_NHAT_KY_CHUNG();
newitem1.SO_CHUNG_TU = nhnttk.SO_CHUNG_TU;
newitem1.NGAY_CHUNG_TU = nhnttk.NGAY_CHUNG_TU;
newitem1.NGAY_HACH_TOAN = nhnttk.NGAY_HACH_TOAN;
newitem1.DOI_TUONG = nhnttk.MA_DOI_TUONG;
newitem1.TRUC_THUOC = "HOPLONG";
newitem1.DIEN_GIAI_CHUNG = nhnttk.DIEN_GIAI_LY_DO_THU;
newitem1.DIEN_GIAI_CHI_TIET = item.DIEN_GIAI;
newitem1.TAI_KHOAN_HACH_TOAN = item.TK_CO;
newitem1.TAI_KHOAN_DOI_UNG = item.TK_NO;
newitem1.PHAT_SINH_NO = 0;
newitem1.PHAT_SINH_CO = tongtien;
db.KT_SO_NHAT_KY_CHUNG.Add(newitem1);
db.SaveChanges();
}
}
nhnttk.TONG_TIEN = tongtien;
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (NH_NTTKExists(chi_nganhang.SO_CHUNG_TU))
{
return(Conflict());
}
else
{
throw;
}
}
return(Ok(nhnttk.SO_CHUNG_TU));
}
