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"));
}
}
