/// <summary> /// Initializes a new instance of the <see cref="SqliteBookingCrud"/> class. /// </summary> /// <param name="connection">The connection.</param> /// <param name="roomCrud">The room crud.</param> /// <param name="customerCrud">The customer crud.</param> /// <param name="employeeCrud">The employee crud.</param> public SqliteBookingCrud(DatabaseConnection connection, RoomCrud roomCrud, CustomerCrud customerCrud, EmployeeCrud employeeCrud) { this.DBConnection = connection; RoomCrud = roomCrud; CustomerCrud = customerCrud; EmployeeCrud = employeeCrud; }
public CreateEdit(string createEdit, ObservableCollection<Booking> bookings, Booking booking = null) { InitializeComponent(); string filePath = Properties.Settings.Default.Postgaarden; var sqliteInstance = SqliteDatabaseConnection.GetInstance(filePath); empCrud = new SqliteEmployeeCrud(sqliteInstance); cusCrud = new SqliteCustomerCrud(sqliteInstance); equiCrud = new SqliteEquipmentCrud(sqliteInstance); roomCrud = new SqliteRoomCrud(sqliteInstance, equiCrud); bookingCrud = new SqliteBookingCrud(sqliteInstance, roomCrud, cusCrud, empCrud); this.createEdit = createEdit; Bookings = bookings; if (booking != null) Booking = booking; }
static void Main(string[] args) { CustomerOptions custOpt = new CustomerOptions { FirstName = "Mema", LastName = "Stamataki", Address = "Kallithea", VatNumber = "123456789", Email = "*****@*****.**", Phone = "6951915214", Dob = new DateTime(1993, 7, 6), }; CustomerCrud custCrud = new CustomerCrud(); Customer customer = custCrud.CreateCustomer(custOpt); Console.WriteLine($"Id = { customer.Id}" + $"FirstName = { customer.FirstName}"); Customer toFind = custCrud.GetCustomerById(1); Console.WriteLine($"Id = { toFind.Id}" + $"FirstName = { toFind.FirstName}"); }
static void Main(string[] args) { CustomerOptions custOpt = new CustomerOptions { FirstName = "Dimitris", LastName = "Dimitriou", Address = "Athens", VatNumber = "012345678", Email = "*****@*****.**", Phone = "210-74 000 111", Dob = new DateTime(1970, 12, 31), }; CustomerCrud custCrud = new CustomerCrud(); Customer customer = custCrud.CreateCustomer(custOpt); //Console.WriteLine("Id = " // + customer.Id // + " FirstName= " // + customer.FirstName); Console.WriteLine($"Id = {customer.Id} " + $"FirstName= {customer.FirstName}"); Customer toFind = custCrud.GetCustomerById(1); Console.WriteLine($"Id = {toFind.Id} " + $"FirstName= {toFind.FirstName}"); toFind = custCrud.GetCustomerById(100); if (toFind != null) { Console.WriteLine($"Id = {toFind.Id} " + $"FirstName= {toFind.FirstName}"); } }