public ActionResult AddProduct()
{
int qid = Request.Form["TransferStockId"].ParseInt();
var id = Request.Form["selProduct"].Split(':'); // ProductId:PriceNet
int qty = Request.Form["RequestQty"].ParseInt();
int WHId = Request.Form["selWareHose"].ParseInt();
if (id.Count() > 0)
{
int pid = int.Parse(id[0]);
int seq = uow.Modules.TransferStock.GetDetails(qid) + 1;
TransferStockDetail ob = uow.Modules.TransferStock.GetDetail(0);
ob.TransferStockId = qid;
ob.ProductId = pid;
ob.RequestQty = qty;
ob.Seq = seq;
ob.WHId = WHId;
bool result = uow.Modules.TransferStock.Add(ob);
//uow.Modules.TransferStock.SetDetail(ob);
//uow.SaveChanges();
}
return(RedirectToAction("Detail", MVCController, new { id = qid, tab = "Product", msg = "บันทึกข้อมูลสินค้าเรียบร้อยแล้ว", msgType = AlertMsgType.Success }));
}
public void DeleteDetail(TransferStockDetail ob)
{
if (IsExist(ob.TransferStockId))
{
db.TransferStockDetail.Remove(ob);
}
}
public bool Add(TransferStockDetail dto)
{
bool result = false;
string sql = "sp_TransferStockDetail_Insert";
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@TransferStockId", dto.TransferStockId));
paramList.Add(new SqlParameter("@ProductId", dto.ProductId));
paramList.Add(new SqlParameter("@RequestQty", dto.RequestQty));
paramList.Add(new SqlParameter("@Seq", dto.Seq));
paramList.Add(new SqlParameter("@WHId", dto.WHId));
try
{
result = webdb.ExcecuteNonQuery(sql, paramList);
}
catch (Exception ex)
{
throw new Exception("sp_TransferStockDetail_Insert::" + ex.ToString());
}
finally
{ }
return(result);
}
public void SetDetail(TransferStockDetail ob)
{
db.TransferStockDetail.Add(ob);
/* if (ob.TransferId == 0)
* { db.TransferDetail.Add(ob); }
* else { db.Entry(ob).State = EntityState.Modified; }*/
}
public bool Del(TransferStockDetail dto)
{
bool result = false;
string sql = "sp_TransferStockDetail_Delete";
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@TransferStockId", dto.TransferStockId));
paramList.Add(new SqlParameter("@Seq", dto.Seq));
try
{
result = webdb.ExcecuteNonQuery(sql, paramList);
}
catch (Exception ex)
{
throw new Exception("sp_TransferStockDetail_Delete::" + ex.ToString());
}
finally
{ }
return(result);
}
//[Authorized]
public ActionResult DetailDelete()
{
int qid = Request.Form["TransferStockId"].ParseInt();
try
{
int Seq = Request.Form["Seq"].ParseInt();
TransferStockDetail ob = uow.Modules.TransferStock.GetDetail(qid, Seq);
if (ob == null)
{
return(RedirectToAction("Detail", MVCController, new { id = qid, tab = "Product", msg = "ไม่พบข้อมูลที่ต้องการ", msgType = AlertMsgType.Warning }));
}
ob.TransferStockId = qid;
ob.Seq = Seq;
bool result = uow.Modules.TransferStock.Del(ob);
//uow.Modules.TransferStock.DeleteDetail(ob);
//uow.SaveChanges();
return(RedirectToAction("Detail", MVCController, new { id = qid, tab = "Product", msg = "ลบข้อมูลเรียบร้อยแล้ว", msgType = AlertMsgType.Success }));
}
catch (Exception ex)
{ return(RedirectToAction("Detail", MVCController, new { id = qid, tab = "Product", msg = ex.GetMessage(), msgType = AlertMsgType.Danger })); }
}
public ActionResult Index(TransferViewModel model) //tambahin kodingan utk rollback
{
if (ModelState.IsValid)
{
using (POSContext context = new POSContext())
{
using (var dbTransaction = context.Database.BeginTransaction())
{
int UserId = User.Identity.GetUserId <int>();
int OutletId = 0;
OutletId = (int)EmployeeOutletDAL.GetDataOutletByUserId(UserId).OutletID;
TransferStock item = new TransferStock()
{
ID = model.ID,
FromOutlet = OutletId,
ToOutlet = model.ToOutlet,
Note = model.Note,
CreatedBy = UserId,
CreatedOn = DateTime.Now,
ModifiedBy = UserId,
ModifiedOn = DateTime.Now,
};
context.TTransferStock.Add(item);
try { context.SaveChanges(); }
catch (Exception) { }
int i = 0;
foreach (var detail in model.VariantID) //pakai Sku hasil null, pakai Variant ID hasil null
{
TransferStockDetail vDetail = new TransferStockDetail()
{
HeaderID = item.ID,
VariantID = detail,
InStock = model.InStock[i],
Quantity = model.Quantity[i],
CreatedBy = UserId,
CreatedOn = DateTime.Now,
ModifiedBy = UserId,
ModifiedOn = DateTime.Now,
};
context.TTransferStockDetail.Add(vDetail);
ItemsIventory vInv = context.TItemsIventory.Where(t => t.VariantID == detail).FirstOrDefault();
if (vInv != null)
{
vInv.VariantID = detail;
vInv.Beginning = model.InStock[i];
vInv.Transfer = model.Quantity[i];
vInv.CreatedBy = UserId;
vInv.CreatedOn = DateTime.Now;
vInv.ModifiedBy = UserId;
vInv.ModifiedOn = DateTime.Now;
}
;
try { context.SaveChanges(); }
catch (Exception) { }
i++;
}
try
{
dbTransaction.Commit();
return(RedirectToAction("Index"));
}
catch (Exception)
{
dbTransaction.Rollback();
}
}
}
}
return(View("Index", model));
}
