/// <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}");
}
}
