public static List <ATTPrivateLawyer> GetPrivateLawyerInfo(double PID) { List <ATTPrivateLawyer> lst = new List <ATTPrivateLawyer>(); try { List <ATTPrivateLawyerRenewal> lstRenewal = BLLPrivateLawyerRenewal.GetPrivateLawyerRenewal(PID); foreach (DataRow row in DLL.DLLPrivateLawyer.GetPrivateLawyerInfo(PID).Rows) { ATTPrivateLawyer obj = new ATTPrivateLawyer(); obj.PersonID = double.Parse(row["p_id"].ToString()); obj.LawyerTypeID = int.Parse(row["lawyer_type_id"].ToString()); obj.Lisence = row["LICENSE_NO"].ToString(); obj.UnitID = int.Parse(row["unit_id"].ToString()); obj.UnitName = row["unit_name"].ToString(); obj.FromDate = row["from_date"].ToString(); obj.ToDate = row["to_date"].ToString(); obj.EntryBy = ""; obj.Action = "N"; obj.LstRenewal = lstRenewal.FindAll ( delegate(ATTPrivateLawyerRenewal r) { return (r.PersonID == obj.PersonID && r.LawyerTypeID == obj.LawyerTypeID && r.Lisence == obj.Lisence && r.UnitID == obj.UnitID); } ); lst.Add(obj); } return(lst); } catch (Exception ex) { throw ex; } }
private static List <ATTPrivateLawyer> SetPrivateLawyer(ATTLawyer objLawyer, DataTable tblPL, DataTable tblPLR) { try { List <ATTPrivateLawyer> lstPrivateLawyer = new List <ATTPrivateLawyer>(); foreach (DataRow row in tblPL.Rows) { if (objLawyer.PID == int.Parse(row["P_ID"].ToString()) && objLawyer.LawyerTypeID == int.Parse(row["LAWYER_TYPE_ID"].ToString()) && objLawyer.LicenseNo == row["LICENSE_NO"].ToString() ) { ATTPrivateLawyer objPrivateLawyer = new ATTPrivateLawyer(); objPrivateLawyer.PersonID = int.Parse(row["P_ID"].ToString()); objPrivateLawyer.LawyerTypeID = int.Parse(row["LAWYER_TYPE_ID"].ToString()); objPrivateLawyer.Lisence = row["LICENSE_NO"].ToString(); objPrivateLawyer.FromDate = row["P_FROM_DATE"].ToString(); objPrivateLawyer.UnitID = int.Parse(row["UNIT_ID"].ToString()); objPrivateLawyer.UnitName = row["unit_name"].ToString(); objPrivateLawyer.ToDate = ""; objPrivateLawyer.EntryBy = ""; objPrivateLawyer.Action = "N"; if (tblPLR.Rows.Count > 0) { objPrivateLawyer.LstRenewal = SetPrivateLawyerRenewal(objPrivateLawyer, tblPLR); } //P_ID,LAWYER_TYPE_ID,LICENSE_NO,P_FROM_DATE,UNIT_ID lstPrivateLawyer.Add(objPrivateLawyer); } } return(lstPrivateLawyer); } catch (Exception ex) { throw (ex); } }
private static List <ATTPrivateLawyerRenewal> SetPrivateLawyerRenewal(ATTPrivateLawyer objPrivateLawyer, DataTable tblPLR) { try { List <ATTPrivateLawyerRenewal> lstPrivateLawyerRenewal = new List <ATTPrivateLawyerRenewal>(); foreach (DataRow row in tblPLR.Rows) { if (objPrivateLawyer.PersonID == int.Parse(row["P_ID"].ToString()) && objPrivateLawyer.LawyerTypeID == int.Parse(row["LAWYER_TYPE_ID"].ToString()) && objPrivateLawyer.Lisence == row["LICENSE_NO"].ToString() && objPrivateLawyer.UnitID == int.Parse(row["UNIT_ID"].ToString()) ) { ATTPrivateLawyerRenewal objPrivateLawyerRenewal = new ATTPrivateLawyerRenewal(); objPrivateLawyerRenewal.PersonID = int.Parse(row["P_ID"].ToString()); objPrivateLawyerRenewal.LawyerTypeID = int.Parse(row["LAWYER_TYPE_ID"].ToString()); objPrivateLawyerRenewal.Lisence = row["LICENSE_NO"].ToString(); objPrivateLawyerRenewal.UnitID = int.Parse(row["UNIT_ID"].ToString()); objPrivateLawyerRenewal.UnitName = row["unit_name"].ToString(); objPrivateLawyerRenewal.FromDate = row["P_FROM_DATE"].ToString(); objPrivateLawyerRenewal.RenewalDate = row["P_RENEWAL_DATE"].ToString(); objPrivateLawyerRenewal.RenewalUpto = row["P_RENEWAL_UPTO"].ToString(); objPrivateLawyerRenewal.EntryBy = ""; objPrivateLawyerRenewal.Action = "N"; lstPrivateLawyerRenewal.Add(objPrivateLawyerRenewal); } } return(lstPrivateLawyerRenewal); } catch (Exception ex) { throw (ex); } }