public string MakeBooking(string VenueName, string EventDate, string Cost)
{
PartyDAL agent = new PartyDAL();
var venueid = agent.FindVenueId(VenueName);
PartyBooking booking = new PartyBooking();
booking.EmployeeID = Convert.ToInt32(Session["UserID"].ToString());
booking.VenueID = Convert.ToInt32(venueid);
booking.EventDate = Convert.ToDateTime(EventDate);
booking.Cost = Convert.ToDouble(Cost);
bool res = agent.MakeBooking(booking);
if (res)
{
return "DONE";
}
else
{
return "ERROR";
}
}
public bool MakeBooking(PartyBooking booking)
{
try
{
ConnectionStr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
Debug.WriteLine("Connection String = " + ConnectionStr);
conn = new SqlConnection(ConnectionStr);
conn.Open();
}
catch (Exception e)
{
Debug.WriteLine("SQL Server connection failed " + e.Message);
return false;
}
bool bookingStatus = false;
try
{
cmd = new SqlCommand("SELECT COUNT(*) FROM PartyBookingDB WHERE VenueID = @venueid AND BookingDate = @bookingdate", conn);
cmd.Parameters.AddWithValue("venueid", booking.VenueID);
cmd.Parameters.AddWithValue("bookingdate", DateTime.Now);
if (Convert.ToInt32(cmd.ExecuteScalar()) == 0)
{
cmd = new SqlCommand("INSERT INTO PartyBookingDB([EmployeeID], [VenueID], [BookingDate], [EventDate], [Cost]) VALUES (@employeeid, @venueid, @bookingdate, @eventdate, @cost)", conn);
cmd.Parameters.AddWithValue("employeeid", booking.EmployeeID);
cmd.Parameters.AddWithValue("venueid", booking.VenueID);
cmd.Parameters.AddWithValue("bookingdate", DateTime.Now);
cmd.Parameters.AddWithValue("eventdate", booking.EventDate);
cmd.Parameters.AddWithValue("cost", booking.Cost);
if (cmd.ExecuteNonQuery().Equals(1))
{
bookingStatus = true;
}
}
else
{
bookingStatus = false;
}
}
catch (SqlException err)
{
Debug.WriteLine("SQL Server connection failed " + err.Message);
}
catch (InvalidOperationException err)
{
Debug.WriteLine("SQL Server connection failed " + err.Message);
}
catch (Exception err)
{
Debug.WriteLine("ERROR: " + err.Message);
}
conn.Close();
return bookingStatus;
}