public static bool EditCargo(int id, Cargo cargo)
{
try
{
using (TransportCompanyContext db = new TransportCompanyContext())
{
bool result = false;
DataValidation dataValidation = new DataValidation();
if (dataValidation.CheckAllInput(cargo))
{
var cargos = db.Cargos.ToList();
for (int i = 0; i < cargos.Count; i++)
{
if (cargos[i].Id == id)
{
cargos[i].CopyFields(cargo);
db.SaveChanges();
result = true;
}
}
}
return(result);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
public static bool DeleteCargo(int id)
{
try
{
using (TransportCompanyContext db = new TransportCompanyContext())
{
bool result = false;
if (id > 0)
{
var cargos = db.Cargos.ToList();
foreach (var cargo in cargos)
{
if (id > 0 && cargo.Id == id)
{
db.Cargos.Remove(cargo);
result = true;
}
}
db.SaveChanges();
}
else
{
result = false;
}
return(result);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
public static void SelectAllInfo(DataGridView dataGridView1)
{
try
{
using (TransportCompanyContext db = new TransportCompanyContext())
{
var cargos = db.Cargos.ToList();
foreach (var cargo in cargos)
{
dataGridView1.Rows.Add(new string[] {
Convert.ToString(cargo.Id),
cargo.Name,
Convert.ToString(cargo.Cost),
Convert.ToString(cargo.Weight),
Convert.ToString(cargo.Volume),
cargo.TrailerType,
cargo.UploadDate.ToString(),
cargo.Status,
cargo.DownloadLocation,
cargo.PlaceOfDischarge,
Convert.ToString(cargo.Distance)
});
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static bool AddCargo(Cargo cargo)
{
try
{
DataValidation dataValidation = new DataValidation();
using (TransportCompanyContext db = new TransportCompanyContext())
{
bool result;
if (dataValidation.CheckAllInput(cargo))
{
db.Cargos.Add(cargo);
db.SaveChanges();
result = true;
}
else
{
result = false;
}
return(result);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
public static string SelectAllDetailed(int id)
{
StringBuilder result = new StringBuilder();
try
{
using (TransportCompanyContext db = new TransportCompanyContext())
{
var cargos = db.Cargos.ToList();
foreach (var cargo in cargos)
{
if (cargo.Id == id)
{
result.Append($"Название: {cargo.Name} \nСтоимость: {cargo.Cost} \nВес: {cargo.Weight} \nОбъём: {cargo.Volume} \n" +
$"Тип кузова: { cargo.TrailerType} \nДата загрузки: {cargo.UploadDate} \nСтатус заказа: {cargo.Status} \nМесто загрузки: " +
$"{cargo.DownloadLocation} \nМесто разгрузки: {cargo.PlaceOfDischarge} \nРасстояние: {cargo.Distance}\n");
}
}
return(result.ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(result.ToString());
}
public static string SelectCargoId(string login)
{
string result = null;
try
{
using (TransportCompanyContext db = new TransportCompanyContext())
{
var users = db.Users.ToList();
foreach (var user in users)
{
if (user.Login == login)
{
result = user.CargoId;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
return(result);
}
return(result);
}
public static void AddUser(string login, string password)
{
try
{
using (TransportCompanyContext db = new TransportCompanyContext())
{
User newUser = new User {
Login = login, Password = password
};
db.Users.Add(newUser);
db.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static Cargo SelectById(int id)
{
try
{
using (TransportCompanyContext db = new TransportCompanyContext())
{
var cargos = db.Cargos.ToList();
foreach (var cargo in cargos)
{
if (cargo.Id == id)
{
return(cargo);
}
}
return(null);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
return(null);
}
}
public static bool CheckCargoInDB(Cargo newCargo)
{
try
{
using (TransportCompanyContext db = new TransportCompanyContext())
{
var cargos = db.Cargos.ToList();
foreach (var cargo in cargos)
{
if (cargo.Equals(newCargo))
{
return(true);
}
}
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
public static void UpdateStatus(string status, int id)
{
try
{
using (TransportCompanyContext db = new TransportCompanyContext())
{
var cargos = db.Cargos.ToList();
foreach (var cargo in cargos)
{
if (cargo.Id == id)
{
cargo.Status = status;
}
}
db.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static bool CheckUserInDB(string login)
{
try
{
using (TransportCompanyContext db = new TransportCompanyContext())
{
var users = db.Users.ToList();
foreach (var user in users)
{
if (user.Login == login)
{
return(true);
}
}
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
public static void UpdateFavourites(string cargoId, string login)
{
try
{
using (TransportCompanyContext db = new TransportCompanyContext())
{
var users = db.Users.ToList();
foreach (var user in users)
{
if (user.Login == login)
{
user.CargoId = cargoId;
}
}
db.SaveChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static void Select(DataGridView dataGridView1)
{
try
{
using (TransportCompanyContext db = new TransportCompanyContext())
{
var cargos = db.Cargos.ToList();
foreach (var cargo in cargos)
{
dataGridView1.Rows.Add(new string[] {
Convert.ToString(cargo.Id),
cargo.Name,
Convert.ToString(cargo.Cost),
Convert.ToString(cargo.Weight),
Convert.ToString(cargo.Volume),
});
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//Проверка авторизации пользователя
public static bool IsUser(string login, string password)
{
using (TransportCompanyContext db = new TransportCompanyContext())
{
bool result = false;
try
{
var users = db.Users.ToList();
foreach (var user in users)
{
if (user.Login == login && user.Password == password)
{
result = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
return(result);
}
}
public static void Initialize(TransportCompanyContext db)
{
db.Database.EnsureCreated();
int rows;
int rowIndex;
if (!db.CarBrands.Any())
{
rows = 500;
rowIndex = 0;
while (rowIndex < rows)
{
CarBrand carBrand = new CarBrand
{
Name = GetRandomElement(brands),
Specification = GetString(6, 12),
Description = GetString(12, 13)
};
db.CarBrands.Add(carBrand);
rowIndex++;
}
db.SaveChanges();
}
if (!db.CarTypes.Any())
{
rows = 500;
rowIndex = 0;
while (rowIndex < rows)
{
CarType carType = new CarType
{
Name = GetRandomElement(types),
Description = GetString(8, 13)
};
db.CarTypes.Add(carType);
rowIndex++;
}
db.SaveChanges();
}
if (!db.Cars.Any())
{
rows = 20000;
rowIndex = 0;
int minCarBrandId = db.CarBrands.Min(x => x.Id);
int maxCarBrandId = db.CarBrands.Max(x => x.Id);
int minCarTypeId = db.CarTypes.Min(x => x.Id);
int maxCarTypeId = db.CarTypes.Max(x => x.Id);
while (rowIndex < rows)
{
Car car = new Car
{
CarBrandId = random.Next(minCarBrandId, maxCarBrandId + 1),
CarTypeId = random.Next(minCarTypeId, maxCarTypeId + 1),
RegistrationNumber = GetString(6, 7),
BodyNumber = GetString(3, 5),
EngineNumber = GetString(3, 5),
YearOfIssue = random.Next(2000, 2021),
DriverEmployee = GetString(4, 8),
DateOfLastMaintenance = NextDateTime().Date,
Mechanic = GetString(4, 8)
};
db.Cars.Add(car);
rowIndex++;
}
db.SaveChanges();
}
}
public CarsController(TransportCompanyContext context)
{
_context = context;
}
