Разработка информационной системы

Domain{publicclassTypeOfRawMateiral : IComparable {publicGuid Id { get; set; }publicstring Name { get; set; }publicintCompareTo(object? obj) {returnName.CompareTo(((TypeOfRawMateiral)obj).Name); }publicoverridestringToString() {return Name;}}}usingSystem.ComponentModel;namespaceExport.Domain{publicclassCountry : IComparable {publicGuid Id { get; set; } [DisplayName("Страна")]publicstring Name { get; set; }publicoverridestringToString() {return Name; }publicintCompareTo(object? obj) {returnName.CompareTo(((Country)obj).Name);} }}СервисныйслойusingExport.Domain;namespaceExport.Service{publicclassExportDataService {public List GetAllContracts() {using (var context = newExportDataContext()) {returncontext.ExportСontracts.Include("Country").Include("TypeOfRawMateiral").ToList(); } }public List GetAllCountries() {using (var context = newExportDataContext()) {returncontext.Countries.ToList(); } }public List GetAllSuppliers() {using (var context = newExportDataContext()) {returncontext.ExportСontracts.Select(x=>x.SupplierFirm).Distinct().ToList(); } }public List GetAllTypeOfRawMaterials() {using (var context = newExportDataContext()){returncontext.TypeOfRawMateirals.ToList(); } }publicvoidSaveCountry(stringcountryName) {using (var context = newExportDataContext()) {context.Countries.Add(new Country() { Id = Guid.NewGuid(), Name = countryName});context.SaveChanges(); } }publicvoidSaveRawMaterial(stringrawMaterial) {using (var context = newExportDataContext()) {context.TypeOfRawMateirals.Add(newTypeOfRawMateiral() { Id = Guid.NewGuid(), Name = rawMaterial });context.SaveChanges(); } }publicvoidSaveContract(stringcompanyRecipient, DateTimeconclusionDate, double sum, string country, stringsupplierFirm, stringtypeOfRawMateiral) {using (var context = newExportDataContext()) {context.ExportСontracts.Add(newExportContract() { Id = Guid.NewGuid(),CompanyRecipient = companyRecipient,ConclusionDate = conclusionDate, Country = context.Countries.First(x=>x.Name == country), Sum = sum,SupplierFirm = supplierFirm,TypeOfRawMateiral = context.TypeOfRawMateirals.First(x=>x.Name == typeOfRawMateiral)});context.SaveChanges(); } } }}Слой представленияusingSystem.ComponentModel;usingExport.Service;namespaceExportView{publicpartialclassForm1 : Form {private List list;privateExportDataService _exportDataService;publicForm1() {InitializeComponent(); _exportDataService = newExportDataService(); _exportDataService.InitDataBase();list = _exportDataService.GetAllContracts().OrderBy(x => x.ConclusionDate).ToList();var source = newBindingList(list);this.ExportContractsGrid.DataSource = source;this.ExportContractsGrid.Columns["Id"].Visible = false;foreach (DataGridViewColumn column inExportContractsGrid.Columns) {column.SortMode = DataGridViewColumnSortMode.Automatic; }this.ExportContractsGrid.ColumnHeaderMouseClick += ExportContractsGrid_ColumnHeaderMouseClick;this.sum.CausesValidation = true;this.sum.Leave += Sum_Leave;this.saveButton.Click += SaveButton_Click;countryComboBox.DataSource = _exportDataService.GetAllCountries();countryComboBox.DisplayMember = "Name";countryComboBox.SelectedIndex = -1;rawMaterialComboBox.DataSource = _exportDataService.GetAllTypeOfRawMaterials();rawMaterialComboBox.DisplayMember = "Name";rawMaterialComboBox.SelectedIndex = -1;CountrySearchComboBox.DataSource = _exportDataService.GetAllCountries();CountrySearchComboBox.DisplayMember = "Name";CountrySearchComboBox.SelectedIndex = -1;RawMaterialSearchComboBox.DataSource = _exportDataService.GetAllTypeOfRawMaterials();RawMaterialSearchComboBox.DisplayMember = "Name";RawMaterialSearchComboBox.SelectedIndex = -1;SupplierComboBox.DataSource = _exportDataService.GetAllSuppliers();SupplierComboBox.DisplayMember = "Name";SupplierComboBox.SelectedIndex = -1;var t = list .GroupBy(l => l.TypeOfRawMateiral.Name) .Select(cl => newRawMaterialConclusion { Name = cl.Key, Sum = cl.Sum(c => c.Sum),}).ToList();varmaterialSource = newBindingList(t);RawMaterialConclusionGrid.DataSource = materialSource;var c = list .GroupBy(l => new { Counrty = l.Country.Name, RawMaterial = l.TypeOfRawMateiral.Name }) .Select(cl => newCountryConclusion { Name = cl.Key.Counrty,RawMaterial = cl.Key.RawMaterial, Sum = cl.Sum(c => c.Sum), }).ToList();varcountrySource = newBindingList(c);countryConclusionGridView.DataSource = countrySource;var s = list .GroupBy(l => new { Supplier = l.SupplierFirm, RawMaterial = l.TypeOfRawMateiral.Name }) .Select(cl => newSupplierConclusion { Name = cl.Key.Supplier,RawMaterial = cl.Key.RawMaterial, Sum = cl.Sum(c => c.Sum), }).ToList();varsupplierSource = newBindingList(s);SupplierFirmGridView.DataSource = supplierSource;var m = list.GroupBy(l => new { Supplier = l.SupplierFirm, ConclusionDate = l.ConclusionDate.ToString("Y")}).Select(cl => newMonthConclusion{ Supplier = cl.Key.Supplier, Month = cl.Key.ConclusionDate, Sum = cl.Sum(c => c.Sum),}).ToList();varmonthSource = newBindingList(m);MonthConclusionGridView.DataSource = monthSource; }privatevoidSaveButton_Click(object? sender, EventArgs e) { _exportDataService.SaveContract(recepientFirm.Text, dateTimePicker.Value, double.Parse(sum.Text), countryComboBox.Text, supplierFirm.Text, rawMaterialComboBox.Text);MessageBox.Show("договор успешно сохранён!");recepientFirm.Text = string.Empty;dateTimePicker.Value = DateTime.Now;sum.Text = string.Empty;countryComboBox.SelectedIndex = -1;supplierFirm.Text = string.Empty;countryComboBox.SelectedIndex =-1; ExportContractsGrid.DataSource = _exportDataService.GetAllContracts(); }privatevoidSum_Leave(object? sender, EventArgs e) {doubledoubleSum = 0;if (!double.TryParse(sum.Text, outdoubleSum)){MessageBox.Show("Сумма договора должна быть числом");sum.Text = string.Empty; } }privatevoidExportContractsGrid_ColumnHeaderMouseClick(object? sender, DataGridViewCellMouseEventArgs e) {var name = ExportContractsGrid.Columns[e.ColumnIndex].Name;ExportContractsGrid.DataSource = list.OrderBy(o => o.GetType() .GetProperty(ExportContractsGrid.Columns[e.ColumnIndex].Name).GetValue(o, null)).ToList();ExportContractsGrid.Show(); }privatevoid Form1_Load(object sender, EventArgs e){ }privatevoidaddCountry_Click(object sender, EventArgs e) {if(!string.IsNullOrEmpty(countryComboBox.Text)) _exportDataService.SaveCountry(countryTextBox.Text);countryComboBox.DataSource = _exportDataService.GetAllCountries();countryComboBox.DisplayMember = "Name"; }privatevoidaddRawMaterial_Click(object sender, EventArgs e) {if (!string.IsNullOrEmpty(rawMaterialComboBox.Text)) _exportDataService.SaveRawMaterial(rawMaterialTextBox.Text);rawMaterialComboBox.DataSource = _exportDataService.GetAllTypeOfRawMaterials();rawMaterialComboBox.DisplayMember = "Name"; }privatevoidsearchButton_Click(object sender, EventArgs e){ List searchResult = list;if (SupplierComboBox.SelectedValue!=null)searchResult = searchResult.Where(x => x.SupplierFirm == SupplierComboBox.SelectedValue.ToString()).ToList();if (RawMaterialSearchComboBox.SelectedValue!=null)searchResult = searchResult.Where(x => x.TypeOfRawMateiral.Name == RawMaterialSearchComboBox.SelectedValue.ToString()).ToList();if (CountrySearchComboBox.SelectedValue!=null)searchResult = searchResult.Where(x => x.Country.Name == CountrySearchComboBox.SelectedValue.ToString()).ToList();if (startDateTimePicker.Value.Date != DateTime.Today || EndDateTimePicker.Value.Date != DateTime.Today)searchResult = searchResult.Where(x => x.ConclusionDate >= startDateTimePicker.Value && x.ConclusionDate <= EndDateTimePicker.Value).ToList();ExportContractsGrid.DataSource = searchResult; } }publicclassRawMaterialConclusion {publicstring Name { get; set; }publicdouble Sum { get; set; } }publicclassCountryConclusion {publicstring Name { get; set; }publicdouble Sum { get; set; }publicstringRawMaterial { get; set; } }publicclassSupplierConclusion {publicstring Name { get; set; }publicdouble Sum { get; set; }publicstringRawMaterial { get; set; } }publicclassMonthConclusion {publicstring Month { get; set; }publicdouble Sum { get; set; }publicstring Supplier { get; set; }}}Тестовыеметоды [TestClass]publicclassUnitTests { [TestMethod]publicvoidTestSaveMethod() {var service = newExport.Service.ExportDataService();int all = 0;all = service.GetAll().Count;service.SaveContract("test", DateTime.Now.AddMonths(-8), 1000, "TestCountry", "Test firm", "Test material");Assert.AreNotEqual(all, service.GetAll().Count); } [TestMethod]publicvoid TestSaveMethod2() {var service = newExport.Service.ExportDataService();int all = 0;all = service.GetAll().Count;service.SaveContract("test", DateTime.Now.AddMonths(-8), 1000, "TestCountry", "Test firm", "Test material");Assert.AreEqual(all+1, service.GetAll().Count);} }