public static string SaveMeetingAgenda(ATTMeetingAgenda objMeetingAgenda, OracleTransaction Tran) { try { string saveSQL = "SP_ADD_MEETING_AGENDA"; string agendaIDs = ""; List <OracleParameter> paramArray = new List <OracleParameter>(); if (objMeetingAgenda.Action == "A") { paramArray.Add(Utilities.GetOraParam(":p_ORG_ID", objMeetingAgenda.OrgID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_MEETING_ID", objMeetingAgenda.MeetingID, OracleDbType.Int64, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_AGENDA_ID", null, OracleDbType.Int64, ParameterDirection.InputOutput)); paramArray.Add(Utilities.GetOraParam(":P_AGENDA", objMeetingAgenda.Agenda, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ENTRY_BY", objMeetingAgenda.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam(":P_ENTRY_ON", objMeetingAgenda.EntryOn, OracleDbType.Date, ParameterDirection.Input)); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, saveSQL, paramArray.ToArray()); agendaIDs = paramArray[2].Value.ToString(); objMeetingAgenda.Action = ""; paramArray.Clear(); } return(agendaIDs); } catch (Exception ex) { throw (ex); } }
public static bool DeleteMeetingAgenda(ATTMeetingAgenda objMeetingAgenda, OracleTransaction Tran) { try { if (objMeetingAgenda.Action == "D") { string deleteSQL = "SP_DEL_MEETING_AGENDA"; OracleParameter[] paramArray = new OracleParameter[3]; paramArray[0] = Utilities.GetOraParam(":P_ORG_ID", objMeetingAgenda.OrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":P_MEETING_ID", objMeetingAgenda.MeetingID, OracleDbType.Int64, ParameterDirection.Input); paramArray[2] = Utilities.GetOraParam(":P_AGENDA_ID", objMeetingAgenda.AgendaID, OracleDbType.Int64, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, deleteSQL, paramArray); } return(true); } catch (Exception ex) { throw (ex); } }