public static GetSubTherapeuticAreaListPJ GetSubTherapeuticListBSForPJ(int TherapeuticId) { GetSubTherapeuticAreaListPJ listresponse = new GetSubTherapeuticAreaListPJ(); listresponse = DefaultListDSForPJ.GetSubTherapeuticListDSForPJ(TherapeuticId); return(listresponse); }
public static GetSubTherapeuticAreaListPJ GetSubTherapeuticListDSForPJ(int TherapeuticId) { GetSubTherapeuticAreaListPJ listresponse = new GetSubTherapeuticAreaListPJ(); using (PJEntities entity = new PJEntities()) { var subTherapeuticData = from r in entity.SubTherapeutic_Area_Master select r; listresponse.SubTherapeuticList = (from a in subTherapeuticData where a.Therapeutic_Area_Master_Id == TherapeuticId where a.Is_Active == true select new SubTherapeuticAreaList() { SubTherapeuticId = a.SubTherapeutic_Area_Master_Id, SubTherapeuticName = a.SubTherapeutic_Area_Name }).OrderBy(x => x.SubTherapeuticName).ToList(); } return(listresponse); }