public static PatientAdminMasterData GetTherapeuticandArchetypeData(string CountryIds)
{
int[] countryid = CountryIds.Split(',').Select(int.Parse).ToArray();
PatientAdminMasterData listresponse = new PatientAdminMasterData();
listresponse = DefaultListDSForPJ.GetTherapeuticandArchetypeData(countryid);
return(listresponse);
}
public static PatientAdminMasterData GetTherapeuticandArchetypeData(int[] countryid)
{
PatientAdminMasterData listresponse = new PatientAdminMasterData();
try
{
using (PJEntities entity = new PJEntities())
{
listresponse.TherapeuticList = (from a in entity.Therapeutic_Area_Master
where a.Is_Active == true
select new TherapeuticAreaList()
{
TherapeuticId = a.Therapeutic_Area_Master_Id,
TherapeuticName = a.Therapeutic_Area_Name
}).OrderBy(x => x.TherapeuticName).ToList();
//ArchetypeList archetype = null;
//listresponse.ArchetypeList = new List<ArchetypeList>();
//for (int i = 0; i < countryid.Length; i++)
//{
// archetype = new ArchetypeList();
// int cuurentcountry = countryid[i];
// archetype = (from arche in entity.Archetype_Master
// join area in entity.Area_Master
// on arche.Archetype_Master_Id equals area.Archetype_Master_Id
// join country in entity.Country_Master
// on area.Archetype_Master_Id equals country.Archetype_Master_Id
// where country.Country_Master_Id == cuurentcountry
// select new ArchetypeList()
// {
// ArchetypeId = arche.Archetype_Master_Id,
// ArchetypeName = arche.Archetype_Name
// }).FirstOrDefault();
// if (archetype != null)
// {
// listresponse.ArchetypeList.Add(archetype);
// }
//}
//listresponse.ArchetypeList.OrderBy(x => x.ArchetypeName);
AreaList areaList = null;
listresponse.AreaList = new List <AreaList>();
for (int i = 0; i < countryid.Length; i++)
{
areaList = new AreaList();
int cuurentcountry = countryid[i];
areaList = (from areaMaster in entity.Area_Master
join country in entity.Country_Master
on areaMaster.Area_Master_Id equals country.Area_Master_Id
where country.Country_Master_Id == cuurentcountry
select new AreaList()
{
AreaId = areaMaster.Area_Master_Id,
AreaName = areaMaster.Area_Name
}).FirstOrDefault();
if (areaList != null)
{
if (!listresponse.AreaList.Exists(x => x.AreaId == areaList.AreaId))
{
listresponse.AreaList.Add(areaList);
}
}
}
listresponse.AreaList = listresponse.AreaList.OrderBy(x => x.AreaName).ToList();
listresponse.YearList = (from a in entity.Year_Master
where a.Active == true
select new YearMasterData()
{
YearId = a.Year_Master_Id,
YearName = a.Year_Name
}).OrderBy(x => x.YearName).ToList();
}
}
catch (Exception)
{
}
return(listresponse);
}
