public void DeleteBasket(string Email, int BasketId) { try { var rep = new Repository(); var removeB = rep.Set <Basket>().SingleOrDefault(b => b.BasketId == BasketId); var removeC = rep.Set <Customer>().SingleOrDefault(c => c.Email == Email); removeC.Baskets.Remove(removeB); rep.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); } }
public bool Delete(string Email) { try { var rep = new Repository(); var delete = rep.Set <Customer>().SingleOrDefault(b => b.Email == Email); rep.Remove(delete); rep.SaveChanges(); return(true); } catch (Exception e) { Console.WriteLine(e); return(false); } }
public Customer Register(string Name, string Address, string Dob, string Email) { try { var rep = new Repository(); rep.Add(new Customer(Name, Address, Dob, Email)); rep.SaveChanges(); var customer = rep.Set <Customer>().Last(); return(customer); } catch (Exception e) { Console.WriteLine(e); return(null); } }
public bool AddBasket(string Email, Basket basket) { try { var rep = new Repository(); var add = rep.Set <Customer>().SingleOrDefault(b => b.Email == Email); if (add != null) { basket.Customer = add; rep.Basket.Add(basket); rep.Add(basket); rep.SaveChanges(); } return(true); } catch (Exception e) { return(false); } }
public Customer Register(string Name, string Address, DateTime Dob, string Email) { try { if (Dob.AddYears(80) >= DateTime.Now) { var rep = new Repository(); rep.Add(new Customer(Name, Address, Dob, Email)); rep.SaveChanges(); var customer = rep.Set <Customer>().Last(); return(customer); } return(null); } catch (Exception e) { return(null); } }
public bool AddBasket(string Email, Basket basket) { try { var rep = new Repository(); var add = rep.Set <Customer>() .SingleOrDefault(b => b.Email == Email); if (add != null) { add.PreviousBaskets.Add(basket); rep.Add(basket); rep.SaveChanges(); } return(true); } catch (Exception e) { Console.WriteLine(e); return(false); } }
public bool Update(string Email, string Name, string Address, string Dob) { try { var rep = new Repository(); var update = rep.Set <Customer>().SingleOrDefault(b => b.Email == Email); if (update == null) { Console.WriteLine("Please Try Again"); } update.Name = Name; update.Address = Address; update.Dob = Dob; rep.SaveChanges(); return(true); } catch (Exception e) { Console.WriteLine(e); return(false); } }
public void DeleteBasket(string Email, int BasketId) { try { var rep = new Repository(); var remove = rep.Set <Customer>() .SingleOrDefault(c => c.Email == Email); if (remove != null) { var remove1 = rep.Set <Basket>() //Basket with given basketId that belongs to above customer .SingleOrDefault(b => b.BasketId == BasketId); if (remove1 != null && remove1.Customer.Id == remove.Id) { remove.PreviousBaskets.Remove(remove1); rep.SaveChanges(); } } } catch (Exception e) { Console.WriteLine(e); } }