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);
}
