public static int SaveMeetingVenueBooking(ATTMeetingVenueBooking objVenueBok) { GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); try { int venueAlreadyExistCount = CheckVenueIfVenueAlreadyBooked(objVenueBok, Tran); if (venueAlreadyExistCount > 0) { Tran.Commit(); //return false; return(0); } string sp = "SP_ADD_MEETING_VENUE_BOOKING"; int countBookedResources = objVenueBok.LstBookedResources.Count; OracleParameter[] paramArray = new OracleParameter[11]; paramArray[0] = Utilities.GetOraParam(":p_ORG_ID", objVenueBok.OrgID, OracleDbType.Int64, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":P_VENUE_ID", objVenueBok.VenueID, OracleDbType.Int64, ParameterDirection.Input); paramArray[2] = Utilities.GetOraParam(":P_BOOKING_ID", objVenueBok.BookingID, OracleDbType.Int64, ParameterDirection.InputOutput); paramArray[3] = Utilities.GetOraParam(":P_BOOKED_BY", objVenueBok.BookedBy, OracleDbType.Int64, ParameterDirection.Input); paramArray[4] = Utilities.GetOraParam(":P_PURPOSE", objVenueBok.Purpose, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[5] = Utilities.GetOraParam(":P_BOOKING_DATE", objVenueBok.BookingDate, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[6] = Utilities.GetOraParam(":P_START_TIME", objVenueBok.StartTime, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[7] = Utilities.GetOraParam(":P_END_TIME", objVenueBok.EndTime, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[8] = Utilities.GetOraParam(":P_ACTIVE", objVenueBok.Active, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[9] = Utilities.GetOraParam(":P_ENTRY_BY", objVenueBok.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[10] = Utilities.GetOraParam(":P_ENTRY_ON", objVenueBok.EntryOn, OracleDbType.Date, ParameterDirection.Input); SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray); objVenueBok.BookingID = int.Parse(paramArray[2].Value.ToString()); if (countBookedResources > 0) { DLLMeetingVenueResources.SaveBookedResources(objVenueBok, Tran); } Tran.Commit(); return(objVenueBok.BookingID); //return true; } catch (Exception ex) { Tran.Rollback(); throw (ex); } finally { GetConn.CloseDbConn(); } }
public static bool DeleteMeetingVenueBooking(int bookingID) { GetConnection GetConn = new GetConnection(); OracleConnection DBConn = GetConn.GetDbConn(Module.OAS); OracleTransaction Tran = DBConn.BeginTransaction(); try { string sp = "SP_DEL_MEETING_VENUE_BOOKING"; List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam(":bookingID", bookingID, OracleDbType.Int32, ParameterDirection.Input)); if (DLLMeetingVenueResources.DeleteBookedResources(bookingID, Tran)) { SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, sp, paramArray.ToArray()); } Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw (ex); } finally { GetConn.CloseDbConn(); } }