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