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