Проектирование процесса автоматизации деятельности зоомагазина

dbContext.Suppliers.Any()) {dbContext.Suppliers.Add(new Supplier() { Name = "ОООзвездочка" });dbContext.Suppliers.Add(new Supplier() { Name = "рогаикопыта" });dbContext.Suppliers.Add(new Supplier() { Name = "четырелапы" });dbContext.SaveChanges(); }if (!dbContext.Categories.Any()) {dbContext.Categories.Add(new Category() { Name = "корма" });dbContext.Categories.Add(new Category() { Name = "игрушки" });dbContext.Categories.Add(new Category() { Name = "животные" });dbContext.Categories.Add(new Category() { Name = "аксессуары" });dbContext.SaveChanges(); }if (!dbContext.Products.Any()) {var category = dbContext.Categories.First(x => x.Name == "корма");dbContext.Products.Add(new Product() { Name = "кормдлярыб", ActualQty = 1, Price = 190, Category = category });dbContext.Products.Add(new Product() { Name = "кормдлякотов", ActualQty = 5, Price = 230, Category = category });dbContext.Products.Add(new Product() { Name = "кормдлясобак", ActualQty = 8, Price = 90, Category = category });dbContext.SaveChanges(); } } }publicDataTableGetReport(string? productName) {using (vardbContext = newPetShopDataContext()) {var table = newDataTable();table.Columns.Add("наименованиетовара");table.Columns.Add("категория товара");table.Columns.Add("тип операции");table.Columns.Add("дата операции");table.Columns.Add("цена");table.Columns.Add("количество");if (productName != null) {var product = dbContext.Products.Include("Category").Include("RetailHistories").Include("SupplienmentHistories").First(x => x.Name == productName);foreach (var item inproduct.RetailHistories) {table.Rows.Add(product.Name, product.Category.Name, "продажа", item.RetailDate, item.Price, item.Qty); }foreach (var item inproduct.SupplienmentHistories) {table.Rows.Add(product.Name, product.Category.Name, "поставка", item.SupplyDate, item.Price, item.Qty); } }else {var products = dbContext.Products.Include("Category").Include("RetailHistories").Include("SupplienmentHistories");foreach (var product in products) {foreach (var item inproduct.RetailHistories) {table.Rows.Add(product.Name, product.Category.Name, "продажа", item.RetailDate, item.Price, item.Qty); }foreach (var item inproduct.SupplienmentHistories) {table.Rows.Add(product.Name, product.Category.Name, "поставка", item.SupplyDate, item.Price, item.Qty); } } }return table; } }publicvoidCreateRetailHistory(DateTime date, GuidproductId, double price, intqty) {using (vardbContext = newPetShopDataContext()) {var product = dbContext.Products.Find(productId);product.ActualQty = product.ActualQty - qty;var history = newRetailHistory() { Price = price, Qty = qty, Product = product, RetailDate = date };dbContext.RetailHistories.Add(history);dbContext.SaveChanges(); } }publicbool Login(string login, string pass) {using (vardbContext = newPetShopDataContext()) {//var password = pass.GetHashCode().ToString();returndbContext.Admins.Any(x => x.Login == login && x.Password == pass); } }publicvoidCreateSupplyHistory(DateTime date, GuidproductId, GuidsupplierId, double price, intqty) {using (vardbContext = newPetShopDataContext()) {var product = dbContext.Products.Find(productId);product.ActualQty = product.ActualQty + qty;var supplier = dbContext.Suppliers.Find(supplierId);var history = newSupplienmentHistory() { Price = price, Qty = qty, Supplier = supplier, Product = product, SupplyDate = date };dbContext.SupplienmentHistories.Add(history);dbContext.SaveChanges(); } }publicvoidCreateProduct(stringproductName, stringcategoryName, intqty, double price) {using (vardbContext = newPetShopDataContext()) {var category = dbContext.Categories.First(x => x.Name == categoryName);dbContext.Products.Add(new Product() { Name = productName, Category = category, ActualQty = qty, Price = price });dbContext.SaveChanges(); } }publicvoidAddSupplier(string name) {using (vardbContext = newPetShopDataContext()) {dbContext.Suppliers.Add(new Supplier() { Name = name });dbContext.SaveChanges(); } }public List GetSupplienmentHistories() {using (vardbContext = newPetShopDataContext()) {return dbContext.SupplienmentHistories.Include("Product").Include("Supplier").ToList(); } }public List GetProducts() {using (vardbContext = newPetShopDataContext()) {returndbContext.Products.Include("Category").ToList(); } }public List GetSuppliers() {using (vardbContext = newPetShopDataContext()) {returndbContext.Suppliers.ToList(); } }public List GetCategories() {using (vardbContext = newPetShopDataContext()) {returndbContext.Categories.ToList(); } }public List GetRetialHistories() {using (vardbContext = newPetShopDataContext()) {returndbContext.RetailHistories.Include("Product").ToList(); } } }}namespacePetShop{internalstaticclassProgram { [STAThread]staticvoid Main() {ApplicationConfiguration.Initialize();Application.Run(newWelcomeForm());} }}usingPetShop;usingPetShop.Service;using System;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Windows.Forms;namespacePetShop{publicpartialclassWelcomeForm : Form {privateDataService _service;publicWelcomeForm() {InitializeComponent(); _service = newDataService(); _service.InitDatabase();passwordTbx.PasswordChar = '*'; }privatevoidEnterBtn_ClickAsync(object sender, EventArgs e) {if ( _service.Login(loginTbx.Text, passwordTbx.Text)) {this.Hide();newPetShopMain().Show();}else {MessageBox.Show("пользователь с такими данными не найден!");loginTbx.Clear();passwordTbx.Clear(); } } }}usingPetShop.Service;namespacePetShop{publicpartialclassPetShopMain : Form {DataService _dataService;publicPetShopMain() {InitializeComponent(); _dataService = newDataService();productComboBox.DataSource = _dataService.GetProducts();productComboBox.SelectedIndex = -1; }privatevoidviewSupplyBtn_Click(object sender, EventArgs e) {newSupplyHistoryForm().Show(); }privatevoidsuppliersBtn_Click(object sender, EventArgs e) {newSuppliersForm().Show(); }privatevoidaddRetailBtn_Click(object sender, EventArgs e) {newRetailHistoryForm().Show(); }privatevoidproductReportBtn_Click(object sender, EventArgs e) {newReportForm(productComboBox.Text).Show(); }privatevoidfullReportBtn_Click(object sender, EventArgs e) {newReportForm(null).Show(); }privatevoidshopProductsBtn_Click(object sender, EventArgs e){newProductForm().Show(); } }}usingPetShop.Domain;usingPetShop.Service;using System;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Windows.Forms;namespacePetShop{publicpartialclassProductForm : Form {DataService _dataService;publicProductForm() {InitializeComponent(); _dataService = newDataService();categoryComboBox.DataSource = _dataService.GetCategories();categoryComboBox.SelectedIndex = -1;UpdateGrid(); }privatevoidUpdateGrid() {var products = _dataService.GetProducts();productDataGridView.DataSource = products;productDataGridView.Columns["Id"].Visible = false;productDataGridView.Columns["SupplienmentHistories"].Visible = false;productDataGridView.Columns["RetailHistories"].Visible = false; }privatevoidsaveProductBtn_Click(object sender, EventArgs e) {try { _dataService.CreateProduct(productName.Text, ((Category)categoryComboBox.SelectedItem).Name, (int)(qtyNumericUpDown.Value), double.Parse(priceTextBox.Text));UpdateGrid(); }catch (Exception ex) {MessageBox.Show(String.Format("возниклаошибка {0}", ex.Message));} } }}usingPetShop.Service;using System;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Windows.Forms;namespacePetShop{publicpartialclassReportForm : Form {DataService _dataService;publicReportForm(string? productName) {InitializeComponent(); _dataService = newDataService();reportDataGridView.DataSource = _dataService.GetReport(productName);} }}usingPetShop.Domain;usingPetShop.Service;using System;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Windows.Forms;namespacePetShop{publicpartialclassRetailHistoryForm : Form {DataService _dataService;publicRetailHistoryForm() {InitializeComponent(); _dataService = newDataService();UpdateGrid();productComboBox.DataSource = _dataService.GetProducts();productComboBox.SelectedItem = -1; }privatevoidUpdateGrid() {var histories = _dataService.GetRetialHistories();retailHistoryGridView.DataSource = histories;retailHistoryGridView.Columns["Id"].Visible = false;retailHistoryGridView.Columns["Name"].Visible = false; }privatevoidaddRetailBtn_Click(object sender, EventArgs e) {try { _dataService.CreateRetailHistory(retailDateTimePicker.Value, ((Product)productComboBox.SelectedValue).Id, double.Parse(retailPriceTextBox.Text), (int)(retailQtyNumericUpDown.Value)); ;UpdateGrid(); }catch (Exception ex) {MessageBox.Show(String.Format("возниклаошибка {0}", ex.Message));} } }}usingPetShop.Service;using System;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Windows.Forms;namespacePetShop{publicpartialclassSuppliersForm : Form {DataService _dataService;publicSuppliersForm() {InitializeComponent(); _dataService = newDataService();UPdateSuuplierList(); }privatevoidUPdateSuuplierList() {suppliersView.Clear();suppliersView.View = View.List;var suppliers = _dataService.GetSuppliers();foreach (var item in suppliers)suppliersView.Items.Add(item.Name); }privatevoidaddSupplierBtn_Click(object sender, EventArgs e) {try { _dataService.AddSupplier(supplierNameTxb.Text);UPdateSuuplierList(); }catch (Exception ex) {MessageBox.Show(String.Format("возниклаошибка {0}", ex.Message)); } } }}usingPetShop.Domain;usingPetShop.Service;using System;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Windows.Forms;namespacePetShop{publicpartialclassSupplyHistoryForm : Form {DataService _dataService;publicSupplyHistoryForm() {InitializeComponent(); _dataService = newDataService();UpdateGrid();suppliersList.DataSource = _dataService.GetSuppliers();suppliersList.SelectedIndex = -1;productList.DataSource = _dataService.GetProducts();productList.SelectedIndex =- 1; }privatevoidpriceTextBox_Validating(object sender, CancelEventArgs e) {double result;double.TryParse(priceTextBox.Text, out result);if (result == 0)validateLabel.Text = "ценадолжнаябытьчислом";elsevalidateLabel.Text = ""; }privatevoidUpdateGrid() {var histories = _dataService.GetSupplienmentHistories();supplyHistoryGridView.DataSource = histories;supplyHistoryGridView.Columns["Id"].Visible = false;supplyHistoryGridView.Columns["Name"].Visible = false; }privatevoidaddSupplyHistoryBtn_Click(object sender, EventArgs e) {try { _dataService.CreateSupplyHistory(supplyDateTimePicker.Value, ((Product)productList.SelectedValue).Id, ((Supplier)suppliersList.SelectedValue).Id, double.Parse(priceTextBox.Text), (int)(qtyNumericUpDown.Value));UpdateGrid(); }catch (Exception ex) {MessageBox.Show(String.Format("возниклаошибка {0}", ex.Message));} } }}