Beispiel #1
0
        public void insert_Bill(string bill_ID, string room_ID, string customer_ID, string month, double service_money)
        {
            string sql = " insert into bill values('" + bill_ID + "','" + room_ID + "','" + customer_ID + "','" + month + "'," + service_money + ")";

            da.ExcuteNonQuery(sql);
        }
        public void insert_Room(string room_ID, string type_room, int number_floor, double price, string status_room, int number_person)
        {
            string sql = " insert into Room values('" + room_ID + "','" + type_room + "'," + number_floor + "," + price + ",'" + status_room + "'," + number_person + ")";

            da.ExcuteNonQuery(sql);
        }