public static bool SaveFacultyMember(ATTFacultyMember objFacultyMember) { GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.DLPDS).BeginTransaction(); double personID; string InsertUpdatePostSql = ""; try { personID = DLLPerson.AddPersonnelDetails(objFacultyMember.ObjPerson, Tran); if (objFacultyMember.LstParticipantPost.Count > 0) { DLLParticipantPost.SaveParticipantPost(objFacultyMember.LstParticipantPost, Tran, personID); } OracleParameter[] ParamArray = new OracleParameter[5]; ParamArray[0] = Utilities.GetOraParam(":p_ORG_ID", objFacultyMember.OrgID, OracleDbType.Int32, ParameterDirection.Input); ParamArray[1] = Utilities.GetOraParam(":p_FACULTY_ID", objFacultyMember.FacultyID, OracleDbType.Int32, ParameterDirection.Input); ParamArray[2] = Utilities.GetOraParam(":p_P_ID", personID, OracleDbType.Double, ParameterDirection.Input); ParamArray[3] = Utilities.GetOraParam(":p_FROM_DATE", objFacultyMember.FromDate, OracleDbType.Varchar2, ParameterDirection.Input); ParamArray[4] = Utilities.GetOraParam(":p_TO_DATE", objFacultyMember.ToDate, OracleDbType.Varchar2, ParameterDirection.Input); if (objFacultyMember.PID == 0) { InsertUpdatePostSql = "SP_ADD_FACULTY_MEMBER"; } else if (objFacultyMember.PID > 0) { InsertUpdatePostSql = "SP_EDIT_FACULTY_MEMBER"; } SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdatePostSql, ParamArray); objFacultyMember.PID = personID; Tran.Commit(); return(true); } 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(); } }
public static bool SaveParticipant(ATTParticipant ObjParticipant) { GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.DLPDS).BeginTransaction(); double personID; string InsertUpdatePostSql = ""; try { personID = DLLPerson.AddPersonnelDetails(ObjParticipant.ObjPerson, Tran); if (ObjParticipant.LstParticipantPost.Count > 0) { DLLParticipantPost.SaveParticipantPost(ObjParticipant.LstParticipantPost, Tran, personID); } OracleParameter[] ParamArray = new OracleParameter[4]; ParamArray[0] = Utilities.GetOraParam(":p_ORG_ID", ObjParticipant.OrgID, OracleDbType.Int64, ParameterDirection.Input); ParamArray[1] = Utilities.GetOraParam(":p_PROGRAM_ID", ObjParticipant.ProgramID, OracleDbType.Int64, ParameterDirection.Input); ParamArray[2] = Utilities.GetOraParam(":p_P_ID", personID, OracleDbType.Double, ParameterDirection.Input); ParamArray[3] = Utilities.GetOraParam(":p_JOINING_DATE", ObjParticipant.JoiningDate, OracleDbType.Varchar2, ParameterDirection.Input); if (ObjParticipant.PID == 0) { InsertUpdatePostSql = "SP_ADD_PARTICIPANT"; } else if (ObjParticipant.PID > 0) { InsertUpdatePostSql = "SP_EDIT_PARTICIPANT"; } SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, InsertUpdatePostSql, ParamArray); ObjParticipant.PID = personID; Tran.Commit(); return(true); } 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(); } }