public IHttpActionResult DeleteKHO_CHUYEN_KHO(string id)
{
KHO_CHUYEN_KHO kHO_CHUYEN_KHO = db.KHO_CHUYEN_KHO.Find(id);
if (kHO_CHUYEN_KHO == null)
{
return(NotFound());
}
db.KHO_CHUYEN_KHO.Remove(kHO_CHUYEN_KHO);
db.SaveChanges();
return(Ok(kHO_CHUYEN_KHO));
}
public IHttpActionResult ChuyenKhoGiuHang(int id, ChuyenKho chuyenkho)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
KHO_CHUYEN_KHO kho = new KHO_CHUYEN_KHO();
kho.SO_CHUNG_TU = GeneralChungTu();
kho.NGAY_CHUNG_TU = DateTime.Today.Date;
kho.NGAY_HACH_TOAN = DateTime.Today.Date;
kho.NGUOI_LAP_PHIEU = chuyenkho.NGUOI_LAP_PHIEU;
kho.TRUC_THUOC = chuyenkho.TRUC_THUOC;
kho.DIEN_GIAI = chuyenkho.DIEN_GIAI;
db.KHO_CHUYEN_KHO.Add(kho);
// Chi tiết chuyển kho
foreach (ChiTietChuyenKho item in chuyenkho.ChiTiet)
{
KHO_CT_CHUYEN_KHO newItem = new KHO_CT_CHUYEN_KHO();
newItem.SO_CHUNG_TU = kho.SO_CHUNG_TU;
newItem.MA_HANG = item.MA_HANG;
newItem.XUAT_TAI_KHO = item.MA_KHO_CON;
newItem.NHAP_TAI_KHO = item.NHAP_TAI_KHO;
newItem.SO_LUONG = item.SO_LUONG;
newItem.DVT = item.DVT;
db.KHO_CT_CHUYEN_KHO.Add(newItem);
//Chuyển hàng vào kho
TONKHO_HOPLONG newkhoxuat = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG && x.MA_KHO_CON == item.MA_KHO_CON).FirstOrDefault();
if (newkhoxuat == null || newkhoxuat.SL_HOPLONG < item.SO_LUONG)
{
return(Ok("Hàng không có trong kho hoặc SL tồn không đủ"));
}
newkhoxuat.SL_HOPLONG -= Convert.ToInt32(item.SO_LUONG);
TONKHO_HOPLONG newkhonhap = db.TONKHO_HOPLONG.Where(x => x.MA_HANG == item.MA_HANG && x.MA_KHO_CON == item.NHAP_TAI_KHO).FirstOrDefault();
if (newkhonhap == null)
{
newkhonhap = new TONKHO_HOPLONG();
newkhonhap.MA_HANG = item.MA_HANG;
newkhonhap.MA_KHO_CON = item.NHAP_TAI_KHO;
newkhonhap.SL_HOPLONG = Convert.ToInt32(item.SO_LUONG);
db.TONKHO_HOPLONG.Add(newkhonhap);
}
else
{
newkhonhap.MA_HANG = item.MA_HANG;
newkhonhap.SL_HOPLONG += Convert.ToInt32(item.SO_LUONG);
}
}
var query = db.BH_CT_DON_HANG_PO.Where(x => x.ID == id).FirstOrDefault();
query.CAN_GIU_HANG = true;
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (KHO_CHUYEN_KHOExists(chuyenkho.SO_CHUNG_TU))
{
return(Conflict());
}
else
{
throw;
}
}
return(Ok(kho.SO_CHUNG_TU));
}
