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