private static List <ATTLawyerRenewal> SetLawyerRenewal(ATTLawyer objLawyer, DataTable tblLR)
{
try
{
List <ATTLawyerRenewal> lstLawyerRenewal = new List <ATTLawyerRenewal>();
foreach (DataRow row in tblLR.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()
)
{
ATTLawyerRenewal objLawyerRenewal = new ATTLawyerRenewal();
objLawyerRenewal.PID = int.Parse(row["P_ID"].ToString());
objLawyerRenewal.LawyerTypeID = int.Parse(row["LAWYER_TYPE_ID"].ToString());
objLawyerRenewal.LawyerTypeName = row["lawyer_type_description"].ToString();
objLawyerRenewal.LicenseNo = row["LICENSE_NO"].ToString();
objLawyerRenewal.RenewalDate = row["RENEWAL_DATE"].ToString();
objLawyerRenewal.RenewalUpto = row["RENEWAL_UPTO"].ToString();
objLawyerRenewal.Action = "N";
lstLawyerRenewal.Add(objLawyerRenewal);
}
}
return(lstLawyerRenewal);
}
catch (Exception ex)
{
throw (ex);
}
}
public static bool SaveLawyerDetails(ATTLawyer objLawyer)
{
try
{
if (DLLLawyer.SaveLawyerDetails(objLawyer))
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool SaveLawyerRenewalDetails(ATTLawyer objLawyer, OracleTransaction Tran)
{
try
{
string sp = "";
foreach (ATTLawyerRenewal objLawyerRenw in objLawyer.LstLawyerRenewal)
{
if (objLawyerRenw.Action == "A")
{
sp = "SP_ADD_LAWYER_RENEWAL";
}
else if (objLawyerRenw.Action == "E")
{
sp = "SP_EDIT_LAWYER_RENEWAL";
}
if (sp != "")
{
OracleParameter[] paramArray = new OracleParameter[7];
paramArray[0] = Utilities.GetOraParam(":p_P_ID", objLawyer.PID, OracleDbType.Double, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":P_LAWYER_TYPE_ID", objLawyerRenw.LawyerTypeID, OracleDbType.Int16, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam(":P_LICENSE_NO", objLawyerRenw.LicenseNo, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[3] = Utilities.GetOraParam(":P_FROM_DATE", objLawyerRenw.RenewalDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[4] = Utilities.GetOraParam(":P_TO_DATE", objLawyerRenw.RenewalUpto, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[5] = Utilities.GetOraParam(":p_ENTRY_BY", objLawyerRenw.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[6] = Utilities.GetOraParam(":p_ENTRY_DATE", null, OracleDbType.Date, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray);
sp = "";
}
objLawyerRenw.PID = objLawyer.PID;
}
return(true);
}
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);
}
}
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);
}
}
public static bool SaveLawyerDetails(ATTLawyer objLawyer)
{
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.LJMS).BeginTransaction();
double pID;
try
{
pID = DLLPerson.AddPersonnelDetails(objLawyer.ObjPerson, Tran);
objLawyer.PID = pID;
if (pID > 0)
{
string sp = "SP_ADD_LAWYER_INFO ";
OracleParameter[] paramArray = new OracleParameter[6];
paramArray[0] = Utilities.GetOraParam(":p_P_ID", pID, OracleDbType.Double, ParameterDirection.Input);
paramArray[1] = Utilities.GetOraParam(":P_LAWYER_TYPE_ID", objLawyer.LawyerTypeID, OracleDbType.Int16, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam(":P_LICENSE_NO", objLawyer.LicenseNo, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[3] = Utilities.GetOraParam(":P_FROM_DATE", objLawyer.FromDate, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[4] = Utilities.GetOraParam(":P_TO_DATE", "", OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[5] = Utilities.GetOraParam(":p_ENTRY_BY", objLawyer.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray);
if (objLawyer.LstLawyerRenewal.Count > 0)
{
//DLLLawyerRenewal.SaveLawyerRenewalDetails(objLawyer, Tran);
DLLLawyer.SaveLawyerDetails(objLawyer);
}
//if (objLawyer.LstPrivateLawyer.Count > 0)
//{
// DLLLawyer.SaveLawyerDetails(objLawyer);
//}
Tran.Commit();
return(true);
}
else
{
Tran.Rollback();
return(false);
}
}
catch (OracleException oex)
{
PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
