//get all cars by make, model,year
public List <CarsForSale> getCarsByMakeModelYear(int makeId, int modelId, int year)
{
var dbcontext = new used_carsContext();
var allCarsForSale = dbcontext.CarsForSale.Where(x => x.ModelId == modelId && x.Year == year && x.ManufacturerId == makeId).ToList();
return(allCarsForSale);
}
public List <CarsForSale> getCars()
{
var dbContext = new used_carsContext();
var carsForSale = dbContext.CarsForSale.ToList();
return(carsForSale);
}
public void addCar(CarsForSale newCar)
{
using (used_carsContext dbcontext = new used_carsContext())
{
dbcontext.CarsForSale.Add(newCar);
dbcontext.SaveChanges();
}
}
public List <CarsForSale> getCarsByColor(string color)
{
var dbContext = new used_carsContext();
var carsForSale = dbContext.CarsForSale.ToList();
carsForSale = carsForSale.Where(x => x.Color == color).ToList();
return(carsForSale);
}
public List <SelectListItem> getManufacturers()
{
var dbContext = new used_carsContext();
var manufacturer = dbContext.Manufacturer.ToList();
return(manufacturer.Select(x => new SelectListItem
{
Id = x.ManufacturerId,
Name = x.Name
}).ToList());
}
public List <SelectListItem> getModels(int manufacturerID)
{
var dbcontext = new used_carsContext();
var model = dbcontext.Models.ToList();
var newModelList = model.Where(x => x.ManufacturerId == manufacturerID).ToList();
return(newModelList.Select(x => new SelectListItem
{
Id = x.ModelId,
Name = x.Name
}).ToList());
}
public CarsForSale getCarByVin(string vin)
{
var dbContext = new used_carsContext();
var carsForSale = dbContext.CarsForSale.ToList();
foreach (var car in carsForSale)
{
if (car.Vin == vin)
{
return(car);
}
}
return(null);
}
public bool AuthImplement(string user, string pwd)
{
var dbcontext = new used_carsContext();
var credentailslist = dbcontext.Login.ToList();
foreach (var x in credentailslist)
{
if (x.Username == user && x.Password == pwd)
{
return(true);
}
}
return(false);
}
public void CreateUserImplement(string user, string pwd, string name, string phone)
{
using (used_carsContext dbcontext = new used_carsContext())
{
//get owner_id number for assignment
var ownerdbcontext = dbcontext.Owner;
var owner_id = dbcontext.Owner.ToList().Max(x => x.Ownerid);
Login login = new Login();
login.Username = user;
login.Password = pwd;
Owner owner = new Owner();
owner.Name = name;
owner.Phone = phone;
owner.Ownerid = (int)(login.Ownerid = ++owner_id);
dbcontext.Owner.Add(owner);
dbcontext.Login.Add(login);
dbcontext.SaveChanges();
}
}
