public static List <SinglePayment> ConvertToSinglePayment(List <List <string> > table) { List <SinglePayment> Allpayments = new List <SinglePayment>(); foreach (List <string> row in table) { string tmp_name = row[1]; double tmp_price = Double.Parse(row[2]); double tmp_quantity = Double.Parse(row[3]); SinglePayment tmp_payment = new SinglePayment(tmp_name, tmp_price, tmp_quantity); Allpayments.Add(tmp_payment); } return(Allpayments); }
public static void InsertSinglePayment(SinglePayment singlePayment) { using (SQLiteConnection connection = new SQLiteConnection(LoadConnectionString())) { connection.Open(); using (SQLiteCommand command = connection.CreateCommand()) { command.CommandType = CommandType.Text; command.CommandText = "INSERT INTO SinglePayment (Name, Price, Quantity) VALUES (@p1, @p2, @p3)"; command.Parameters.Add(new SQLiteParameter("@p1", singlePayment.Title)); command.Parameters.Add(new SQLiteParameter("@p2", singlePayment.Price)); command.Parameters.Add(new SQLiteParameter("@p3", singlePayment.Quantity)); } connection.Close(); } }
static void Main(string[] args) { Console.WriteLine("-----------------HOTEL--------------------------------"); Hotel hotel = new Hotel("NAJLEPSZY HOTEL NA ŚWIACIE"); Employee employee = hotel.CreateEmplyee("Karolina", "Grzanka", "879-987-987", Sex.Woman, "Administrator"); Room room01 = hotel.CreateRoom(01, 0, 1, false, employee); Room room02 = hotel.CreateRoom(02, 1, 1, false, employee); SinglePayment singlePayment = new SinglePayment("Kawa late", 10.50, 2); Client client1 = hotel.CreateClient("Jan", "Główka", "765-234-567", Sex.Man, "*****@*****.**", "RSE 654332", employee); Client client2 = hotel.CreateClient("Zosia", "Samosia", "546-653-765", Sex.Woman, "*****@*****.**", "RES 645378", employee); hotel.CreateReservation("Reservation room 1 28/09/2019 - 30/09/2019", client1, "2019/09/28", "2019/09/30", 2, 0, 0, employee, room01); hotel.AddSinglePayment(client1, singlePayment); Console.WriteLine(hotel); Console.WriteLine("-----------------ACCOUNTS--------------------------------"); foreach (Account account in hotel.Accounts) { Console.WriteLine(account.ToString()); Console.WriteLine("Debet: "); Console.WriteLine(account.AccountDebt()); } Console.WriteLine("-----------------SERIALIZACJA--------------------------------"); Hotel.SaveXML("hotel.xml", hotel); Console.WriteLine("Odczyt XML"); Hotel hotel2 = Hotel.ReadXML("hotel.xml"); Console.WriteLine(hotel2); /* SQL test */ Console.WriteLine("-----------------TEST SQL--------------------------------"); Console.WriteLine("\nWpisywanie do bazy"); Employee employee_test = new Employee("Szymon", "Bednarek", "222-333-222", Sex.Man, "Szef"); Sql.InsertEmployee(employee_test); Console.WriteLine("Wpisano nowego pracownika"); Console.WriteLine("\nAll Employees:"); List <List <string> > querry_output = Sql.ExecuteSelectQuerry("SELECT * FROM Employees"); List <Employee> AllEmployees = Sql.ConvertToEmployee(querry_output); foreach (Employee employee1 in AllEmployees) { Console.WriteLine(employee1.ToString()); } Console.WriteLine("\nAll Clients:"); List <List <string> > querry_output2 = Sql.ExecuteSelectQuerry("SELECT * FROM Clients"); List <Client> AllClients = Sql.ConvertToClient(querry_output2); foreach (Client client in AllClients) { Console.WriteLine(client.ToString()); } Console.WriteLine("\nAll Rooms:"); List <List <string> > querry_output3 = Sql.ExecuteSelectQuerry("SELECT * FROM Rooms"); List <Room> AllRooms = Sql.ConvertToRoom(querry_output3); foreach (Room room in AllRooms) { Console.WriteLine(room.ToString()); } Console.WriteLine("\nAll single payments:"); List <List <string> > querry_output4 = Sql.ExecuteSelectQuerry("SELECT * FROM SinglePayment"); List <SinglePayment> AllSinglePayments = Sql.ConvertToSinglePayment(querry_output4); foreach (SinglePayment single_payment in AllSinglePayments) { Console.WriteLine(single_payment.ToString()); } Console.ReadLine(); }