public string CreateOrder(CartList cart, InquiryMst inquiry) { _context.CartLists.Add(cart); _context.InquiryMsts.Add(inquiry); _context.SaveChanges(); return("Successfully Create Order!"); }
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 DeleteConfirmed(string id) { InquiryMst inquiryMst = db.InquiryMsts.Find(id); db.InquiryMsts.Remove(inquiryMst); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "inquiryID,transactionId,fname,lname,address,city,mobNo,emailId,cmt,cdate,cardNo,expdate,CVV_No")] InquiryMst inquiryMst) { if (ModelState.IsValid) { db.Entry(inquiryMst).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.transactionId = new SelectList(db.TransactionMsts, "transactionId", "transactionId", inquiryMst.transactionId); return(View(inquiryMst)); }
// GET: Admin/InquiryMsts/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } InquiryMst inquiryMst = db.InquiryMsts.Find(id); if (inquiryMst == null) { return(HttpNotFound()); } return(View(inquiryMst)); }
// GET: Admin/InquiryMsts/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } InquiryMst inquiryMst = db.InquiryMsts.Find(id); if (inquiryMst == null) { return(HttpNotFound()); } ViewBag.transactionId = new SelectList(db.TransactionMsts, "transactionId", "transactionId", inquiryMst.transactionId); return(View(inquiryMst)); }
public ActionResult Index(InquiryViewModel model) { var DB = new BG_DBEntities(); string UserID = DB.AspNetUsers.FirstOrDefault(x => x.Email == User.Identity.Name).Id; var obj = new InquiryMst { InquiryName = model.InquiryName, Type = model.Type, CompanyName = model.CompanyName, CompanyAddress = model.CompanyAddress, Comments = model.Comments, CountryId = model.CountryId, StateId = model.StateId, CityId = model.CityId, UserId = UserID, IsResolve = false }; DB.InquiryMsts.Add(obj); DB.SaveChanges(); return(Json(obj.InquiryId > 0 ? true : false, JsonRequestBehavior.AllowGet)); }
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")); } }