Example #1
0
        public static GetSubTherapeuticAreaListPJ GetSubTherapeuticListBSForPJ(int TherapeuticId)
        {
            GetSubTherapeuticAreaListPJ listresponse = new GetSubTherapeuticAreaListPJ();

            listresponse = DefaultListDSForPJ.GetSubTherapeuticListDSForPJ(TherapeuticId);

            return(listresponse);
        }
Example #2
0
        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);
        }