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