internal Customer getCustomer(string phonenumber) { Customer customer; string name = ""; string address = ""; string phone = ""; string email = ""; List<Receipt> receipts = new List<Receipt>(); int id = 0; using (BSPetShopEntities context = new BSPetShopEntities()) { var customerToGet = from c in context.CustomerSet where c.PhoneNumber == phonenumber select c; if (customerToGet != null) { foreach(var c in customerToGet) { name = c.Name; address = c.Adress; phone = c.PhoneNumber; email = c.Email; id = c.Id; } foreach (ReceiptSet rs in customerToGet.FirstOrDefault().ReceiptSet) { List<Animal> animals = new List<Animal>(); foreach (var v in rs.BirdSet) { animals.Add(new Common.Classes.Bird(v.Type, v.Price, v.Family, v.Age, v.Id)); } foreach (var v in rs.FishSet) { animals.Add(new Common.Classes.Fish(v.Type, v.Price, v.Id, v.Water, v.Aggressive)); } receipts.Add(new Receipt(animals, rs.Date, rs.Id)); } customer = new Customer(receipts, name, address, phone, email, id); } else { customer = null; } return customer; } }
internal List<Receipt> getReceipts(string phonenumber) { List<Receipt> receipts = new List<Receipt>(); using (BSPetShopEntities context = new BSPetShopEntities()) { var customer = from c in context.CustomerSet where c.PhoneNumber.Equals(phonenumber) select c; var receiptsFromDB = from r in context.ReceiptSet where r.Customer_Id == customer.FirstOrDefault().Id select r; foreach(ReceiptSet rs in receiptsFromDB) { List<Animal> animals = new List<Animal>(); foreach (var v in rs.BirdSet) { animals.Add(new Common.Classes.Bird(v.Type, v.Price, v.Family, v.Age, v.Id)); } foreach (var v in rs.FishSet) { animals.Add(new Common.Classes.Fish(v.Type, v.Price, v.Id, v.Water, v.Aggressive)); } receipts.Add(new Receipt(animals, rs.Date, rs.Id)); } } return receipts; }
internal void insertBirds(ArrayList birds) { using (BSPetShopEntities context = new BSPetShopEntities()) { var query = from b in context.BirdSet select b; foreach (var item in query) { context.BirdSet.Remove(item); } foreach (Bird b in birds) { context.BirdSet.Add(new BirdSet() { Age = (short)b.age, Family = b.family, Price = b.price, Type = b.type }); } context.SaveChanges(); } }
internal void newCustomer(string name, string adress, string phonenumber, string email) { using (BSPetShopEntities context = new BSPetShopEntities()) { context.CustomerSet.Add(new CustomerSet() { Name = name, Adress = adress, PhoneNumber = phonenumber, Email = email }); context.SaveChanges(); } }
internal ArrayList loadStock() { ArrayList animals = new ArrayList(); using (BSPetShopEntities context = new BSPetShopEntities()) { foreach (var v in context.BirdSet) { animals.Add(new Common.Classes.Bird(v.Type, v.Price, v.Family, v.Age, v.Id)); } foreach (var v in context.FishSet) { animals.Add(new Common.Classes.Fish(v.Type, v.Price, v.Id, v.Water, v.Aggressive)); } } return animals; }
internal void insertReceipt(Receipt receip, Customer customer) { using (BSPetShopEntities context = new BSPetShopEntities()) { var customerWithID = from c in context.CustomerSet where c.PhoneNumber.Equals(customer.phonenumber) select c; context.ReceiptSet.Add(new ReceiptSet() { Totalprice = receip.totalPrice().ToString(), Date = receip.date, Customer_Id = customerWithID.Single().Id }); context.SaveChanges(); foreach (Animal a in receip.animals) { Type birdType = typeof(Bird); Type fishType = typeof(Fish); var receipt = from r in context.ReceiptSet where r.Date == receip.date && r.Customer_Id == customer.id select r; if (a.GetType() == birdType) { var query = from b in context.BirdSet where b.Id == a.id select b; foreach (BirdSet b in query) { b.Receipt_Id = receipt.Single().Id; } context.SaveChanges(); } else { var queryF = from f in context.FishSet where f.Id == a.id select f; foreach (FishSet f in queryF) { f.Receipt_Id = receipt.Single().Id; } context.SaveChanges(); } } } }
internal void insertFish(ArrayList fish) { using (BSPetShopEntities context = new BSPetShopEntities()) { var query = from f in context.FishSet select f; foreach (var item in query) { context.FishSet.Remove(item); } foreach (Fish f in fish) { context.FishSet.Add(new FishSet() { Type = f.type.ToString(), Price = f.price, Aggressive = f.aggressive, Water = f.water }); } context.SaveChanges(); } }