public IHttpActionResult PutBH_CT_DON_HANG_PO(int id, BH_CT_DON_HANG_PO bH_CT_DON_HANG_PO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != bH_CT_DON_HANG_PO.ID) { return(BadRequest()); } db.Entry(bH_CT_DON_HANG_PO).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!BH_CT_DON_HANG_POExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult ThemPOTuKinhDoanh(ThongTinDonPO thongtinPO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } BH_DON_HANG_PO baogia = new BH_DON_HANG_PO(); baogia.MA_SO_PO = GenerateMaSoPO(); baogia.NGAY_LEN_PO = 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.NHAN_VIEN_QUAN_LY = thongtinPO.NHAN_VIEN_QUAN_LY; baogia.SO_BAO_GIA = thongtinPO.SO_BAO_GIA; baogia.PHI_VC = thongtinPO.PHI_VC; if (thongtinPO.NGAY_GIAO_HANG_KD != null) { baogia.NGAY_GIAO_HANG = thongtinPO.NGAY_GIAO_HANG_KD; } baogia.DIA_DIEM_GIAO_HANG = thongtinPO.DIA_DIEM_GIAO_HANG; baogia.CAN_LAY_HOA_DON = thongtinPO.CAN_LAY_HOA_DON; baogia.CAN_XUAT_NGAY = thongtinPO.CAN_XUAT_NGAY; db.BH_DON_HANG_PO.Add(baogia); db.SaveChanges(); foreach (var item in thongtinPO.ChiTietPO) { BH_CT_DON_HANG_PO lienhe = new BH_CT_DON_HANG_PO(); lienhe.MA_SO_PO = baogia.MA_SO_PO; lienhe.MA_HANG = item.MA_HANG; lienhe.MA_DIEU_CHINH = item.MA_DIEU_CHINH; 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 = thongtinPO.THUE_SUAT_GTGT; lienhe.TIEN_THUE_GTGT = ((Convert.ToDouble(item.THANH_TIEN_HANG) * (thongtinPO.THUE_SUAT_GTGT / 100))); lienhe.TIEN_THANH_TOAN = Convert.ToDouble(lienhe.THANH_TIEN_HANG) + lienhe.TIEN_THUE_GTGT; db.BH_CT_DON_HANG_PO.Add(lienhe); } try { db.SaveChanges(); } catch (DbUpdateException) { throw; } return(Ok(baogia.MA_SO_PO)); }
public IHttpActionResult GetBH_CT_DON_HANG_PO(int id) { BH_CT_DON_HANG_PO bH_CT_DON_HANG_PO = db.BH_CT_DON_HANG_PO.Find(id); if (bH_CT_DON_HANG_PO == null) { return(NotFound()); } return(Ok(bH_CT_DON_HANG_PO)); }
public IHttpActionResult PostBH_CT_DON_HANG_PO(BH_CT_DON_HANG_PO bH_CT_DON_HANG_PO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.BH_CT_DON_HANG_PO.Add(bH_CT_DON_HANG_PO); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = bH_CT_DON_HANG_PO.ID }, bH_CT_DON_HANG_PO)); }
public IHttpActionResult DeleteBH_CT_DON_HANG_PO(int id) { BH_CT_DON_HANG_PO bH_CT_DON_HANG_PO = db.BH_CT_DON_HANG_PO.Find(id); if (bH_CT_DON_HANG_PO == null) { return(NotFound()); } db.BH_CT_DON_HANG_PO.Remove(bH_CT_DON_HANG_PO); db.SaveChanges(); return(Ok(bH_CT_DON_HANG_PO)); }
public IHttpActionResult PostKHO_GIU_HANG1(KhoGiu khogiuhang) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } KHO_GIU_HANG kg = new KHO_GIU_HANG(); kg.SALES_GIU = khogiuhang.SALES_GIU; kg.MA_KHACH_HANG = khogiuhang.MA_KHACH_HANG; kg.NGAY_GIU = DateTime.Today.Date; kg.MA_HANG = khogiuhang.MA_HANG; kg.SL_GIU = khogiuhang.SL_GIU; kg.GIU_PO = Convert.ToBoolean(khogiuhang.GIU_PO); kg.TRUC_THUOC = khogiuhang.TRUC_THUOC; kg.ID_CT_PO = khogiuhang.ID_CT_PO; db.KHO_GIU_HANG.Add(kg); TONKHO_HOPLONG newhanggiu = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == khogiuhang.MA_HANG && x.MA_KHO_CON == "IVHOPLONG05").FirstOrDefault(); if (newhanggiu == null) { TONKHO_HOPLONG soluonggiumoi = new TONKHO_HOPLONG(); soluonggiumoi.MA_HANG = khogiuhang.MA_HANG; soluonggiumoi.MA_KHO_CON = "IVHOPLONG05"; soluonggiumoi.SL_HOPLONG = Convert.ToInt32(khogiuhang.SL_GIU); db.TONKHO_HOPLONG.Add(soluonggiumoi); db.SaveChanges(); } else { newhanggiu.SL_HOPLONG += Convert.ToInt32(khogiuhang.SL_GIU); } foreach (TonKho item in khogiuhang.TonKho) { //Cập nhật hàng tồn TONKHO_HOPLONG newHangTon = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == khogiuhang.MA_HANG && x.MA_KHO_CON == item.MA_KHO).FirstOrDefault(); if (newHangTon != null) { newHangTon.SL_HOPLONG = newHangTon.SL_HOPLONG - Convert.ToInt32(item.TON_TANG_2) - Convert.ToInt32(item.TON_TANG_3) - Convert.ToInt32(item.TON_TANG_4); } //if (newHangTon == null || newHangTon.SL_HOPLONG < khogiuhang.SL_GIU) //{ // return Ok("Hàng không có trong kho hoặc SL tồn không đủ"); //} BH_CT_DON_HANG_PO trangthai = db.BH_CT_DON_HANG_PO.Where(x => x.ID == khogiuhang.ID_CT_PO).FirstOrDefault(); if (trangthai != null) { trangthai.CAN_GIU_HANG = true; } db.SaveChanges(); var dagiu = db.BH_CT_DON_HANG_PO.Where(x => x.MA_SO_PO == khogiuhang.MA_SO_PO && x.CAN_GIU_HANG == false).ToList().Count(); if (dagiu == 0) { var dagiuhang = db.BH_DON_HANG_PO.Where(x => x.MA_SO_PO == khogiuhang.MA_SO_PO).FirstOrDefault(); if (dagiuhang != null) { dagiuhang.DA_GIU = true; } } } try { db.SaveChanges(); } catch (DbUpdateException) { throw; } return(Ok()); }
public IHttpActionResult PostDon_Hang_PO(ThongTinDonPO thongtinPO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } BH_DON_HANG_PO baogia = new BH_DON_HANG_PO(); baogia.MA_SO_PO = GenerateMaSoPO(); baogia.NGAY_LEN_PO = 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.PHI_VC = thongtinPO.PHI_VC; baogia.TRUC_THUOC = thongtinPO.TRUC_THUOC; baogia.DA_BAN_HANG = thongtinPO.DA_BAN_HANG; baogia.NHAN_VIEN_QUAN_LY = thongtinPO.NHAN_VIEN_QUAN_LY; baogia.SO_BAO_GIA = thongtinPO.SO_BAO_GIA; 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.CAN_LAY_HOA_DON = thongtinPO.CAN_LAY_HOA_DON; baogia.CAN_XUAT_NGAY = thongtinPO.CAN_XUAT_NGAY; db.BH_DON_HANG_PO.Add(baogia); db.SaveChanges(); foreach (var item in thongtinPO.ChiTietPO) { var query = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG).ToList(); //tongton = 0; //if (query != null) //{ // foreach (var tonkho in query) // { // tongton = tongton + tonkho.SL_HOPLONG; // } //} else //{ // tongton = 0; //} BH_CT_DON_HANG_PO lienhe = new BH_CT_DON_HANG_PO(); lienhe.MA_SO_PO = baogia.MA_SO_PO; lienhe.MA_HANG = item.MA_HANG; lienhe.MA_DIEU_CHINH = item.MA_DIEU_CHINH; 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 = thongtinPO.THUE_SUAT_GTGT; lienhe.TIEN_THUE_GTGT = ((Convert.ToDouble(item.THANH_TIEN_HANG) * (thongtinPO.THUE_SUAT_GTGT / 100))); lienhe.TIEN_THANH_TOAN = Convert.ToDouble(lienhe.THANH_TIEN_HANG) + lienhe.TIEN_THUE_GTGT; //if(item.SO_LUONG <= tongton) //{ // lienhe.CAN_GIU_HANG = true; // lienhe.CAN_DAT_HANG = false; //} else if(item.SO_LUONG > tongton) //{ // lienhe.CAN_GIU_HANG = false; // lienhe.CAN_DAT_HANG = true; //} db.BH_CT_DON_HANG_PO.Add(lienhe); } try { db.SaveChanges(); } catch (DbUpdateException) { throw; } return(Ok(baogia.MA_SO_PO)); }