public static bool DeleteMeetingEvents(ATTMeeting objMeeting) { string deleteSQL = "SP_DEL_MEETING"; int CountMeetingAgenda = objMeeting.LstMeetingAgenda.Count; int CountMeetingParticipant = objMeeting.LstMeetingParticipant.Count; OracleParameter[] paramArray = new OracleParameter[2]; paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", objMeeting.OrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":p_MEETING_ID", objMeeting.MeetingID, OracleDbType.Int64, ParameterDirection.Input); GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); try { if (CountMeetingAgenda > 0) { DLLMeetingAgenda.DeleteMeetingAgenda(objMeeting, Tran); } if (CountMeetingParticipant > 0) { DLLMeetingParticipant.DeleteMeetingParticipant(objMeeting, Tran); } DLLMeetingMinute.DeleteMeetingMinute(objMeeting, Tran); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, deleteSQL, paramArray); Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw (ex); } finally { GetConn.CloseDbConn(); } }
public static string SaveMeetingEvents(ATTMeeting objMeeting) { GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); if (objMeeting.VenueType == "INS") { int bookedVenueCount = CheckVenueAvailability(objMeeting, Tran); if (bookedVenueCount < 1) { Tran.Commit(); return("-1"); } int venueInUseCount = CheckVenueInUse(objMeeting, Tran); if (venueInUseCount > 0) { Tran.Commit(); return("-2"); } } string SaveSQL = "SP_ADD_MEETING"; string eventIDs = ""; int CountMeetingAgenda = objMeeting.LstMeetingAgenda.Count; int CountMeetingParticipant = objMeeting.LstMeetingParticipant.Count; OracleParameter[] paramArray = new OracleParameter[18]; paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", objMeeting.OrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":p_MEETING_ID", null, OracleDbType.Int64, ParameterDirection.Output); paramArray[2] = Utilities.GetOraParam(":P_MTYPE_ID", objMeeting.MeetingTypeID, OracleDbType.Int64, ParameterDirection.Input); paramArray[3] = Utilities.GetOraParam(":P_VENUE_ID", objMeeting.VenueID, OracleDbType.Int64, ParameterDirection.Input); paramArray[4] = Utilities.GetOraParam(":P_MEETING_SUBJECT", objMeeting.Subject, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[5] = Utilities.GetOraParam(":P_MEETING_DATE", objMeeting.MeetingDate, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[6] = Utilities.GetOraParam(":P_CALLED_BY", objMeeting.CalledBy, OracleDbType.Int64, ParameterDirection.Input); paramArray[7] = Utilities.GetOraParam(":P_START_TIME", objMeeting.StartTime, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[8] = Utilities.GetOraParam(":P_END_TIME", objMeeting.EndTime, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[9] = Utilities.GetOraParam(":P_ENTRY_BY", objMeeting.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[10] = Utilities.GetOraParam(":P_ENTRY_ON", objMeeting.EntryOn, OracleDbType.Date, ParameterDirection.Input); paramArray[11] = Utilities.GetOraParam(":P_STATUS", objMeeting.Status, OracleDbType.Int64, ParameterDirection.Input); paramArray[12] = Utilities.GetOraParam(":P_REMARKS", objMeeting.Remark, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[13] = Utilities.GetOraParam(":P_IS_GRP_CALLER ", objMeeting.IsGrpCaller, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[14] = Utilities.GetOraParam(":P_CALLED_BY_P_ID", objMeeting.CalledByPID, OracleDbType.Int64, ParameterDirection.Input); paramArray[15] = Utilities.GetOraParam(":P_VENUE_TYPE", objMeeting.VenueType, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[16] = Utilities.GetOraParam(":P_VENUE_DATA", objMeeting.VenueData, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[17] = Utilities.GetOraParam(":P_VENUE_BOOKING_ID", objMeeting.VenueBookingID, OracleDbType.Int64, ParameterDirection.Input); try { SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, SaveSQL, paramArray); objMeeting.MeetingID = int.Parse(paramArray[1].Value.ToString()); eventIDs += paramArray[1].Value.ToString() + "/"; if (CountMeetingAgenda > 0) { eventIDs += DLLMeetingAgenda.SaveMeetingAgenda(objMeeting, Tran); } if (CountMeetingParticipant > 0) { eventIDs += DLLMeetingParticipant.SaveMeetingParticipant(objMeeting, Tran); } Tran.Commit(); if (eventIDs.Length > 0) { eventIDs = eventIDs.Substring(0, eventIDs.Length - 1); } return(eventIDs); } catch (Exception ex) { Tran.Rollback(); throw (ex); } finally { GetConn.CloseDbConn(); } }