public async void Edit()
{
TablePackagesController tpCtrl = new TablePackagesController();
VenuesController vCtrl = new VenuesController();
tablePackagesGUI = TablePackagesGUI.Instance;
try {
editedTablePackage = await tpCtrl.Get(tablePackagesGUI.idFromTable);
// Finding venue from venueID on table and adding it to combobox.
Venue venue = await vCtrl.Get(editedTablePackage.VenueId);
// Creating a list because combobox demands it.
var venuesList = new List <Venue>();
venuesList.Add(venue);
lblTitle.Text = "Edit Table Package";
create = false;
BtnSaveChanges.Text = "Save changes";
tbName.Text = editedTablePackage.Name;
tbPrice.Text = "" + editedTablePackage.Price;
cbVenue.DataSource = venuesList;
}
catch (Exception) {
MessageBox.Show("No connection to service");
this.Visible = false;
}
// Resetting idFromTable to remove possibility to show other employees tables
tablePackagesGUI.idFromTable = -1;
}
public int Add(TablePackage tablePackage)
{
const string INSERT_SQL = @"INSERT INTO TablePackages
(Name, Price, VenueId)
output INSERTED.ID
VALUES (@name, @price, @venueId);";
using (var conn = Database.Open()) {
int insertedId = (int)conn.ExecuteScalar(INSERT_SQL, tablePackage);
return(insertedId > 0 ? insertedId : 0);
}
}
public async Task <TablePackage> Get(int id)
{
List <TablePackage> TablePackageInfo = new List <TablePackage>();
TablePackage tablePackage = null;
bCtrl = new BaseController();
using (var client = bCtrl.GetClient()) {
HttpResponseMessage Res = await client.GetAsync("tablePackages/" + id);
if (Res.IsSuccessStatusCode)
{
var TablePackageResponse = Res.Content.ReadAsStringAsync().Result;
TablePackageInfo = JsonConvert.DeserializeObject <List <TablePackage> >(TablePackageResponse);
tablePackage = TablePackageInfo[0];
}
}
return(tablePackage);
}
private async void BtnSaveChanges_Click(object sender, EventArgs e)
{
TablePackagesController tpCtrl = new TablePackagesController();
DashboardGUI dGUI = DashboardGUI.Instance;
if (TextBoxesHasValues())
{
if (create)
{
try {
Venue currVenue = (Venue)cbVenue.SelectedItem;
TablePackage newTablePackage = new TablePackage {
Name = tbName.Text, Price = Int32.Parse(tbPrice.Text), VenueId = currVenue.Id
};
await tpCtrl.Create(newTablePackage);
this.Visible = false;
dGUI.AddTablePackageStats();
}
catch (Exception) {
MessageBox.Show("No connection to service");
}
}
else if (!create)
{
MessageBox.Show("Method not implemented");
this.Visible = false;
/*int id = editedTablePackage.Id;
* TablePackage updatedTablePackage = await tpCtrl.Get(editedTablePackage.Id);
* await tpCtrl.Update(updatedTablePackage.Id, updatedTablePackage);
* this.Visible = false;*/
}
else
{
MessageBox.Show("Error...One or more fields are empty!");;
}
}
}
public async Task <bool> Create(TablePackage tablePackage)
{
tablePackagesGUI = TablePackagesGUI.Instance;
bool res = false;
bCtrl = new BaseController();
var root = new {
TablePackage = tablePackage
};
var json = JsonConvert.SerializeObject(root);
var data = new StringContent(json, Encoding.UTF8, "application/json");
using (var client = bCtrl.GetClient()) {
var response = await client.PostAsync(bCtrl.BaseUrl + "tablePackages/", data);
string result = response.Content.ReadAsStringAsync().Result;
res = true;
}
tablePackagesGUI.AddDataToTable();
return(res);
}
static void Main(string[] args)
{
BeverageRepository _beverageRepository = new BeverageRepository();
CustomerRepository _customerRepository = new CustomerRepository();
EmployeeRepository _employeeRepository = new EmployeeRepository();
ReservationRepository _reservationRepository = new ReservationRepository();
TablePackageRepository _tablePackageRepository = new TablePackageRepository();
ReservationTablePackageRepository _reservationTablePackageRepository = new ReservationTablePackageRepository();
TableRepository _tableRepository = new TableRepository();
VenueHourRepository _venueHourRepository = new VenueHourRepository();
VenueEmployeeRepository _venueEmployeeRepository = new VenueEmployeeRepository();
VenueRepository _venueRepository = new VenueRepository();
Console.WriteLine("Seeding database ..");
_beverageRepository.Truncate();
_reservationTablePackageRepository.Truncate();
_reservationRepository.Truncate();
_tablePackageRepository.Truncate();
_tableRepository.Truncate();
_venueHourRepository.Truncate();
_venueEmployeeRepository.Truncate();
_venueRepository.Truncate();
_customerRepository.Truncate();
_employeeRepository.Truncate();
Console.WriteLine("Seeding venues ..");
Venue venue = new Venue {
Name = "Kongebaren",
Address = "Gammel Kongevej 1",
Zip = 9000,
City = "Aalborg"
};
venue.Id = _venueRepository.Add(venue);
Venue venue1 = new Venue {
Name = "Dronningenbaren",
Address = "Gammel Kongevej 2",
Zip = 9000,
City = "Aalborg"
};
venue1.Id = _venueRepository.Add(venue1);
Console.WriteLine("Seeding employees ..");
Employee employee0 = new Employee
{
Name = "Kongen Kongessen",
Phone = "+4598765432",
Email = "*****@*****.**",
Password = HashingHelper.GenerateHash("12345678"),
EmployeeNo = 1,
Title = "Kongen",
Salt = HashingHelper.RandomString(20)
};
Employee employee1 = new Employee
{
Name = "Dronningen Dronningensen",
Phone = "+4509876543",
Email = "*****@*****.**",
Password = HashingHelper.GenerateHash("12345678"),
EmployeeNo = 1,
Title = "Dronningen",
Salt = HashingHelper.RandomString(20),
};
Employee employee2 = new Employee {
Name = "Prins Prinsen",
Phone = "+4539847837",
Email = "*****@*****.**",
Password = HashingHelper.GenerateHash("12345678"),
EmployeeNo = 1,
Title = "Prinsen",
Salt = HashingHelper.RandomString(20),
};
employee0.Id = _employeeRepository.Add(employee0);
employee1.Id = _employeeRepository.Add(employee1);
employee2.Id = _employeeRepository.Add(employee2);
Console.WriteLine("Seeding venue employees ..");
_venueEmployeeRepository.Add(new VenueEmployee
{
VenueId = venue.Id,
EmployeeId = employee0.Id,
AccessLevel = 1
});
_venueEmployeeRepository.Add(new VenueEmployee
{
VenueId = venue1.Id,
EmployeeId = employee1.Id,
AccessLevel = 1
});
_venueEmployeeRepository.Add(new VenueEmployee {
VenueId = venue.Id,
EmployeeId = employee2.Id,
AccessLevel = 1
});
_venueEmployeeRepository.Add(new VenueEmployee {
VenueId = venue1.Id,
EmployeeId = employee2.Id,
AccessLevel = 1
});
Console.WriteLine("Seeding customers ..");
string salt = HashingHelper.RandomString(20);
Customer customer0 = new Customer {
Name = "Kunde Kundessen",
Phone = "+4512345678",
Email = "*****@*****.**",
Salt = salt,
Password = HashingHelper.GenerateHashWithSalt("12345678", salt),
CustomerNo = 1,
};
salt = HashingHelper.RandomString(20);
Customer customer1 = new Customer
{
Name = "Gæst Gæstessen",
Phone = "+4587654321",
Email = "*****@*****.**",
Salt = salt,
Password = HashingHelper.GenerateHashWithSalt("87654321", salt),
CustomerNo = 2
};
customer0.Id = _customerRepository.Add(customer0);
customer1.Id = _customerRepository.Add(customer1);
Console.WriteLine("Seeding tables ..");
Table table0 = new Table {
NoOfSeats = 4,
Name = "Vinderbordet",
VenueId = venue.Id,
};
Table table1 = new Table
{
NoOfSeats = 6,
Name = "Taberbordet",
VenueId = venue.Id
};
Table table2 = new Table {
NoOfSeats = 7,
Name = "Det gode bord",
VenueId = venue1.Id,
};
Table table3 = new Table {
NoOfSeats = 3,
Name = "Det dårlige bord",
VenueId = venue1.Id
};
table0.Id = _tableRepository.Add(table0);
table1.Id = _tableRepository.Add(table1);
table2.Id = _tableRepository.Add(table2);
table3.Id = _tableRepository.Add(table3);
Console.WriteLine("Seeding table packages ..");
TablePackage tablePackage0 = new TablePackage {
Name = "Den dyre",
Price = 6000,
VenueId = venue.Id,
};
TablePackage tablePackage1 = new TablePackage
{
Name = "Den billige",
Price = 500,
VenueId = venue.Id
};
TablePackage tablePackage2 = new TablePackage {
Name = "Den Gode",
Price = 4000,
VenueId = venue1.Id,
};
TablePackage tablePackage3 = new TablePackage {
Name = "Den Den Dårlige",
Price = 300,
VenueId = venue1.Id
};
tablePackage0.Id = _tablePackageRepository.Add(tablePackage0);
tablePackage1.Id = _tablePackageRepository.Add(tablePackage1);
tablePackage2.Id = _tablePackageRepository.Add(tablePackage2);
tablePackage3.Id = _tablePackageRepository.Add(tablePackage3);
Console.WriteLine("Seeding reservations ..");
Reservation reservation0 = new Reservation
{
ReservationNo = 10001,
DateTimeStart = Convert.ToDateTime("28/12-2019 20:00"),
DateTimeEnd = Convert.ToDateTime("29/12-2019 05:00"),
State = 1,
CustomerId = customer0.Id,
VenueId = venue.Id,
TableId = table0.Id,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now
};
Reservation reservation1 = new Reservation
{
ReservationNo = 10002,
DateTimeStart = Convert.ToDateTime("31/12-2019 20:00"),
DateTimeEnd = Convert.ToDateTime("01/01-2020 05:00"),
State = 1,
CustomerId = customer1.Id,
VenueId = venue1.Id,
TableId = table1.Id,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now
};
reservation0.Id = _reservationRepository.Add(reservation0);
reservation1.Id = _reservationRepository.Add(reservation1);
_reservationTablePackageRepository.Add(new ReservationTablePackage
{
ReservationId = reservation0.Id,
TablePackageId = tablePackage0.Id
});
_reservationTablePackageRepository.Add(new ReservationTablePackage
{
ReservationId = reservation1.Id,
TablePackageId = tablePackage1.Id
});
}
