//
// GET: /EventBooking/Create
public ActionResult Create()
{
EventBookingViewModel modelObj = new EventBookingViewModel();
EventType typ = new EventType(0, "Please Select", "");
modelObj.EventType = eventBookingMnger.GetEventTypeList();
modelObj.EventType.Insert(0, typ);
modelObj.EventID = 0;
Venue ven = new Venue(0, "Please Select");
modelObj.Venue = eventBookingMnger.GetVenueList();
modelObj.Venue.Insert(0, ven);
modelObj.VenueID = 0;
Caterers cat = new Caterers(0, "Please Select");
modelObj.Caterer = eventBookingMnger.GetCaterersList();
modelObj.Caterer.Insert(0, cat);
modelObj.CatererID = 0;
Customer cust = new Customer();
cust.CustomerID = 0;
cust.FirstName = "Please Select";
modelObj.Customer = customerManager.GetCustomerList();
modelObj.Customer.Insert(0, cust);
modelObj.CustomerID = 0;
return(View(modelObj));
}
public ActionResult Create(EventBookingViewModel eventBookings)
{
if (ModelState.IsValid)
{
if (eventBookings.EventID != 0 && eventBookings.VenueID != 0 && eventBookings.CatererID != 0 && eventBookings.CustomerID != 0)
{
if (eventBookings.StartTime < eventBookings.EndTime)
{
if (eventBookingMnger.InsertNewEventBooking(eventBookings.EventID, eventBookings.StartTime, eventBookings.EndTime, eventBookings.EventDate, eventBookings.VenueID, eventBookings.CustomerID, eventBookings.CatererID, 1000))
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Error"));
}
}
else
{
ModelState.AddModelError("", "Event start time should be less than event end time.");
}
}
else
{
ModelState.AddModelError("", "Please enter values for required fields.");
}
}
else
{
ModelState.AddModelError("", "Error Occured.");
}
EventBookingViewModel modelObj = new EventBookingViewModel();
EventType typ = new EventType(0, "Please Select", "");
modelObj.EventType = eventBookingMnger.GetEventTypeList();
modelObj.EventType.Insert(0, typ);
modelObj.EventID = 0;
Venue ven = new Venue(0, "Please Select");
modelObj.Venue = eventBookingMnger.GetVenueList();
modelObj.Venue.Insert(0, ven);
modelObj.VenueID = 0;
Caterers cat = new Caterers(0, "Please Select");
modelObj.Caterer = eventBookingMnger.GetCaterersList();
modelObj.Caterer.Insert(0, cat);
modelObj.CatererID = 0;
Customer cust = new Customer();
cust.CustomerID = 0;
cust.FirstName = "Please Select";
modelObj.Customer = customerManager.GetCustomerList();
modelObj.Customer.Insert(0, cust);
modelObj.CustomerID = 0;
return(View(modelObj));
}
/// <summary>
/// Fetches the caterers list.
/// </summary>
/// <returns>List;Caterers;.</returns>
public static List <Caterers> FetchCaterersList()
{
// create a list to hold the returned data
var caterersList = new List <Caterers>();
// get a connection to the database
var conn = DBConnection.GetDBConnection();
//query to select
string query = @"SELECT CatererID, CatererName " +
@"FROM Caterers ";
//ommand object
var cmd = new SqlCommand(query, conn);
// 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())
{
Caterers caterers = new Caterers()
{
CatererID = reader.GetInt32(0),
CatererName = reader.GetString(1)
};
caterersList.Add(caterers);
}
}
}
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(caterersList);
}
/// <summary>
/// Fetches the caterers by identifier.
/// </summary>
/// <param name="caterersID">The caterers identifier.</param>
/// <returns>Caterers.</returns>
public static Caterers FetchCaterersByID(int caterersID)
{
Caterers caterers = new Caterers();
// get a connection to the database
var conn = DBConnection.GetDBConnection();
//query to select
string query = @"SELECT CatererID, CatererName " +
@"FROM Caterers Where CatererID = @CatererID";
//ommand object
var cmd = new SqlCommand(query, conn);
cmd.Parameters.Add(new SqlParameter("CatererID", SqlDbType.Int)).Value = caterersID;
// 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())
{
caterers = new Caterers()
{
CatererID = caterersID,
CatererName = reader.GetString(0)
};
}
}
}
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(caterers);
}
/// <summary>
/// Fetches the event bookings list.
/// </summary>
/// <returns>List of EventBookings;.</returns>
public static List <EventBookings> FetchEventBookingsList()
{
// create a list to hold the returned data
var eventBookingsList = new List <EventBookings>();
// get a connection to the database
var conn = DBConnection.GetDBConnection();
// create a query to send through the connection
string query = "sp_EventBookingsGetAllDetails";
// 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())
{
EventType eventType = new EventType()
{
EventTypeID = reader.GetInt32(4),
EventTypeName = reader.GetString(5),
EventTypeDescription = reader.GetString(6)
};
Venue venue = new Venue()
{
VenueID = reader.GetInt32(7),
BuildingName = reader.GetString(8)
};
Customer customer = new Customer()
{
CustomerID = reader.GetInt32(9),
FirstName = reader.GetString(10),
LastName = reader.GetString(11)
};
Caterers caterer = new Caterers()
{
CatererID = reader.GetInt32(12),
CatererName = reader.GetString(13)
};
UserProfile user = new UserProfile()
{
UserID = reader.GetInt32(14),
UserName = reader.GetString(15),
};
EventBookings eventBooking = new EventBookings()
{
BookingID = (Int32)reader["BookingID"], //reader.GetInt32(0),
StartTime = (TimeSpan)reader["StartTime"], //reader.GetTimeSpan(1)
EndTime = (TimeSpan)reader["EndTime"], //reader.GetTimeSpan(2),
EventDate = (DateTime)reader["EventDate"], //reader.GetDateTime(3),
EventType = eventType,
Venue = venue,
Customer = customer,
Caterer = caterer,
UserProfile = user,
};
//BookingID,StartTime,EndTime,EventDate,
//EventTypeID,EventType,EventTypeDescription,
//VenueID,BuildingName,
//CustomerID,FirstName,LastName,
//CatererID,CatererName,
//UserID,UserName
eventBookingsList.Add(eventBooking);
}
}
}
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(eventBookingsList);
}
