public void add_Address(Address address) { using (var context = new ShopReviewsdb()) { context.Addresses.Add(address); context.SaveChanges(); } }
public void add_Shop(Shop shop) { using (var context = new ShopReviewsdb()) { context.shops.Add(shop); context.SaveChanges(); } }
public void add_Review(Review review) { using (var context = new ShopReviewsdb()) { review.Product = null; context.Reviews.Add(review); context.SaveChanges(); } }
public void add_Product(Product product) { using (var context = new ShopReviewsdb()) { product.Shop = null; context.Products.Add(product); context.SaveChanges(); } }
public void update_Address(Address a) { using (var context = new ShopReviewsdb()) { var old = context.Addresses.Find(a.AddressID); old.AddressID = a.AddressID; old.BuildingNumber = a.BuildingNumber; old.City = a.City; old.Street = a.Street; context.SaveChanges(); } }
public void update_Shop(Shop shop) { using (var context = new ShopReviewsdb()) { var old = context.shops.Find(shop.ShopID); update_Address(shop.Address); old.Facebook = shop.Facebook; old.ImageURL = shop.ImageURL; old.Instagram = shop.Instagram; old.ShopID = shop.ShopID; old.Website = shop.Website; old.Phone = shop.Phone; context.SaveChanges(); } }
public void update_Review(Review r) { using (var context = new ShopReviewsdb()) { var old = context.Reviews.Find(r.ReviewID); old.ProductID = r.ProductID; old.Image = r.Image; old.PublishDate = r.PublishDate; old.Rating = r.Rating; old.ReviewContent = r.ReviewContent; old.ReviewerName = r.ReviewerName; old.ReviewID = r.ReviewID; old.ReviwerBirthday = r.ReviwerBirthday; old.ReviwerEmail = r.ReviwerEmail; context.SaveChanges(); } }
public void update_Product(Product p) { using (var context = new ShopReviewsdb()) { var old = context.Products.Find(p.ProductID); old.ProductID = p.ProductID; old.Name = p.Name; old.NutritionalValues = p.NutritionalValues; old.Price = p.Price; old.ShopID = p.ShopID; old.SugarFree = p.SugarFree; old.Vegan = p.Vegan; old.ShopID = p.ShopID; old.Description = p.Description; try { old.GetType().GetProperty("FreeExtras").SetValue(old, p.GetType().GetProperty("FreeExtras").GetValue(p)); } catch (Exception e) { } try { old.GetType().GetProperty("Fat").SetValue(old, p.GetType().GetProperty("Fat").GetValue(p)); } catch (Exception e) { } try { old.GetType().GetProperty("MilkType").SetValue(old, p.GetType().GetProperty("MilkType").GetValue(p)); } catch (Exception e) { } try { old.GetType().GetProperty("Flaver").SetValue(old, p.GetType().GetProperty("Flaver").GetValue(p)); } catch (Exception e) { } try { old.GetType().GetProperty("GlutenFree").SetValue(old, p.GetType().GetProperty("GlutenFree").GetValue(p)); } catch (Exception e) { } context.SaveChanges(); } }