public ActionResult CartItems()
{
List <CartItemsViewModel> cdList = new List <CartItemsViewModel>();
if (Session["cart"] != null)
{
List <CartItems> cartIds = (List <CartItems>)Session["cart"];
using (RahmanDbEntities db = new RahmanDbEntities())
{
foreach (var item in cartIds)
{
CartItemsViewModel cd = db.tblProductDetails.Where(c => c.Id == item.ProductId).Select(c => new CartItemsViewModel
{
CompanyName = c.CompanyName,
ProdDescription = c.ProdDescription,
Id = c.Id,
Images = c.Images,
Price = c.Price,
ProductId = c.ProductId,
Quantity = item.Quantity
}).FirstOrDefault();
cdList.Add(cd);
}
}
}
return(View(cdList));
}
//
// GET: /ShoppingSite/
public ActionResult ShoppingPage()
{
RahmanDbEntities db = new RahmanDbEntities();
var result = db.tblProductDetails.ToList();
return(View(result));
}
public ActionResult List()
{
RahmanDbEntities objdb = new RahmanDbEntities();
{
tblOrderMst objtblOrdMst = new tblOrderMst();
{
List <tblOrderMst> result = objdb.tblOrderMsts.ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult ShippingDetails(RdplForm.Models.CustDetail result)
{
RahmanDbEntities db = new RahmanDbEntities();
{
tblCustDetail objcustdt = new tblCustDetail();
objcustdt.CustName = result.CustName;
objcustdt.Address = result.Address;
objcustdt.MobileNo = result.MobileNO;
// For total Amount Calculation
List <CartItems> cartId = (List <CartItems>)Session["cart"];
var total_Amount = 0;
foreach (var item in cartId)
{
//tblProductDetail prodDetail = new tblProductDetail();
var Amount = db.tblProductDetails.Where(c => c.ProductId == item.ProductId).FirstOrDefault();
total_Amount = total_Amount + (Amount.Price) * (item.Quantity);
}
objcustdt.Total_Amount = total_Amount;
db.tblCustDetails.Add(objcustdt);
db.SaveChanges();
ViewBag.Success = " Order placed Successfully ";
tblProductDetail prodDetails = new tblProductDetail();
List <CartItems> cartIds = (List <CartItems>)Session["cart"];
foreach (var item in cartIds)
{
CustOrderDetail orddt = new CustOrderDetail();
orddt.Order_Id = objcustdt.CustId;
orddt.Quntity = item.Quantity;
orddt.Product_Id = item.ProductId;
db.CustOrderDetails.Add(orddt);
}
db.SaveChanges();
ModelState.Clear();
}
return(View());
}
public ActionResult SaveEmpDetail(OrderMst objOrder)
{
RahmanDbEntities objdb = new RahmanDbEntities();
if (objOrder.CustomerName == null || objOrder.OrderDetail == null)
{
ViewBag.msg = "Plz Fill all the details";
return(View("EmpDetail"));
}
else
{
tblOrderMst objordmst = new tblOrderMst();
// List<tblOrderDt objordDt = new tblOrderDt();
{
objordmst.OrderNo = objOrder.No;
objordmst.OrdDate = objOrder.Date;
objordmst.CustName = objOrder.CustomerName;
}
objdb.tblOrderMsts.Add(objordmst);
objdb.SaveChanges();
var id = objdb.tblOrderMsts.OrderByDescending(x => x.OrderId).First().OrderId;
foreach (var lstg in objOrder.OrderDetail)
{
tblOrderDt objdt = new tblOrderDt();
objdt.OrderId = id;
objdt.Item = lstg.Item;
objdt.Quantity = lstg.Quantity;
objdt.Rate = lstg.Rate;
objdb.tblOrderDts.Add(objdt);
objdb.SaveChanges();
}
}
return(Json(" Data Successfuly Saved"));
}
