public ActionResult Create([Bind(Include = "stoneId,stoneShape,stoneCrt,stoneColor,stoneRate,stoneImg")] StoneInfoMst stoneInfoMst, HttpPostedFileBase[] files)
{
if (ModelState.IsValid)
{
int index = 0;
foreach (HttpPostedFileBase file in files)
{
index++;
//Checking file is available to save.
if (file != null)
{
if (files.Length != index)
{
stoneInfoMst.stoneImg += file.FileName + ", ";
}
else
{
stoneInfoMst.stoneImg += file.FileName;
}
var InputFileName = Path.GetFileName(file.FileName);
var ServerSavePath = Path.Combine(Server.MapPath("~/assets/image/") + InputFileName);
//Save file to server folder
file.SaveAs(ServerSavePath);
}
}//end of insert image
db.StoneInfoMsts.Add(stoneInfoMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(stoneInfoMst));
}
public ActionResult Create([Bind(Include = "dimId,dimShape,dimCrt,dimSize,dimColor,dimClarity,dimCut,dimPolish,dimSymmetry,dimReport,dimRate,dimImg")] DimInfoMst dimInfoMst, HttpPostedFileBase[] files)
{
if (ModelState.IsValid)
{
int index = 0;
foreach (HttpPostedFileBase file in files)
{
index++;
//Checking file is available to save.
if (file != null)
{
if (files.Length != index)
{
dimInfoMst.dimImg += file.FileName + ", ";
}
else
{
dimInfoMst.dimImg += file.FileName;
}
var InputFileName = Path.GetFileName(file.FileName);
var ServerSavePath = Path.Combine(Server.MapPath("~/assets/image/") + InputFileName);
//Save file to server folder
file.SaveAs(ServerSavePath);
}
}//end of insert image
db.DimInfoMsts.Add(dimInfoMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dimInfoMst));
}
public ActionResult Create([Bind(Include = "certificateId,certificateType")] CertificateMst certificateMst)
{
if (ModelState.IsValid)
{
db.CertificateMsts.Add(certificateMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(certificateMst));
}
public ActionResult Create([Bind(Include = "newsletterId,newsletterEmail")] NewsletterMst newsletterMst)
{
if (ModelState.IsValid)
{
db.NewsletterMsts.Add(newsletterMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(newsletterMst));
}
public ActionResult Create([Bind(Include = "catId,catName")] CategoryMst categoryMst)
{
if (ModelState.IsValid)
{
db.CategoryMsts.Add(categoryMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(categoryMst));
}
public ActionResult Create([Bind(Include = "brandId,brandType")] BrandMst brandMst)
{
if (ModelState.IsValid)
{
db.BrandMsts.Add(brandMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(brandMst));
}
public ActionResult Create([Bind(Include = "goldId,goldCrt,goldType,goldRate")] GoldInfoMst goldInfoMst)
{
if (ModelState.IsValid)
{
db.GoldInfoMsts.Add(goldInfoMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(goldInfoMst));
}
public ActionResult Create([Bind(Include = "username,password")] AdminLoginMst adminLoginMst)
{
if (ModelState.IsValid)
{
db.AdminLoginMsts.Add(adminLoginMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adminLoginMst));
}
public ActionResult Create([Bind(Include = "prodId,prodType")] ProductMst productMst)
{
if (ModelState.IsValid)
{
db.ProductMsts.Add(productMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(productMst));
}
public ActionResult Create([Bind(Include = "contactId,contactName,contactMob,contactEmail,contactSubject,contactMessage")] ContactMst contactMst)
{
if (ModelState.IsValid)
{
db.ContactMsts.Add(contactMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contactMst));
}
public ActionResult Review(string review, string itemCode, int userId)
{
CommentMst c = new CommentMst();
c.cmtContent = review;
c.itemCode = itemCode;
c.userId = userId;
_context.CommentMsts.Add(c);
_context.SaveChanges();
return(RedirectToAction("ItemDetails", "Client", new { id = itemCode }));
}
public ActionResult Create([Bind(Include = "blogId,blogImg,blogTitle,blogContent,cdate")] BlogMst blogMst)
{
if (ModelState.IsValid)
{
db.BlogMsts.Add(blogMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(blogMst));
}
public ActionResult Create([Bind(Include = "transactionId,userId,totPrice,totQty,approvalStt")] TransactionMst transactionMst)
{
if (ModelState.IsValid)
{
db.TransactionMsts.Add(transactionMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.userId = new SelectList(db.UserRegMsts, "userId", "userId", transactionMst.userId);
return(View(transactionMst));
}
public ActionResult Create([Bind(Include = "inquiryID,transactionId,fname,lname,address,city,mobNo,emailId,cmt,cdate,cardNo,expdate,CVV_No")] InquiryMst inquiryMst)
{
if (ModelState.IsValid)
{
db.InquiryMsts.Add(inquiryMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.transactionId = new SelectList(db.TransactionMsts, "transactionId", "transactionId", inquiryMst.transactionId);
return(View(inquiryMst));
}
public ActionResult Create([Bind(Include = "cartId,transactionId,itemCode,qty,price")] CartList cartList)
{
if (ModelState.IsValid)
{
db.CartLists.Add(cartList);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.itemCode = new SelectList(db.ItemMsts, "itemCode", "itemCode", cartList.itemCode);
ViewBag.transactionId = new SelectList(db.TransactionMsts, "transactionId", "transactionId", cartList.transactionId);
return(View(cartList));
}
public ActionResult Create([Bind(Include = "cmtId,userId,itemCode,cmtContent,ratingValue")] CommentMst commentMst)
{
if (ModelState.IsValid)
{
db.CommentMsts.Add(commentMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.itemCode = new SelectList(db.ItemMsts, "itemCode", "brandId", commentMst.itemCode);
ViewBag.userId = new SelectList(db.UserRegMsts, "userId", "userFname", commentMst.userId);
return(View(commentMst));
}
public string CreateOrder(CartList cart, InquiryMst inquiry)
{
_context.CartLists.Add(cart);
_context.InquiryMsts.Add(inquiry);
_context.SaveChanges();
return("Successfully Create Order!");
}
public ActionResult Create([Bind(Include = "itemCode,brandId,catId,certificateId,prodId,dimId,goldId,stoneId,itemName,itemDescription,itemImg,pairs,dimQty,dimTot,stoneQty,stoneTot,goldWt,goldTot,wstgPer,wstg,goldMaking,stoneMaking,otherMaking,totMaking,MRP")] ItemMst itemMst, HttpPostedFileBase[] files)
{
if (ModelState.IsValid)
{
int index = 0;
if (files[0] == null)
{
return(View());
}
foreach (HttpPostedFileBase file in files)
{
index++;
//Checking file is available to save.
if (file != null)
{
if (files.Length != index)
{
itemMst.itemImg += file.FileName + ",";
}
else
{
itemMst.itemImg += file.FileName;
}
var InputFileName = Path.GetFileName(file.FileName);
var ServerSavePath = Path.Combine(Server.MapPath("~/assets/image/") + InputFileName);
//Save file to server folder
file.SaveAs(ServerSavePath);
}
}
itemMst.itemStatus = true;
itemMst.created_at = DateTime.Now;
db.ItemMsts.Add(itemMst);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.brandId = new SelectList(db.BrandMsts, "brandId", "brandType", itemMst.brandId);
ViewBag.catId = new SelectList(db.CategoryMsts, "catId", "catName", itemMst.catId);
ViewBag.certificateId = new SelectList(db.CertificateMsts, "certificateId", "certificateType", itemMst.certificateId);
ViewBag.dimId = new SelectList(db.DimInfoMsts, "dimId", "dimShape", itemMst.dimId);
ViewBag.goldId = new SelectList(db.GoldInfoMsts, "goldId", "goldType", itemMst.goldId);
ViewBag.prodId = new SelectList(db.ProductMsts, "prodId", "prodType", itemMst.prodId);
ViewBag.stoneId = new SelectList(db.StoneInfoMsts, "stoneId", "stoneShape", itemMst.stoneId);
return(View(itemMst));
}
public ActionResult Create([Bind(Include = "userId,userFname,userLname,address,city,state,mobNo,emailId,dob,password,status")] UserRegMst userRegMst)
{
if (ModelState.IsValid)
{
userRegMst.status = true;
userRegMst.cdate = DateTime.Now;
db.UserRegMsts.Add(userRegMst);
if (db.UserRegMsts.Where(item => item.emailId == userRegMst.emailId).FirstOrDefault() != null)
{
ViewBag.ExistsEmail = "Email is already exists";
return(View("Login"));
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userRegMst));
}
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"));
}
}
