Example #1
0
        /// <summary>
        /// Called with 'CANCEL a reservation'
        /// </summary>
        /// <returns></returns>
        public ActionResult Cancel(BookingCancellation bookingCancellationDetails)
        {
            //var bookingCancellationDetails = new Models.BookingCancellation { BookingId = "A1234", ReservationId = "B1234" };
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["defaultConnection"].ConnectionString);
            SqlCommand    cmd  = new SqlCommand("sp_cancel_room", conn);

            cmd.CommandType = System.Data.CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@ReservationNumber", bookingCancellationDetails.ReservationId);
            cmd.Parameters.AddWithValue("@CancellationRemarks", string.Empty);
            SqlParameter param = new SqlParameter("@RtnValue", SqlDbType.Int);

            param.Direction = ParameterDirection.ReturnValue;
            cmd.Parameters.Add(param);
            conn.Open();
            cmd.ExecuteScalar();
            conn.Close();

            if ((int)cmd.Parameters["@RtnValue"].Value != 0)
            {
                return(null);
            }


            return(View(bookingCancellationDetails));
        }
Example #2
0
        private void BOOKINGCANCELLATIONToolStripMenuItem_Click_1(System.Object sender, System.EventArgs e)
        {
            Master.Completed();
            BookingCancellation b1 = new BookingCancellation();

            b1.MdiParent = this;
            b1.Show();
            b1.BringToFront();
        }