public static bool SaveLawyerPerson(ATTLawyerPerson objLawyerPerson)
{
GetConnection GetConn = new GetConnection();
OracleTransaction Tran = GetConn.GetDbConn(Module.LJMS).BeginTransaction();
double pID = 0;
try
{
pID = DLLPerson.AddPersonnelDetails(objLawyerPerson, Tran);
DLLLawyer.SaveLawyerDetails(pID, objLawyerPerson.LstLawyer, Tran);
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
GetConn.CloseDbConn();
}
}
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();
}
}
