public async void Execute(object parameter)
{
await Task.Run(() => CreateCar(parameter));
using (Cars_DB db = new Cars_DB())
ViewService.Resolve <WorkCarWindow>().DataGridTask.ItemsSource = db.Cars.ToList();
}
public async void Execute(object parameter)
{
await Task.Run(() => UpdateBrand(parameter));
using (Cars_DB db = new Cars_DB())
ViewService.Resolve <WorkBrandWindow>().DataGridTask.ItemsSource = db.BrandCar.ToList();
}
public void Execute(object parameter)
{
using (Cars_DB db = new Cars_DB())
{
ViewService.Resolve <MainWindow>().DataGridTask2.ItemsSource = db.BrandCar.ToList();
ViewService.Resolve <MainWindow>().DataGridTask.ItemsSource = db.Cars.ToList();
}
}
public async void Execute(object parameter)
{
TextBox text = (TextBox)parameter;
string value = text.Text;
await Task.Run(() => DeleteBrand(value));
using (Cars_DB db = new Cars_DB())
ViewService.Resolve <WorkBrandWindow>().DataGridTask.ItemsSource = db.BrandCar.ToList();
}
private static string[] GetBrandForComboBox()
{
using (Cars_DB db = new Cars_DB())
{
string[] mas = new string[db.BrandCar.ToList().Count()];
for (int i = 0; i < db.BrandCar.ToList().Count(); i++)
{
mas[i] = db.BrandCar.ToList().ElementAt(i).Brand_Name.ToString();
}
return(mas);
}
}
private static void DeleteBrand(string parameter)
{
try
{
using (Cars_DB db = new Cars_DB())
{
db.BrandCar.Remove(db.BrandCar.Find(parameter));
db.SaveChanges();
MessageBox.Show("Брэнд успешно удалён");
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
private static void CreateCar(object parameter)
{
try
{
using (Cars_DB db = new Cars_DB())
{
db.Cars.Add((Cars)parameter);
db.SaveChanges();
MessageBox.Show("Автомобиль успешно добавлен");
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
private static void DeleteCar(string parameter)
{
try
{
using (Cars_DB db = new Cars_DB())
{
db.Cars.Remove(db.Cars.Find(parameter));
db.SaveChanges();
MessageBox.Show("Автомобиль успешно удалён");
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
private static void UpdateCar(object parameter)
{
try
{
using (Cars_DB db = new Cars_DB())
{
Cars car = (Cars)parameter;
car.Car_Name = ViewModelService.Resolve <WorkCarWindowViewModel>().Car_Name;
db.Entry(car).State = EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Автомобиль успешно изменён");
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
private static void CreateBrand(object parameter)
{
try
{
using (Cars_DB db = new Cars_DB())
{
BrandCar brand = (BrandCar)parameter;
brand.Logotype = ViewModelService.Resolve <WorkBrandWindowViewModel>().Logotype;
brand.Type_Image = ViewModelService.Resolve <WorkBrandWindowViewModel>().ImageType;
db.BrandCar.Add(brand);
db.SaveChanges();
MessageBox.Show("Брэнд успешно добавлен");
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
private static List <BrandCar> SearchBrand(object parameter)
{
string[] str = (string[])parameter;
using (Cars_DB db = new Cars_DB())
try
{
if (str[1] != null && str[1] != "")
{
switch (str[0])
{
case "Название":
var selectedcars2 = db.BrandCar.ToList();
List <BrandCar> BrandsGroup2 = new List <BrandCar>();
foreach (var c in selectedcars2)
{
if (c.Brand_Name != null && c.Brand_Name.Contains(str[1]))
{
BrandsGroup2.Add(c);
}
}
return(BrandsGroup2);
case "Описание":
var selectedcars3 = db.BrandCar.ToList();
List <BrandCar> BrandsGroup3 = new List <BrandCar>();
foreach (var c in selectedcars3)
{
if (c.Description != null && c.Description.Contains(str[1]))
{
BrandsGroup3.Add(c);
}
}
return(BrandsGroup3);
}
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
return(null);
}
private static void UpdateBrand(object parameter)
{
try
{
using (Cars_DB db = new Cars_DB())
{
BrandCar brand = (BrandCar)parameter;
if (brand.Brand_Name != ViewModelService.Resolve <WorkBrandWindowViewModel>().Brand_Name_For_Update)
{
db.BrandCar.Add(brand);
foreach (var p in db.Cars.ToList())
{
if (ViewModelService.Resolve <WorkBrandWindowViewModel>().Brand_Name_For_Update == p.Brand_Name)
{
p.Brand_Name = ViewModelService.Resolve <WorkBrandWindowViewModel>().Brand_Name;
db.Entry(p).State = EntityState.Modified;
}
}
db.BrandCar.Remove(db.BrandCar.Find(ViewModelService.Resolve <WorkBrandWindowViewModel>().Brand_Name_For_Update));
db.SaveChanges();
return;
}
brand.Brand_Name = ViewModelService.Resolve <WorkBrandWindowViewModel>().Brand_Name;
brand.Logotype = ViewModelService.Resolve <WorkBrandWindowViewModel>().Logotype;
brand.Type_Image = ViewModelService.Resolve <WorkBrandWindowViewModel>().ImageType;
db.Entry(brand).State = EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Брэнд успешно изменён");
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
private static List <Cars> SearchCar(object parameter)
{
string[] str = (string[])parameter;
using (Cars_DB db = new Cars_DB())
try
{
if (str[1] != null && str[1] != "")
{
switch (str[0])
{
case "Название":
var selectedcars1 = db.Cars.ToList();
List <Cars> CarsGroup1 = new List <Cars>();
foreach (var c in selectedcars1)
{
if (c.Car_Name != null && c.Car_Name.Contains(str[1]))
{
CarsGroup1.Add(c);
}
}
return(CarsGroup1);
case "Брэнд":
var selectedcars2 = db.Cars.ToList();
List <Cars> CarsGroup2 = new List <Cars>();
foreach (var c in selectedcars2)
{
if (c.Brand_Name != null && c.Brand_Name.Contains(str[1]))
{
CarsGroup2.Add(c);
}
}
return(CarsGroup2);
case "Тип топлива":
var selectedcars3 = db.Cars.ToList();
List <Cars> CarsGroup3 = new List <Cars>();
foreach (var c in selectedcars3)
{
if (c.Type_Fuel != null && c.Type_Fuel.Contains(str[1]))
{
CarsGroup3.Add(c);
}
}
return(CarsGroup3);
case "Цена":
var selectedcars4 = db.Cars.ToList();
List <Cars> CarsGroup4 = new List <Cars>();
foreach (var c in selectedcars4)
{
if (c.Price != null && c.Price.ToString().Contains(str[1]))
{
CarsGroup4.Add(c);
}
}
return(CarsGroup4);
case "Дата появления":
var selectedcars5 = db.Cars.ToList();
List <Cars> CarsGroup5 = new List <Cars>();
if (str[1].Contains("/"))
{
str[1] = str[1].Replace("/", ".");
}
if (str[1].Contains("-"))
{
str[1] = str[1].Replace("-", ".");
}
foreach (var c in selectedcars5)
{
if (c.Date_Appearance != null && c.Date_Appearance.ToString().Contains(str[1]))
{
CarsGroup5.Add(c);
}
}
return(CarsGroup5);
case "Класс":
var selectedcars6 = db.Cars.ToList();
List <Cars> CarsGroup6 = new List <Cars>();
foreach (var c in selectedcars6)
{
if (c.Class_Car != null && c.Class_Car.Contains(str[1]))
{
CarsGroup6.Add(c);
}
}
return(CarsGroup6);
case "Вместимость":
var selectedcars7 = db.Cars.ToList();
List <Cars> CarsGroup7 = new List <Cars>();
foreach (var c in selectedcars7)
{
if (c.Capacity_People != null && c.Capacity_People.ToString().Contains(str[1]))
{
CarsGroup7.Add(c);
}
}
return(CarsGroup7);
case "Доступность":
var selectedcars8 = db.Cars.ToList();
List <Cars> CarsGroup8 = new List <Cars>();
foreach (var c in selectedcars8)
{
if (c.Availability != null && c.Availability.ToString().Contains(str[1]))
{
CarsGroup8.Add(c);
}
}
return(CarsGroup8);
}
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
return(null);
}
public List <BrandCar> GetBrands()
{
using (Cars_DB db = new Cars_DB())
listbrands = db.BrandCar.ToList();
return(listbrands);
}
private List <Cars> GetCars()
{
using (Cars_DB db = new Cars_DB())
listcars = db.Cars.ToList();
return(listcars);
}
