public IHttpActionResult PostBH_CT_DON_BAN_HANG(BH_CT_DON_BAN_HANG bH_CT_DON_BAN_HANG) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.BH_CT_DON_BAN_HANG.Add(bH_CT_DON_BAN_HANG); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = bH_CT_DON_BAN_HANG.ID }, bH_CT_DON_BAN_HANG)); }
public IHttpActionResult DeleteBH_CT_DON_BAN_HANG(int id) { BH_CT_DON_BAN_HANG bH_CT_DON_BAN_HANG = db.BH_CT_DON_BAN_HANG.Find(id); if (bH_CT_DON_BAN_HANG == null) { return(NotFound()); } db.BH_CT_DON_BAN_HANG.Remove(bH_CT_DON_BAN_HANG); db.SaveChanges(); return(Ok(bH_CT_DON_BAN_HANG)); }
public IHttpActionResult PostThemPhieuBanHang(ThongTinDonPO thongtinPO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } BH_DON_BAN_HANG baogia = new BH_DON_BAN_HANG(); baogia.MA_SO_BH = GenerateSoBanHang(); baogia.NGAY_BH = DateTime.Today.Date; baogia.MA_KHACH_HANG = thongtinPO.MA_KHACH_HANG; baogia.TEN_LIEN_HE = thongtinPO.TEN_LIEN_HE; baogia.HINH_THUC_THANH_TOAN = thongtinPO.HINH_THUC_THANH_TOAN; baogia.TONG_TIEN_THANH_TOAN = thongtinPO.TONG_TIEN_THANH_TOAN; baogia.TONG_TIEN_HANG = thongtinPO.TONG_TIEN_HANG; baogia.TONG_TIEN_THUE_GTGT = thongtinPO.TONG_TIEN_THUE_GTGT; baogia.SO_TIEN_VIET_BANG_CHU = thongtinPO.SO_TIEN_VIET_BANG_CHU; baogia.TRUC_THUOC = thongtinPO.TRUC_THUOC; baogia.DA_LAP_HOA_DON = thongtinPO.DA_LAP_HOA_DON; baogia.NHAN_VIEN_QUAN_LY = thongtinPO.NHAN_VIEN_QUAN_LY; if (thongtinPO.NGAY_GIAO_HANG != null) { baogia.NGAY_GIAO_HANG = xlnt.Xulydatetime(thongtinPO.NGAY_GIAO_HANG.ToString()); } baogia.DIA_DIEM_GIAO_HANG = thongtinPO.DIA_DIEM_GIAO_HANG; baogia.DA_XUAT_KHO = thongtinPO.DA_XUAT_KHO; baogia.MA_SO_PO = thongtinPO.MA_SO_PO; db.BH_DON_BAN_HANG.Add(baogia); db.SaveChanges(); foreach (var item in thongtinPO.ChiTietPO) { BH_CT_DON_BAN_HANG lienhe = new BH_CT_DON_BAN_HANG(); lienhe.MA_SO_BH = baogia.MA_SO_BH; lienhe.MA_HANG = item.MA_HANG; lienhe.MA_DIEU_CHINH = item.MA_DIEU_CHINH; lienhe.MA_PO = item.MA_SO_PO; lienhe.TK_CO = item.TK_CO; lienhe.TK_NO = item.TK_NO; lienhe.TK_THUE = item.TK_THUE; lienhe.SO_LUONG = item.SO_LUONG; lienhe.DVT = item.DVT; lienhe.DON_GIA = item.DON_GIA; lienhe.THANH_TIEN_HANG = item.THANH_TIEN_HANG; lienhe.THUE_GTGT = item.THUE_GTGT; lienhe.TIEN_THUE_GTGT = ((Convert.ToDouble(item.THANH_TIEN_HANG) * (item.THUE_GTGT / 100))); lienhe.TIEN_THANH_TOAN = Convert.ToDouble(lienhe.THANH_TIEN_HANG) + lienhe.TIEN_THUE_GTGT; lienhe.DIEN_GIAI_THUE = item.DIEN_GIAI_THUE; db.BH_CT_DON_BAN_HANG.Add(lienhe); } foreach (var item in thongtinPO.ChiTietPO) { var query = db.BH_CT_DON_HANG_PO.Where(x => x.ID == item.ID).FirstOrDefault(); if (query != null) { query.DA_BAN = true; db.SaveChanges(); } } var data = db.BH_CT_DON_HANG_PO.Where(x => x.MA_SO_PO == thongtinPO.MA_SO_PO && x.DA_BAN == false).ToList(); if (data.Count() == 0) { var data1 = db.BH_DON_HANG_PO.Where(x => x.MA_SO_PO == thongtinPO.MA_SO_PO).FirstOrDefault(); if (data1 != null) { data1.DA_BAN_HANG = true; } } try { db.SaveChanges(); } catch (DbUpdateException) { throw; } return(Ok(baogia.MA_SO_BH)); }