public static GetBrandAndAreaListPJ GetBrandAndAreaListBSForPJ()
{
GetBrandAndAreaListPJ listresponse = new GetBrandAndAreaListPJ();
listresponse = DefaultListDSForPJ.GetBrandAndAreaListDSForPJ();
return(listresponse);
}
public static GetBrandAndAreaListPJ GetBrandAndAreaListDSForPJ()
{
GetBrandAndAreaListPJ listresponse = new GetBrandAndAreaListPJ();
using (PJEntities entity = new PJEntities())
{
var therapeuticAreaData = from r in entity.Therapeutic_Area_Master select r;
var areaData = from r in entity.Area_Master select r;
var countryData = entity.Country_Master.ToList();
var archetypeData = entity.Archetype_Master.ToList();
listresponse.TherapeuticList = (from a in therapeuticAreaData
where a.Is_Active == true
select new TherapeuticAreaList()
{
TherapeuticId = a.Therapeutic_Area_Master_Id,
TherapeuticName = a.Therapeutic_Area_Name
}).OrderBy(x => x.TherapeuticName).ToList();
listresponse.ArchetypeLists = (from a in archetypeData
where a.Is_Active == true
select new ArchetypeList()
{
ArchetypeId = a.Archetype_Master_Id,
ArchetypeName = a.Archetype_Name
}).OrderBy(x => x.ArchetypeName).ToList();
listresponse.AreaList = (from a in areaData
where a.Is_Active == true
select new AreaList()
{
AreaId = a.Area_Master_Id,
AreaName = a.Area_Name
}).OrderBy(x => x.AreaName).ToList();
List <AreaList2> areaListFinal = new List <AreaList2>();
for (int i = 0; i < listresponse.AreaList.Count; i++)
{
AreaList2 _area = new AreaList2();
_area.AreaId = Convert.ToInt32(listresponse.AreaList[i].AreaId);
_area.AreaName = areaData.Where(x => x.Area_Master_Id == _area.AreaId).FirstOrDefault().Area_Name.ToString();
var countrylist = (from h in countryData
where h.Area_Master_Id == _area.AreaId
where h.Is_Active == true
select new CountryList()
{
CountryId = h.Country_Master_Id,
CountryName = h.Country_Name,
AreaId = h.Area_Master_Id
}).OrderBy(x => x.CountryName).ToList();
_area.CountryList = countrylist;
areaListFinal.Add(_area);
}
listresponse.AreaList2 = areaListFinal;
}
return(listresponse);
}
