public List<Customer> allCustomers()
{
using (var db = new NettbutikkContext())
{
List<Customer> allCustomers = db.Customers.Select(c => new Customer
{
customerId = c.CustomerId,
firstname = c.Firstname,
lastname = c.Lastname,
address = c.Address,
zipcode = c.Zipcode,
postalarea = c.Postalareas.Postalarea,
email = c.Mail,
password = c.Password,
salt = c.Salt
}).ToList();
return allCustomers;
}
}
public Product FindProduct(int productid)
{
using (var db = new NettbutikkContext())
{
List<Products> GetAllProducts = db.Products.ToList();
Product c = new Product();
for (int i = 0; i < GetAllProducts.Count; i++)
{
if (GetAllProducts[i].ProductId == productid)
{
c.productid = productid;
c.productname = GetAllProducts[i].Productname;
c.price = GetAllProducts[i].Price;
c.category = GetAllProducts[i].Category;
c.description = GetAllProducts[i].Description;
return c;
}
}
}
return null;
}
public bool addOrderList(int orderid)
{
using (var db = new NettbutikkContext())
{
try
{
Cart cart = (Cart)context.Session["Cart"];
List<int> pidlistdesc = new List<int>();
pidlistdesc = cart.productids.Distinct().ToList();
List<int> count = new List<int>();
foreach (int p in pidlistdesc)
{
int c = cart.productids.Count(x => x == p);
count.Add(c);
}
for (int i = 0; i < count.Count; i++)
{
Debug.Print("pid " + pidlistdesc[i]);
Debug.Print("Count " + count[i]);
OrderLists list = new OrderLists();
list.OrderID = orderid;
list.ProductID = pidlistdesc[i];
list.Quantity = count[i];
list.UnitPrice = FindProduct(pidlistdesc[i]).price;
db.OrderLists.Add(list);
}
db.SaveChanges();
context.Session["Cart"] = null;
return true;
}
catch (Exception e)
{
return false;
}
}
}
public int saveOrer(float price, int customerid)
{
using (var db = new NettbutikkContext())
{
try
{
Debug.Write("KOMMER TIL TRY");
String timeStamp = (DateTime.Now).ToString("yyyyMMddHHmmssffff");
// Debug.Write("CustomerID " + c.customerId);
var newOrderRow = new Orders();
newOrderRow.CustomerId = customerid;
newOrderRow.TimeStamp = timeStamp;
newOrderRow.SumTotal = price;
db.Orders.Add(newOrderRow);
db.SaveChanges();
List<Orders> GetAllOrders = db.Orders.ToList();
return GetAllOrders.Count;
}
catch (Exception feil)
{
return 0;
}
}
}
public bool saveCustomer(Customer inCustomer)
{
using (var db = new NettbutikkContext())
{
try
{
String salt = GenerateSalt(32);
var newCustomerRow = new Customers();
newCustomerRow.Mail = inCustomer.email;
newCustomerRow.Password = HashPassword(inCustomer.password, salt);
newCustomerRow.Firstname = inCustomer.firstname;
newCustomerRow.Lastname = inCustomer.lastname;
newCustomerRow.Address = inCustomer.address;
newCustomerRow.Zipcode = inCustomer.zipcode;
newCustomerRow.Salt = salt;
var checkZipcode = db.PostalAreas.Find(inCustomer.zipcode);
if(checkZipcode==null)
{
var postalareaRow = new PostalAreas();
postalareaRow.Zipcode = inCustomer.zipcode;
postalareaRow.Postalarea = inCustomer.postalarea;
newCustomerRow.Postalareas = postalareaRow;
}
db.Customers.Add(newCustomerRow);
db.SaveChanges();
return true;
}catch(Exception feil)
{
return false;
}
}
}
