protected override void Act() { if (!Checker.IsNumber(textBox1.Text)) { MessageBox.Show("Неверный номер квартиры"); return; } int ind = dataGridView1.SelectedRows[0].Index; int id = 0; bool ok = int.TryParse(dataGridView1[Program.FindTitle(dataGridView1, "Id"), ind].Value.ToString(), out id); if (!ok) { return; } if (ActionMode == ActionMode.Add) { if (Operations.AddAddress(int.Parse(textBox1.Text), Operations.FindHouse(id), out string Res)) { Close(); } MessageBox.Show(Res); } else { if (Operations.ChangeAddress(Id, int.Parse(textBox1.Text), Operations.FindHouse(id), out string Res)) { Close(); } MessageBox.Show(Res); } }
private void button5_Click(object sender, EventArgs e) { if (openFileDialog1.ShowDialog() == DialogResult.OK) { Excel.Worksheet worksheet = null; Excel.Range range = null; try { application = new Excel.Application(); workbook = application.Workbooks.Open(openFileDialog1.FileName); application.Visible = true; worksheet = workbook.Worksheets[1]; range = worksheet.UsedRange; string CityName = range.Cells[1, 2].Value2.ToString(); string StreetName = range.Cells[2, 2].Value2.ToString(); string HouseNumber = range.Cells[3, 2].Value2.ToString(); string FlatNumber = range.Cells[4, 2].Value2.ToString(); string FIO = range.Cells[5, 2].Value2.ToString(); string PassportNumber = range.Cells[6, 2].Value2.ToString(); string PhoneNumber = range.Cells[7, 2].Value2.ToString(); string CompanyName = range.Cells[8, 2].Value2.ToString(); string INN = range.Cells[9, 2].Value2.ToString(); string ErrorMsg = string.Empty; bool NotCompany = CompanyName.Length == 0 && INN.Length == 0; if (!Checker.IsName(CityName)) { ErrorMsg += "Неверная строка в названии города\n"; } if (!Checker.IsName(StreetName)) { ErrorMsg += "Неверная строка в названии улицы\n"; } if (!Checker.IsHouseNumber(HouseNumber)) { ErrorMsg += "Неверная строка в номере дома\n"; } if (!Checker.IsNumber(FlatNumber)) { ErrorMsg += "Неверная строка в номере квартиры\n"; } if (!Checker.IsFIO(FIO)) { ErrorMsg += "Неверная строка в ФИО\n"; } if (!Checker.IsPassportNumber(PassportNumber)) { ErrorMsg += "Неверная строка в номере паспорта\n"; } if (!Checker.IsPhoneNumber(PhoneNumber)) { ErrorMsg += "Неверная строка в номере телефона\n"; } if (!Checker.IsName(CompanyName) && !NotCompany) { ErrorMsg += "Неверная строка в названии организации\n"; } if (!Checker.IsINN(INN) && !NotCompany) { ErrorMsg += "Неверная строка в ИНН\n"; } if (ErrorMsg.Length == 0) { _City _City = new _City { Name = CityName }; _Street _Street = new _Street { Name = StreetName }; _House _House = new _House { Number = HouseNumber }; _Address _Address = new _Address { Flat = int.Parse(FlatNumber) }; _Customer _Customer; if (NotCompany) { _Customer = new _Customer() { FIO = FIO, Passport = PassportNumber, PhoneNumber = PhoneNumber }; } else { _Customer = new _Company() { FIO = FIO, Passport = PassportNumber, PhoneNumber = PhoneNumber, CompanyName = CompanyName, INN = INN } }; List <_OrderEntry> list = new List <_OrderEntry>(); int row = 2; while (range[row, 4] != null && range[row, 4].Value2 != null && range[row, 4].Value2.ToString().Length > 0 && ErrorMsg.Length == 0) { string MeterId = range[row, 4].Value2.ToString(); if (!Checker.IsNumber(MeterId)) { ErrorMsg += "Неверная строка в номере счётчика\n"; } DateTime StartTime = default(DateTime), EndTime = default(DateTime); if (range[row, 5] != null && range[row, 5].Value2 != null) { string sStartTime = range[row, 5].Value2.ToString(); if (sStartTime.Length > 0 && double.TryParse(sStartTime, out double dstart)) { StartTime = DateTime.FromOADate(dstart); } else { ErrorMsg += "Неверная строка во времени начала\n"; } } if (range[row, 6] != null && range[row, 6].Value2 != null) { string sEndTime = range[row, 6].Value2.ToString(); if (sEndTime.Length > 0 && double.TryParse(sEndTime, out double dend)) { EndTime = DateTime.FromOADate(dend); } else { ErrorMsg += "Неверная строка во времени конца\n"; } } if (StartTime != default(DateTime) && EndTime != default(DateTime) && StartTime > EndTime) { ErrorMsg += "Дата начала позже даты конца\n"; } if (ErrorMsg.Length == 0) { var ord = new _OrderEntry { MeterId = int.Parse(MeterId) }; if (StartTime != default(DateTime)) { ord.startTime = StartTime; } if (EndTime != default(DateTime)) { ord.endTime = EndTime; } list.Add(ord); ++row; } } if (ErrorMsg.Length == 0) { try { dataGridView1.DataSource = list; Program.HideColumns(ref dataGridView1, EntityTypes.OrderEntry, CurrentUser); Program.HidaColumns(ref dataGridView1, new List <string> { "Id", "OrderId", "StatusId", "RegNum" }); Program.Rename(ref dataGridView1); address1 = _Address; house1 = _House; street1 = _Street; city1 = _City; customer1 = _Customer; } catch (Exception ex) { MessageBox.Show(ex.Message); return; } } else { MessageBox.Show(ErrorMsg); } } else { MessageBox.Show(ErrorMsg); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (range != null) { Marshal.ReleaseComObject(range); } if (worksheet != null) { Marshal.ReleaseComObject(worksheet); } } } }
private void button2_Click(object sender, EventArgs e) { Customer customer; if (radioButton2.Checked) { if (!Checker.IsFIO(NameTextBox.Text)) { MessageBox.Show("Неверное ФИО заказчика"); return; } if (!Checker.IsPhoneNumber(PhoneNumberTextBox.Text)) { MessageBox.Show("Неверный номер телефона"); return; } if (!Checker.IsPassportNumber(PassportTextBox.Text)) { MessageBox.Show("Неверный номер пасспорта"); return; } if (!BCompany) { if (!Operations.AddCustomer(NameTextBox.Text, PassportTextBox.Text, PhoneNumberTextBox.Text, out string Res)) { MessageBox.Show(Res); return; } customer = (from c in Operations.cont.CustomerSet where !(c is Company) && c.Passport == PassportTextBox.Text select c).First(); } else { if (!Checker.IsName(CompanyNameTextBox.Text)) { MessageBox.Show("Неверная строка названия компании"); return; } if (!Checker.IsINN(INNTextBox.Text)) { MessageBox.Show("Неверный ИНН компании"); return; } if (!Operations.AddCompany(NameTextBox.Text, PassportTextBox.Text, PhoneNumberTextBox.Text, CompanyNameTextBox.Text, INNTextBox.Text, out string Res)) { MessageBox.Show(Res); return; } customer = (from c in Operations.cont.CustomerSet where c is Company && (c as Company).INN == INNTextBox.Text select c).First(); } } else { int id = int.Parse(CustomerDataGridView[Program.FindTitle(CustomerDataGridView, "Id"), CustomerDataGridView.SelectedRows[0].Index].Value.ToString()); if (!BCompany) { customer = Operations.FindCustomer(id); } else { customer = Operations.FindCompany(id); } } if (city == null) { if (!Checker.IsName(CityTextBox.Text)) { MessageBox.Show("Неверное название города"); return; } if (!Operations.AddCity(CityTextBox.Text, out string Res)) { MessageBox.Show(Res); return; } city = (from p in Operations.cont.CitySet where p.Name == CityTextBox.Text select p).First(); } if (street == null) { if (!Checker.IsName(StreetTextBox.Text)) { MessageBox.Show("Неверное название улицы"); return; } if (!Operations.AddStreet(StreetTextBox.Text, city, out string Res1)) { MessageBox.Show(Res1); return; } street = (from p in city.Street where p.Name == StreetTextBox.Text select p).First(); } if (house == null) { if (!Checker.IsHouseNumber(HouseTextBox.Text)) { MessageBox.Show("Неверный номер дома"); return; } if (!Operations.AddHouse(HouseTextBox.Text, street, out string res2)) { MessageBox.Show(res2); return; } house = (from p in street.House where p.Number == HouseTextBox.Text select p).First(); } if (address == null) { if (!Checker.IsNumber(AddressTextBox.Text)) { MessageBox.Show("Неверный номер квартиры"); return; } if (!Operations.AddAddress(int.Parse(AddressTextBox.Text), house, out string Res4)) { MessageBox.Show(Res4); return; } address = (from p in house.Address where p.Flat == int.Parse(AddressTextBox.Text) select p).First(); } if (!Operations.AddOrder(CurrentUser, customer, address, out string res, out int order)) { MessageBox.Show(res); return; } foreach (_OrderEntry o in OrderEntryList) { if (!Operations.AddOrderEntry(Operations.FindOrder(order), o.startTime, o.endTime, o.RegNum, Operations.FindMeter(o.MeterId), null, Operations.FindStatus(1), out string Res2)) { MessageBox.Show(Res2); return; } } MessageBox.Show("Успешно добавлен заказ №" + order); }
protected override void Act() { if (textBox1.Text.Length > 0 && !Checker.IsNumber(textBox1.Text)) { MessageBox.Show("Неверный регистрационный номер"); return; } int ind1 = dataGridView1.SelectedRows[0].Index; int id1 = 0; bool ok = int.TryParse(dataGridView1[Program.FindTitle(dataGridView1, "Id"), ind1].Value.ToString(), out id1); if (!ok) { return; } int ind2 = dataGridView2.SelectedRows[0].Index; int id2 = 0; ok = int.TryParse(dataGridView2[Program.FindTitle(dataGridView2, "Id"), ind2].Value.ToString(), out id2); if (!ok) { return; } int ind3 = dataGridView3.SelectedRows[0].Index; int id3 = 0; ok = int.TryParse(dataGridView3[Program.FindTitle(dataGridView3, "Id"), ind3].Value.ToString(), out id3); if (!ok) { return; } Person person; if (dataGridView4.SelectedRows.Count > 0) { int ind4 = dataGridView4.SelectedRows[0].Index; int id4 = 0; ok = int.TryParse(dataGridView4[Program.FindTitle(dataGridView4, "Id"), ind4].Value.ToString(), out id4); if (!ok) { return; } person = Operations.FindPerson(id4); } else { person = null; } if (ActionMode == ActionMode.Add) { if (Operations.AddOrderEntry(Operations.FindOrder(id1), dateTimePicker1.Value, dateTimePicker2.Value, textBox1.Text, Operations.FindMeter(id2), person, Operations.FindStatus(id3), out string Res)) { Close(); } MessageBox.Show(Res); } else { if (Operations.ChangeOrderEntry(Id, Operations.FindOrder(id1), dateTimePicker1.Value, dateTimePicker2.Value, textBox1.Text, Operations.FindMeter(id2), person, Operations.FindStatus(id3), out string Res)) { Close(); } MessageBox.Show(Res); } }