public ActionResult RegisterCustomer(string fullname, string email, string number, string organizationname, string organizationaddress, string username, string password, string password2, string[] warehouses) { WarehouseBusinessLayer wbl = new WarehouseBusinessLayer(); Customer useracc = new Customer(); useracc.fullName = fullname; useracc.email = email; useracc.contact = number; useracc.password = password; useracc.userName = username; useracc.organizationAddress = organizationaddress; useracc.organizationName = organizationname; useracc.selectedWarehouse = JsonConvert.SerializeObject(warehouses); WarehouseDBEntities wdb = new WarehouseDBEntities(); wdb.Customers.Add(useracc); wdb.SaveChanges(); Session["UserID"] = wbl.getRecentlyId(); Session["Username"] = username; return(RedirectToAction("LoggedIn")); }
public JsonResult GetSpecificItem(string id) { try { WarehouseDBEntities wdb = new WarehouseDBEntities(); WarehouseBusinessLayer ware = new WarehouseBusinessLayer(); int warehouseID = ware.getWarehouseId(Convert.ToInt32(Session["UserID"])); // Shelf shelf = wdb.Shelves.FirstOrDefault(a => a.shelfName == sname); Item item = wdb.Items.Find(Convert.ToInt32(id)); List <String> sitems = new List <String>(); sitems.Add(item.Manufacturer); sitems.Add(item.itemCode); sitems.Add(item.itemDetail.dimensions); sitems.Add(item.itemDetail.weight); sitems.Add(item.itemDetail.picture); sitems.Add(item.Country); return(new JsonResult { Data = sitems, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } catch (Exception ex) { return(null); } }
public ActionResult EditProfile(int id) { WarehouseDBEntities wde = new WarehouseDBEntities(); UserAccount useracc = wde.UserAccounts.Find(id); return(View(useracc)); }
public JsonResult GetAllItems(string id) { try { WarehouseDBEntities wdb = new WarehouseDBEntities(); WarehouseBusinessLayer ware = new WarehouseBusinessLayer(); int warehouseID = ware.getWarehouseId(Convert.ToInt32(Session["UserID"])); Warehouse warehouse = wdb.Warehouses.FirstOrDefault(k => k.id == warehouseID); int palletsInOneRow = ((int)warehouse.shelfSlots / (int)warehouse.sections) / (int)warehouse.shelfRows; string sname = warehouseID.ToString() + id; Shelf shelf = wdb.Shelves.FirstOrDefault(a => a.shelfName == sname); shelf.shelfName = id; shelf.warehouse_id = palletsInOneRow; shelf.slotsRemaining = warehouse.sections; List <Shelf> sitems = new List <Shelf>(); sitems.Add(shelf); return(new JsonResult { Data = sitems, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } catch (Exception ex) { return(null); } }
/// <summary> /// Get and update current product quantity in warehouse /// </summary> public void GetCurrentWarehouseQuantity() { int sum = 0; try { using (WarehouseDBEntities context = new WarehouseDBEntities()) { List <Product> products = new List <Product>(); products = context.Products.ToList(); for (int i = 0; i < products.Count; i++) { if (products[i].Stored == "stored") { sum += products[i].Quantity; } } } currentWarehouseQuantity = sum; } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); } }
/// <summary> /// Method for change of product Stored status /// </summary> /// <param name="product">product for storing</param> public void StoreProduct(tblProduct product) { try { using (WarehouseDBEntities context = new WarehouseDBEntities()) { tblProduct productToStore = (from x in context.tblProducts where x.ID == product.ID select x).First(); List <tblProduct> storedList = GetStoredProducts(); int counter = 0; foreach (var item in storedList) { counter += item.Quantity; } //check quantity if its less than 100 it can be stored if (productToStore.Stored == "no" && (counter + productToStore.Quantity <= 100)) { //change status to yes productToStore.Stored = "yes"; context.SaveChanges(); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); } }
/// <summary> /// Delete product execute /// </summary> private void DeleteProductExecute() { try { if (Product != null) { int productID = Product.ProductID; if (Product.Stored == "stored") { MessageBox.Show("Can't delete stored product"); } else { service.DeleteProduct(productID); service.Notify("Deleted " + product.ProductName + ", code " + product.ProductCode + ", quantity " + product.Quantity + ", price " + product.Price); MessageBox.Show("Product has been deleted"); } using (WarehouseDBEntities wcf = new WarehouseDBEntities()) { ProductList = wcf.Products.ToList(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// Constructor with one parameter /// </summary> /// <param name="mainOpen">Main window</param> public MainWindowViewModel(MainWindow mainOpen) { main = mainOpen; using (WarehouseDBEntities context = new WarehouseDBEntities()) { ProductList = context.Products.ToList(); } }
public ActionResult PlaceOrder() { WarehouseDBEntities wdb = new WarehouseDBEntities(); List <Warehouse> warehouses = wdb.Warehouses.ToList(); ViewBag.Warehouses = warehouses; return(View()); }
/// <summary> /// Constructor with one parameter /// </summary> /// <param name="storeOpen">Storekeeper window</param> public StorekeeperViewModel(Storekeeper storeOpen) { storekeeper = storeOpen; using (WarehouseDBEntities context = new WarehouseDBEntities()) { ProductList = context.Products.ToList(); } service.GetCurrentWarehouseQuantity(); }
public ActionResult ViewWorkers() { WarehouseDBEntities wdb = new WarehouseDBEntities(); int warehouseID = Convert.ToInt32(Session["UserId"]); List <UserAccount> useracc = wdb.UserAccounts.Where(a => a.Worker.warehouseId == warehouseID && a.Role == "Worker").ToList(); return(View(useracc)); }
public ActionResult OrderInstruction() { WarehouseDBEntities wdb = new WarehouseDBEntities(); WarehouseBusinessLayer wbl = new WarehouseBusinessLayer(); int id = wbl.getWarehouseId(Convert.ToInt32(Session["UserID"])); List <Order> orders = wdb.Orders.Where(a => a.warehouseId == id && a.orderStatus == "Dispatched").ToList(); return(View(orders)); }
public ActionResult GetOrders() { WarehouseBusinessLayer wbl = new WarehouseBusinessLayer(); WarehouseDBEntities wdb = new WarehouseDBEntities(); int warehouseIdd = wbl.getWarehouseId(Convert.ToInt32(Session["UserID"])); List <Order> orderNew = wdb.Orders.Where(a => a.warehouseId == warehouseIdd).ToList(); return(View(orderNew)); }
public RedirectToRouteResult Delete(int id) { WarehouseDBEntities wdb = new WarehouseDBEntities(); var user = (from d in wdb.UserAccounts where d.UserID == id select d).Single(); wdb.UserAccounts.Remove(user); wdb.SaveChanges(); return(RedirectToAction("ViewWorkers")); }
public RedirectToRouteResult CreateWorker(string fullname, string email, string number, string username, string password, string[] shelfs) { WarehouseDBEntities wde = new WarehouseDBEntities(); UserAccount acc = new UserAccount(); acc.Email = email; acc.Name = fullname; acc.UserName = username; acc.Password = password; acc.Contact = number; acc.Role = "Worker"; acc.Registered = DateTime.Now.ToShortDateString(); wde.Workers.Add(new Worker { warehouseId = Convert.ToInt32(Session["UserId"]), assignedShelfs = JsonConvert.SerializeObject(shelfs) }); if (wde.UserAccounts.Where(a => a.UserName == acc.UserName).ToList().Count < 1) { try { wde.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } // acc.workerId = Convert.ToInt32(Session["UserId"]); acc.workerId = wde.Workers.Max(a => a.Id); ConsignmentBusinessLayer cbl = new ConsignmentBusinessLayer(); cbl.addAccount(acc); return(RedirectToAction("ViewWorkers")); } else { return(null); } }
public void UpdateOrderCancel(string status) { int orderId = Convert.ToInt32(status); WarehouseDBEntities wdm = new WarehouseDBEntities(); Order Oldorder = wdm.Orders.FirstOrDefault(a => a.orderId == orderId); Order orderCopy = Oldorder; orderCopy.orderStatus = "Canceled"; wdm.Entry(Oldorder).CurrentValues.SetValues(orderCopy); wdm.SaveChanges(); wdm.Dispose(); }
public ActionResult StepTwoCustomer() { if (TempData["SignupStepOne"] != null) { UserAccount useracc = (UserAccount)TempData["SignupStepOne"]; WarehouseDBEntities wdb = new WarehouseDBEntities(); List <Warehouse> warehouses = wdb.Warehouses.ToList(); ViewBag.Warehouses = warehouses; return(View(useracc)); } else { return(RedirectToAction("Register")); } }
/// <summary> /// Add or edit product in warehouse /// </summary> /// <param name="product">Product to add or edit</param> /// <returns>Added or updated product</returns> public Product AddProduct(Product product) { try { using (WarehouseDBEntities context = new WarehouseDBEntities()) { if (product.ProductID == 0) { //add product Product p = new Product(); p.ProductName = product.ProductName; p.ProductCode = product.ProductCode; p.Quantity = product.Quantity; p.Price = product.Price; p.Stored = "not stored"; context.Products.Add(p); context.SaveChanges(); product.ProductID = p.ProductID; action = "added"; return(product); } else { //edit product Product productToEdit = (from x in context.Products where x.ProductID == product.ProductID select x).FirstOrDefault(); productToEdit.ProductName = product.ProductName; productToEdit.ProductCode = product.ProductCode; productToEdit.Price = product.Price; productToEdit.Quantity = product.Quantity; productToEdit.ProductID = product.ProductID; context.SaveChanges(); action = "updated"; return(product); } } } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); return(null); } }
/// <summary> /// Delete product from warehouse /// </summary> /// <param name="id">Product id</param> public void DeleteProduct(int id) { try { using (WarehouseDBEntities context = new WarehouseDBEntities()) { Product productToDelete = (from r in context.Products where r.ProductID == id select r).First(); context.Products.Remove(productToDelete); context.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); } }
/// <summary> /// Method to get all stored products from table /// </summary> /// <returns>list of stored products</returns> public List <tblProduct> GetStoredProducts() { try { using (WarehouseDBEntities context = new WarehouseDBEntities()) { List <tblProduct> stored = new List <tblProduct>(); stored = (from x in context.tblProducts where x.Stored == "yes" select x).ToList(); return(stored); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
/// <summary> /// Method gets all products from database /// </summary> /// <returns>List of products</returns> public List <tblProduct> GetAllProducts() { try { using (WarehouseDBEntities context = new WarehouseDBEntities()) { List <tblProduct> products = new List <tblProduct>(); products = (from x in context.tblProducts select x).ToList(); OnNotification = logger.WriteToFile; return(products); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
/// <summary> /// Store not stored product in warehpuse /// </summary> /// <param name="id"></param> public void StoreProduct(int id) { try { using (WarehouseDBEntities context = new WarehouseDBEntities()) { Product productToStore = (from r in context.Products where r.ProductID == id select r).First(); productToStore.Stored = "stored"; context.SaveChanges(); GetCurrentWarehouseQuantity(); } } catch (Exception ex) { Console.WriteLine(ex.Message.ToString()); } }
public JsonResult GetWorkerLogs(string id) { try { WarehouseDBEntities wde = new WarehouseDBEntities(); Worker worker = wde.Workers.Find(Convert.ToInt32(id)); List <WorkerLogs> logs = Newtonsoft.Json.JsonConvert.DeserializeObject <List <WorkerLogs> >(worker.workerLogs); return(new JsonResult { Data = logs, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } catch (Exception ex) { return(null); } }
/// <summary> /// Add product execute /// </summary> private void AddProductExecute() { try { AddProduct addProduct = new AddProduct(); addProduct.ShowDialog(); if ((addProduct.DataContext as AddProductViewModel).IsUpdateProduct == true) { using (WarehouseDBEntities wcf = new WarehouseDBEntities()) { ProductList = wcf.Products.ToList(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public JsonResult GetItems(int warehouseId) { List <Item> items = new List <Item>(); WarehouseDBEntities wdb = new WarehouseDBEntities(); List <Item_Warehouse> iw = wdb.Item_Warehouse.Where(i => i.warehouseId == warehouseId).ToList(); ConsignmentBusinessLayer cbl = new ConsignmentBusinessLayer(); foreach (Item_Warehouse i in iw) { //Item it = wdb.Items.First(k=>k.id==i.itemId); items.Add(cbl.getItem(i.itemId, (int)i.quantity)); } wdb.Dispose(); return(new JsonResult { Data = items, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult PlaceOrderRegister(string fullname, string email, string number, string organizationname, string organizationaddress, string orderCountries, string orderWarehouse) { WarehouseDBEntities wdb = new WarehouseDBEntities(); Customer customer = new Customer(); customer.fullName = fullname; customer.email = email; customer.contact = number; customer.organizationName = organizationname; customer.organizationAddress = organizationaddress; customer.selectedWarehouse = orderWarehouse; Session["warehouseKey"] = orderWarehouse; int warehouseID = Convert.ToInt32(orderWarehouse); Warehouse w = wdb.Warehouses.FirstOrDefault(a => a.id == warehouseID); Session["warehouseName"] = w.warehouseName; Session["customerRecord"] = customer; return(RedirectToAction("PlaceOrderComplete")); }
/// <summary> /// Method for add or edit products in database /// </summary> /// <param name="product"></param> /// <returns>new or edited product</returns> public tblProduct AddEditProduct(tblProduct product) { try { using (WarehouseDBEntities context = new WarehouseDBEntities()) { if (product.ID == 0) { tblProduct newProduct = new tblProduct(); newProduct.ProductName = product.ProductName; newProduct.ProductCode = product.ProductCode; newProduct.Quantity = product.Quantity; newProduct.Price = product.Price; newProduct.Stored = "no"; context.tblProducts.Add(newProduct); context.SaveChanges(); product.ID = newProduct.ID; action = "added"; return(product); } else { tblProduct productForEdit = (from x in context.tblProducts where x.ID == product.ID select x).FirstOrDefault(); productForEdit.ProductName = product.ProductName; productForEdit.ProductCode = product.ProductCode; productForEdit.Quantity = product.Quantity; productForEdit.Price = product.Price; productForEdit.Stored = product.Stored; context.SaveChanges(); action = "edited"; return(product); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
public RedirectToRouteResult SaveEditWorker(string userid, string fullname, string email, string number, string username, string password, string[] shelfs) { WarehouseDBEntities wde = new WarehouseDBEntities(); UserAccount useracc = wde.UserAccounts.Find(Convert.ToInt32(userid)); useracc.Name = fullname; useracc.Email = email; useracc.UserName = username; useracc.Contact = number; useracc.Password = password; useracc.ConfirmPassword = password; useracc.Worker.assignedShelfs = JsonConvert.SerializeObject(shelfs); wde.Entry(useracc).State = EntityState.Modified; try { wde.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } return(RedirectToAction("ViewWorkers")); }
public void DispatchOrders(string id) { WarehouseBusinessLayer wbl = new WarehouseBusinessLayer(); int warehouseId = wbl.getWarehouseId(Convert.ToInt32(Session["UserID"])); int oid = Convert.ToInt32(id); WarehouseDBEntities wde = new WarehouseDBEntities(); List <Order> orders = wde.Orders.Where(a => a.warehouseId == warehouseId && a.orderId == oid && (a.orderStatus == "Unseen" || a.orderStatus == "Seen")).OrderBy(a => a.totalOrderQuanitity).ToList(); int i = 0; //Sorting items according to quantity foreach (var order in orders) { var neworder = order.item_Order; neworder = neworder.OrderBy(a => a.quantity).ToList(); orders.ElementAt(i).item_Order = neworder; i++; } Slotting slotting = new Slotting(); List <Item_Warehouse> itemWarehouse = wde.Item_Warehouse.Where(a => a.warehouseId == warehouseId).ToList(); List <Shelf> shelfs = wde.Shelves.Where(a => a.warehouse_id == warehouseId).ToList(); Dictionary <int, List <ShelfItems> > shelfItems = new Dictionary <int, List <ShelfItems> >(); foreach (Shelf shelf in shelfs) { List <ShelfItems> shelves = slotting.covert_to_object(shelf.shelfItems); shelfItems.Add(shelf.id, shelves); } List <Item> items = new List <Item>(); foreach (Item_Warehouse item_Warehouse in itemWarehouse) { items.Add(item_Warehouse.Item); } OrderPicking orderPick = new OrderPicking(); orderPick.getFirstOrder(orders, shelfItems); }
/// <summary> /// delete order execute /// </summary> private void DeleteExecute() { var result = MessageBox.Show("Are you sure you want to delete the product?", "Confirmation", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { try { if (Product != null) { int productId = Product.ID; if (Product.Stored == "yes") { MessageBox.Show("Product is stored and cannot be deleted from database."); service.Notify("Could not delete Product: " + Product.ProductName + " with code: " + Product.ProductCode + " since its stored."); } else { service.DeleteProduct(productId); MessageBox.Show("Product " + Product.ProductName + " with code:" + Product.ProductCode + " removed from database."); service.Notify("Product " + Product.ProductName + " with code:" + Product.ProductCode + " removed from database."); } using (WarehouseDBEntities context = new WarehouseDBEntities()) { ProductList = context.tblProducts.ToList(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } else { return; } }