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