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