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));
}
}
