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