public OrderViewModel GetElement(OrderBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoshowDbContext())
{
var order = context.Orders
.Include(rec => rec.Employee)
.Include(rec => rec.Customer)
.Include(rec => rec.Car)
.FirstOrDefault(rec => rec.Id == model.Id);
return(order != null ?
new OrderViewModel
{
Id = order.Id,
Date = order.Date,
CarId = order.CarId,
EmployeeId = order.EmployeeId,
CustomerId = order.CustomerId,
CarName = order.Car.Model,
EmployeeName = order.EmployeeId.HasValue ? order.Employee.FirstName : string.Empty,
CustomerName = order.Customer.FirstName
} : null);
}
}
public List <OrderViewModel> GetFilteredList(OrderBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoshowDbContext())
{
return(context.Orders
.Include(rec => rec.Employee)
.Include(rec => rec.Customer)
.Include(rec => rec.Car)
.Select(rec => new OrderViewModel
{
Id = rec.Id,
Date = rec.Date,
CarId = rec.CarId,
EmployeeId = rec.EmployeeId,
CustomerId = rec.CustomerId,
CarName = rec.Car.Model,
EmployeeName = rec.EmployeeId.HasValue ? rec.Employee.FirstName : string.Empty,
CustomerName = rec.Customer.FirstName
}).ToList());
}
}
public void Insert(PostBindingModel model)
{
using (var context = new AutoshowDbContext())
{
context.Posts.Add(CreateModel(model, new Post()));
context.SaveChanges();
}
}
public void Insert(BranchBindingModel model)
{
using (var context = new AutoshowDbContext())
{
context.Branches.Add(CreateModel(model, new Branch()));
context.SaveChanges();
}
}
public void Insert(CustomerBindingModel model)
{
using (var context = new AutoshowDbContext())
{
context.Customers.Add(CreateModel(model, new Customer()));
context.SaveChanges();
}
}
public void Insert(EmployeeBindingModel model)
{
using (var context = new AutoshowDbContext())
{
context.Employees.Add(CreateModel(model, new Employee()));
context.SaveChanges();
}
}
public List <BranchViewModel> GetFullList()
{
using (var context = new AutoshowDbContext())
{
return(context.Branches
.Select(rec => new BranchViewModel
{
Id = rec.Id,
Address = rec.Address,
BranchName = rec.BranchName
}).ToList());
}
}
public List <CustomerViewModel> GetFullList()
{
using (var context = new AutoshowDbContext())
{
return(context.Customers
.Select(rec => new CustomerViewModel
{
Id = rec.Id,
FirstName = rec.FirstName,
LastName = rec.LastName
}).ToList());
}
}
public List <PostViewModel> GetFullList()
{
using (var context = new AutoshowDbContext())
{
return(context.Posts
.Select(rec => new PostViewModel
{
Id = rec.Id,
PostName = rec.PostName,
Salary = rec.Salary
}).ToList());
}
}
public List <CarViewModel> GetFullList()
{
using (var context = new AutoshowDbContext())
{
return(context.Cars
.Select(rec => new CarViewModel
{
Id = rec.Id,
Model = rec.Model,
Color = rec.Color,
Price = rec.Price
}).ToList());
}
}
public void Update(PostBindingModel model)
{
using (var context = new AutoshowDbContext())
{
var Post = context.Posts.FirstOrDefault(rec => rec.Id == model.Id);
if (Post == null)
{
throw new Exception("Сотрудник не найден");
}
CreateModel(model, Post);
context.SaveChanges();
}
}
public void Update(EmployeeBindingModel model)
{
using (var context = new AutoshowDbContext())
{
var employee = context.Employees.FirstOrDefault(rec => rec.Id == model.Id);
if (employee == null)
{
throw new Exception("Сотрудник не найден");
}
CreateModel(model, employee);
context.SaveChanges();
}
}
public List <EmployeeViewModel> GetFullList()
{
using (var context = new AutoshowDbContext())
{
return(context.Employees
.Select(rec => new EmployeeViewModel
{
Id = rec.Id,
FirstName = rec.FirstName,
LastName = rec.LastName,
BranchId = rec.BranchId,
PostId = rec.PostId
}).ToList());
}
}
public void Delete(CustomerBindingModel model)
{
using (var context = new AutoshowDbContext())
{
Customer Customer = context.Customers.FirstOrDefault(rec => rec.Id == model.Id);
if (Customer != null)
{
context.Customers.Remove(Customer);
context.SaveChanges();
}
else
{
throw new Exception("Сотрудник не найден");
}
}
}
public void Delete(EmployeeBindingModel model)
{
using (var context = new AutoshowDbContext())
{
Employee employee = context.Employees.FirstOrDefault(rec => rec.Id == model.Id);
if (employee != null)
{
context.Employees.Remove(employee);
context.SaveChanges();
}
else
{
throw new Exception("Сотрудник не найден");
}
}
}
public void Delete(PostBindingModel model)
{
using (var context = new AutoshowDbContext())
{
Post Post = context.Posts.FirstOrDefault(rec => rec.Id == model.Id);
if (Post != null)
{
context.Posts.Remove(Post);
context.SaveChanges();
}
else
{
throw new Exception("Сотрудник не найден");
}
}
}
public List <CustomerViewModel> GetFilteredList(CustomerBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoshowDbContext())
{
return(context.Customers
.Where(rec => rec.FirstName.Contains(model.FirstName))
.Select(rec => new CustomerViewModel
{
Id = rec.Id,
FirstName = rec.FirstName,
LastName = rec.LastName
}).ToList());
}
}
public List <BranchViewModel> GetFilteredList(BranchBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoshowDbContext())
{
return(context.Branches
.Where(rec => rec.BranchName.Contains(model.BranchName))
.Select(rec => new BranchViewModel
{
Id = rec.Id,
Address = rec.Address,
BranchName = rec.BranchName
}).ToList());
}
}
public List <PostViewModel> GetFilteredList(PostBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoshowDbContext())
{
return(context.Posts
.Where(rec => rec.PostName.Contains(model.PostName))
.Select(rec => new PostViewModel
{
Id = rec.Id,
PostName = rec.PostName,
Salary = rec.Salary
}).ToList());
}
}
public CustomerViewModel GetElement(CustomerBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoshowDbContext())
{
var Customer = context.Customers
.FirstOrDefault(rec => rec.Id == model.Id);
return(Customer != null ?
new CustomerViewModel
{
Id = Customer.Id,
FirstName = Customer.FirstName,
LastName = Customer.LastName
} : null);
}
}
public BranchViewModel GetElement(BranchBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoshowDbContext())
{
var Branch = context.Branches
.FirstOrDefault(rec => rec.Id == model.Id);
return(Branch != null ?
new BranchViewModel
{
Id = Branch.Id,
Address = Branch.Address,
BranchName = Branch.BranchName
} : null);
}
}
public List <CarViewModel> GetFilteredList(CarBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoshowDbContext())
{
return(context.Cars
.Where(rec => rec.Model.Contains(model.Model))
.Select(rec => new CarViewModel
{
Id = rec.Id,
Model = rec.Model,
Color = rec.Color,
Price = rec.Price
}).ToList());
}
}
public PostViewModel GetElement(PostBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoshowDbContext())
{
var Post = context.Posts
.FirstOrDefault(rec => rec.Id == model.Id);
return(Post != null ?
new PostViewModel
{
Id = Post.Id,
PostName = Post.PostName,
Salary = Post.Salary
} : null);
}
}
public CarViewModel GetElement(CarBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoshowDbContext())
{
var Car = context.Cars
.FirstOrDefault(rec => rec.Id == model.Id);
return(Car != null ?
new CarViewModel
{
Id = Car.Id,
Model = Car.Model,
Color = Car.Color,
Price = Car.Price
} : null);
}
}
public List <EmployeeViewModel> GetFilteredList(EmployeeBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoshowDbContext())
{
return(context.Employees
.Where(rec => rec.FirstName.Contains(model.FirstName))
.Select(rec => new EmployeeViewModel
{
Id = rec.Id,
FirstName = rec.FirstName,
LastName = rec.LastName,
BranchId = rec.BranchId,
PostId = rec.PostId
}).ToList());
}
}
public EmployeeViewModel GetElement(EmployeeBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoshowDbContext())
{
var employee = context.Employees
.FirstOrDefault(rec => rec.Id == model.Id);
return(employee != null ?
new EmployeeViewModel
{
Id = employee.Id,
FirstName = employee.FirstName,
LastName = employee.LastName,
BranchId = employee.BranchId,
PostId = employee.PostId
} : null);
}
}
