Exemple #1
0
        public bool UpdateTourBooking(string BookingID, string CustomerID, string BookingDate, string BookingType, string Tour)
        {
            SqlConnection myconn = GetSqlConnection();
            int           update;
            bool          flag = false;

            //update statment
            string sql = "Update Booking set CustomerID=@CustomerID,Date=@date,type=@type,Package=@Package,Hotel=@hotel,Room=@room,HotelNight=@night where ID=@ID";
            //Using Booking Class
            tourBooking tr = new tourBooking(CustomerID, BookingDate, BookingType, Tour);

            //define sql command and parameters

            SqlCommand cmd = new SqlCommand(sql, myconn);

            cmd.Parameters.AddWithValue("@ID", BookingID);
            cmd.Parameters.AddWithValue("@CustomerID", tr.GetCustomerID);
            cmd.Parameters.AddWithValue("@date", tr.GetDate);
            cmd.Parameters.AddWithValue("@type", tr.GetBookingType);
            cmd.Parameters.AddWithValue("@Package", tr.GetTour);
            cmd.Parameters.AddWithValue("@hotel", DBNull.Value);
            cmd.Parameters.AddWithValue("@room", DBNull.Value);
            cmd.Parameters.AddWithValue("@night", DBNull.Value);

            try
            {
                myconn.Open();                  //opens the connection
                update = cmd.ExecuteNonQuery(); //executes the sql command
                if (update >= 1)
                {
                    flag = true;
                }
                else
                {
                    flag = false;
                }
            }
            catch (SqlException ex)
            {//display on the console the exeception message
                Console.WriteLine(ex.ToString());
                Console.ReadLine();
            }
            finally
            {// Close the connection
                myconn.Close();
            }
            if (flag == true)
            { // Counting the deposit, amount and update the record in the database
                sql = "update Booking set Charge=0, Discount=0, Deposit=(select (cost *(0.2)) from Booking b, Package p where p.Package=b.Package and b.ID=@ID),Total=(select cost from Booking b, Package p where p.Package=b.Package and b.ID=@ID) where ID=@ID";
                SqlCommand cmn = new SqlCommand(sql, myconn);
                cmn.Parameters.AddWithValue("@ID", BookingID);
                try
                {
                    myconn.Open();                  //opens the connection
                    update = cmn.ExecuteNonQuery(); //executes the sql command
                    if (update >= 1)
                    {
                        flag = true;
                    }
                    else
                    {
                        flag = false;
                    }
                }
                catch (SqlException ex)
                {//display on the console the exeception message
                    Console.WriteLine(ex.ToString());
                    Console.ReadLine();
                }
                finally
                {// Close the connection
                    myconn.Close();
                }
            }

            return(flag);
        }
Exemple #2
0
        public bool TourBooking(string ID, string BookingDate, string BookingType, string Tour)
        {
            SqlConnection myconn = GetSqlConnection();
            int           add;
            bool          flag = false;
            string        sql  = "Insert into Booking (CustomerID, Date, Type, Package, Hotel, Room) values (@ID,@BookingDate,@BookingType,@Tour,@Hotel,@Room)";

            //Using Booking Class
            tourBooking tr = new tourBooking(ID, BookingDate, BookingType, Tour);

            //define sql command and parameters

            SqlCommand cmd = new SqlCommand(sql, myconn);

            cmd.Parameters.AddWithValue("@ID", tr.GetCustomerID);
            cmd.Parameters.AddWithValue("@BookingType", tr.GetBookingType);
            cmd.Parameters.AddWithValue("@Tour", tr.GetTour);
            cmd.Parameters.AddWithValue("@BookingDate", tr.GetDate);
            cmd.Parameters.AddWithValue("@Hotel", DBNull.Value);
            cmd.Parameters.AddWithValue("@Room", DBNull.Value);
            try
            {
                myconn.Open();               //opens the connection
                add = cmd.ExecuteNonQuery(); //executes the sql command
                if (add >= 1)
                {
                    flag = true;
                }
                else
                {
                    flag = false;
                }
            }
            catch (SqlException ex)
            {//display on the console the exeception message
                Console.WriteLine(ex.ToString());
                Console.ReadLine();
            }
            finally
            {// Close the connection
                myconn.Close();
            }

            if (flag == true)
            { // Count the totalamount of the booking
                sql = "update Booking set Deposit=(select (cost *(0.2)) from Booking b, Package p where p.Package=b.Package and b.ID=(select MAX(ID) from Booking)),Total=(select cost from Booking b, Package p where p.Package=b.Package and b.ID=(select MAX(ID) from Booking)) where ID=(select MAX(ID) from Booking)";
                SqlCommand cmn = new SqlCommand(sql, myconn);
                try
                {
                    myconn.Open();               //opens the connection
                    add = cmn.ExecuteNonQuery(); //executes the sql command
                    if (add >= 1)
                    {
                        flag = true;
                    }
                    else
                    {
                        flag = false;
                    }
                }
                catch (SqlException ex)
                {//display on the console the exeception message
                    Console.WriteLine(ex.ToString());
                    Console.ReadLine();
                }
                finally
                {// Close the connection
                    myconn.Close();
                }
            }

            return(flag);
        }