public tblCars getCar(int CarID) { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblCars.Where(a => a.CarID == CarID).SingleOrDefault()); } }
public tblBrands getBrand(int brandID) { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblBrands.Where(a => a.BrandID == brandID).Include(a => a.tblCars).SingleOrDefault()); } }
public ICollection <tblImages> GetFrontImages() { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblImages.Where(a => a.ImageOrder == 0).Include(a => a.tblCars).ToList()); } }
public ICollection <tblImages> getXImagesOfCarY(int numberOfImages, int CarID) { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblImages.Where(a => a.CarID == CarID).Take(numberOfImages).ToList()); } }
public ICollection <tblCars> FilterByKM(ICollection <tblCars> cars, int startKM, int endKM) { using (var db = new CSCbelgiumDatabaseEntities()) { return(cars.Where(d => (int)d.CarKilometers >= startKM && (double)d.CarKilometers <= endKM).ToList()); } }
public ICollection <tblImages> GetImagesByCar(tblCars car) { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblImages.Where(a => a.CarID == car.CarID).ToList()); } }
public ICollection <tblCars> FilterByTransmission(ICollection <tblCars> cars) { using (var db = new CSCbelgiumDatabaseEntities()) { return(cars); } }
public ICollection <tblCars> FilterByPrice(ICollection <tblCars> cars, int startprice, int endprice) { using (var db = new CSCbelgiumDatabaseEntities()) { return(cars.Where(d => (int)d.CarPrice >= startprice && (double)d.CarPrice <= endprice).ToList()); } }
public ICollection <tblCars> FilterByBrand(ICollection <tblCars> cars, tblBrands brand) { using (var db = new CSCbelgiumDatabaseEntities()) { return(cars.Where(a => a.tblBrands.BrandName == brand.BrandName).ToList()); } }
public ICollection <tblCars> FilterByColor(ICollection <tblCars> cars, tblColors color) { using (var db = new CSCbelgiumDatabaseEntities()) { return(cars.Where(a => a.tblColors.ColorName == color.ColorName).ToList()); } }
public tblRimBrands getBrand(int brandID) { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblRimBrands.Where(a => a.RimBrandID == brandID).FirstOrDefault()); } }
public ICollection <tblRimBrands> getBrands() { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblRimBrands.ToList()); } }
public ICollection <tblRimImages> getImagesOfRim(int rimID) { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblRimImages.Where(a => a.RimID == rimID).ToList()); } }
public tblRims getRim(int rimID) { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblRims.Where(a => a.RimID == rimID).FirstOrDefault()); } }
public ICollection <tblPosts> getAllPosts() { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblPosts.ToList()); } }
public ICollection <tblRims> getRims() { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblRims.Include(a => a.tblRimBrands).ToList()); } }
public ICollection <tblColors> getColors() { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblColors.Include(a => a.tblCars).ToList()); } }
public tblColors getColor(int colorID) { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblColors.Where(a => a.ColorID == colorID).Include(a => a.tblCars).SingleOrDefault()); } }
public ICollection <tblSlides> getSlides() { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblSlides.OrderBy(a => a.SlideOrder).ToList()); } }
public tblSlides getSlide(int slideID) { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblSlides.Where(a => a.SlideID == slideID).FirstOrDefault()); } }
public tblPosts getPost(int id) { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblPosts.Where(a => a.PostID == id).FirstOrDefault()); } }
public ICollection <tblPosts> get30LastPosts() { using (var db = new CSCbelgiumDatabaseEntities()) { return(db.tblPosts.OrderByDescending(a => a.PostDate).Take(30).ToList()); } }
public void addColor(tblColors color) { using (var db = new CSCbelgiumDatabaseEntities()) { db.tblColors.Add(color); db.SaveChanges(); } }
public void UpdateSlide(tblSlides slide) { using (var db = new CSCbelgiumDatabaseEntities()) { db.Entry(slide).State = EntityState.Modified; db.SaveChanges(); } }
public void addSlide(tblSlides slide) { using (var db = new CSCbelgiumDatabaseEntities()) { db.tblSlides.Add(slide); db.SaveChanges(); } }
public void DeleteAllImagesOfCar(tblCars car) { using (var db = new CSCbelgiumDatabaseEntities()) { db.tblImages.RemoveRange(db.tblImages.Where(a => a.CarID == car.CarID)); db.SaveChanges(); } }
public void UpdateImage(tblImages image) { using (var db = new CSCbelgiumDatabaseEntities()) { db.Entry(image).State = EntityState.Modified; db.SaveChanges(); } }
public void AddImage(tblImages image) { using (var db = new CSCbelgiumDatabaseEntities()) { db.tblImages.Add(image); db.SaveChanges(); } }
public void addNewPost(tblPosts newPost) { using (var db = new CSCbelgiumDatabaseEntities()) { db.tblPosts.Add(newPost); db.SaveChanges(); } }
public void UpdatePost(tblPosts post) { using (var db = new CSCbelgiumDatabaseEntities()) { db.Entry(post).State = EntityState.Modified; db.SaveChanges(); } }