public ActionResult ServicesDetails(int id) { ROP_WEBEntities db = new ROP_WEBEntities(); return(View(db.SERVICEs.FirstOrDefault(x => x.Service_Id == id))); }
public ActionResult FAQ() { ROP_WEBEntities db = new ROP_WEBEntities(); return(View(db.FAQMains.ToList())); }
// ServiceReference1.Service1Client service = new ServiceReference1.Service1Client(); // GET: Home public ActionResult Index() { ROP_WEBEntities db = new ROP_WEBEntities(); ViewModel mymodel = new ViewModel(); //slider id 1 will be active one,, other normal List <Slider> slides = new List <Slider>(); //use try andcatch for erorr control + id showd come from user request XElement xelement = XElement.Load(HttpContext.Server.MapPath("~/ROP-Content/Xmls/Slider.xml")); var slidslist = xelement.Elements(); // var element = (from Offense in OffenseClass where (int)Offense.Element("OffenseId") == 1 select Offense).ToList(); foreach (XElement xEle in slidslist) { slides.Add(new Slider { SlideId = (int)xEle.Element("SlideId"), SlideImg = xEle.Element("SlideImg").Value, SlideUrl = xEle.Element("SlideUrl").Value, SlideAlt = xEle.Element("SlideAlt").Value, SlideLang = xEle.Element("SlideLang").Value }); } CultureInfo currentInfo = Thread.CurrentThread.CurrentCulture; if (currentInfo.IetfLanguageTag.ToString().Equals("ar-OM") || (currentInfo.IetfLanguageTag.ToString().Equals("ar"))) { mymodel.Sliders = slides.Where(x => x.SlideLang == "ar").ToList(); } else { mymodel.Sliders = slides.Where(x => x.SlideLang == "en").ToList(); } //get last 3 ads/*******************************/ //slider id 1 will be active one,, other normal List <Ad> ad = new List <Ad>(); //use try andcatch for erorr control + id showd come from user request XElement adsxelement = XElement.Load(HttpContext.Server.MapPath("~/ROP-Content/Xmls/Ads.xml")); var adslist = adsxelement.Elements(); // var element = (from Offense in OffenseClass where (int)Offense.Element("OffenseId") == 1 select Offense).ToList(); foreach (XElement xEle in adslist) { ad.Add(new Ad { AdId = (int)xEle.Element("AdId"), AdTitle = xEle.Element("AdTitle").Value, Adtxt = xEle.Element("Adtxt").Value, Adimg = xEle.Element("Adimg").Value, Adfile = xEle.Element("Adfile").Value, AdLang = xEle.Element("AdLang").Value, AdEndDate = (DateTime)xEle.Element("AdEndDate") });; } if (currentInfo.IetfLanguageTag.ToString().Equals("ar-OM") || (currentInfo.IetfLanguageTag.ToString().Equals("ar"))) { mymodel.Ads = ad.Where(x => x.AdLang == "ar").ToList(); } else { mymodel.Ads = ad.Where(x => x.AdLang == "en").ToList(); } //get last 4 news/***************************/ if (currentInfo.IetfLanguageTag.ToString().Equals("ar-OM") || (currentInfo.IetfLanguageTag.ToString().Equals("ar"))) { mymodel.News = db.NewsMains.Where(x => x.Show == true && x.Archive == false && x.Language == "ar").Take(4).ToList(); } else { mymodel.News = db.NewsMains.Where(x => x.Show == true && x.Archive == false && x.Language == "en").Take(4).ToList(); } return(View(mymodel)); }