private void DetailedInformation(object sender, EventArgs e) { int id = GetIdInformationGridView(); string information = CargosDB.SelectAllDetailed(id); MessageBox.Show(information, "Подробная информация", MessageBoxButtons.OK); }
//Добавление записи в БД private void CargoAdd_Click(object sender, EventArgs e) { Cargo cargo; try { cargo = Initializer.InitCargoWithAddForm(this); if (!CargosDB.CheckCargoInDB(cargo)) { if (CargosDB.AddCargo(cargo)) { MessageBox.Show("Груз успешно добавлен."); this.Close(); } else { MessageBox.Show("Проверьте правильность ввода данных", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Груз с таким наименованием уже существует", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch { MessageBox.Show("Проверьте правильность ввода данных", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void DetailedInformation(object sender, EventArgs e) { int line = dataGridView1.CurrentRow.Index; int id = Convert.ToInt32(dataGridView1.Rows[line].Cells[0].Value); string information = CargosDB.SelectAllDetailed(id); MessageBox.Show(information, "Просмотр", MessageBoxButtons.OK); }
public void SelectByIdTest_InCorrectId_ReturnNull() { Cargo factResult; int id = 99; factResult = CargosDB.SelectById(id); Assert.AreEqual(null, factResult); }
public void DeleteCargoTest_CorrectId_ReturnFalse() { bool factResult; int id = 99; factResult = CargosDB.DeleteCargo(id); Assert.IsFalse(factResult); }
public void SelectAllDetailedTest_inCorrectId_ReturnNull() { string expectResult = ""; string factResult; int id = 33; factResult = CargosDB.SelectAllDetailed(id); Assert.AreEqual(expectResult, factResult); }
public void SelectAllDetailedTest_CorrectId_ReturnDetailedInformation() { string expectResult = "Название: Чипсы \nСтоимость: 1900 \nВес: 4 \nОбъём: 86 \n" + "Тип кузова: Крытый \nДата загрузки: 20.12.2019 0:00:00 \nСтатус заказа: Не доставлен \nМесто загрузки: " + "Брест \nМесто разгрузки: Витебск \nРасстояние: 630\n"; string factResult; int id = 12; factResult = CargosDB.SelectAllDetailed(id); Assert.AreEqual(expectResult, factResult); }
//Запись данных в таблицу private void Catalog_Load(object sender, EventArgs e) { if (userForm != null) { userForm.Visible = false; } else { CheckGuestCatalog(); homeForm.Visible = false; } CargosDB.Select(informationGridView); }
private void DeleteCargoButton_Click(object sender, EventArgs e) { if (MessageBox.Show("Удалить запись?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { int line = informationGridView.CurrentRow.Index; int id = Convert.ToInt32(informationGridView.Rows[line].Cells[0].Value.ToString()); CargosDB.DeleteCargo(id); MessageBox.Show("Запись удалена", "Информация", MessageBoxButtons.OK, MessageBoxIcon.Information); } adminForm.Visible = true; this.Close(); }
private void Favourites_Load(object sender, EventArgs e) { string resultId = UsersDB.SelectCargoId(userForm.Login); if (resultId != null && resultId != "") { userForm.Visible = false; int[] id = resultId.Split(' '). Where(x => !string.IsNullOrWhiteSpace(x)). Select(x => int.Parse(x)).ToArray(); CargosDB.SelectFavourites(dataGridView1, id); } else { MessageBox.Show("Добавьте груз в избранное", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); this.Close(); } }
public void AddCargoTest_CorrectData_ReturnTrue() { bool factResult; Cargo cargo = new Cargo { Name = "Чипсы", Cost = 1900, Weight = 4, Volume = 86, UploadDate = DateTime.Parse("20.12.2019"), TrailerType = "Крытый", Status = "Не доставлен", DownloadLocation = "Брест", PlaceOfDischarge = "Витебск", Distance = 630 }; factResult = CargosDB.AddCargo(cargo); Assert.IsTrue(factResult, "Проверьте введенные данные"); }
public void AddCargoTest_IncorrectData_ReturnFalse() { bool factResult; Cargo cargo = new Cargo { Name = "Минеральная вода", Cost = -50, Weight = 0, Volume = 20, UploadDate = DateTime.Parse("09.11.2019"), TrailerType = "Крытый", Status = "В пути", DownloadLocation = "", PlaceOfDischarge = "Витебск", Distance = -10 }; factResult = CargosDB.AddCargo(cargo); Assert.IsFalse(factResult); }
public void AddCargoTest3_IncorrectDate_ReturnFalse() { bool factResult; Cargo cargo = new Cargo { Name = "Минеральная вода", Cost = 1900, Weight = 4, Volume = 20, UploadDate = DateTime.Parse("20.12.2018"), TrailerType = "Крытый", Status = "В пути", DownloadLocation = "Минск", PlaceOfDischarge = "Витебск", Distance = 290 }; factResult = CargosDB.AddCargo(cargo); Assert.IsFalse(factResult, "Проверьте введенную дату"); }
public void CheckCargoInDBTest_NotExistingCargo_ReturnFalse() { bool factResult; Cargo newCargo = new Cargo { Name = "Минеральная вода", Cost = 100, Weight = 5, Volume = 2, UploadDate = DateTime.Parse("30.12.2019"), TrailerType = "Крытый", Status = "Не доставлен", DownloadLocation = "Минск", PlaceOfDischarge = "Жодино", Distance = 100 }; factResult = CargosDB.CheckCargoInDB(newCargo); Assert.IsFalse(factResult); }
public void SelectByIdTest_CorrectId_ReturnCargo() { Cargo expectResult = new Cargo { Name = "Чипсы", Cost = 1900, Weight = 4, Volume = 86, UploadDate = DateTime.Parse("20.12.2019"), TrailerType = "Крытый", Status = "Не доставлен", DownloadLocation = "Брест", PlaceOfDischarge = "Витебск", Distance = 630 }; Cargo factResult; int id = 12; factResult = CargosDB.SelectById(id); Assert.ReferenceEquals(expectResult, factResult); }
public void EditCargoTest_IncorrectData_ReturnFalse() { bool factResult; int idCargo = -4; Cargo cargo = new Cargo { Name = "Минеральная вода", Cost = -10, Weight = 5, Volume = 0, UploadDate = DateTime.Parse("30.12.2018"), TrailerType = "Крытый", Status = "Не доставлен", DownloadLocation = "", PlaceOfDischarge = "Несвиж", Distance = 0 }; factResult = CargosDB.EditCargo(idCargo, cargo); Assert.IsFalse(factResult, "Проверьте введенные данные"); }
public CatalogForAdmin(AdminForm adminForm) { InitializeComponent(); this.adminForm = adminForm; CargosDB.SelectAllInfo(informationGridView); }
//Запись данных в таблицу private void DeleteCargoForm_Load(object sender, EventArgs e) { CargosDB.SelectAllInfo(informationGridView); adminForm.Visible = false; }
private void StatusChange(object sender, EventArgs e) { int id = GetIdInformationGridView(); CargosDB.UpdateStatus("В пути", id); }