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