//show specific product details
public ActionResult ViewAd(int?id)
{
Adviewmodel ad = new Adviewmodel();
product p = context.products.Where(x => x.pro_id == id).SingleOrDefault();
ad.pro_id = p.pro_id;
ad.pro_name = p.pro_name;
ad.pro_image = p.pro_image;
ad.pro_price = p.pro_price;
ad.pro_des = p.pro_description;
category cat = context.categories.Where(x => x.cat_id == p.pro_fk_cat).SingleOrDefault();
ad.cat_name = cat.cat_name;
return(View(ad));
}
public ActionResult ViewAd(int?id)
{
Adviewmodel ad = new Adviewmodel();
tbl_product p = db.tbl_product.Where(x => x.pro_id == id).SingleOrDefault();
ad.pro_id = p.pro_id;
ad.pro_name = p.pro_name;
ad.pro_image = p.pro_image;
ad.pro_price = p.pro_price;
tbl_category cat = db.tbl_category.Where(x => x.cat_id == p.pro_fk_cat).SingleOrDefault();
ad.cat_name = cat.cat_name;
tbl_user u = db.tbl_user.Where(x => x.u_id == p.pro_fk_us).SingleOrDefault();
ad.u_name = u.u_name;
ad.u_image = u.u_image;
ad.u_contact = u.u_contact;
return(View(ad));
}
public ActionResult ViewAd(int?id)
{
Adviewmodel ad = new Adviewmodel();
tbl_product p = db.tbl_product.Where(x => x.pro_id == id).SingleOrDefault();
ad.pro_id = p.pro_id;
ad.pro_name = p.pro_name;
ad.pro_image = p.pro_image;
ad.pro_price = p.pro_price;
ad.pro_des = p.pro_des;
tbl_category cat = db.tbl_category.Where(x => x.cat_id == p.pro_fk_cat).SingleOrDefault();
ad.cat_name = cat.cat_name;
//tbl_user u = db.tbl_user.Where(x => x.u_id == p.pro_fk_user).SingleOrDefault();
//ad.u_name = u.u_name;
//ad.u_image = u.u_image;
//ad.u_contact = u.u_contact;
//ad.pro_fk_user = u.u_id;
//tbl_comment com = db.tbl_comment.Where(x => x.comment_id == p.pro_fk_comment).SingleOrDefault();
//ad.comment_content = com.comment_content;
//tbl_rate ra = db.tbl_rate.Where(x => x.rate_id == p.pro_fk_rate).SingleOrDefault();
//ad.rate_content = ra.rate_content;
return(View(ad));
}
