public TransferStockHeader Get(int id) { TransferStockHeader transferStockHeader = db.TransferStockHeader .Where(x => x.TransferStockId == id) .FirstOrDefault() ?? new TransferStockHeader() { }; transferStockHeader.TransferStockDetail = (from q in db.TransferStockDetail.Include(x => x.Product) where q.TransferStockId == id select new TransferStockDetail { TransferStockId = q.TransferStockId, Seq = q.Seq, ProductId = q.ProductId, CurrentQty = q.CurrentQty, RequestQty = q.RequestQty, RequestUnit = q.RequestUnit, RequestUnitFactor = q.RequestUnitFactor, LastModified = q.LastModified, WHId = q.WHId, Product = db.TblProduct.Where(p => p.ProductId == q.ProductId).FirstOrDefault(), WareHouse = db.TblWareHouse.Where(w => w.Whid == q.WHId).FirstOrDefault(), }).ToList(); return(transferStockHeader); }
public TransferStockHeader GetHeader(int id) { TransferStockHeader transferStockHeader = (from q in db.TransferStockHeader .Where(x => x.TransferStockId == id) select new TransferStockHeader { TransferStockId = q.TransferStockId, TransferNo = q.TransferNo, TransferType = q.TransferType, TransferDate = q.TransferDate, TransferTime = q.TransferTime, ReceiveTo = q.ReceiveTo, Reason = q.Reason, CarType = q.CarType, Company = q.Company, CarNo = q.CarNo, CarBrand = q.CarBrand, SendToDepartment = q.SendToDepartment, Remark = q.Remark, EmpId = q.EmpId, BillNo = q.BillNo, TransferStatus = q.TransferStatus, Note1 = q.Note1, CreateDate = q.CreateDate, CreateBy = q.CreateBy, UpdateDate = q.UpdateDate, Status = q.Status }) .FirstOrDefault() ?? new TransferStockHeader() { }; return(transferStockHeader); }
public void Delete(TransferStockHeader ob) { if (IsExist(ob.TransferNo)) { db.TransferStockHeader.Remove(ob); } }
public void Set(TransferStockHeader ob) { if (ob.TransferStockId == 0) { db.TransferStockHeader.Add(ob); } else { db.Entry(ob).State = EntityState.Modified; } }
public ActionResult SetDetail(TransferStockHeader obj) { System.Globalization.CultureInfo _cultureTHInfo = new System.Globalization.CultureInfo("en-US"); TransferStockHeader old = uow.Modules.TransferStock.GetHeader(obj.TransferStockId); string TransferStockId = this.Request.Form["TransferStockId"]; if (TransferStockId == "" || TransferStockId == "0") { obj.TransferNo = getId("I"); obj.CreateDate = DateTime.Now; obj.TransferStatus = 0; } else { //obj.TransferStockId = Convert.ToInt32(TransferStockId); obj.UpdateDate = DateTime.Now; obj.CreateDate = old.CreateDate; obj.TransferStatus = old.TransferStatus; } obj.TransferType = "I"; if (Request.Form["TransferDate"].ToString() != "") { var dd = Request.Form["TransferDate"]; obj.TransferDate = dd.ParseDate(DateFormat.ddMMyyyy, culInfo: _cultureTHInfo); } obj.CreateBy = Convert.ToInt32(CurrentUID); try { uow.Modules.TransferStock.Set(obj); uow.SaveChanges(); } catch (Exception ex) { string msg = ex.GetMessage(true); return(ViewDetail(obj, msg, AlertMsgType.Danger)); } return(RedirectToAction("Detail", MVCController, new { id = obj.TransferStockId, msg = "บันทึกข้อมูลเรียบร้อยแล้ว", msgType = AlertMsgType.Success })); // return RedirectToAction("Detail", MVCController, new { id = 1, msg = "บันทึกข้อมูลเรียบร้อยแล้ว", msgType = AlertMsgType.Success }); }
private ActionResult ViewDetail(TransferStockHeader ob, string msg, AlertMsgType?msgType) { try { if (ob == null) { throw new Exception("ไม่พบข้อมูลที่ต้องการ, กรุณาลองใหม่อีกครั้ง"); } if (!string.IsNullOrWhiteSpace(msg)) { WidgetAlertModel alert = new WidgetAlertModel() { Message = msg }; if (msgType.HasValue) { alert.Type = msgType.Value; } ViewBag.Alert = alert; } ViewData["optCustomer"] = uow.Modules.Customer.GetAllAddress(); ViewData["optCustomerAddress"] = uow.Modules.CustomerAddress.Gets(); ViewData["optProduct"] = uow.Modules.Product.Gets(); ViewData["optContact"] = uow.Modules.CustomerContact.Gets(); ViewData["optEmployee"] = uow.Modules.Employee.Gets(); ViewData["optWareHouse"] = uow.Modules.WareHouse.Gets(); CurrentUser.TblEmployee = uow.Modules.Employee.GetEmployeeByAccount(CurrentUID); ViewData["userAccount"] = CurrentUser; return(View(ob)); } catch (Exception ex) { return(RedirectToAction("Index", MVCController, new { area = MVCArea, msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); } }
public ActionResult Detail(int?id, string msg, AlertMsgType?msgType) { TransferStockHeader ob = uow.Modules.TransferStock.Get(id ?? 0); return(ViewDetail(ob, msg, msgType)); }