public void add_Shop(Shop shop) { using (var context = new ShopReviewsdb()) { context.shops.Add(shop); context.SaveChanges(); } }
public void add_Address(Address address) { using (var context = new ShopReviewsdb()) { context.Addresses.Add(address); 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 List <Address> Get_all_Adrress() { List <Address> result = new List <Address>(); using (var context = new ShopReviewsdb()) { result = context.Addresses.ToList <Address>(); } return(result); }
public List <Review> Get_all_Reviews() { List <Review> result = new List <Review>(); using (var context = new ShopReviewsdb()) { result = context.Reviews.ToList <Review>(); } return(result); }
public List <Shop> Get_all_Shops() { List <Shop> result = new List <Shop>(); using (var context = new ShopReviewsdb()) { result = context.shops.Include(a => a.Address).Include(p => p.Products).Include(l => l.Products.Select(r => r.Reviews)).ToList <Shop>(); } return(result); }
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 List <Product> Get_all_Products() { List <Product> result = new List <Product>(); List <Product> retrn = new List <Product>(); using (var context = new ShopReviewsdb()) { result = context.Products.Include(s => s.Shop).Include(r => r.Reviews).Include(a => a.Shop.Address).ToList <Product>(); } foreach (Product p in result) { var field = p.GetType().GetField("_entityWrapper"); if (field == null) { retrn.Add(p); } var wrapper = field.GetValue(p); var property = wrapper.GetType().GetProperty("IdentityType").GetValue(wrapper); var name = property.GetType().GetProperty("Name").GetValue(property); Product prod = null; if (name.ToString() == "IceCream") { prod = new IceCream(p); } if (name.ToString() == "FrozenYogurt") { prod = new FrozenYogurt(p); } if (name.ToString() == "Waffle") { prod = new Waffle(p); } if (name.ToString() == "FrenchCrape") { prod = new FrenchCrape(p); } if (name.ToString() == "Smoothie") { prod = new Smoothie(p); } prod.NutritinosValuesDictonary = new GetNutritions().GetProductNutritions(prod.NutritionalValues); retrn.Add(prod); } return(retrn); }
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(); } }