public ActionResult LineChart() { var db = new OnlineJewelryShopDBEntities(); ArrayList xValue = new ArrayList(); ArrayList yValue = new ArrayList(); var result = (from c in db.TransactionMsts select c); result.ToList().ForEach(rs => { if (rs.UserRegMst == null) { InquiryMst inquiryMst = db.InquiryMsts.Where(item => item.transactionId == rs.transactionId).FirstOrDefault(); xValue.Add(inquiryMst.cdate); } }); result.ToList().ForEach(rs => { if (rs.UserRegMst == null) { yValue.Add(rs.totPrice); } }); new Chart(width: 800, height: 400, theme: ChartTheme.Blue) .AddTitle("Chart for Diamond [Collumn Chart]") .AddSeries("Default", chartType: "Column", xValue: xValue, yValues: yValue) .Write("bmp"); return(null); }
public ActionResult Checkout(string fname, string lname, string address, string city, string state, string email, string mobNo, string cardNo, string expDate, string CVV) { using (OnlineJewelryShopDBEntities _context = new OnlineJewelryShopDBEntities()) { if (Session["cartList"] != null) { if (Session[CommonConstants.USER_SESSION] != null) { UserLogin u = new UserLogin(); u = (UserLogin)Session[CommonConstants.USER_SESSION]; RandomGenerator ran = new RandomGenerator(); InquiryMst i = new InquiryMst(); i.inquiryID = ran.RandomSth(); i.fname = fname; i.lname = lname; i.city = city; i.address = address; i.cmt = ""; i.mobNo = mobNo; i.emailId = email; i.cardNo = cardNo; i.expdate = expDate; i.CVV_No = CVV; i.cdate = System.DateTime.Now; foreach (CartList item in (List <CartList>)Session["cartList"]) { i.transactionId = item.transactionId; break; } _context.InquiryMsts.Add(i); foreach (CartList item in (List <CartList>)Session["cartList"]) { CartList c = new CartList(); c.cartId = item.cartId; c.transactionId = item.transactionId; c.itemCode = item.itemCode; c.qty = item.qty; c.price = item.price; _context.CartLists.Add(c); } TransactionMst t = new TransactionMst(); foreach (CartList item in (List <CartList>)Session["cartList"]) { t.transactionId = item.transactionId; break; } t.userId = u.UserID; t.approvalStt = "Pending"; t.totPrice = ViewBag.TotalPrice; t.totQty = ViewBag.TotalQty; _context.TransactionMsts.Add(t); } else { RandomGenerator ran = new RandomGenerator(); InquiryMst i = new InquiryMst(); i.inquiryID = ran.RandomSth(); i.fname = fname; i.lname = lname; i.city = city; i.address = address; i.cmt = ""; i.mobNo = mobNo; i.emailId = email; i.cardNo = cardNo; i.expdate = expDate; i.CVV_No = CVV; i.cdate = System.DateTime.Now; foreach (CartList item in (List <CartList>)Session["cartList"]) { i.transactionId = item.transactionId; break; } _context.InquiryMsts.Add(i); foreach (CartList item in (List <CartList>)Session["cartList"]) { CartList c = new CartList(); c.cartId = item.cartId; c.transactionId = item.transactionId; c.itemCode = item.itemCode; c.qty = item.qty; c.price = item.price; _context.CartLists.Add(c); } TransactionMst t = new TransactionMst(); foreach (CartList item in (List <CartList>)Session["cartList"]) { t.transactionId = item.transactionId; break; } t.approvalStt = "Pending"; t.totPrice = ViewBag.TotalPrice; t.totQty = ViewBag.TotalQty; _context.TransactionMsts.Add(t); } _context.SaveChanges(); Session.Remove("cartList"); CartController.totalPrice = 0; CartController.totalQty = 0; } return(RedirectToAction("Index")); } }