public IHttpActionResult PutQUY_PHIEU_CHI(string id, QUY_PHIEU_CHI qUY_PHIEU_CHI)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != qUY_PHIEU_CHI.SO_CHUNG_TU)
{
return(BadRequest());
}
db.Entry(qUY_PHIEU_CHI).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!QUY_PHIEU_CHIExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetQUY_PHIEU_CHI(string id)
{
QUY_PHIEU_CHI qUY_PHIEU_CHI = db.QUY_PHIEU_CHI.Find(id);
if (qUY_PHIEU_CHI == null)
{
return(NotFound());
}
return(Ok(qUY_PHIEU_CHI));
}
public IHttpActionResult DeleteQUY_PHIEU_CHI(string id)
{
QUY_PHIEU_CHI qUY_PHIEU_CHI = db.QUY_PHIEU_CHI.Find(id);
if (qUY_PHIEU_CHI == null)
{
return(NotFound());
}
db.QUY_PHIEU_CHI.Remove(qUY_PHIEU_CHI);
db.SaveChanges();
return(Ok(qUY_PHIEU_CHI));
}
public IHttpActionResult PostQUY_PHIEUCHI(QuyPhieuChi quy_phieuchi)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//Lưu thông tin nhập kho
QUY_PHIEU_CHI qpc = new QUY_PHIEU_CHI();
qpc.NGAY_CHUNG_TU = GeneralFunction.ConvertToTime(quy_phieuchi.NGAY_CHUNG_TU);
qpc.NGAY_HACH_TOAN = GeneralFunction.ConvertToTime(quy_phieuchi.NGAY_HACH_TOAN);
qpc.SO_CHUNG_TU = AutoMA_DU_KIEN();
qpc.MA_DOI_TUONG = quy_phieuchi.MA_DOI_TUONG;
qpc.LY_DO_CHI = quy_phieuchi.LY_DO_CHI;
qpc.DIEN_GIAI_LY_DO_CHI = quy_phieuchi.DIEN_GIAI_LY_DO_CHI;
qpc.NGUOI_NHAN = quy_phieuchi.NGUOI_NHAN;
qpc.NHAN_VIEN_MUA_HANG = quy_phieuchi.NHAN_VIEN_MUA_HANG;
qpc.NGUOI_LAP_BIEU = quy_phieuchi.NGUOI_LAP_BIEU;
qpc.TRUC_THUOC = "HOPLONG";
db.QUY_PHIEU_CHI.Add(qpc);
//Lưu thông tin tham chiếu
if (quy_phieuchi.ThamChieu.Count > 0)
{
foreach (ThamChieu item in quy_phieuchi.ThamChieu)
{
XL_THAM_CHIEU_CHUNG_TU newItem = new XL_THAM_CHIEU_CHUNG_TU();
newItem.SO_CHUNG_TU_GOC = qpc.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 (quy_phieuchi.ChiTietQPC != null && quy_phieuchi.ChiTietQPC.Count > 0)
{
foreach (ChiTietQuyPhieuChi item in quy_phieuchi.ChiTietQPC)
{
QUY_CT_PHIEU_CHI newItem = new QUY_CT_PHIEU_CHI();
newItem.SO_CHUNG_TU = qpc.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 = qpc.MA_DOI_TUONG;
newItem.TK_NGAN_HANG = item.TK_NGAN_HANG;
newItem.DIEN_GIAI_THUE = item.DIEN_GIAI_THUE;
newItem.TK_THUE_GTGT = item.TK_THUE_GTGT;
newItem.TIEN_THUE_GTGT = Convert.ToDecimal(item.TIEN_THUE_GTGT);
newItem.CK_THUE_GTGT = item.CK_THUE_GTGT;
newItem.GIA_TRI_HHDV_CHUA_THUE = Convert.ToDecimal(item.GIA_TRI_HHDV_CHUA_THUE);
newItem.NGAY_HD = Convert.ToDateTime(item.NGAY_HD);
newItem.SO_HD = item.SO_HD;
newItem.MAU_SO_HD = item.MAU_SO_HD;
newItem.KY_HIEU_HD = item.KY_HIEU_HD;
if (qpc.MA_DOI_TUONG.Substring(0, 3) == "NCC")
{
newItem.MA_NHA_CUNG_CAP = qpc.MA_DOI_TUONG;
}
else
{
newItem.MA_NHA_CUNG_CAP = null;
}
db.QUY_CT_PHIEU_CHI.Add(newItem);
}
}
//Lưu nhật ký chung
if (quy_phieuchi.ChiTietQPC != null && quy_phieuchi.ChiTietQPC.Count > 0)
{
foreach (ChiTietQuyPhieuChi item in quy_phieuchi.ChiTietQPC)
{
KT_SO_NHAT_KY_CHUNG newitem = new KT_SO_NHAT_KY_CHUNG();
newitem.SO_CHUNG_TU = qpc.SO_CHUNG_TU;
newitem.NGAY_CHUNG_TU = qpc.NGAY_CHUNG_TU;
newitem.NGAY_HACH_TOAN = qpc.NGAY_HACH_TOAN;
newitem.DOI_TUONG = qpc.MA_DOI_TUONG;
newitem.TRUC_THUOC = "HOPLONG";
newitem.DIEN_GIAI_CHUNG = qpc.DIEN_GIAI_LY_DO_CHI;
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 = qpc.SO_CHUNG_TU;
newitem1.NGAY_CHUNG_TU = qpc.NGAY_CHUNG_TU;
newitem1.NGAY_HACH_TOAN = qpc.NGAY_HACH_TOAN;
newitem1.DOI_TUONG = qpc.MA_DOI_TUONG;
newitem1.TRUC_THUOC = "HOPLONG";
newitem1.DIEN_GIAI_CHUNG = qpc.DIEN_GIAI_LY_DO_CHI;
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);
if (item.TK_THUE_GTGT != null)
{
KT_SO_NHAT_KY_CHUNG newitem2 = new KT_SO_NHAT_KY_CHUNG();
newitem2.SO_CHUNG_TU = qpc.SO_CHUNG_TU;
newitem2.NGAY_CHUNG_TU = qpc.NGAY_CHUNG_TU;
newitem2.NGAY_HACH_TOAN = qpc.NGAY_HACH_TOAN;
newitem2.DOI_TUONG = qpc.MA_DOI_TUONG;
newitem2.TRUC_THUOC = "HOPLONG";
newitem2.DIEN_GIAI_CHUNG = qpc.DIEN_GIAI_LY_DO_CHI;
newitem2.DIEN_GIAI_CHI_TIET = item.DIEN_GIAI;
newitem2.TAI_KHOAN_HACH_TOAN = item.TK_THUE_GTGT;
newitem2.TAI_KHOAN_DOI_UNG = item.TK_NO;
newitem2.PHAT_SINH_NO = item.TIEN_THUE_GTGT;
newitem2.PHAT_SINH_CO = 0;
db.KT_SO_NHAT_KY_CHUNG.Add(newitem2);
KT_SO_NHAT_KY_CHUNG newitem3 = new KT_SO_NHAT_KY_CHUNG();
newitem3.SO_CHUNG_TU = qpc.SO_CHUNG_TU;
newitem3.NGAY_CHUNG_TU = qpc.NGAY_CHUNG_TU;
newitem3.NGAY_HACH_TOAN = qpc.NGAY_HACH_TOAN;
newitem3.DOI_TUONG = qpc.MA_DOI_TUONG;
newitem3.TRUC_THUOC = "HOPLONG";
newitem3.DIEN_GIAI_CHUNG = qpc.DIEN_GIAI_LY_DO_CHI;
newitem3.DIEN_GIAI_CHI_TIET = item.DIEN_GIAI;
newitem3.TAI_KHOAN_HACH_TOAN = item.TK_NO;
newitem3.TAI_KHOAN_DOI_UNG = item.TK_THUE_GTGT;
newitem3.PHAT_SINH_NO = 0;
newitem3.PHAT_SINH_CO = item.TIEN_THUE_GTGT;
db.KT_SO_NHAT_KY_CHUNG.Add(newitem3);
db.SaveChanges();
}
}
}
qpc.TONG_TIEN = tongtien;
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (QUY_PHIEU_CHIExists(quy_phieuchi.SO_CHUNG_TU))
{
return(Conflict());
}
else
{
throw;
}
}
return(Ok(qpc.SO_CHUNG_TU));
}
