public async Task <IHttpActionResult> XuLyChyenSale([FromBody] KH_CHUYEN_SALES datachuyensale)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
var query = db.KH_CHUYEN_SALES.Where(x => x.MA_KHACH_HANG == datachuyensale.MA_KHACH_HANG).FirstOrDefault();
if (query == null)
{
KH_CHUYEN_SALES chuyensale = new KH_CHUYEN_SALES();
chuyensale.MA_KHACH_HANG = datachuyensale.MA_KHACH_HANG;
chuyensale.SALE_HIEN_THOI = datachuyensale.SALE_HIEN_THOI;
chuyensale.KHO_PHU_TRACH = datachuyensale.KHO_PHU_TRACH;
db.KH_CHUYEN_SALES.Add(chuyensale);
}
else
{
query.KHO_PHU_TRACH = datachuyensale.KHO_PHU_TRACH;
query.SALE_CU_2 = query.SALE_CU;
query.SALE_CU = query.SALE_HIEN_THOI;
query.SALE_HIEN_THOI = datachuyensale.SALE_HIEN_THOI;
}
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
throw;
}
//return this.CreatedAtRoute("GetNH_NTTK", new { id = nH_NTTK.SO_CHUNG_TU }, nH_NTTK);
return(Ok(datachuyensale));
}
public async Task <IHttpActionResult> EditChiTietPO([FromBody] List <ChiTietPOMuaHang> mH_CT_DON_HANG_PO)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
//if (id != bH_CT_DON_HANG_PO.ID)
//{
// return BadRequest();
//}
foreach (var item in mH_CT_DON_HANG_PO)
{
var donhangPO = db.MH_PO_CT_MUA_HANG.Where(x => x.ID == item.ID).FirstOrDefault();
if (donhangPO != null)
{
donhangPO.SL = item.SL;
donhangPO.DON_GIA_CHUA_VAT = item.DON_GIA_CHUA_VAT;
donhangPO.THANH_TIEN_CHUA_VAT = item.THANH_TIEN_CHUA_VAT;
donhangPO.THOI_GIAN_GIAO_HANG = item.THOI_GIAN_GIAO_HANG;
donhangPO.GHI_CHU = item.GHI_CHU;
}
}
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
throw;
}
//return this.CreatedAtRoute("GetNH_NTTK", new { id = nH_NTTK.SO_CHUNG_TU }, nH_NTTK);
return(Ok(mH_CT_DON_HANG_PO));
}
public async Task <IHttpActionResult> PutXuLyHoiHang(int id, [FromBody] List <XuLyHoiHang> bH_CT_BAO_GIA)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
//try
//{
foreach (var item in bH_CT_BAO_GIA)
{
var baogia = db.MH_XL_YEU_CAU_HOI_GIA.Where(x => x.ID == item.ID).FirstOrDefault();
if (baogia != null)
{
baogia.MA_HANG = item.MA_HANG;
baogia.MA_KHACH_ORDER = item.MA_KHACH_ORDER;
baogia.SO_LUONG = item.SO_LUONG;
baogia.MA_NCC = item.MA_NCC;
baogia.GIA = item.GIA;
baogia.THOI_GIAN_CAP_HANG = item.THOI_GIAN_CAP_HANG;
if (item.NGAY_HOI_GIA != null)
{
baogia.NGAY_HOI_GIA = item.NGAY_HOI_GIA;
}
baogia.TRUC_THUOC = item.TRUC_THUOC;
baogia.PUR_XU_LY = item.PUR_XU_LY;
baogia.GHI_CHU = item.GHI_CHU;
db.SaveChanges();
}
else if (baogia == null)
{
MH_XL_YEU_CAU_HOI_GIA newxuly = new MH_XL_YEU_CAU_HOI_GIA();
newxuly.ID_YEU_CAU_HOI_GIA = id;
newxuly.MA_HANG = item.MA_HANG;
newxuly.MA_KHACH_ORDER = item.MA_KHACH_ORDER;
newxuly.SO_LUONG = item.SO_LUONG;
newxuly.MA_NCC = item.MA_NCC;
newxuly.GIA = item.GIA;
newxuly.THOI_GIAN_CAP_HANG = item.THOI_GIAN_CAP_HANG;
newxuly.NGAY_HOI_GIA = DateTime.Today.Date;
newxuly.TRUC_THUOC = item.TRUC_THUOC;
newxuly.PUR_XU_LY = item.PUR_XU_LY;
newxuly.GHI_CHU = item.GHI_CHU;
db.MH_XL_YEU_CAU_HOI_GIA.Add(newxuly);
}
}
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
throw;
}
//return this.CreatedAtRoute("GetNH_NTTK", new { id = nH_NTTK.SO_CHUNG_TU }, nH_NTTK);
return(Ok(bH_CT_BAO_GIA));
}
public async Task <IHttpActionResult> PutBH_CT_DON_HANG_PO([FromBody] List <ChiTietDonHangPO> bH_CT_DON_HANG_PO)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
//if (id != bH_CT_DON_HANG_PO.ID)
//{
// return BadRequest();
//}
foreach (var item in bH_CT_DON_HANG_PO)
{
var donhangPO = db.BH_CT_DON_HANG_PO.Where(x => x.ID == item.ID).FirstOrDefault();
if (donhangPO != null)
{
donhangPO.MA_HANG = item.MA_HANG;
donhangPO.SO_LUONG = item.SO_LUONG;
donhangPO.DON_GIA = item.DON_GIA;
donhangPO.MA_DIEU_CHINH = item.MA_DIEU_CHINH;
donhangPO.DVT = item.DVT;
donhangPO.THANH_TIEN_HANG = item.THANH_TIEN_HANG;
donhangPO.THUE_GTGT = item.THUE_GTGT;
donhangPO.TIEN_THUE_GTGT = item.TIEN_THUE_GTGT;
donhangPO.TIEN_THANH_TOAN = item.TIEN_THANH_TOAN;
}
}
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
throw;
}
//return this.CreatedAtRoute("GetNH_NTTK", new { id = nH_NTTK.SO_CHUNG_TU }, nH_NTTK);
return(Ok(bH_CT_DON_HANG_PO));
}
public async Task <IHttpActionResult> PostMultiNCC_TK_NGAN_HANG(string mancc, [FromBody] List <NCC_TK_NGAN_HANG> qUY_CHI_TIET_PHIEU_CHI)
{
for (int i = 0; i < qUY_CHI_TIET_PHIEU_CHI.Count(); i++)
{
//nH_NTTKs[i].ID = (index + i + 1).ToString();
db.NCC_TK_NGAN_HANG.Add(qUY_CHI_TIET_PHIEU_CHI[i]);
}
try
{
await db.SaveChangesAsync();
}
catch (Exception ex)
{
return(Ok(ex.Message));
}
return(Ok(qUY_CHI_TIET_PHIEU_CHI));
}
public async Task <IHttpActionResult> PUTBH_CT_BAN_HANG([FromBody] List <ChiTietDonBanHang> chitietbanhang)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
//if (id != bH_CT_DON_HANG_PO.ID)
//{
// return BadRequest();
//}
foreach (var item in chitietbanhang)
{
var banhang = db.BH_CT_DON_BAN_HANG.Where(x => x.ID == item.ID).FirstOrDefault();
if (banhang != null)
{
banhang.MA_HANG = item.MA_HANG;
banhang.SO_LUONG = item.SO_LUONG;
banhang.DON_GIA = item.DON_GIA;
banhang.MA_DIEU_CHINH = item.MA_DIEU_CHINH;
banhang.DVT = item.DVT;
banhang.THANH_TIEN_HANG = item.THANH_TIEN_HANG;
banhang.THUE_GTGT = item.THUE_GTGT;
banhang.TIEN_THUE_GTGT = item.TIEN_THUE_GTGT;
banhang.TIEN_THANH_TOAN = item.TIEN_THANH_TOAN;
banhang.DIEN_GIAI_THUE = item.DIEN_GIAI_THUE;
banhang.TK_THUE = item.TK_THUE;
banhang.TK_NO = item.TK_NO;
banhang.TK_CO = item.TK_CO;
}
}
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
throw;
}
//return this.CreatedAtRoute("GetNH_NTTK", new { id = nH_NTTK.SO_CHUNG_TU }, nH_NTTK);
return(Ok(chitietbanhang));
}
public async Task <IHttpActionResult> PostKhoCT_GiuKho([FromBody] List <KHO_CT_GIU_HANG> ChiTietGiuKho)
{
foreach (var item in ChiTietGiuKho)
{
var tonkho = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG).FirstOrDefault();
if (item.SL_GIU < tonkho.SL_HOPLONG)
{
item.THANH_TIEN = item.SL_GIU * item.DON_GIA;
db.KHO_CT_GIU_HANG.Add(item);
tonkho.SL_HOPLONG = tonkho.SL_HOPLONG - item.SL_GIU;
}
}
try
{
await db.SaveChangesAsync();
}
catch (Exception ex)
{
return(Ok(ex.Message));
}
return(Ok(ChiTietGiuKho));
}
public async Task <IHttpActionResult> PutBH_CT_BAO_GIA([FromBody] List <ChiTietBaoGia> bH_CT_BAO_GIA)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
//try
//{
foreach (var item in bH_CT_BAO_GIA)
{
var baogia = db.BH_CT_BAO_GIA.Where(x => x.ID == item.ID).FirstOrDefault();
if (baogia != null)
{
baogia.MA_HANG = item.MA_HANG;
baogia.MA_DIEU_CHINH = item.MA_DIEU_CHINH;
baogia.TEN_HANG = item.TEN_HANG;
baogia.HANG_SP = item.HANG_SP;
baogia.ITEM_CODE = item.ITEM_CODE;
baogia.SO_LUONG = item.SO_LUONG;
baogia.DVT = item.DVT;
baogia.DON_GIA = item.DON_GIA;
baogia.THANH_TIEN = item.THANH_TIEN;
baogia.THANH_TIEN_NET = item.THANH_TIEN_NET;
baogia.THOI_GIAN_GIAO_HANG = item.THOI_GIAN_GIAO_HANG;
baogia.CHIET_KHAU = item.CHIET_KHAU;
baogia.GIA_LIST = item.GIA_LIST;
baogia.DON_GIA_NHAP = item.DON_GIA_NHAP;
baogia.HE_SO_LOI_NHUAN = item.HE_SO_LOI_NHUAN;
baogia.DON_GIA_BAO_DI_NET = item.DON_GIA_BAO_DI_NET;
baogia.CM = item.CM;
baogia.DON_GIA_MOI = item.DON_GIA_MOI;
baogia.THUE_TNDN = item.THUE_TNDN;
baogia.TIEN_THUE_TNDN = item.TIEN_THUE_TNDN;
baogia.KHACH_NHAN_DUOC = item.KHACH_NHAN_DUOC;
baogia.GHI_CHU = item.GHI_CHU;
}
else if (baogia == null)
{
BH_CT_BAO_GIA newbaogia = new BH_CT_BAO_GIA();
newbaogia.SO_BAO_GIA = item.SO_BAO_GIA;
newbaogia.MA_HANG = item.MA_HANG;
newbaogia.MA_DIEU_CHINH = item.MA_DIEU_CHINH;
newbaogia.TEN_HANG = item.TEN_HANG;
newbaogia.HANG_SP = item.HANG_SP;
newbaogia.ITEM_CODE = item.ITEM_CODE;
newbaogia.SO_LUONG = item.SO_LUONG;
newbaogia.DVT = item.DVT;
newbaogia.DON_GIA = item.DON_GIA;
newbaogia.THANH_TIEN = item.THANH_TIEN;
newbaogia.THANH_TIEN_NET = item.THANH_TIEN_NET;
newbaogia.THOI_GIAN_GIAO_HANG = item.THOI_GIAN_GIAO_HANG;
newbaogia.CHIET_KHAU = item.CHIET_KHAU;
newbaogia.GIA_LIST = item.GIA_LIST;
newbaogia.DON_GIA_NHAP = item.DON_GIA_NHAP;
newbaogia.HE_SO_LOI_NHUAN = item.HE_SO_LOI_NHUAN;
newbaogia.DON_GIA_BAO_DI_NET = item.DON_GIA_BAO_DI_NET;
newbaogia.CM = item.CM;
newbaogia.DON_GIA_MOI = item.DON_GIA_MOI;
newbaogia.THUE_TNDN = item.THUE_TNDN;
newbaogia.TIEN_THUE_TNDN = item.TIEN_THUE_TNDN;
newbaogia.KHACH_NHAN_DUOC = item.KHACH_NHAN_DUOC;
newbaogia.GHI_CHU = item.GHI_CHU;
db.BH_CT_BAO_GIA.Add(newbaogia);
}
}
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
throw;
}
//return this.CreatedAtRoute("GetNH_NTTK", new { id = nH_NTTK.SO_CHUNG_TU }, nH_NTTK);
return(Ok(bH_CT_BAO_GIA));
}
public async Task <IHttpActionResult> PutBH_CT_BAO_GIA([FromBody] List <ChiTietBaoGia> bH_CT_BAO_GIA)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
//try
//{
foreach (var item in bH_CT_BAO_GIA)
{
var baogia = db.BH_CT_BAO_GIA.Where(x => x.ID == item.ID).FirstOrDefault();
if (baogia != null)
{
baogia.SO_BAO_GIA = item.SO_BAO_GIA;
baogia.MA_HANG = item.MA_HANG;
baogia.SO_LUONG = item.SO_LUONG;
baogia.DON_GIA = item.DON_GIA;
baogia.DON_GIA_LIST = item.DON_GIA_LIST;
baogia.DON_GIA_NHAP = item.DON_GIA_NHAP;
baogia.HE_SO_LOI_NHUAN = item.HE_SO_LOI_NHUAN;
baogia.CHIET_KHAU = item.CHIET_KHAU;
baogia.THANH_TIEN = item.THANH_TIEN;
baogia.TINH_TRANG_HANG = item.TINH_TRANG_HANG;
baogia.THOI_GIAN_GIAO_HANG = item.THOI_GIAN_GIAO_HANG;
if (item.NGAY_GIAO_HANG != null)
{
baogia.NGAY_GIAO_HANG = xlnt.Xulydatetime(item.NGAY_GIAO_HANG.ToString());
}
baogia.DIA_DIEM_GIAO_HANG = item.DIA_DIEM_GIAO_HANG;
baogia.GHI_CHU = item.GHI_CHU;
}
else if (baogia == null)
{
BH_CT_BAO_GIA newbaogia = new BH_CT_BAO_GIA();
newbaogia.SO_BAO_GIA = item.SO_BAO_GIA;
newbaogia.MA_HANG = item.MA_HANG;
newbaogia.SO_LUONG = item.SO_LUONG;
newbaogia.DON_GIA = item.DON_GIA;
newbaogia.CHIET_KHAU = item.CHIET_KHAU;
newbaogia.THANH_TIEN = item.THANH_TIEN;
newbaogia.DON_GIA_LIST = item.DON_GIA_LIST;
newbaogia.DON_GIA_NHAP = item.DON_GIA_NHAP;
newbaogia.HE_SO_LOI_NHUAN = item.HE_SO_LOI_NHUAN;
newbaogia.TINH_TRANG_HANG = item.TINH_TRANG_HANG;
newbaogia.THOI_GIAN_GIAO_HANG = item.THOI_GIAN_GIAO_HANG;
if (item.NGAY_GIAO_HANG != null && item.NGAY_GIAO_HANG != "")
{
newbaogia.NGAY_GIAO_HANG = xlnt.Xulydatetime(item.NGAY_GIAO_HANG.ToString());
}
newbaogia.DIA_DIEM_GIAO_HANG = item.DIA_DIEM_GIAO_HANG;
newbaogia.GHI_CHU = item.GHI_CHU;
db.BH_CT_BAO_GIA.Add(newbaogia);
}
}
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
throw;
}
//return this.CreatedAtRoute("GetNH_NTTK", new { id = nH_NTTK.SO_CHUNG_TU }, nH_NTTK);
return(Ok(bH_CT_BAO_GIA));
}
