// // GET: /Country/ // Controller action receives the Continent id parameter public ActionResult Index(int id) { // instantiate the db WorldDataContext _dataContext = new WorldDataContext(); // Linq query to select the countries with the same continent id of the parameter var listofCountries = from c in _dataContext.Countries where c.continentId == id select c; //Validation to check if any country was found in the DB, to avoid user type invalid Id in the URL if (listofCountries.Count() == 0) //Redirect to Home return RedirectToAction("Index","Home"); //create a list of countries to send to the view IEnumerable<CountryObj> listOfItems = listofCountries.Select(c => new CountryObj(c.countryId, c.countryName, c.continentId )); //add a obj to the list with a invalid Id to use like a default value for the drop down list CountryObj c1 = new CountryObj(-1, "Select a Country", -1); listOfItems = (new[] { c1 }).Concat(listOfItems); // Get the Continent name and keep in the viewbag var continentsearch = from c in _dataContext.Continents where c.continentId == id select c.continentName; IEnumerable<string> continentName = continentsearch.Select(c => c); ViewBag.ContinentName = continentName.First(); return View(listOfItems); }
public string getCountryName(int id) { string cName = ""; WorldDataContext _dataContext = new WorldDataContext(); var countrysearch = from c in _dataContext.Countries where c.countryId == id select c.countryName; IEnumerable<string> countryName = countrysearch.Select(c => c); cName = countryName.First(); return cName; }
// // GET: /Comment/ public ActionResult Index() { // instantiate the db WorldDataContext _dataContext = new WorldDataContext(); // Linq query to get the comments list var listofComments = from c in _dataContext.Infos select c; IEnumerable<CommentObj> listOfItems = listofComments.Select(c => new CommentObj(c.infoId, c.name, c.countryId, c.dateOfVisit,c.countryInformation)); return View(listOfItems); }
public ActionResult Create(Info info) { //Get the HttpPost request from the Comments form and fill with the remaining information info.countryId = Convert.ToInt16(Session["CountryId"]); info.infoDate = DateTime.Now; info.ip = GetUserIP(); info.ipLocation = getCityLocationFromIp(info.ip); WorldDataContext _dataContext = new WorldDataContext(); //Insert the Info object into the database and submit the changes _dataContext.Infos.InsertOnSubmit(info); _dataContext.SubmitChanges(); return Redirect("/"); }