public void UpdateImage(tblImages image)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
db.Entry(image).State = EntityState.Modified;
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();
}
}
private void deleteImagesOfRim(int rimID)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
db.tblRimImages.RemoveRange(db.tblRimImages.Where(a => a.RimID == rimID));
db.SaveChanges();
}
}
public void AddImage(tblImages image)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
db.tblImages.Add(image);
db.SaveChanges();
}
}
public void UpdatePost(tblPosts post)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
db.Entry(post).State = EntityState.Modified;
db.SaveChanges();
}
}
public void addNewPost(tblPosts newPost)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
db.tblPosts.Add(newPost);
db.SaveChanges();
}
}
public void addBrand(tblBrands brand)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
db.tblBrands.Add(brand);
db.SaveChanges();
}
}
public void UpdateSlide(tblSlides slide)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
db.Entry(slide).State = EntityState.Modified;
db.SaveChanges();
}
}
public void editCar(tblCars car)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
db.Entry(car).State = EntityState.Modified;
db.SaveChanges();
}
}
public void addColor(tblColors color)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
db.tblColors.Add(color);
db.SaveChanges();
}
}
public void addSlide(tblSlides slide)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
db.tblSlides.Add(slide);
db.SaveChanges();
}
}
public void addRimImage(tblRimImages rimImage)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
db.tblRimImages.Add(rimImage);
db.SaveChanges();
}
}
public void deleteSlide(int slideID)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
tblSlides slide = getSlide(slideID);
db.Entry(slide).State = EntityState.Deleted;
db.SaveChanges();
}
}
public void deleteBrand(int brandid)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
tblBrands brand = getBrand(brandid);
db.Entry(brand).State = EntityState.Deleted;
db.SaveChanges();
}
}
public void SellCar(tblCars car, bool sold)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
if (sold)
{
car.Sold = (byte)1;
db.Entry(car).State = EntityState.Modified;
db.SaveChanges();
}
else
{
car.Sold = (byte)0;
db.Entry(car).State = EntityState.Modified;
db.SaveChanges();
}
}
}
public void SellRim(tblRims rim, bool sold)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
if (sold)
{
rim.Sold = (byte)1;
db.Entry(rim).State = EntityState.Modified;
db.SaveChanges();
}
else
{
rim.Sold = (byte)0;
db.Entry(rim).State = EntityState.Modified;
db.SaveChanges();
}
}
}
public void deleteColor(int colorid)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
tblColors color = getColor(colorid);
db.Entry(color).State = EntityState.Deleted;
db.SaveChanges();
}
}
public void deletePost(int postID)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
tblPosts post = getPost(postID);
db.Entry(post).State = EntityState.Deleted;
db.SaveChanges();
}
}
public void deleteRim(int rimID)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
deleteImagesOfRim(rimID);
tblRims rim = getRim(rimID);
db.Entry(rim).State = EntityState.Deleted;
db.SaveChanges();
}
}
public void UpdateOrder(tblSlides slide, int txtOrder)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
System.Diagnostics.Debug.WriteLine(txtOrder);
slide.SlideOrder = txtOrder;
db.Entry(slide).State = EntityState.Modified;
db.SaveChanges();
}
}
public void deleteCar(int CarID)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
tblImagesDAO imagesdao = new tblImagesDAO();
imagesdao.DeleteAllImagesOfCar(getCar(CarID));
tblCars car = getCar(CarID);
db.Entry(car).State = EntityState.Deleted;
db.SaveChanges();
}
}
public void updateAlignment(tblSlides slide, int ddlID)
{
using (var db = new CSCbelgiumDatabaseEntities())
{
switch (ddlID)
{
case 0:
slide.CaptionAlignment = "Links";
break;
case 1:
slide.CaptionAlignment = "Midden";
break;
case 2:
slide.CaptionAlignment = "Rechts";
break;
}
db.Entry(slide).State = EntityState.Modified;
db.SaveChanges();
}
}