public int RegisterUser(User user) { try { var count = (from users in dbContext.NfUser where users.Email == user.Email select users).Count(); if (count == 0) { NfUser newUser = new NfUser(); newUser.FirstName = user.FirstName; newUser.LastName = user.LastName; newUser.Email = user.Email; newUser.Password = user.Password; newUser.IsActive = true; newUser.PasswordHash = ""; newUser.SecurityStamp = ""; dbContext.Add(newUser); dbContext.SaveChanges(); user.Id = newUser.UserId; return(1); } else { return(-1); } } catch (Exception ex) { return(0); } }
public int AddToCart(CartModel model) { try { var item = (from cart in dbContext.ScUserCart where cart.UserId == model.UserId && cart.ItemId == model.ItemId select cart).FirstOrDefault(); if (item != null) { ScUserCart userCart = dbContext.ScUserCart.Find(item.UserCartId); userCart.UserCartId = userCart.UserCartId; userCart.UserId = model.UserId; userCart.ItemId = model.ItemId; userCart.Quantity = item.Quantity + model.Quantity; dbContext.Entry(userCart).State = Microsoft.EntityFrameworkCore.EntityState.Modified; dbContext.SaveChanges(); model.UserCartId = userCart.UserCartId; } else { ScUserCart newCart = new ScUserCart(); newCart.UserId = model.UserId; newCart.ItemId = model.ItemId; newCart.Quantity = model.Quantity; dbContext.Add(newCart); dbContext.SaveChanges(); model.UserCartId = newCart.UserCartId; } return(model.UserCartId); } catch (Exception ex) { return(0); } }
public int AddItem(ItemsModel model) { try { var list = (from Items in dbContext.ScItems where Items.Description == model.Description && Items.ItemCategoryId == model.ItemCategoryId select Items).Count(); if (list == 0) { ScItems newItem = new ScItems(); newItem.ItemCategoryId = model.ItemCategoryId; newItem.Description = model.Description; newItem.Price = model.Price; newItem.DisplayOrder = model.DisplayOrder; newItem.IsInOffer = model.IsInOffer; newItem.OfferValidFrom = model.OfferValidFrom; newItem.OfferValidTo = model.OfferValidTo; newItem.OfferPrice = model.OfferPrice; dbContext.Add(newItem); dbContext.SaveChanges(); model.ItemId = newItem.ItemId; return(newItem.ItemId); } else { return(-1); } } catch (Exception ex) { return(0); } }
public void AddProduct(Product p) { _context.Products.Add(p); _context.SaveChanges(); }
public bool PaymentConf(PaymentConformation payments) { //int orderID = 0; payconf = payments; try { if (payments != null) { using (var context = new ShoppingCartDBContext(ShoppingCartDBContext.optionBuild.dbOption)) { //// foreach (var pay in payments) { var order = new Order(); { order.DateTime = payments.datetime; order.Total = payments.total; order.customers = context.Customers.First(c => c.CustomerId == payments.customerId); // order.Payments = context.Payments.First(p =>p.PayamentId == payments.P); ////payment context.Orders.Add(order); context.SaveChanges(); } CartItemModel cartItem = new CartItemModel(); int orderID = order.OrderId; var cutomerName = context.Customers.First(c => c.CustomerId == payments.customerId); foreach (var ordersdetail in payments.cartItemModel) { OrderDetail orderDetail = new OrderDetail(); { orderDetail.UnitPrice = ordersdetail.unitPrice; orderDetail.Quantity = ordersdetail.quantity; orderDetail.discount = ordersdetail.discount; // // orderDetail.product = context.products.First(o => o.ProductId == cartItem.productId ); orderDetail.product = context.products.First(o => o.ProductId == ordersdetail.productId); orderDetail.orders = context.Orders.First(o => o.OrderId == orderID); context.OrderDetails.Add(orderDetail); context.SaveChanges(); }; int orderItemId = orderDetail.OrderDtailId; } Payment payment = new Payment(); { payment.Amount = payments.total; payment.PaymentMethod = payments.paymentMethod; payment.order = context.Orders.FirstOrDefault(x => x.OrderId == orderID); context.Payments.Add(payment); context.SaveChanges(); } } // MailMessage msg = new MailMessage(); // message.From = new MailAddress(Session["Email"].Tostring()); // message.To.Add(ConfigurationSettings.AppSettings["RequesEmail"].ToString()); // msg.Subject = "Shopping Cart Oder Details "; // msg.IsBodyHtml = true; MailMessage mail = new MailMessage(); SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com"); mail.Subject = "Shopping Cart Order "; mail.From = new MailAddress("*****@*****.**"); mail.To.Add("*****@*****.**"); mail.Subject = "Shopping Cart"; foreach (var pay in payments.cartItemModel) { ProductId = pay.productId; ProductName = pay.productName; UnitPrice = pay.unitPrice; Quantity = pay.quantity; } string textBody = "" + "<h4>Customer Name</h4><span>" + payments.customerId + "</span><span><h4>Address</h4>" + payments.deliveryAddress + "</span></br>" + "<span><h4>Date</h4>" + payments.datetime + "</span></br>" + "<span><h4>Payment Method</h4>" + payments.paymentMethod + "</span></br>" + "<span><h4>Payment Amount</h4>" + payments.total + "</span></br>" + "<table border=" + 1 + " cellpadding=" + 0 + " cellspacing=" + 0 + " width = " + 400 + "><tr bgcolor='#4da6ff'><th><b>Product Id</b></th> <th> <b> Product Name </b> </th> <th> <b> Quantity </b> </th> <th> <b> UnitPrice </b> </th></tr>";// + foreach (var pay in payments.cartItemModel) { textBody += "<tr>" + "<td>" + pay.productId + "</td>" + "<td>" + pay.productName + "</td>" + "<td>" + pay.unitPrice + "</td>" + "<td>" + pay.quantity + "</td>" + "</tr> "; } textBody += "</table> <br/><h3>Thank You</h3>"; //MailMessage mail = new MailMessage(); //SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com"); //mail.Subject = "Shopping Cart Order "; //mail.From = new MailAddress("*****@*****.**"); //mail.To.Add("*****@*****.**"); //mail.Subject = "Shopping Cart"; mail.Body = textBody; mail.IsBodyHtml = true; SmtpServer.Port = 587; SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "lash1234"); SmtpServer.EnableSsl = true; SmtpServer.Send(mail); } return(true); } catch (Exception ex) { } return(true); }
public void AddMember(Member m) { _context.Members.Add(m); _context.SaveChanges(); }
public void AddCart(Cart c) { _context.Carts.Add(c); _context.SaveChanges(); }
public void AddOrderDetails(OrderDetails od) { _context.OrderDetails.Add(od); _context.SaveChanges(); }
public void AddOrder(Order o) { _context.Orders.Add(o); _context.SaveChanges(); }