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