public ActionResult searchdivs(string DivisionName) { DivisionsbyCountry DivC = (DivisionsbyCountry)Session["DivisionsbyCountry"]; if (DivC != null) { if (DivisionName != null) { if (DivisionName == string.Empty) { return(RedirectToAction("Index")); } else { int count = 0; int Country = DivC.Country; var Divs = (from Lab in db.Divisions join Count in db.Countries on Lab.CountryId equals Count.CountryId where Lab.CountryId == Country select new joinDivisionsCountries { Countries = Count, Divisions = Lab }); if (!string.IsNullOrEmpty(DivisionName)) { Divs = Divs.Where(s => s.Divisions.DivisionName.StartsWith(DivisionName)); foreach (joinDivisionsCountries J in Divs) { count = count + 1; } ViewData["Count"] = count; } return(View("Index", Divs)); } } } else { return(RedirectToAction("Logout", "Login")); } return(View()); }
public ActionResult Index(string CountryId) { DivisionsbyCountry DivC = (DivisionsbyCountry)Session["DivisionsbyCountry"]; if (CountryId != null) { int count = 0; int Country = int.Parse(CountryId); var Divs = (from Lab in db.Divisions join Count in db.Countries on Lab.CountryId equals Count.CountryId where Lab.CountryId == Country select new joinDivisionsCountries { Countries = Count, Divisions = Lab }).OrderBy(x => x.Divisions.DivisionName); foreach (joinDivisionsCountries jdc in Divs) { count = count + 1; } if (count == 0) { ViewData["CountProds"] = null; } else { ViewData["CountProds"] = count; } DivisionsbyCountry DivisionsbyCountry = new DivisionsbyCountry(Country); Session["DivisionsbyCountry"] = DivisionsbyCountry; return(View(Divs)); } else if (DivC != null) { int count = 0; int Country = DivC.Country; var Divs = (from Lab in db.Divisions join Count in db.Countries on Lab.CountryId equals Count.CountryId where Lab.CountryId == Country select new joinDivisionsCountries { Countries = Count, Divisions = Lab }).OrderBy(x => x.Divisions.DivisionName); foreach (joinDivisionsCountries jdc in Divs) { count = count + 1; } if (count == 0) { ViewData["CountProds"] = null; } else { ViewData["CountProds"] = count; } return(View(Divs)); } else { var Divs = (from Lab in db.Divisions join Count in db.Countries on Lab.CountryId equals Count.CountryId where Lab.CountryId == 0 select new joinDivisionsCountries { Countries = Count, Divisions = Lab }).OrderBy(x => x.Divisions.DivisionName); ViewData["CountProds"] = 0; return(View(Divs)); } }