public ActionResult GetItems() { int UserId = User.Identity.GetUserId<int>(); int OutletId = 0; OutletId = (int)EmployeeOutletDAL.GetDataOutletByUserId(UserId).OutletID; List<ItemsViewModel> model = ItemsDAL.GetData(OutletId); return PartialView("_ListItems", model); }
public ActionResult GetItemsSearch(string searchKey) { int UserId = User.Identity.GetUserId<int>(); int OutletId = 0; OutletId = (int)EmployeeOutletDAL.GetDataOutletByUserId(UserId).OutletID; List<ItemsViewModel> models = ItemsDAL.GetDataSearch(searchKey, OutletId); return PartialView("_ListItems", models); }
public ActionResult GetVariantSearchAdj(string SearchKey) { int UserId = User.Identity.GetUserId<int>(); int OutletId = 0; OutletId = (int)EmployeeOutletDAL.GetDataOutletByUserId(UserId).OutletID; List<ItemIventoryViewModel> model = ItemIventoryDAL.GetDataByOutletSearch(SearchKey, OutletId); return PartialView("_Add", model); }
public ActionResult GetVariant() { int UserId = User.Identity.GetUserId<int>(); int OutletId = 0; OutletId = (int)EmployeeOutletDAL.GetDataOutletByUserId(UserId).OutletID; List<ItemIventoryViewModel> model = ItemIventoryDAL.GetDataByOutletid(OutletId); return PartialView("_Variant", model); }
public ActionResult Delete(ListItemViewModel model) { 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; int i = 0; foreach (var item in model.InventoryId) { ItemsIventory data3 = context.TItemsIventory.Where(x => x.ID == item).FirstOrDefault(); context.TItemsIventory.Remove(data3); try { context.SaveChanges(); } catch (Exception) { } i++; } i = 0; foreach (var item in model.VariantId) { ItemsVariant data2 = context.TItemsVariant.Where(x => x.ID == item).FirstOrDefault(); context.TItemsVariant.Remove(data2); try { context.SaveChanges(); } catch (Exception) { } i++; } Items data = context.TItems.Where(x => x.ID == model.ID).FirstOrDefault(); context.TItems.Remove(data); try { context.SaveChanges(); } catch (Exception) { } try { dbTransaction.Commit(); return(RedirectToAction("Index")); } catch (Exception) { dbTransaction.Rollback(); } } } return(PartialView("Delete", model)); }
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)); }
public ActionResult Edit(ListItemViewModel model) { 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; Items data = context.TItems.Where(x => x.ID == model.ID).FirstOrDefault(); if (data != null) { data.Name = model.Name; data.CategoryID = model.CategoryId; data.Description = model.Description; data.CreatedBy = UserId; data.CreatedOn = DateTime.Now; data.ModifiedBy = UserId; data.ModifiedOn = DateTime.Now; } try { context.SaveChanges(); } catch (Exception) { } int i = 0; foreach (var item in model.VariantId) { ItemsVariant data2 = context.TItemsVariant.Where(x => x.ID == item).FirstOrDefault(); if (data2 != null) { data2.VariantName = model.VariantName[i]; data2.Price = model.VariantPrice[i]; data2.SKU = model.VariantSKU[i]; data2.CreatedBy = UserId; data2.CreatedOn = DateTime.Now; data2.ModifiedBy = UserId; data2.ModifiedOn = DateTime.Now; } ; try { context.SaveChanges(); } catch (Exception) { } i++; } i = 0; foreach (var item in model.InventoryId) { ItemsIventory data3 = context.TItemsIventory.Where(x => x.ID == item).FirstOrDefault(); if (data3 != null) { data3.Beginning = model.Beginning[i]; data3.AlertAt = model.AlertAt[i]; data3.CreatedBy = UserId; data3.CreatedOn = DateTime.Now; data3.ModifiedBy = UserId; data3.ModifiedOn = DateTime.Now; } try { context.SaveChanges(); } catch (Exception) { } i++; } try { dbTransaction.Commit(); return(RedirectToAction("Index")); } catch (Exception) { dbTransaction.Rollback(); } } } } return(PartialView("Edit", model)); }