public List<CustomerModel> GetAllCustomers()
{
var customerList = new List<CustomerModel>();
try
{
using (var db = new TankshopDbContext())
{
var dbCustomers = db.Customers.ToList();
foreach (var c in dbCustomers)
{
var p = db.People.Find(c.Email);
var customer = new CustomerModel()
{
Email = p.Email,
Firstname = p.Firstname,
Lastname = p.Lastname,
Address = p.Address,
Zipcode = p.Zipcode,
City = p.Postal.City,
CustomerId = c.CustomerId,
Orders = c.Orders.Select(o => new OrderModel()
{
CustomerId = o.CustomerId,
Date = o.Date,
OrderId = o.OrderId,
Orderlines = o.Orderlines.Select(l => new OrderlineModel()
{
Count = l.Count,
OrderId = l.OrderId,
OrderlineId = l.OrderlineId,
ProductId = l.ProductId,
ProductName = l.Product.Name,
ProductPrice = l.Product.Price
}).ToList()
}).ToList()
};
customerList.Add(customer);
}
return customerList;
}
}
catch (Exception)
{
return customerList;
}
}
public CustomerControllerTest()
{
orderlineModel = new OrderlineModel()
{
Count = 1,
OrderId = 1,
OrderlineId = 1,
ProductId = 1,
ProductName = "Tank",
ProductPrice = 500000
};
orderlineModels = new List<OrderlineModel>();
orderlineModels.Add(orderlineModel);
orderlineModels.Add(orderlineModel);
orderlineModels.Add(orderlineModel);
orderModel = new OrderModel()
{
CustomerId = 1,
Date = new DateTime(2015, 1, 1),
OrderId = 1,
Orderlines = orderlineModels
};
orderModels = new List<OrderModel>();
orderModels.Add(orderModel);
orderModels.Add(orderModel);
orderModels.Add(orderModel);
customerModel = new CustomerModel()
{
CustomerId = 1,
Email = "*****@*****.**",
Firstname = "Ole",
Lastname = "Olsen",
Address = "Persveien 5",
Zipcode = "0123",
City = "Oslo",
Orders = orderModels
};
userEmail = "*****@*****.**";
anotherUserEmail = "*****@*****.**";
adminEmail = "admin";
}
public CustomerModel GetCustomer(string email)
{
using (var db = new TankshopDbContext())
{
try
{
var dbPerson = GetPerson(email);
var customerId = db.Customers.FirstOrDefault(c => c.Email == email).CustomerId;
var orderRepo = new OrderRepo();
var customer = new CustomerModel()
{
CustomerId = customerId,
Email = dbPerson.Email,
Firstname = dbPerson.Firstname,
Lastname = dbPerson.Lastname,
Address = dbPerson.Address,
Zipcode = dbPerson.Zipcode,
City = dbPerson.City,
Orders = orderRepo.GetOrders(customerId)
};
return customer;
}
catch (Exception)
{
return null;
}
}
}
