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