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