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