public addFeedback(Accomodation currentAccomondation, Customer currentCust) { // TODO: Complete member initialization InitializeComponent(); CurrentFacility = null; CurrentAccomondation = currentAccomondation; rtb_feedback.Text = CurrentAccomondation.Feedback; CurrentCustomer = currentCust; Db = new Database(); }
public Details(Customer c, Accomodation a, DateTime start, DateTime end, string roomID) { InitializeComponent(); CurrentCustomer = c; CurrentAccomodation = a; StartD = start; EndD = end; RoomID = roomID; Database = new Database(); populateDetails(); }
public Bookings(Customer c, Accomodation a, int book_id, int acc_id, int room_id, int room_number, string start_date, string end_date) { C = c; A = a; Book_id = book_id; Acc_id = acc_id; Room_id = room_id; Room_number = room_number; Start_date = start_date; End_date = end_date; }
public accomodationInfo(Customer c, Accomodation a) { InitializeComponent(); CurrentCustomer = c; CurrentAccomondation = a; CurrentFacility = null; db = new Database(); try { CurrentAccomondation = db.searchAccomodation(CurrentAccomondation.ID); } catch (Exception e) { Console.WriteLine(e.ToString()); } showAccommodationData(); }
public bookingDetails(Accomodation a, Customer c) { InitializeComponent(); startDateRoom = new List<DateTime>(); endDateRoom = new List<DateTime>(); roomId = new List<int>(); rooms = new Dictionary<int, int>(); CurrentCustomer = c; CurrentAccomodation = a; accommodation_id = a.ID; user_id = c.Custi_id; Database = new Database(); dgv_bookings.ColumnCount = 2; dgv_bookings.Columns[0].Name = "Room ID"; dgv_bookings.Columns[1].Name = "Room Number"; dgv_bookings.Columns[0].Width = dgv_bookings.Width / 2 - 22; dgv_bookings.Columns[1].Width = dgv_bookings.Width / 2 - 21; l_hotelName_bd.Text = Database.getHotelNameDb(accommodation_id); dbDateCheck(); }
public void updateAccFeedback(Accomodation a, Customer c) { try { SQLiteConnection connection = new SQLiteConnection("Data Source=tourismus.db"); connection.Open(); SQLiteCommand command = new SQLiteCommand(connection); string myEditQuery = "UPDATE accommodations SET acco_feedback='" + a.Feedback + "' WHERE acc_id=" + a.ID; command.CommandText = myEditQuery; command.ExecuteNonQuery(); connection.Close(); // 1 = Account created + // 2 = Account updated + // 3 = Account deleted + // 4 = Aquired accommodation information // 5 = Aquired facility information + // 6 = Booked an accommodation + // 7 = Deleted a booking + // 8 = Gave feedback about accommodation + // 9 = Gave feedback about facility + // 10 = Start of session // 11 = End of session //log(string custname, int custId, int action) logger.log(c.Custi_id, 8); } catch (Exception et) { Console.WriteLine(et.ToString()); } }
public Accomodation searchAccomodation(string acc_id) { try { string accommodation_id = acc_id; Accomodation ac = null; SQLiteConnection connection = new SQLiteConnection("Data Source=tourismus.db"); connection.Open(); SQLiteCommand cmd = new SQLiteCommand("select * from accommodations where acc_id = " + accommodation_id, connection); SQLiteDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { string name = reader.GetString(reader.GetOrdinal("acc_name")); string adress_city = reader.GetString(reader.GetOrdinal("acc_adress_city")); string adress_county = reader.GetString(reader.GetOrdinal("acc_adress_county")); string adress_postcode = reader.GetString(reader.GetOrdinal("acc_adress_postcode")); string adress_street = reader.GetString(reader.GetOrdinal("acc_adress_street")); string adress_number = reader.GetString(reader.GetOrdinal("acc_adress_number")); string description = reader.GetString(reader.GetOrdinal("acc_description")); string picture_url = reader.GetString(reader.GetOrdinal("acc_picture_url")); string feedback = reader.GetString(reader.GetOrdinal("acco_feedback")); ac = new Accomodation(""+acc_id,name, adress_city, adress_county, adress_postcode, adress_street, adress_number, description,picture_url, feedback); } } connection.Close(); return ac; } catch (Exception et) { Console.WriteLine(et.ToString()); } return null; }
//returning all accommodations in a list public List<Accomodation> getAllAccommodations() { List<Accomodation> allAccommodationList = new List<Accomodation>(); try { SQLiteConnection connection = new SQLiteConnection("Data Source=tourismus.db"); connection.Open(); Accomodation ac = null; SQLiteCommand cmd = new SQLiteCommand("select * from accommodations", connection); SQLiteDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { int acc_id = reader.GetInt32(reader.GetOrdinal("acc_id")); string name = reader.GetString(reader.GetOrdinal("acc_name")); string adress_city = reader.GetString(reader.GetOrdinal("acc_adress_city")); string adress_county = reader.GetString(reader.GetOrdinal("acc_adress_county")); string adress_postcode = reader.GetString(reader.GetOrdinal("acc_adress_postcode")); string adress_street = reader.GetString(reader.GetOrdinal("acc_adress_street")); string adress_number = reader.GetString(reader.GetOrdinal("acc_adress_number")); string description = reader.GetString(reader.GetOrdinal("acc_description")); string picture_url = reader.GetString(reader.GetOrdinal("acc_picture_url")); string feedback = reader.GetString(reader.GetOrdinal("acco_feedback")); ac = new Accomodation("" + acc_id, name, adress_city, adress_county, adress_postcode, adress_street, adress_number, description, picture_url,feedback); allAccommodationList.Add(ac); } } connection.Close(); } catch (Exception e) { System.Console.WriteLine(e.ToString()); } return allAccommodationList; }