public ActionResult GetProductRecords() { string Product_Id = Request.QueryString["Product_Id"]; var productrecord = interfaceobj.GetModel().Where(a => a.ID == Convert.ToInt32(Product_Id)).AsEnumerable(); // DataContext dc = new DataContext(); // var catlist = dc.FF_Category; // //ViewBag.id = productrecord.FirstOrDefault().Category_ID.ToString(); // //ViewBag.Dropdown_Category = new SelectList(catlist, "ID", "Category", "4"); // ViewBag.Dropdown_Category = catlist //.ToList() //.Select(x => new SelectListItem //{ // Value = x.ID.ToString(), // Text = x.Category, // Selected = (x.ID == 4) //}); //ViewBag.Dropdown_Category = new SelectList(catlist.Select(item => new SelectListItem //{ // Value = item.ID.ToString(), // Text = item.Category.ToString() // //Selected = (productrecord.Select(s => s.Category_ID).ToString() == item.ID.ToString() ? true : false) // //Selected = "select" == item.FF_Products.FirstOrDefault().Category_ID.ToString() //})); var productrecordList = productrecord.Select(s => new { ProductId = s.ID, BrandName = (string.IsNullOrEmpty(s.Brand) ? "" : s.Brand), ProductName = s.Product_Name, ProductCode = s.Product_Code, ProductPrice = (string.IsNullOrEmpty(s.Price) ? "" : s.Price), ProductQuantity = (string.IsNullOrEmpty(s.Quantity) ? "-" : s.Quantity), ProductDiscount = (string.IsNullOrEmpty(s.Discount) ? "-" : s.Discount + " %"), CreationDate = s.Creation_Date.ToString("dd-MMM-yyyy"), Description = (string.IsNullOrEmpty(s.Description) ? "-" : s.Description), Category = s.FF_Category.Category, ImageCollection = MyHelperClass.GetProduct_Images(Convert.ToInt32(Product_Id)) }); return(Json(productrecordList, JsonRequestBehavior.AllowGet)); //return Json(productrecord, JsonRequestBehavior.AllowGet); }
public ActionResult Get_ProductDetails() { int Product_ID = Convert.ToInt32(Request.QueryString["Product_ID"]); using (DataContext dc = new DataContext()) { //var displayproductrecord = dc.FF_Products.Where(a => a.ID == Product_ID).AsEnumerable(); var ProductAllImages = MyHelperClass.GetProduct_Images(Product_ID); var displayproductrecord = dc.FF_Products.Where(a => a.ID == Product_ID).AsEnumerable().Select(s => new { Product_ID = s.ID, Product_Name = s.Product_Name, Product_Code = s.Product_Code, Price = s.Price, Discount = s.Discount, Quantity = s.Quantity, Description = s.Description, ImageCollection = ProductAllImages ////ProductOtherDetails = s.FF_Product_SubTable.Select(b => new { ////Size = b.Product_Size ////}) }); return(Json(displayproductrecord, JsonRequestBehavior.AllowGet)); ////VM_Product model = new VM_Product(); ////model.ID = displayproductrecord.First().ID; ////model.Product_Name = displayproductrecord.First().Product_Name; ////model.Product_Code = displayproductrecord.First().Product_Code; ////model.Price = Convert.ToDecimal(displayproductrecord.First().Price); ////model.Discount = displayproductrecord.First().Discount; ////model.Quantity = displayproductrecord.First().Quantity; ////model.Description = displayproductrecord.First().Description; ////model.ImageCollection = ProductAllImages; ////return PartialView("_ProductQuickView", model);//F:\MVC-New\FennyFeeds\FennyFeeds\Views\Shared\_ProductQuickView.cshtml } }
public ActionResult ProductQuickView() { int Product_ID = Convert.ToInt32(Request.QueryString["Product_ID"]); using (DataContext dc = new DataContext()) { var displayproductrecord = dc.FF_Products.Where(a => a.ID == Product_ID).AsEnumerable(); var ProductAllImages = MyHelperClass.GetProduct_Images(Product_ID); VM_Product model = new VM_Product(); model.ID = displayproductrecord.First().ID; model.Product_Name = displayproductrecord.First().Product_Name; model.Product_Code = displayproductrecord.First().Product_Code; model.Price = displayproductrecord.First().Price; model.Discount = displayproductrecord.First().Discount; model.Quantity = displayproductrecord.First().Quantity; model.Description = displayproductrecord.First().Description; model.ImageCollection = ProductAllImages; return(PartialView("_ProductQuickView", model));//F:\MVC-New\FennyFeeds\FennyFeeds\Views\Shared\_ProductQuickView.cshtml } }
public ActionResult GetProductRecordsForEdit() { int Product_Id = Convert.ToInt32(Request.QueryString["Product_Id"]); //Product Main Table// var productrecord = interfaceobj.GetModel().Where(a => a.ID == Product_Id).AsEnumerable(); DataContext dc = new DataContext(); //Category for dropdownlist var catlist = dc.FF_Category; ViewBag.Dropdown_Category = new SelectList(catlist, "ID", "Category"); //Sub Category for dropdownlist var subcatlist = dc.FF_Sub_Category; ViewBag.Dropdown_SubCategory = new SelectList(subcatlist, "ID", "SubCategory"); //Product Variant for dropdownlist var variantlist = dc.FF_Product_Variants; ViewBag.Dropdown_Variant = new SelectList(variantlist, "ID", "Variants_Name", "Select Variant"); VM_Product modal = new VM_Product(); var Product_Variant_Id = ((dc.FF_Product_SubTable.Where(a => a.Product_Id == Product_Id).Count() > 0) ? dc.FF_Product_SubTable.Where(a => a.Product_Id == Product_Id).First().Product_Variant_Id : 0); modal.ID = Product_Id; modal.Category_ID = productrecord.FirstOrDefault().Category_ID; modal.Sub_Category_ID = productrecord.FirstOrDefault().Sub_Category_ID; //modal.Product_Variant_Id = dc.FF_Product_SubTable.FirstOrDefault(a => a.Product_Id == Product_Id).Product_Variant_Id; modal.Product_Variant_Id = ((dc.FF_Product_SubTable.Where(a => a.Product_Id == Product_Id).Count() > 0) ? dc.FF_Product_SubTable.Where(a => a.Product_Id == Product_Id).First().Product_Variant_Id : 0); modal.Brand = productrecord.FirstOrDefault().Brand; modal.Product_Name = productrecord.FirstOrDefault().Product_Name; modal.Product_Code = productrecord.FirstOrDefault().Product_Code; modal.Price = productrecord.FirstOrDefault().Price; modal.Quantity = productrecord.FirstOrDefault().Quantity; modal.Discount = productrecord.FirstOrDefault().Discount; modal.Description = productrecord.FirstOrDefault().Description; modal.ImageCollection = MyHelperClass.GetProduct_Images(Product_Id); if (Product_Variant_Id != 4 && Product_Variant_Id != 0) { modal.VariantCollectionList = dc.FF_Product_SubTable.Where(f => f.Product_Id == Product_Id).Select(s => new VariantCollection { Product_Sub_Table_ID = s.ID, First_Input = (string.IsNullOrEmpty(s.Product_Size) ? (string.IsNullOrEmpty(s.Product_Colour) ? s.Product_Weight : s.Product_Colour) : s.Product_Size), Second_Input = s.Product_Price, Third_Input = s.Product_Quantity, //Size = s.Product_Size, //Colour = s.Product_Colour, //Weight = s.Product_Weight, //Price = s.Product_Price, //Quantity = s.Product_Quantity }).ToList(); } else if (Product_Variant_Id == 4) { modal.VariantCollectionList = dc.FF_Product_SubTable.Where(f => f.Product_Id == Product_Id).Select(s => new VariantCollection { Product_Sub_Table_ID = s.ID, First_Input = s.Product_Size, Second_Input = s.Product_Colour, Third_Input = s.Product_Price, Fourth_Input = s.Product_Quantity //Size = s.Product_Size, //Colour = s.Product_Colour, //Weight = s.Product_Weight, //Price = s.Product_Price, //Quantity = s.Product_Quantity }).ToList(); } return(View("PV_EditProduct", modal)); //return Json(productrecord, JsonRequestBehavior.AllowGet); }
public ActionResult Get_All_FeaturedProducts() { using (DataContext dc = new DataContext()) { var get_allfeatured_category = dc.FF_HomePage_Display_Product.ToList(); System.Text.StringBuilder Build = new System.Text.StringBuilder(); //Check Local Path Or Server Path string rootpath = Utility_FF.Root_Path(); foreach (var item in get_allfeatured_category) { var getproduct = dc.FF_Products.Where(s => s.Category_ID == item.Category_ID); if (getproduct.Count() > 0) { Build.Append("<div class='row'>"); Build.Append("<h2 class='head_collections'>" + item.Title + "<span>Food Product</span></h2>"); Build.Append("</div>"); Build.Append("<div class='row'>"); Build.Append("<div class='owl-carousel owl-theme owl-featured' id='FeaturedProperties'>"); foreach (var item1 in getproduct) { string firstimage = ""; string secondimage = ""; var ProductAllImages = MyHelperClass.GetProduct_Images(item1.ID); if (ProductAllImages.Count() > 0) { firstimage = rootpath + "/Product_Image/" + item1.ID + "/" + ProductAllImages[0]; if (ProductAllImages.Count() > 1) { secondimage = rootpath + "/Product_Image/" + item1.ID + "/" + ProductAllImages[1]; } } else { firstimage = rootpath + "/Product_Image/no_image.jpg"; secondimage = rootpath + "/Product_Image/no_image.jpg"; } Build.Append("<div class=''>"); Build.Append("<div class='product-grid7'>"); Build.Append("<div class='product-image7'>"); Build.Append("<a href='../Master/ProductDetails?Product_ID=" + item1.ID + "'>"); Build.Append("<img class='pic-1' src='" + firstimage + "'>");//../content/Product_Image/" + item1.ID + "/Image-1.jpg Build.Append("<img class='pic-2' src='" + secondimage + "'>"); Build.Append("</a>"); Build.Append("<ul class='social'>"); Build.Append("<li><a href='' class='mdi mdi-magnify' onclick='Get_ProductQuickView(" + item1.ID + ")' data-toggle='modal' data-target=''></a></li>"); Build.Append("<li><a href='' class='mdi mdi-heart' onclick=CheckUserLoginOrNot('addproduct_to_wishlist','" + item1.ID + "') data-toggle='modal' data-target=''></a></li>"); Build.Append("<li><a href='' class='mdi mdi-cart' data-toggle='modal' data-target='#slidermodal'></a></li>"); Build.Append("</ul>"); Build.Append("</div>"); Build.Append("<div class='product-content'>"); Build.Append("<h3 class='title'><a href='#'>" + item1.Product_Name + "</a></h3>"); Build.Append(""); Build.Append("<div class='price'>"); Build.Append("<span class='featured-price wrap-text'><i class='mdi mdi-currency-inr mr-2'></i>" + item1.Price + "</span>"); Build.Append("</div>"); Build.Append("</div>"); Build.Append("</div>"); Build.Append("</div>"); } Build.Append("</div>"); Build.Append("</div>"); } } return(Json(Build.ToString(), JsonRequestBehavior.AllowGet)); } }