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