private ProductList_ViewModel CreateProductList(IDataRecord Record)
{
try
{
ProductList_ViewModel objProduct = new ProductList_ViewModel();
objProduct.SrNo = Convert.ToInt32(Record["SrNo"]);
objProduct.ProductId = Convert.ToInt32(Record["ProductId"]);
objProduct.ProductName = Record["ProductName"].ToString();
objProduct.ProductDescription = Record["ProductDescription"].ToString();
objProduct.UserId = Convert.ToInt32(Record["UserId"]);
objProduct.ProductCategoryId = Convert.ToInt32(Record["ProductCategoryId"]);
objProduct.Quantity = Convert.ToInt32(Record["Quantity"]);
objProduct.Active = Convert.ToBoolean(Record["Active"]);
objProduct.Deleted = Convert.ToBoolean(Record["Deleted"]);
objProduct.AddedDate = Convert.ToDateTime(Record["AddedDate"]);
objProduct.PictureId = Convert.ToInt32(Record["PictureId"]);
objProduct.PictureContent = (byte[])Record["PictureContent"];
objProduct.Price = Convert.ToInt32(Record["Price"]);
objProduct.UserName = Record["UserName"].ToString();
objProduct.ProductCategoryName = Record["ProductCategoryName"].ToString();
//objProduct.TotalRecords = Convert.ToInt32(Record["TotalRecords"]);
return(objProduct);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult ViewProductDetails(int ProductId)
{
try
{
if (Session["UserId"] != null)
{
ProductList_ViewModel ProductDetails = new ProductList_ViewModel();
//var Result = objDbEntities.ProductMasters
// .Join(objDbEntities.UserMasters, p => p.UserId, u => u.UserId, (p, u) => new { p, u })
// .Join(objDbEntities.PictureMasters, pic => pic.ProductId, abc =>abc.ProductId)
// .Join(objDbEntities.ProductCategoryMasters, pc => pc.p.ProductCategoryId, p => p.ProductCategoryId, (p, pc) =>
// new
// {
// ProductId = p.p.ProductId,
// ProductName = p.p.ProductName,
// ProductDescription = p.p.ProductDescription,
// UserId = p.u.UserId,
// FirstName = p.u.FirstName,
// LastName = p.u.LastName,
// ProductCategoryId = pc.ProductCategoryId,
// ProductCategoryName = pc.ProductCategoryName,
// Quantity = p.p.Quantity,
// Active = p.p.Active,
// Deleted = p.p.Deleted,
// AddedDate = p.p.AddedDate,
// Price = p.p.Price
// })
// .Where(c => c.ProductId == ProductId)
// .Select(a => new
// {
// ProductId = a.ProductId,
// ProductName = a.ProductName,
// ProductDescription = a.ProductDescription,
// UserId = a.UserId,
// FirstName = a.FirstName,
// LastName = a.LastName,
// ProductCategoryId = a.ProductCategoryId,
// ProductCategoryName = a.ProductCategoryName,
// Quantity = a.Quantity,
// Active = a.Active,
// Deleted = a.Deleted,
// AddedDate = a.AddedDate,
// Price = a.Price
// }).FirstOrDefault();
var Result = (from pm in objDbEntities.ProductMasters
join um in objDbEntities.UserMasters on pm.UserId equals um.UserId
join pcm in objDbEntities.ProductCategoryMasters on pm.ProductCategoryId equals pcm.ProductCategoryId
join picm in objDbEntities.PictureMasters on pm.ProductId equals picm.ProductId
where pm.ProductId == ProductId
orderby picm.PictureId
select new
{
ProductId = pm.ProductId,
ProductName = pm.ProductName,
ProductDescription = pm.ProductDescription,
UserId = pm.UserId,
FirstName = um.FirstName,
LastName = um.LastName,
ProductCategoryId = pm.ProductCategoryId,
ProductCategoryName = pcm.ProductCategoryName,
Quantity = pm.Quantity,
Active = pm.Active,
Deleted = pm.Deleted,
AddedDate = pm.AddedDate,
PictureId = picm.PictureId,
PictureContent = picm.PictureContent,
Price = pm.Price
}).FirstOrDefault();
ProductDetails.SrNo = 1;
ProductDetails.ProductId = Result.ProductId;
ProductDetails.ProductName = Result.ProductName;
ProductDetails.ProductDescription = Result.ProductDescription;
ProductDetails.UserId = Result.UserId;
ProductDetails.UserName = Result.FirstName + ' ' + Result.LastName;
ProductDetails.ProductCategoryId = Result.ProductCategoryId;
ProductDetails.ProductCategoryName = Result.ProductCategoryName;
ProductDetails.Quantity = Result.Quantity;
ProductDetails.Active = Result.Active;
ProductDetails.Deleted = Result.Deleted;
ProductDetails.AddedDate = Result.AddedDate;
ProductDetails.PictureId = Result.PictureId;
ProductDetails.PictureContent = Result.PictureContent;
ProductDetails.Price = Result.Price;
var PictureCount = objDbEntities.PictureMasters.Where(pic => pic.ProductId == ProductId).Count();
Session["PictureCount"] = PictureCount;
Session["PictureNumber"] = 0;
return(PartialView("_ViewProductDetails", ProductDetails));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception ex)
{
throw ex;
}
}
