public ActionResult XuatHuy(ExportModelXuatHuy model)
{
var ctx = new SmsContext();
using (var transaction = new System.Transactions.TransactionScope())
{
try
{
var infor = ctx.XUAT_KHO.Create();
infor.MA_KHO_XUAT = model.Infor.MA_KHO_XUAT;
infor.NGAY_XUAT = model.Infor.NGAY_XUAT;
infor.MA_NHAN_VIEN_XUAT = Convert.ToInt32(Session["UserId"]);
infor.CREATE_AT = DateTime.Now;
infor.CREATE_BY = Convert.ToInt32(Session["UserId"]);
infor.UPDATE_AT = DateTime.Now;
infor.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
infor.ACTIVE = "A";
infor.GHI_CHU = model.Infor.GHI_CHU;
infor.LY_DO_XUAT = 1; // nhập mua hàng
ctx.XUAT_KHO.Add(infor);
ctx.SaveChanges();
CHI_TIET_XUAT_KHO exportDetail;
foreach (var detail in model.Detail)
{
if (detail.DEL_FLG != 1 && detail.MA_SAN_PHAM != null && !string.IsNullOrEmpty(detail.MA_SAN_PHAM.ToString()))
{
exportDetail = ctx.CHI_TIET_XUAT_KHO.Create();
exportDetail.ACTIVE = "A";
exportDetail.MA_SAN_PHAM = detail.MA_SAN_PHAM;
exportDetail.SO_LUONG_TEMP = detail.SO_LUONG_TEMP;
exportDetail.HE_SO = detail.HE_SO;
exportDetail.SO_LUONG = detail.SO_LUONG_TEMP * detail.HE_SO;
exportDetail.MA_DON_VI = detail.MA_DON_VI;
exportDetail.MA_XUAT_KHO = infor.MA_XUAT_KHO;
exportDetail.CREATE_AT = DateTime.Now;
exportDetail.CREATE_BY = Convert.ToInt32(Session["UserId"]);
exportDetail.UPDATE_AT = DateTime.Now;
exportDetail.UPDATE_BY = Convert.ToInt32(Session["UserId"]);
exportDetail.GIA_VON = detail.GIA_VON / detail.HE_SO;
ctx.CHI_TIET_XUAT_KHO.Add(exportDetail);
ctx.SaveChanges();
}
}
transaction.Complete();
ctx.Dispose();
return(RedirectToAction("ExportCancelList", new { @inforMessage = "Xuất hủy thành công." }));
}
catch (Exception)
{
Transaction.Current.Rollback();
ctx.Dispose();
return(RedirectToAction("ExportCancelList", new { @message = "Xuất hủy thất bại, vui lòng liên hệ admin." }));
}
}
}
public ActionResult XuatHuy()
{
var ctx = new SmsContext();
var stores = ctx.KHOes.Where(u => u.ACTIVE == "A").ToList <KHO>();
var units = ctx.DON_VI_TINH.Where(u => u.ACTIVE == "A").ToList <DON_VI_TINH>();
ViewBag.Stores = stores;
ExportModelXuatHuy model = new ExportModelXuatHuy();
XUAT_KHO Infor = new XUAT_KHO();
model.Infor = Infor;
var storeList = ctx.SP_GET_STORES_BY_USR_ID(Convert.ToInt32(Session["UserId"])).ToList <SP_GET_STORES_BY_USR_ID_Result>();
if (storeList != null && storeList.Count > 0)
{
model.Infor.MA_KHO_XUAT = storeList.First().MA_KHO;
}
model.Stores = stores;
model.Units = units;
model.StoreList = storeList;
ViewBag.InputKind = -1;
ctx.Dispose();
return(View(model));
}
