internal static void DeleteUser(UserViewModel user) { WarehouseEntities entity = new WarehouseEntities(); var userToDelete = from utd in entity.Users where utd.Username.Contains(user.Username) select utd; if (userToDelete.Count() != 0) { foreach (var item in userToDelete) { entity.Users.Remove(item); } entity.SaveChanges(); MessageBox.Show("User " + user.Username + " deleted", "Confirmation", MessageBoxButton.OK); } else { MessageBox.Show("User " + user.Username + " doesn't exist", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); return; } }
private void ButtonLoginClick(object sender, RoutedEventArgs e) { var pass = Convert.ToString(Convert.ToBase64String(System.Security.Cryptography.MD5.Create().ComputeHash(Encoding.UTF8.GetBytes(TextBoxPassword.Password)))); WarehouseEntities entity = new WarehouseEntities(); try { var userToLogin = (from utl in entity.Users where utl.Username == TextBoxUsernameLogin.Text && utl.Password == pass select utl).First(); if (userToLogin != null) { switch (userToLogin.Rank) { case "Admin": AdminPanel adminPanelWindow = new AdminPanel(); adminPanelWindow.Show(); break; case "Worker": TechnicianPanelWindow techPanelWindow = new TechnicianPanelWindow(); techPanelWindow.Show(); break; } Application.Current.MainWindow.Close(); } } catch(Exception) { MessageBox.Show("Wrong username or password", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } }
internal static void AddUser(UserViewModel user) { WarehouseEntities entity = new WarehouseEntities(); var userToAdd = from uta in entity.Users where uta.Username==user.Username select uta; if (userToAdd.Count()!=0) { MessageBox.Show("User " + user.Username + " exists", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } else { entity.Users.Add(new User() { Username = user.Username, Password = Convert.ToBase64String(System.Security.Cryptography.MD5.Create(). ComputeHash(Encoding.UTF8.GetBytes(user.Password))), Rank = user.Rank }); entity.SaveChanges(); MessageBox.Show("User " + user.Username + " added", "Confirmation", MessageBoxButton.OK); } }
internal static void DeleteProduct(ProductViewModel product) { WarehouseEntities entity = new WarehouseEntities(); var productToDelete = from ptd in entity.Products where ptd.Name.Contains(product.Name) && ptd.Vendor1.Name.Contains(product.Vendor.Name) select ptd; if (productToDelete.Count() != 0) { foreach (var item in productToDelete) { entity.Products.Remove(item); } MessageBox.Show("Product " + product.Name + " deleted", "Confirmation", MessageBoxButton.OK); entity.SaveChanges(); } else { MessageBox.Show("Product " + product.Name + " doesn't exist", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } }
internal static void DeleteVendor(VendorViewModel vendor) { WarehouseEntities entity = new WarehouseEntities(); var vendorToDelete = (from vtd in entity.Vendors where vtd.Name == vendor.Name select vtd).First(); if (vendorToDelete!=null) { var del = vendorToDelete.Products; foreach (var item in del.ToList()) { entity.Products.Remove(item); } entity.Vendors.Remove(vendorToDelete); MessageBox.Show("Vendor " + vendor.Name + " deleted", "Confirmation", MessageBoxButton.OK); entity.SaveChanges(); } else { MessageBox.Show("Vendor " + vendor.Name + " doesn't exist", "Confirmation", MessageBoxButton.OK); } }
internal static void AddVendor(VendorViewModel vendor) { WarehouseEntities entity = new WarehouseEntities(); var vendorToAdd = from vta in entity.Vendors where vta.Name.Contains(vendor.Name) select vta; if (vendorToAdd.Count()!=0) { MessageBox.Show("Vendor " + vendor.Name + " exists", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } else { entity.Vendors.Add(new Vendor() { Name = vendor.Name }); MessageBox.Show("Vendor " + vendor.Name + " added", "Confirmation", MessageBoxButton.OK); entity.SaveChanges(); } }
internal static IEnumerable<VendorViewModel> GetAllVendors() { WarehouseEntities entity = new WarehouseEntities(); var allVendors = from av in entity.Vendors select new VendorViewModel() { Name = av.Name, }; return allVendors; }
internal static IEnumerable<UserViewModel> GetAllUsers() { WarehouseEntities entity = new WarehouseEntities(); var allUsers = from au in entity.Users select new UserViewModel() { Username = au.Username, Rank = au.Rank }; return allUsers; }
internal static IEnumerable<ProductViewModel> GetAllProducts() { WarehouseEntities entity = new WarehouseEntities(); var allProducts = from ap in entity.Products select new ProductViewModel() { Name = ap.Name, Quantity = ap.Quantity, BuyPrice = ap.BuyPrice, SellPrice = ap.SellPrice, DayOfPurchase = ap.DayOfPurchase, Vendor = new VendorViewModel() { Name = ap.Vendor1.Name } }; return allProducts; }
internal static void AddProduct(ProductViewModel product) { WarehouseEntities entity = new WarehouseEntities(); var productToAdd = from pta in entity.Products where ((pta.Name == product.Name) && (pta.Vendor1.Name == product.Vendor.Name)) select pta; if (productToAdd.Count() != 0) { UpdateProduct(product); } else { var productVendor = (from pv in entity.Vendors where pv.Name == product.Vendor.Name select pv).First(); entity.Products.Add(new Product() { Name = product.Name, BuyPrice = product.BuyPrice, SellPrice = product.SellPrice, Quantity = product.Quantity, DayOfPurchase = DateTime.Now, Vendor = productVendor.VendorID }); MessageBox.Show("Product " + product.Name + " added!", "Confirmation", MessageBoxButton.OK); entity.SaveChanges(); } }
internal static void UseProduct(ProductViewModel product) { WarehouseEntities entity = new WarehouseEntities(); var productToUse = from ptu in entity.Products where ptu.Name.Contains(product.Name) && ptu.Vendor1.Name.Contains(product.Vendor.Name) select ptu; if (productToUse.Count() != 0) { foreach (var item in productToUse) { item.Quantity -= product.Quantity; item.DayOfSale = DateTime.Now; if (item.SaleQuantity == null) { item.SaleQuantity = product.Quantity; } else { item.SaleQuantity += product.Quantity; } } MessageBox.Show("Product " + product.Name + " used", "Confirmation", MessageBoxButton.OK); entity.SaveChanges(); } else { MessageBox.Show("Product " + product.Name + " doesn't exist", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } }
internal static void UpdateProduct(ProductViewModel product) { WarehouseEntities entity = new WarehouseEntities(); var productToUpdate = from ptu in entity.Products where ptu.Name.Contains(product.Name) && ptu.Vendor1.Name.Contains(product.Vendor.Name) select ptu; if (productToUpdate.Count() != 0) { foreach (var item in productToUpdate) { item.Quantity += product.Quantity; item.BuyPrice = product.BuyPrice; } MessageBox.Show("Product " + product.Name + " updated", "Confirmation", MessageBoxButton.OK); entity.SaveChanges(); } else { MessageBox.Show("Product " + product.Name + " doesn't exist", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } }
internal static IEnumerable<ProductViewModel> GetProductReportSales(ProductViewModel product) { WarehouseEntities entity = new WarehouseEntities(); var productReportSales = (from prs in entity.Products where prs.DayOfSale.Day.Equals(product.DayOfSale.Day) && prs.DayOfSale.Month.Equals(product.DayOfSale.Month) && prs.DayOfSale.Year.Equals(product.DayOfSale.Year) select new ProductViewModel() { Name = prs.Name, Quantity = prs.Quantity, SaleQuantity = prs.SaleQuantity, BuyPrice = prs.BuyPrice, SellPrice = prs.SellPrice, DayOfSale = prs.DayOfSale, Vendor = new VendorViewModel() { Name = prs.Vendor1.Name } }).ToList(); return productReportSales; }