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 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 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);
}
// GET: TransferStock
public ActionResult Index()
{
ViewBag.ListOutlet = new SelectList(OutletDAL.GetData(), "ID", "OutletName");
var UserId = User.Identity.GetUserId();
ViewBag.Transfer = new SelectList(EmployeeOutletDAL.GetDataByID(int.Parse(UserId)), "OutletID", "OutletName");
return(View());
}
public ActionResult Add()
{
var UserId = User.Identity.GetUserId();
ViewBag.ListOutlet = new SelectList(EmployeeOutletDAL.GetDataByID(int.Parse(UserId)), "OutletID", "OutletName");
ViewBag.ListSupplier = new SelectList(SuppliersDAL.GetData(), "ID", "Name");
return(PartialView("Add"));
}
public ActionResult Add()
{
var UserId = User.Identity.GetUserId();
ViewBag.Transfer = new SelectList(EmployeeOutletDAL.GetDataByID(int.Parse(UserId)), "OutletID", "OutletName");
AdjustmentViewModel model = new AdjustmentViewModel();
return(PartialView("Add", model));
}
public ActionResult Edit(int Id)
{
var UserId = User.Identity.GetUserId();
ViewBag.ListOutlet = new SelectList(EmployeeOutletDAL.GetDataByID(int.Parse(UserId)), "OutletID", "OutletName");
ViewBag.ListSupplier = new SelectList(SuppliersDAL.GetData(), "ID", "Name");
ListPurchaseOrderViewModel model = PurchaseOrderDAL.GetDataByIdPO(Id);
return(PartialView("Edit", 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));
}
