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";
            }
        }
Beispiel #2
0
        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;
        }