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();
}
}
