public ActionResult Index(string Id)
{
CountriesSs D = (CountriesSs)Session["CountriesSs"];
if (Id != null)
{
int LabId = int.Parse(Id);
var Labs = (from Lab in db.Divisions
join Count in db.Countries
on Lab.CountryId equals Count.CountryId
where Lab.LaboratoryId == LabId
select new joinDivisionsCountries {
Countries = Count, Divisions = Lab
}).OrderBy(x => x.Divisions.DivisionName);
if (Labs.LongCount() > 0)
{
ViewData["CountProds"] = 0;
}
else
{
ViewData["CountProds"] = null;
}
CountriesSs CountriesSs = new CountriesSs(LabId);
Session["CountriesSs"] = CountriesSs;
return(View(Labs));
}
else if (D != null)
{
int LabId = D.LabId;
var Labs = (from Lab in db.Divisions
join Count in db.Countries
on Lab.CountryId equals Count.CountryId
where Lab.LaboratoryId == LabId
select new joinDivisionsCountries {
Countries = Count, Divisions = Lab
}).OrderBy(x => x.Divisions.DivisionName);
if (Labs.LongCount() > 0)
{
ViewData["CountProds"] = 0;
}
else
{
ViewData["CountProds"] = null;
}
return(View(Labs));
}
else
{
var Labs = (from Lab in db.Divisions
join Count in db.Countries
on Lab.CountryId equals Count.CountryId
where Lab.LaboratoryId == 0
select new joinDivisionsCountries {
Countries = Count, Divisions = Lab
}).OrderBy(x => x.Divisions.DivisionName);
return(View(Labs));
}
}
public ActionResult searchdivisions(string DivisionName)
{
int count = 0;
CountriesSs c = (CountriesSs)Session["CountriesSs"];
if (DivisionName != null)
{
if (DivisionName == string.Empty)
{
return(RedirectToAction("Index", "Divisions"));
}
else
{
int LabId = c.LabId;
var Divs = (from Lab in db.Divisions
join Count in db.Countries
on Lab.CountryId equals Count.CountryId
where Lab.LaboratoryId == LabId
select new joinDivisionsCountries {
Countries = Count, Divisions = Lab
}).OrderBy(x => x.Divisions.DivisionName);
if (!string.IsNullOrEmpty(DivisionName))
{
Divs = Divs.Where(x => x.Divisions.DivisionName.StartsWith(DivisionName) || x.Divisions.ShortName.StartsWith(DivisionName)).OrderBy(q => q.Divisions.DivisionName);
foreach (joinDivisionsCountries D in Divs)
{
count = count + 1;
}
ViewData["Count"] = count;
}
SearchDiv SearchDiv = new SearchDiv(DivisionName);
Session["SearchDiv"] = SearchDiv;
return(View("Index", Divs));
}
}
else
{
SearchDiv s = (SearchDiv)Session["SearchDiv"];
int LabId = c.LabId;
var Divs = (from Lab in db.Divisions
join Count in db.Countries
on Lab.CountryId equals Count.CountryId
where Lab.LaboratoryId == LabId
select new joinDivisionsCountries {
Countries = Count, Divisions = Lab
}).OrderBy(x => x.Divisions.DivisionName);
if (!string.IsNullOrEmpty(s.DivisionName))
{
Divs = Divs.Where(x => x.Divisions.DivisionName.StartsWith(DivisionName) || x.Divisions.ShortName.StartsWith(DivisionName)).OrderBy(q => q.Divisions.DivisionName);
foreach (joinDivisionsCountries D in Divs)
{
count = count + 1;
}
ViewData["Count"] = count;
}
return(View("Index", Divs));
}
}
public ActionResult creatediv(string DivisionN, string ShortName, string Country)
{
CountriesUsers p = (CountriesUsers)Session["CountriesUsers"];
int ApplicationId = p.ApplicationId;
int UsersId = p.userId;
CountriesSs D = (CountriesSs)Session["CountriesSs"];
int LabId = D.LabId;
bool Div = CreateDiv.CreateDivs(DivisionN, ShortName, Country, LabId, ApplicationId, UsersId);
return(Json(Div, JsonRequestBehavior.AllowGet));
}