public ActionResult Products()
{
var db = new ShoppingCartDBContext();
var products = db.ProductCategoryItems.ToList();
return(View(products));
}
public IEnumerable <Customer> GetAll()
{
List <Customer> customers = new List <Customer>();
using (var context = new ShoppingCartDBContext(ShoppingCartDBContext.optionBuild.dbOption))
{
customers = context.Customers.ToList();
}
return(customers);
}
public async Task <int> InsertCustomerRecord(Customer customer)
{
using (var context = new ShoppingCartDBContext(ShoppingCartDBContext.optionBuild.dbOption))
{
await context.Customers.AddAsync(customer);
await context.SaveChangesAsync();
}
return(customer.CustomerId);
}
//GetAllProduct(List<int> productId);
// public IEnumerable<Product> GetAllProducts()
//public IEnumerable<Product> GetAllProducts()
//{
// List<Product> products = new List<Product>();
// using (var context = new ShoppingCartDBContext(ShoppingCartDBContext.optionBuild.dbOption))
// {
// products = context.products.ToList();
// }
// return products;
//}
public List <Product> GetAllProducts()
{
List <Product> products = new List <Product>();
using (var context = new ShoppingCartDBContext(ShoppingCartDBContext.optionBuild.dbOption))
{
products = context.products.ToList();
}
return(products);
}
public List <Customer> getuserdetails(int userid)
{
// IEnumerable<Customer> customer;
List <Customer> customers = new List <Customer>();
using (var context = new ShoppingCartDBContext(ShoppingCartDBContext.optionBuild.dbOption))
{
customers = context.Customers.ToList();
}
return(customers);
}
public async Task <List <Product> > GetAllProducts()
{
List <Product> productlist = new List <Product>();
using (var context = new ShoppingCartDBContext(ShoppingCartDBContext.optionBuild.dbOption))
{
productlist = await context.products.ToListAsync();
}
return(productlist);
}
public async void Test_AddtoCart()
{
InitData();
var product = new Product() {
Id = 1,
Name = "TV",
Baseprice = 1200.00m
};
var carts = shoppingCartDbContext.Carts.ToArray();
Assert.True(carts.Length > 0);
var cartid = carts.ElementAt(0).Id;
var result = await cartRepo.AddToCart(cartid, product, 10);
Assert.True(result);
var context = new ShoppingCartDBContext(ConnectionString);
var firstOrDefault = context.SaleItems.FirstOrDefault();
Assert.True(firstOrDefault != null && firstOrDefault.Quantity == 20);
}
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 MembersRepository(ShoppingCartDBContext context)
{
_context = context;
}
public UserService(ShoppingCartDBContext context, IOptions <AppSettings> appSettings)
{
dbContext = context;
_appSettings = appSettings.Value;
}
public ProductsRepository(ShoppingCartDBContext context)
{
_context = context;
}
public ItemsService(ShoppingCartDBContext context)
{
dbContext = context;
}
public CategoryTblsController(ShoppingCartDBContext context)
{
_context = context;
}
public OrderDetailsRepository(ShoppingCartDBContext context)
{
_context = context;
}
public CategoriesRepository(ShoppingCartDBContext context)
{
_context = context;
}
public Categories(ShoppingCartDBContext _db)
{
db = _db;
}
public DashboardService(ShoppingCartDBContext context)
{
dbContext = context;
}
public ProductTblsController(ShoppingCartDBContext context)
{
_context = context;
}
public Products(ShoppingCartDBContext _db)
{
db = _db;
}
public CartServices(ShoppingCartDBContext context)
{
dbContext = context;
}
