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