public ActionResult Edit(EventBookingViewModel eventBookingViewModelObj) { try { EventBookingsO eventBookingObj = new EventBookingsO(); // TODO: Add update logic here eventBookingObj.BookingID = eventBookingViewModelObj.BookingID; eventBookingObj.CaterersID = eventBookingViewModelObj.CatererID; eventBookingObj.CustomerID = eventBookingViewModelObj.CustomerID; eventBookingObj.EventTypeID = eventBookingViewModelObj.EventID; eventBookingObj.VenueID = eventBookingViewModelObj.VenueID; eventBookingObj.StartTime = eventBookingViewModelObj.StartTime; eventBookingObj.EndTime = eventBookingViewModelObj.EndTime; eventBookingObj.EventDate = eventBookingViewModelObj.EventDate; eventBookingObj.UserProfileID = 1000; eventBookingMnger.UpdateEventBooking(eventBookingObj); return(RedirectToAction("Index")); } catch { return(View()); } }
/// <summary> /// Fills the entry form. /// </summary> /// <param name="eventBook">The event book.</param> private void FillEntryForm(EventBookingsO eventBook) { dpEventDate.Text = eventBook.EventDate.ToString(); txtStartTime.Text = eventBook.StartTime.ToString(); txtEndTime.Text = eventBook.EndTime.ToString(); cmbEventName.SelectedIndex = eventBook.EventTypeID; cmbVenue.SelectedIndex = eventBook.VenueID; cmbCustomer.SelectedIndex = eventBook.CustomerID; cmbCaterers.SelectedIndex = eventBook.CaterersID; }
/// <summary> /// Updates the event booking. /// </summary> /// <param name="eventBooking">The event booking.</param> /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns> public bool UpdateEventBooking(EventBookingsO eventBooking) { try { //CustomerAccessor.UpdateCustomer(customer) >= 1) if (EventBookingsAccessorO.UpdateEventBookings(eventBooking) >= 1) { return(true); } else { return(false); } } catch (Exception) { throw; } }
// // GET: /EventBooking/Details/5 public ActionResult Details(int id) { EventBookingsO eventBookingO = eventBookingMnger.GetEventBookingOnBookingId(id); EventBookingViewModel modelObj = new EventBookingViewModel(); modelObj.BookingID = id; modelObj.EventType = eventBookingMnger.GetEventTypeList(); modelObj.EventID = eventBookingO.EventTypeID; modelObj.StartTime = eventBookingO.StartTime; modelObj.EndTime = eventBookingO.EndTime; modelObj.EventDate = eventBookingO.EventDate; modelObj.Venue = eventBookingMnger.GetVenueList(); modelObj.VenueID = eventBookingO.VenueID; modelObj.Caterer = eventBookingMnger.GetCaterersList(); modelObj.CatererID = eventBookingO.CaterersID; modelObj.Customer = customerManager.GetCustomerList(); modelObj.CustomerID = eventBookingO.CustomerID; return(View(modelObj)); }
/// <summary> /// Inserts the new event booking. /// </summary> /// <param name="eventTypeID">The event type identifier.</param> /// <param name="startTime">The start time.</param> /// <param name="endTime">The end time.</param> /// <param name="eventDate">The event date.</param> /// <param name="venueID">The venue identifier.</param> /// <param name="customerID">The customer identifier.</param> /// <param name="catererID">The caterer identifier.</param> /// <param name="userID">The user identifier.</param> /// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns> public bool InsertNewEventBooking(int eventTypeID, TimeSpan startTime, TimeSpan endTime, DateTime eventDate, int venueID, int customerID, int catererID, int userID) { try { var eventBookingsO = new EventBookingsO() { BookingID = 0, EventTypeID = eventTypeID, VenueID = venueID, CustomerID = customerID, CaterersID = catererID, UserProfileID = userID, StartTime = startTime, EndTime = endTime, EventDate = eventDate }; if (EventBookingsAccessorO.InsertEventBookings(eventBookingsO) != 0) { return(true); } } catch (Exception) { throw; } return(false); }
/// <summary> /// Fetches the event bookings o list. /// </summary> /// <returns>List of EventBookingsO;.</returns> public static List <EventBookingsO> FetchEventBookingsOList() { // create a list to hold the returned data var eventBookingsOList = new List <EventBookingsO>(); // get a connection to the database var conn = DBConnection.GetDBConnection(); // create a query to send through the connection string query = "sp_EventBookingsGetAll"; // create a command object - SP var cmd = new SqlCommand(query, conn); cmd.CommandType = CommandType.StoredProcedure; // try-catch try { // open connection conn.Open(); // execute the command and return a data reader SqlDataReader reader = cmd.ExecuteReader(); // before trying to read the reader, be sure it has data if (reader.HasRows) { // now we just need a loop to process the reader while (reader.Read()) { EventBookingsO eventBookingO = new EventBookingsO() { BookingID = reader.GetInt32(0), EventTypeID = reader.GetInt32(1), StartTime = (TimeSpan)reader["StartTime"], //reader.GetTimeSpan(2) EndTime = (TimeSpan)reader["EndTime"], //reader.GetTimeSpan(3), EventDate = reader.GetDateTime(4), VenueID = reader.GetInt32(5), CustomerID = reader.GetInt32(6), CaterersID = reader.GetInt32(7), UserProfileID = reader.GetInt32(8), //BookingID, EventTypeID, StartTime, EndTime, EventDate, VenueID, CustomerID, CatererID, UserID }; eventBookingsOList.Add(eventBookingO); } } } catch (Exception) { // rethrow all Exceptions, let the logic layer sort them out throw; } finally { conn.Close(); } // this list may be empty, if so, the logic layer will need to deal with it return(eventBookingsOList); }
/// <summary> /// Fetch the event bookings. /// </summary> /// <param name="eventBooking">The event booking.</param> /// <returns>System.Int32.</returns> public static EventBookingsO FetchEventBookings(int bookingId) { EventBookingsO eventBookO = new EventBookingsO(); // begin with a connection var conn = DBConnection.GetDBConnection(); // get some commandText string cmdText = "sp_GetBookingDetails"; // create a command object var cmd = new SqlCommand(cmdText, conn); // here is where things change a bit // first, we need to set the command type cmd.CommandType = CommandType.StoredProcedure; // we need to construct and add the parameters cmd.Parameters.Add(new SqlParameter("BookingID", SqlDbType.Int)).Value = bookingId; // try-catch try { // open connection conn.Open(); // execute the command and return a data reader SqlDataReader reader = cmd.ExecuteReader(); // before trying to read the reader, be sure it has data if (reader.HasRows) { // now we just need a loop to process the reader while (reader.Read()) { eventBookO.BookingID = reader.GetInt32(0); eventBookO.EventTypeID = reader.GetInt32(1); eventBookO.StartTime = (TimeSpan)reader["StartTime"]; //reader.GetTimeSpan(2) eventBookO.EndTime = (TimeSpan)reader["EndTime"]; //reader.GetTimeSpan(3), eventBookO.EventDate = reader.GetDateTime(4); eventBookO.VenueID = reader.GetInt32(5); eventBookO.CustomerID = reader.GetInt32(6); eventBookO.CaterersID = reader.GetInt32(7); } } } catch (Exception) { // rethrow all Exceptions, let the logic layer sort them out throw; } finally { conn.Close(); } return(eventBookO); }
/// <summary> /// Updates the event bookings. /// </summary> /// <param name="eventBooking">The event booking.</param> /// <returns>System.Int32.</returns> public static int UpdateEventBookings(EventBookingsO eventBooking) { int rowCount = 0; // begin with a connection var conn = DBConnection.GetDBConnection(); // get some commandText string cmdText = "sp_EventBookingsUpdate"; // create a command object var cmd = new SqlCommand(cmdText, conn); // here is where things change a bit // first, we need to set the command type cmd.CommandType = CommandType.StoredProcedure; // we need to construct and add the parameters cmd.Parameters.Add(new SqlParameter("BookingID", SqlDbType.Int)).Value = eventBooking.BookingID; cmd.Parameters.Add(new SqlParameter("EventTypeID", SqlDbType.Int)).Value = eventBooking.EventTypeID; cmd.Parameters.Add(new SqlParameter("StartTime", SqlDbType.Time, 7)).Value = eventBooking.StartTime; cmd.Parameters.Add(new SqlParameter("EndTime", SqlDbType.Time, 7)).Value = eventBooking.EndTime; cmd.Parameters.Add(new SqlParameter("EventDate", SqlDbType.Date)).Value = eventBooking.EventDate; cmd.Parameters.Add(new SqlParameter("VenueID", SqlDbType.Int)).Value = eventBooking.VenueID; cmd.Parameters.Add(new SqlParameter("CustomerID", SqlDbType.Int)).Value = eventBooking.CustomerID; cmd.Parameters.Add(new SqlParameter("CatererID", SqlDbType.Int)).Value = eventBooking.CaterersID; cmd.Parameters.Add(new SqlParameter("UserID", SqlDbType.Int)).Value = eventBooking.UserProfileID; // output parameter var o = new SqlParameter("Rowcount", SqlDbType.Int); o.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(o); try { // open the connection conn.Open(); // execute the command rowCount = cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { conn.Close(); } return(rowCount); }
/// <summary> /// Handles the Click event of the btnSave control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param> private void btnSave_Click(object sender, RoutedEventArgs e) { try { DateTime eventDate = DateTime.Parse(dpEventDate.SelectedDate.ToString()); TimeSpan startTime = TimeSpan.Parse(txtStartTime.Text); TimeSpan endTime = TimeSpan.Parse(txtEndTime.Text); int eventTypeId = int.Parse(cmbEventName.SelectedValue.ToString()); int venueId = int.Parse(cmbVenue.SelectedValue.ToString()); int customerId = int.Parse(cmbCustomer.SelectedValue.ToString()); int catererId = int.Parse(cmbCaterers.SelectedValue.ToString()); int uID = 1001; if (!isEdit) { if ((eventDate.ToString() != string.Empty) && (startTime.ToString() != string.Empty) && (endTime.ToString() != string.Empty) && (eventTypeId.ToString() != string.Empty && venueId.ToString() != string.Empty && customerId.ToString() != string.Empty)) { if (eventBookingManager.InsertNewEventBooking(eventTypeId, startTime, endTime, eventDate, venueId, customerId, catererId, uID)) { MessageBox.Show("New event has been booked.", "New Record", MessageBoxButton.OK, MessageBoxImage.Information); DisplayEventBookingsData(); CleanEntryForm(); isEdit = false; btnSave.IsEnabled = false; btnCancel.IsEnabled = false; btnEdit.IsEnabled = true; // btnDelete.IsEnabled = true; grdEventEntryForm.IsEnabled = false; } } else { MessageBox.Show("Please enter all required fields", "New Record", MessageBoxButton.OK, MessageBoxImage.Information); } } if (isEdit) { if (grdEventBookingList.SelectedItem != null) { try { var selectedBooking = (EventBookings)grdEventBookingList.SelectedItem; MessageBoxResult _result = MessageBox.Show("Are you sure you want to update this booking record, Booking Id - " + selectedBooking.BookingID, "Edit Confirmation", MessageBoxButton.YesNo, MessageBoxImage.Question); if (_result == MessageBoxResult.Yes) { if ((eventDate.ToString() != string.Empty) && (startTime.ToString() != string.Empty) && (endTime.ToString() != string.Empty) && (eventTypeId.ToString() != string.Empty && venueId.ToString() != string.Empty && customerId.ToString() != string.Empty)) { EventBookingsO _editEvent = new EventBookingsO(); _editEvent.EventDate = eventDate; _editEvent.StartTime = startTime; _editEvent.EndTime = endTime; _editEvent.EventTypeID = eventTypeId; _editEvent.VenueID = venueId; _editEvent.CustomerID = customerId; _editEvent.CaterersID = catererId; _editEvent.BookingID = selectedBooking.BookingID; _editEvent.UserProfileID = uID; if (eventBookingManager.UpdateEventBooking(_editEvent)) { MessageBox.Show("Selected booking has been updated."); DisplayEventBookingsData(); CleanEntryForm(); isEdit = false; btnSave.IsEnabled = false; btnCancel.IsEnabled = false; btnEdit.IsEnabled = true; //btnDelete.IsEnabled = true; } } } } catch { MessageBox.Show("You must select a line in grid with customer in it."); } } } } catch (Exception ex) { throw ex; } }