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