예제 #1
0
        public static List <ATTLawyer> GetLawyerDetails(double PID)
        {
            try
            {
                List <ATTLawyer> lst = new List <ATTLawyer>();

                DataTable tblL   = DLLLawyer.GetLawyerDetailTable(PID);
                DataTable tblLR  = BLLLawyerRenewal.GetLawyerRenewalDetails(PID);
                DataTable tblPL  = BLLPrivateLawyer.GetPrivateLawyerDetails(PID);
                DataTable tblPLR = BLLPrivateLawyerRenewal.GetPrivateLawyerRenewalDetails(PID);

                foreach (DataRow row in tblL.Rows)
                {
                    ATTLawyer objLawyer = new ATTLawyer();
                    objLawyer.PID            = int.Parse(row["P_ID"].ToString());
                    objLawyer.LawyerTypeID   = int.Parse(row["LAWYER_TYPE_ID"].ToString());
                    objLawyer.LawyerTypeName = row["lawyer_type_description"].ToString();
                    objLawyer.LicenseNo      = row["LICENSE_NO"].ToString();
                    objLawyer.FromDate       = row["FROM_DATE"].ToString();

                    if (tblLR.Rows.Count > 0)
                    {
                        objLawyer.LstLawyerRenewal = SetLawyerRenewal(objLawyer, tblLR);
                    }

                    if (tblPL.Rows.Count > 0)
                    {
                        objLawyer.LstPrivateLawyer = SetPrivateLawyer(objLawyer, tblPL, tblPLR);
                    }

                    lst.Add(objLawyer);
                }

                return(lst);
            }
            catch (Exception ex)
            {
                throw(ex);
            }
        }