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