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