//Add salesorder constructor public SalesOrder_AddEdit(ProjectApplicationContext ctx, ObservableCollection <SalesOrder> salesOrders) { Ctx = ctx; SalesOrders = salesOrders; InitializeComponent(); lblOrderId.Visibility = Visibility.Hidden; tbOrderId.Visibility = Visibility.Hidden; ProductsOrdered = new ObservableCollection <Product>(); lvOrderedProducts.ItemsSource = ProductsOrdered; //select customer List <Customer> customers = Ctx.Customers.ToList(); cbCustomer.ItemsSource = customers; //Employee tbEmployee.Text = MainMenu.User.Employee.ToString(); //Product Type var categories = Enum.GetValues(typeof(ProductCategory)); cbProductType.ItemsSource = categories; }
//add employee form public Customer_AddEdit(ProjectApplicationContext ctx, ObservableCollection <Customer> customers) { Ctx = ctx; Customers = customers; InitializeComponent(); tbCustomerId.Visibility = Visibility.Hidden; lblCustomerId.Visibility = Visibility.Hidden; }
//edit employee form public Customer_AddEdit(ProjectApplicationContext ctx, ObservableCollection <Customer> customers, Customer selectedCustomer) { Ctx = ctx; Customers = customers; SelectedCustomer = selectedCustomer; this.DataContext = selectedCustomer; InitializeComponent(); }
//add contructor public Supplier_AddEdit(ProjectApplicationContext ctx, ObservableCollection <Supplier> suppliers) { Ctx = ctx; Suppliers = suppliers; InitializeComponent(); this.Title = "Add Supplier"; tbSupplierId.Visibility = Visibility.Hidden; lblSupplierId.Visibility = Visibility.Hidden; }
public ManageUsers_UserControl(ProjectApplicationContext ctx) { InitializeComponent(); Ctx = ctx; GetUserAccountData(); //List<UserAccount> userAccounts = ctx.UserAccounts.ToList(); //ObservableCollection<UserAccount> observableUserAccounts = new ObservableCollection<UserAccount>(userAccounts); //makes an observable collection from the list //UsersDataGrid.ItemsSource = userAccounts; }
// Add employee public Employee_AddEdit(ProjectApplicationContext ctx, ObservableCollection <Employee> employees) { Ctx = ctx; Employees = employees; InitializeComponent(); tbUserAccount.Visibility = Visibility.Hidden; tbEmployeeId.Visibility = Visibility.Hidden; lblEmployeeId.Visibility = Visibility.Hidden; lblUserAccount.Visibility = Visibility.Hidden; }
//edit constructor public Supplier_AddEdit(ProjectApplicationContext ctx, ObservableCollection <Supplier> suppliers, Supplier selectedSupplier) { Ctx = ctx; SelectedSupplier = selectedSupplier; Suppliers = suppliers; InitializeComponent(); this.Title = "Edit Supplier"; this.DataContext = selectedSupplier; dpCustomerSince.IsEnabled = false; tbSupplierId.IsEnabled = false; }
public SalesOrders_UserControl(ProjectApplicationContext ctx) { Ctx = ctx; InitializeComponent(); getSalesOrderData(); if (MainMenu.User.Role == Role.WarehouseEmployee) { btnCancelSalesOrder.Visibility = Visibility.Hidden; btnEditSalesOrder.Visibility = Visibility.Hidden; btnNewSalesOrder.Visibility = Visibility.Hidden; } }
public User_AddEdit(ObservableCollection <UserAccount> userAccounts, ProjectApplicationContext context) { UserAccounts = userAccounts; Ctx = context; var employeesWithoutUserAccount = Ctx.Employees .Include("UserAccount") .Where(e => e.UserAccount == null) .ToList(); InitializeComponent(); cbEmployees.ItemsSource = employeesWithoutUserAccount; }
//add constructor public Product_AddEdit(ProjectApplicationContext ctx, ObservableCollection <RegisteredProduct> products) { Ctx = ctx; Products = products; InitializeComponent(); this.Title = "Add Product"; cbSupplier.ItemsSource = Ctx.Suppliers.ToList(); cbProductType.ItemsSource = Enum.GetValues(typeof(ProductCategory)); tbQuantity.Visibility = Visibility.Hidden; tbProductId.Visibility = Visibility.Hidden; lblNumberInStock.Visibility = Visibility.Hidden; lblProductId.Visibility = Visibility.Hidden; }
public MainMenu(UserAccount user, ProjectApplicationContext ctx) { // this.WindowState = WindowState.Maximized; User = user; Ctx = ctx; InitializeComponent(); this.MainContentControl.Content = new Overview_UserControl(Ctx); switch (User.Role) { case Role.Administrator: DataSubMenuItems.Add("Manage Users"); DataSubMenuItems.Add("Manage Employees"); DataSubMenuItems.Add("Manage Products"); DataSubMenuItems.Add("Manage Suppliers"); DataSubMenuItems.Add("Manage Customers"); DataSubMenuItems.Add("Manage Stock (to add)"); /* OverviewSubMenuItems.Add("Employee Overview"); * OverviewSubMenuItems.Add("Warehouse Overview"); * OverviewSubMenuItems.Add("Supplier Overview"); * OverviewSubMenuItems.Add("Products Overview");*/ OrdersSubMenuItems.Add("Sales"); OrdersSubMenuItems.Add("Purchases"); break; case Role.SalesEmployee: DataSubMenuItems.Add("Manage Customers"); OrdersSubMenuItems.Add("Sales"); OrdersSubMenuItems.Add("Purchases"); break; case Role.WarehouseEmployee: DataSubMenuItems.Add("Manage Suppliers"); DataSubMenuItems.Add("Manage Stock (to add)"); //OverviewSubMenuItems.Add("Warehouse Overview"); //OverviewSubMenuItems.Add("Products Overview"); OrdersSubMenuItems.Add("Sales"); OrdersSubMenuItems.Add("Purchases"); break; } DataSubMenu.ItemsSource = DataSubMenuItems; //OverviewSubMenu.ItemsSource = OverviewSubMenuItems; OrdersSubmenu.ItemsSource = OrdersSubMenuItems; }
public User_AddEdit(ObservableCollection <UserAccount> userAccounts, ProjectApplicationContext context, UserAccount selectedUser) { UserAccounts = userAccounts; Ctx = context; SelectedUser = selectedUser; InitializeComponent(); this.DataContext = selectedUser; var employee = Ctx.Employees .Where(e => e.EmployeeId == selectedUser.UserAccountId) .ToList(); lblEmployee.Content = "Employee:"; lblAddEditAccount.Content = "Edit user account details"; cbEmployees.ItemsSource = employee; cbEmployees.SelectedItem = employee[0]; cbEmployees.IsEnabled = false; }
//constructor new purchase order public PurchaseOrder_AddEdit(ProjectApplicationContext ctx) { Ctx = ctx; ProductsOrdered = new ObservableCollection <Product>(); InitializeComponent(); lvOrderedProducts.ItemsSource = ProductsOrdered; //List warehouse employees and administrators var purchaseEmployees = Ctx.Employees.Where(e => e.Role == Role.Administrator || e.Role == Role.WarehouseEmployee).ToList(); cbEmployee.ItemsSource = purchaseEmployees; //List existing suppliers var currentSuppliers = Ctx.Suppliers.ToList(); cbSupplier.ItemsSource = currentSuppliers; }
public Employee_AddEdit(ProjectApplicationContext ctx, Employee selectedEmployee, ObservableCollection <Employee> employees) { Ctx = ctx; Employees = employees; SelectedEmployee = selectedEmployee; this.DataContext = selectedEmployee; InitializeComponent(); if (SelectedEmployee.UserAccount == null) { tbUserAccount.Visibility = Visibility.Hidden; lblUserAccount.Visibility = Visibility.Hidden; } /* tbEmployeeId.Text = selectedEmployee.EmployeeId.ToString(); * * tbUserAccount.Text = selectedEmployee.UserAccount.UserName; * * tbSalary.Text = selectedEmployee.Salary.ToString();*/ }
//edit constructor public Product_AddEdit(ProjectApplicationContext ctx, ObservableCollection <RegisteredProduct> products, RegisteredProduct selectedProduct) { Ctx = ctx; Products = products; SelectedProduct = selectedProduct; OriginalBarcode = SelectedProduct.BarCode; InitializeComponent(); this.Title = "Edit Product"; cbProductType.ItemsSource = Enum.GetValues(typeof(ProductCategory)); var productAndSupplier = Ctx.RegisteredProducts.Include("Supplier").Where(rp => rp.RegisteredProductId == selectedProduct.RegisteredProductId).ToList(); this.DataContext = productAndSupplier; var suppliers = Ctx.Suppliers.ToList(); cbSupplier.DataContext = suppliers; cbSupplier.ItemsSource = suppliers; Supplier selectedSupplier = null; foreach (var item in suppliers) { if (item.SupplierId == productAndSupplier[0].Supplier.SupplierId) { selectedSupplier = item; } } cbSupplier.SelectedItem = selectedSupplier; int numberOfProducts = Ctx.Products.Where(p => p.RegisteredProductId == selectedProduct.RegisteredProductId).ToList().Count(); tbQuantity.Text = numberOfProducts.ToString(); tbQuantity.IsEnabled = false; tbProductId.IsEnabled = false; cbSupplier.IsEnabled = false; }
//Edit salesorder constructor public SalesOrder_AddEdit(ProjectApplicationContext ctx, ObservableCollection <SalesOrder> salesOrders, SalesOrder selectedSalesOrder) { Ctx = ctx; SelectedSalesOrder = selectedSalesOrder; SalesOrders = salesOrders; InitializeComponent(); //Set existing properties this.DataContext = selectedSalesOrder; //product overview ProductsOrdered = new ObservableCollection <Product>(); lvOrderedProducts.ItemsSource = ProductsOrdered; foreach (var item in SelectedSalesOrder.SalesOrderProducts) { ProductsOrdered.Add(item.Product); } tbPrice.Text = Convert.ToString(CalculateTotal()); //order id tbOrderId.Text = SelectedSalesOrder.SalesOrderId.ToString(); //Customer var customers = Ctx.Customers.ToList(); cbCustomer.ItemsSource = customers; cbCustomer.SelectedItem = SelectedSalesOrder.Customer; //Employee tbEmployee.Text = selectedSalesOrder.Employee.ToString(); //Product Type var categories = Enum.GetValues(typeof(ProductCategory)); cbProductType.ItemsSource = categories; }
public ManageCustomers_UserControl(ProjectApplicationContext ctx) { Ctx = ctx; InitializeComponent(); getCustomerData(); }
public ManageProducts_UserControl(ProjectApplicationContext ctx) { Ctx = ctx; InitializeComponent(); GetRegisteredProductData(); }
public Overview_UserControl(ProjectApplicationContext ctx) { Ctx = ctx; InitializeComponent(); DateTime date = DateTime.Now; lblDateTime.Content = date.ToString("HH:mm"); lblWelcome.Content = $"Welcome \n{MainMenu.User.Employee.FirstName} {MainMenu.User.Employee.LastName} \nEmployee Id: {MainMenu.User.Employee.EmployeeId}"; //new employees DateTime today = DateTime.Now; DateTime onemonthago = today.AddDays(-30); var newEmployees = Ctx.Employees.Where(e => e.StartDate > onemonthago).ToList(); lbnewStaff.ItemsSource = newEmployees; //top sellers var topSellers = Ctx.Employees .Include("SalesOrders") .OrderByDescending(e => e.SalesOrders.Count) .Select(e => new { Name = e.FirstName + " " + e.LastName, NumberofSales = e.SalesOrders.Count() }) .Take(5) .ToList(); lbTopSellers.ItemsSource = topSellers; //current stock var currentStock = Ctx.Products .GroupBy(p => p.Name) .Select(p => new { Name = p.Key, NumberInStock = p.Count() }) .ToList(); lvStock.ItemsSource = currentStock; //sales order total DateTime oneweekago = today.AddDays(-7); var weeklySales = Ctx.SalesOrders.Where(s => s.OrderDate > oneweekago).ToList(); double totalSales = 0; foreach (var sale in weeklySales) { totalSales += sale.TotalPrice; } tbSalesNumber.Text = $"{weeklySales.Count()} sales"; tbIncome.Text = $"£{totalSales.ToString()}"; //purchase order total var weeklyPurchases = Ctx.PurchaseOrders.Where(p => p.OrderDate > oneweekago).ToList(); double totalPurchases = 0; foreach (var purchase in weeklyPurchases) { totalPurchases += purchase.TotalPrice; } tbPurchases.Text = $"{weeklyPurchases.Count()} purchases"; tbSpendings.Text = $"£{totalPurchases.ToString()}"; // profit double profit = totalSales - totalPurchases; tbProfitMade.Text = $" £{profit}"; //Most popular products var salesOrders = Ctx.SalesOrders .Include(so => so.SalesOrderProducts.Select(p => p.Product)) .ToList(); var productGroups = Ctx.Products .GroupBy(p => p.BarCode) .ToList(); List <Product> products = new List <Product>(); foreach (var group in productGroups) { products.Add(group.First()); } int occurences = 0; Dictionary <Product, int> productOccurences = new Dictionary <Product, int>(); for (int i = 0; i < products.Count(); i++) { foreach (var order in salesOrders) { if (order.SalesOrderProducts.ToList().Exists(p => p.Product.BarCode == products[i].BarCode)) { occurences++; } } productOccurences.Add(products[i], occurences); occurences = 0; } List <KeyValuePair <Product, int> > sortedList = productOccurences.ToList(); sortedList.Sort((x, y) => x.Value.CompareTo(y.Value)); sortedList.Reverse(); lvPopularProducts.ItemsSource = sortedList; /*method * private double calculateTotal(List<T>) * { * * }*/ }
public ManageSuppliers_UserControl(ProjectApplicationContext ctx) { Ctx = ctx; InitializeComponent(); GetSupplierData(); }
public ManageEmployees_UserControl(ProjectApplicationContext ctx) { Ctx = ctx; InitializeComponent(); GetEmployeeData(); }
public PurchaseOrders_UserControl(ProjectApplicationContext ctx) { Ctx = ctx; InitializeComponent(); getPurchaseOrderData(); }