public ActionResult Gallery(int?pId) { mHome vHome = new mHome(); List <mGallery> aGallery = new List <mGallery>(); mCategory vCat = new mCategory(); vCat.category_type = 2; List <mCategory> aCat = new List <mCategory>(); if (pSkip == 0) { vHome.page_number = 1; } else { vHome.page_number = (pSkip / 12) + 1; } aGallery = g.fGalleryList(pGet, pSkip, pId); aCat = c.fCategoryList(12, 0, vCat.category_type); if (aGallery != null && aGallery.Count > 0) { vHome.aGallery = aGallery; } else { vHome.aGallery = new List <mGallery>(); } if (aCat != null && aCat.Count > 0) { vHome.aCategory = aCat; } else { vHome.aCategory = new List <mCategory>(); } return(View(vHome)); }
public ActionResult Videos() { mHome vHome = new mHome(); List <mVideo> aVideo = new List <mVideo>(); mCategory vCat = new mCategory(); vCat.category_type = 2; List <mCategory> aCat = new List <mCategory>(); if (pSkip == 0) { vHome.page_number = 1; } else { vHome.page_number = (pSkip / 12) + 1; } aVideo = v.fVidoeList(pGet, pSkip); aCat = c.fCategoryList(12, 0, vCat.category_type); if (aVideo != null && aVideo.Count > 0) { vHome.aVideo = aVideo; } else { vHome.aVideo = new List <mVideo>(); } if (aCat != null && aCat.Count > 0) { vHome.aCategory = aCat; } else { vHome.aCategory = new List <mCategory>(); } return(View(vHome)); }
public List <mArticle> fArticlesListMostVisited(int pGet, int pSkip, mArticle pArticle, mHome pHome) { var vArticles = (from a in Db.tbl_article where a.article_visit > 0 && a.article_type == pArticle.article_type select new mArticle { article_id = a.article_id, article_exp = a.article_exp, article_title = a.article_title, article_file = a.article_file, article_img = a.article_img, article_img2 = a.article_img2, article_img3 = a.article_img3, article_img_alt = a.article_img_alt, article_summery = a.article_summery, article_date = a.article_date, article_writer = a.article_writer, article_href = a.article_href, article_code = a.article_code, article_visit = a.article_visit, article_type = a.article_type }).OrderByDescending(b => b.article_id).Skip(pSkip).Take(pGet); return(vArticles.ToList()); }
public mHome fGetSearch(string pSearch) { try { mHome pHome = new mHome(); var vNews = (from n in Db.tbl_news where n.news_title.ContaIns(pSearch) || n.news_summery.ContaIns(pSearch) || n.news_exp.ContaIns(pSearch) select new mNews { news_id = n.news_id, news_title = n.news_title, news_summery = n.news_summery, news_image = n.news_image, news_exp = n.news_exp, news_category = n.news_category, news_img_alt = n.news_img_alt, news_visit = n.news_visit, news_writer = n.news_writer, news_date = n.news_date }).OrderByDescending(b => b.news_id); pHome.aNews = vNews.ToList(); var vArticle = (from n in Db.tbl_article where n.article_title.ContaIns(pSearch) || n.article_summery.ContaIns(pSearch) || n.article_exp.ContaIns(pSearch) select new mArticle { article_id = n.article_id, article_exp = n.article_exp, article_summery = n.article_summery, article_title = n.article_title, article_date = n.article_date, article_img = n.article_img, article_img_alt = n.article_img_alt, article_type = n.article_type, article_writer = n.article_writer, article_visit = n.article_visit }).OrderByDescending(b => b.article_id); pHome.aArticles = vArticle.ToList(); var vLink = (from n in Db.tbl_link where n.link_title.ContaIns(pSearch) || n.link_title_en.ContaIns(pSearch) select new mLink { link_title = n.link_title, link_exp = n.link_exp, link_exp_en = n.link_exp_en, link_id = n.link_id, link_img = n.link_img, link_status = n.link_status, link_title_en = n.link_title_en, link_url = n.link_url }).OrderByDescending(b => b.link_id); pHome.aLink = vLink.ToList(); return(pHome); } catch (Exception) { return(null); } }
public mHome fGetHomeContent() { mHome pHome = new mHome(); var vSlider = (from s in Db.tbl_slider select new mSlider { slider_id = s.slider_id, slider_img = s.slider_img, slider_title = s.slider_title, slider_link = s.slider_link, slider_img_alt = s.slider_img_alt, slider_exp = s.slider_exp, }).OrderBy(b => b.slider_id); pHome.aSlider = vSlider.ToList(); var vCategory = (from c in Db.tbl_category select new mCategory { category_id = c.category_id, category_href = c.category_href, category_img = c.category_img, category_title = c.category_title, category_parent = c.category_parent, category_href_en = c.category_href_en, category_type = c.category_type, category_title_en = c.category_title_en }).OrderBy(b => b.category_id); pHome.aCategory = vCategory.ToList(); var vAboutUs = (from a in Db.tbl_about where a.about_us_type == 1 select new mAbout { about_us_id = a.about_us_id, about_us_img = a.about_us_img, about_us_title = a.about_us_title, about_us_exp_one = a.about_us_exp_one, about_summery = a.about_summery, about_us_exp_two = a.about_us_exp_two, about_us_img_alt = a.about_us_img_alt, about_us_type = a.about_us_type }).FirstOrDefault(); pHome.About = vAboutUs; var aAbout = (from a in Db.tbl_about where a.about_us_type == 2 select new mAbout { about_us_id = a.about_us_id, about_us_img = a.about_us_img, about_us_title = a.about_us_title, about_us_exp_one = a.about_us_exp_one, about_summery = a.about_summery, about_us_exp_two = a.about_us_exp_two, about_us_img_alt = a.about_us_img_alt, about_us_type = a.about_us_type }).ToList(); pHome.aAboutUs = aAbout; var aGallery = (from a in Db.tbl_gallery where a.gallery_cat == 2 select new mGallery { gallery_id = a.gallery_id, gallery_alt = a.gallery_alt, gallery_cat = a.gallery_cat, gallery_date = a.gallery_date, gallery_exp = a.gallery_exp, gallery_image = a.gallery_image, gallery_summery = a.gallery_summery, gallery_title = a.gallery_title, gallery_is_fa = a.gallery_is_fa, gallery_visit = a.gallery_visit }).ToList(); pHome.aGallery = aGallery; var vNews = (from n in Db.tbl_news select new mNews { news_id = n.news_id, news_title = n.news_title, news_image = n.news_image, news_summery = n.news_summery, news_date = n.news_date, news_writer = n.news_writer, news_category = n.news_category, news_exp = n.news_exp, news_img_alt = n.news_img_alt, news_visit = n.news_visit }).Take(3).OrderByDescending(b => b.news_id); pHome.aNews = vNews.ToList(); var vLink = (from n in Db.tbl_link where n.link_status == 1 select new mLink { link_id = n.link_id, link_exp = n.link_exp, link_img = n.link_img, link_status = n.link_status, link_title = n.link_title, link_exp_en = n.link_exp_en, link_title_en = n.link_title_en }).Take(12).OrderByDescending(b => b.link_id); pHome.aLink = vLink.ToList(); var vLink7 = (from n in Db.tbl_link where n.link_status == 7 select new mLink { link_id = n.link_id, link_exp = n.link_exp, link_img = n.link_img, link_status = n.link_status, link_title = n.link_title, link_exp_en = n.link_exp_en, link_url = n.link_url, link_title_en = n.link_title_en }).Take(6).OrderByDescending(b => b.link_id); pHome.aLink7 = vLink7.ToList(); var vLink5 = (from l in Db.tbl_link where l.link_status == 5 select new mLink { link_id = l.link_id, link_exp = l.link_exp, link_img = l.link_img, link_status = l.link_status, link_title = l.link_title, link_exp_en = l.link_exp_en, link_title_en = l.link_title_en }).Take(3).OrderByDescending(b => b.link_id); pHome.aLink5 = vLink5.ToList(); var vArticles = (from a in Db.tbl_article where a.article_type == 1 select new mArticle { article_id = a.article_id, article_exp = a.article_exp, article_title = a.article_title, article_img = a.article_img, article_img2 = a.article_img2, article_img3 = a.article_img3, article_img_alt = a.article_img_alt, article_summery = a.article_summery, article_date = a.article_date, article_writer = a.article_writer, article_visit = a.article_visit, article_type = a.article_type }).Take(3).OrderByDescending(b => b.article_id); pHome.aArticles = vArticles.ToList(); var vFeedback = (from a in Db.tbl_customer_feedback select new mFeedback { cust_feedback_id = a.cust_feedback_id, cust_feedback_title = a.cust_feedback_title, cust_feedback_img = a.cust_feedback_img, cust_feedback_exp = a.cust_feedback_exp, cust_company_title = a.cust_company_title, cust_address = a.cust_address, cust_feedback_project_img = a.cust_feedback_project_img, cust_feedback_img_height = a.cust_feedback_img_height, cust_feedback_img_width = a.cust_feedback_img_width }).Take(6).OrderByDescending(b => b.cust_feedback_id); pHome.aFeedback = vFeedback.ToList(); var vIns = (from p in Db.tbl_product select new mProduct { product_id = p.product_id, product_img1 = p.product_img1, product_img2 = p.product_img2, product_img_alt = p.product_img_alt, product_price = p.product_price, product_summery = p.product_summery, product_title1 = p.product_title1, product_title2 = p.product_title2, product_cat = p.product_cat, product_parent = p.product_parent, product_exist = p.product_exist, product_exp = p.product_exp, product_visit = p.product_visit, }).Take(4).OrderByDescending(b => b.product_id);; pHome.aIns = vIns.ToList(); return(pHome); }