public IActionResult EditDeleteStationery(string?cmd, int Id) //stationery id { if (!(HttpContext.Session.GetString("role") == EmployeeRole.STORECLERK || HttpContext.Session.GetString("role") == EmployeeRole.STOREMANAGER || HttpContext.Session.GetString("role") == EmployeeRole.STORESUPERVISOR)) { return(RedirectToAction(HttpContext.Session.GetString("role"), "Home")); } ViewData["alertMsg"] = TempData["alertMsg"]; SupplierStationery s = supService.GetSupplierStationeryById(Id); if (cmd == "delete") { supService.DeleteSupplierStationeryById(Id); TempData["alertMsg"] = "Deleted successfully!"; return(RedirectToAction("Details", new { Id = s.SupplierId })); } if (cmd == "edit") { ViewData["item"] = s; return(View("UpdateStationery")); } return(RedirectToAction("Details", new { Id = s.SupplierId })); }
public int DeleteSupplierStationery(string itemCode, string supplierCode) { SupplierStationery supplierstationery = context.SupplierStationeries.Where(x => x.ItemCode == itemCode && x.SupplierCode == supplierCode).First(); context.SupplierStationeries.Remove(supplierstationery); return(context.SaveChanges()); }
public void DeleteSupplierStationeryById(int id) { SupplierStationery supplierstationery = GetSupplierStationeryById(id); supplierstationery.InventoryItem = null; supplierstationery.Supplier = null; adProjContext.Remove(supplierstationery); adProjContext.SaveChanges(); }
public void UpdateSupplierStationeryById(int StationeryId, string SupplierId, string InventoryItemId, string UOM, float TenderPrice) { SupplierStationery item = GetSupplierStationeryById(StationeryId); item.SupplierId = SupplierId; item.UOM = UOM; item.TenderPrice = TenderPrice; adProjContext.SaveChanges(); }
public int UpdateSupplierStationery(int id, string supplierCode, string itemCode, double unitPrice, int rank) { SupplierStationery ss = context.SupplierStationeries.Where(x => x.SupplierStationeryId == id).First(); ss.SupplierCode = supplierCode; ss.ItemCode = itemCode; ss.UnitPrice = unitPrice; ss.SupplierRank = rank; return(context.SaveChanges()); }
public void CreateSupplierStationery(string SupplierId, string InventoryItemId, string UOM, float TenderPrice) { SupplierStationery item = new SupplierStationery(); item.SupplierId = SupplierId; item.InventoryItemId = InventoryItemId; item.UOM = UOM; item.TenderPrice = TenderPrice; adProjContext.Add(item); adProjContext.SaveChanges(); }
void PopulateData(Stationery stationery) { lblItemCode.Text = stationery.ItemCode; lblItemDescription.Text = stationery.Description; lblBin.Text = stationery.Bin.ToString(); lblUOM.Text = stationery.UnitOfMeasure; Label[] txbSuppliers = { lblSupplier1, lblSupplier2, lblSupplier3 }; for (int i = 1; i <= 3; i++) { SupplierStationery ss = stationery.SupplierStationeries.Where(x => x.SupplierRank == i).FirstOrDefault(); txbSuppliers[i - 1].Text = ss == null ? "NIL" : ss.Supplier.SupplierName; } int storeClerkId = (int)Session["employeeId"]; gvMaintainStockCard.DataSource = StockManagementBizLogic.getStockManagements(stationery.ItemCode, storeClerkId); gvMaintainStockCard.DataBind(); }
//create a adjustment Voucher; public void createAdjustmentVoucher(string itemname, int AdjustQty, double AdjustAmt, string reason, int employeeId) { string name = itemname; InventoryItem inventoryItem = GetInventoryItem(name); inventoryItem.QtyInStock += AdjustQty; SupplierStationery supplierStationery = GetSupplierStationery(name); Employee emp = GetEmployeeById(employeeId); AdjustmentVoucher adjustmentVoucher = new AdjustmentVoucher(); adjustmentVoucher.date = DateTime.Now; adjustmentVoucher.AdjustQty = AdjustQty; adjustmentVoucher.InventoryItemId = inventoryItem.Id; adjustmentVoucher.AdjustAmt = AdjustAmt; adjustmentVoucher.InventoryItem = inventoryItem; adjustmentVoucher.SupplierStationery = supplierStationery; adjustmentVoucher.Reason = reason; adjustmentVoucher.EmployeeId = employeeId; dbcontext.Add(adjustmentVoucher); dbcontext.SaveChanges(); }
public SupplierStationery GetSupplierStationery(string name) { SupplierStationery item = dbcontext.SupplierStationeries.Where(x => x.InventoryItem.Id == name).FirstOrDefault(); return(item); }
public int AddSupplierStationery(SupplierStationery supplierstationery) { context.SupplierStationeries.Add(supplierstationery); return(context.SaveChanges()); }
public SupplierStationery FindSupplierStationery(string itemCode, string supplierCode) { SupplierStationery supplierstationery = context.SupplierStationeries.Where(x => x.ItemCode == itemCode && x.SupplierCode == supplierCode).First(); return(supplierstationery); }
public SupplierStationery FindSupplierStationery(int id) { SupplierStationery supplierstationery = context.SupplierStationeries.Where(x => x.SupplierStationeryId == id).First(); return(supplierstationery); }
public SupplierStationery GetSupplierStationeryBySupplierId(string supplierid) { SupplierStationery supplierstationery = adProjContext.SupplierStationeries.Where(x => x.SupplierId == supplierid).FirstOrDefault(); return(supplierstationery); }
public SupplierStationery GetSupplierStationeryById(int id) { SupplierStationery supplierstationery = adProjContext.SupplierStationeries.Where(x => x.Id == id).FirstOrDefault(); return(supplierstationery); }