public ActionResult SubmitOrder(string addressId, string paymentType)
{
int custId = Convert.ToInt32(Session["UserKey"]);
Customers _cust = bCustomer.List().Where(m => m.Customer_Id == custId).FirstOrDefault();
int custAdrId = Convert.ToInt32(addressId);
int selPaymentType = Convert.ToInt32(paymentType);
List <Carts> _cart = _mcartmdl.GetCarts().Where(m => m.Customer_Id == custId && m.Cart_Status == eCartStatus.Open.ToString()).ToList();
string _res = string.Empty;
foreach (var item in _cart)
{
Product _prd = context.Product.Where(m => m.Product_Id == item.Product_Id).FirstOrDefault();
Order Orders = new Order()
{
Order_Price = item.Cart_Price,
Order_Qty = item.Cart_Qty,
Order_Size = item.Cart_Size,
Order_Status = eOrderStatus.Placed.ToString(),
Product_Id = item.Product_Id,
Product_Banner = item.Product_Banner,
Product_Price = item.Product_Price,
Product_Title = item.Product_Title,
Customer_Id = item.Customer_Id,
Customer_Name = item.Customer_Name,
CustomerAddress_Id = custAdrId,
Payment_Method_Id = selPaymentType,
Order_Date = DateTime.Now,
Order_Delievery_Date = DateTime.Now.AddDays(_prd.Product_Delivery_Time),
Store_Id = _prd.Store_Id,
Order_UpdateDate = DateTime.Now
};
int maxBnrCusAdrAdminId = 1;
if (context.Orders.ToList().Count > 0)
{
maxBnrCusAdrAdminId = context.Orders.Max(m => m.Order_Id);
}
maxBnrCusAdrAdminId = (maxBnrCusAdrAdminId == 1 && context.Orders.ToList().Count > 0) ? (maxBnrCusAdrAdminId + 1) : maxBnrCusAdrAdminId;
Orders.Order_Code = "ORDRACH" + maxBnrCusAdrAdminId + "TERA" + (maxBnrCusAdrAdminId + 1);
context.Orders.Add(Orders);
context.SaveChanges();
Administrators _adm = context.Administrator.Where(m => m.EmailId == "*****@*****.**").FirstOrDefault();
OrderHistory OrderHistories = new OrderHistory()
{
Order_Id = Orders.Order_Id,
OrderHistory_Status = eOrderStatus.Placed.ToString(),
OrderHistory_Description = "Order Submitted successfully on " + DateTime.Now.ToString("D").ToString(),
OrderHistory_CreatedDate = DateTime.Now,
OrderHistory_UpdatedDate = DateTime.Now,
Administrators_Id = _adm.Administrators_Id,
Store_Id = Orders.Store_Id
};
context.OrderHistories.Add(OrderHistories);
context.SaveChanges();
Carts _carts = _mcartmdl.GetCarts().Where(m => m.Cart_Id == item.Cart_Id).FirstOrDefault();
_mcartmdl.DeleteCartByCartId(_carts);
string productUrl = "http://rachnateracotta.com/product/index?id=" + item.Product_Id;
_res = _res + "<tr style='border: 1px solid black;'><td style='border: 1px solid black;'><img src='" + ConfigurationSettings.AppSettings["DomainUrl"].ToString() + item.Product_Banner + "' width='100' height='100'/></td>"
+ "<td style='border: 1px solid black;'><a href='" + productUrl + "'>" + item.Product_Title + "</a></td><td style='border: 1px solid black;'> Total Quantity :" + item.Cart_Qty + " </td><td style='border: 1px solid black;'> " + item.Cart_Price + " </td></tr>";
}
if (Convert.ToBoolean(ConfigurationSettings.AppSettings["IsEmailEnable"]))
{
string host = string.Empty;
host = "<table style='width:100%'>" + _res + "</ table >";
string body = MailHelper.CustomerOrderPlaced(host, (_cust.Customers_FullName));
MailHelper.SendEmail(_cust.Customers_EmailId, "Success!!! You Order Placed In Rachna Teracotta Estore.", body, "Rachna Teracotta Order Placed");
}
return(Json("success", JsonRequestBehavior.AllowGet));
}
