public ChiTietPOMuaHang ChiTietPOMuaHang(string masoPO)
{
var data = db.Database.SqlQuery <GetAll_ThongTinChungDonHangPO_MuaHang_Result>("GetAll_ThongTinChungDonHangPO_MuaHang @masoPO", new SqlParameter("masoPO", masoPO));
var resultdata = data.FirstOrDefault();
var query = db.Database.SqlQuery <GetAll_ChiTiet_DonHangPO_MuaHang_Result>("GetAll_ChiTiet_DonHangPO_MuaHang @masoPO", new SqlParameter("masoPO", masoPO));
var resultquery = query.ToList();
ChiTietPOMuaHang baogia = new ChiTietPOMuaHang();
baogia.ChungPO = resultdata;
baogia.ChiTietPO = resultquery;
return(baogia);
}
public IHttpActionResult PostMH_DE_NGHI_NHAP_KHO(ChiTietPOMuaHang denghinhapkho)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
MH_DE_NGHI_NHAP_KHO newdenghi = new MH_DE_NGHI_NHAP_KHO();
newdenghi.MA_SO_DN = GenerateMaSoDeNghi();
newdenghi.NGAY_DN = DateTime.Today.Date;
if (denghinhapkho.NGAY_VE_DU_KIEN != "")
{
newdenghi.NGAY_VE_DU_KIEN = xlnt.Xulydatetime(denghinhapkho.NGAY_VE_DU_KIEN);
}
newdenghi.NGUOI_DN = denghinhapkho.NGUOI_DN;
newdenghi.MA_NCC = denghinhapkho.MA_NCC;
newdenghi.ID_NGUOI_LIEN_HE = denghinhapkho.ID_NGUOI_LIEN_HE;
newdenghi.MA_SO_PO = denghinhapkho.MA_SO_PO;
newdenghi.HINH_THUC_THANH_TOAN = denghinhapkho.HINH_THUC_THANH_TOAN;
newdenghi.HINH_THUC_VAN_CHUYEN = denghinhapkho.HINH_THUC_VAN_CHUYEN;
newdenghi.THOI_HAN_THANH_TOAN = denghinhapkho.THOI_HAN_THANH_TOAN;
newdenghi.DIEN_GIAI = denghinhapkho.DIEN_GIAI;
newdenghi.TONG_TIEN_HANG = denghinhapkho.TONG_TIEN_HANG;
newdenghi.THUE_GTGT = denghinhapkho.THUE_GTGT;
newdenghi.TIEN_THUE_VAT = denghinhapkho.TIEN_THUE_VAT;
newdenghi.TONG_TIEN_DA_BAO_GOM_VAT = denghinhapkho.TONG_TIEN_DA_BAO_GOM_VAT;
newdenghi.TONG_TIEN_BANG_CHU = denghinhapkho.TONG_TIEN_BANG_CHU;
db.MH_DE_NGHI_NHAP_KHO.Add(newdenghi);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (MH_DE_NGHI_NHAP_KHOExists(denghinhapkho.MA_SO_DN))
{
return(Conflict());
}
else
{
throw;
}
}
return(Ok(newdenghi));
}
