public static int DeleteReservation(Reservation myReservation)
        {
            SqlConnection conn = new SqlConnection(getConnectionString());
            SqlCommand cmd = conn.CreateCommand();

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "DeleteReservation";

            cmd.Parameters.AddWithValue("ReservationID", myReservation._ReservationID);

            conn.Open();
            int delete = cmd.ExecuteNonQuery();
            try
            {
                //conn.Open();
            }
            catch (SqlException myEx)
            {
                if (conn.State != ConnectionState.Closed)
                {
                    conn.Close();
                }
            }
            finally
            {
            }
            conn.Close();
            return delete;
        }
        public static List<Reservation> getAllReservations()
        {
            List<Reservation> Reservations = new List<Reservation>();
            SqlConnection conn = new SqlConnection(getConnectionString());
            SqlCommand cmd = conn.CreateCommand();

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "GetAllReservations";

            try
            {
                conn.Open();
                SqlDataReader dr = cmd.ExecuteReader();

                while (dr.Read())
                {
                    Reservation myReservation = new Reservation();
                    myReservation._ReservationID = (int)dr["ReservationID"];
                    myReservation._MemberID = (int)dr["MemberID"];
                    myReservation._ReservationInfo = (string)dr["Reservation Details"];
                    myReservation._ReservationDate = (datetime)dr["Reservation Date"];
                    Reservations.Add(myReservation);

                }
                conn.Close();
            }
            catch (SqlException myEx)
            {
                if (conn.State != ConnectionState.Closed)
                {
                    conn.Close();
                }
            }
            finally
            {
            }
            return Reservations;
        }
        public static int UpdateReservation(Reservation original_myReservation, Reservation myReservation)
        {
            SqlConnection conn = new SqlConnection(getConnectionString());
            SqlCommand cmd = conn.CreateCommand();

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "UpdateReservation";

            cmd.Parameters.AddWithValue("original_ReservationID", original_myReservation._ReservationID);
            cmd.Parameters.AddWithValue("MemberID", myReservation._MemberID);
            cmd.Parameters.AddWithValue("Reservation Details", myReservation._ReservationInfo);
            cmd.Parameters.AddWithValue("Date of Reservation", myReservation._ReservationDate);

            int i = -1;

            try
            {
                conn.Open();
                i = cmd.ExecuteNonQuery();
                conn.Close();
            }
            catch (SqlException myEx)
            {
                if (conn.State != ConnectionState.Closed)
                {
                    conn.Close();
                }
            }
            finally
            {

            }
            return i;
        }
        public static int InsertReservation(Reservation myReservation)
        {
            SqlConnection conn = new SqlConnection(getConnectionString());
            SqlCommand cmd = conn.CreateCommand();

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "InsertReservation";

            cmd.Parameters.AddWithValue("@_ReservationID", myReservation._ReservationID);
            cmd.Parameters.AddWithValue("@_MemberID", myReservation._MemberID);
            cmd.Parameters.AddWithValue("@_ReservationInfo", myReservation._ReservationInfo);
            cmd.Parameters.AddWithValue("@_ReservationDate", myReservation._ReservationDate);

            try
            {
                conn.Open();
            }
            catch (SqlException myEx)
            {
                if (conn.State != ConnectionState.Closed)
                {
                    conn.Close();
                }
            }
            finally
            {
            }
            int i = cmd.ExecuteNonQuery();
            conn.Close();
            return i;
        }