public bool AddCustomer(Shopping.Customers customer, string affiliate_key) { try { ModelsContext.Customers.Add(customer); ModelsContext.Affiliates.Add(new Affiliate() { Email = customer.Email }); ModelsContext.SaveChanges(); if (!String.IsNullOrEmpty(affiliate_key)) { var affiliate = ModelsContext.Affiliates.Find(Guid.Parse(affiliate_key)); if (affiliate != null) { ModelsContext.Affiliate_Joiners.Add(new Affiliate_Joiner() { Affiliate_Key = affiliate.Affiliate_Key, New_Customer_Email = customer.Email, Email = affiliate.Email, used = false }); ModelsContext.SaveChanges(); } } return(true); } catch (Exception ex) { return(false); } }
public void AddOrder(Shopping.Customers customer) { try { var newOrder = new Order(); newOrder.Order_ID = GenerateOrderNumber(10); newOrder.Email = customer.Email; newOrder.date_created = DateTime.Now; newOrder.shipped = false; newOrder.status = "Awaiting Payment"; newOrder.packed = false; ModelsContext.Orders.Add(newOrder); ModelsContext.SaveChanges(); //ModelsContext.Orders.Add(new Order() //{ // Order_ID = GenerateOrderNumber(10), // Email = customer.Email, // date_created = DateTime.Now, // shipped = false, // status = "Awaiting Payment" //}); //ModelsContext.SaveChanges(); } catch (Exception ex) { } }
public bool UpdateCustomer(Shopping.Customers customer) { try { ModelsContext.Entry(customer).State = EntityState.Modified; ModelsContext.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }