コード例 #1
0
        public string addHotel(TableTypes.Hotel hotel)
        {
            string log = "";

            //add Hotel to Hotel table
            AdminHotelListManipulationClass.hotelInstance = hotel;
            log += AddHotelToSqlTables(hotel);
            return(log);
        }
コード例 #2
0
        private void Button_Add_Hotel_Click(object sender, EventArgs e)
        {
            TableTypes.Hotel hotel = new TableTypes.Hotel();
            hotel.Addr      = Hotel_Address.Text;
            hotel.City      = Hotel_City.Text;
            hotel.Hotel_Id  = Int32.Parse(Hotel_id.Text);
            hotel.Phone_Num = Int32.Parse(Hotel_Phone_Num.Text);
            hotel.Name      = Hotel_Name.Text;
            AdminHotelListManipulationClass HMInstance = new AdminHotelListManipulationClass();
            string log = HMInstance.addHotel(hotel);

            MessageBox.Show(log);
        }
コード例 #3
0
        private string constructQuery(object queryObject)
        {
            if (queryObject is TableTypes.Hotel)
            {
                TableTypes.Hotel hotel = (TableTypes.Hotel)queryObject;
                return("insert into Hotel(Hotel_Id, HotelName, Addrs, City, Phone_no)" +
                       "values('" + hotelInstance.Hotel_Id + "', '" + hotelInstance.Name + "', '"
                       + hotelInstance.Addr + "', '" + hotelInstance.Addr + "'," + hotelInstance.Phone_Num + ");");
            }

            if (queryObject is UserTypes.Employee)
            {
                UserTypes.Employee employee = (UserTypes.Employee)queryObject;
                return("insert into Employee( Staff_Id,First_name , Last_name , DOB , Addrs , Phone_no , Email , Pass , Hotel_Id )" +
                       "values('" + employee.Staff_Id + "','" + employee.First_Name + "', '" + employee.Last_name + "', '" + employee.Date_Of_Birth + "', '" + employee.Addr + "', '" + employee.Phone_Num + "', '" + employee.Email + "', '" + employee.Pass + "'," + hotelInstance.Hotel_Id + ")");
            }
            if (queryObject is TableTypes.Room)
            {
                TableTypes.Room room = (TableTypes.Room)queryObject;
                return("insert into Room (Room_Id  ,Hotel_ID ,Room_Type ,Room_Description)"
                       + "values(" + room.Room_Id + "," + hotelInstance.Hotel_Id + ", '" + room.Room_Type + "', '" + room.Room_Description + "')");
            }
            return("");
        }