public static Control showBarService()
{
// make a list for retrieving data from it
List <SomerenModel.BarService> barServices = new List <SomerenModel.BarService>();
// linking the list to the DB connection in order to get data from it
barServices = SomerenDB.DB_getBarServices();
// Making a list and editing its format
ListView barServiceListView = new ListView();
barServiceListView.Height = 370;
barServiceListView.Width = 370;
barServiceListView.View = View.Details;
barServiceListView.FullRowSelect = true;
// add columns to the list view
barServiceListView.Columns.Add("ID", -2, HorizontalAlignment.Left);
barServiceListView.Columns.Add("Drink Name", -2, HorizontalAlignment.Left);
barServiceListView.Columns.Add("Drink Price", -2, HorizontalAlignment.Left);
barServiceListView.Columns.Add("Amount (In Stock)", -2, HorizontalAlignment.Left);
// declare a string variable for adding new text to stock amount data
string StockState;
// store data to the list view
foreach (SomerenModel.BarService barService in barServices)
{
ListViewItem entryListItem = barServiceListView.Items.Add(barService.getDrinkId().ToString());
entryListItem.SubItems.Add(barService.getDrinkName().ToString());
entryListItem.SubItems.Add(barService.getDrinkPrice().ToString());
// adding new text to stock amount data depending on its value
if (barService.getStockAmount() < 10)
{
StockState = barService.getStockAmount() + " (Stock nearly depleted)";
}
else
{
StockState = barService.getStockAmount() + " (Stock sufficient)";
}
entryListItem.SubItems.Add(StockState.ToString());
}
// return a list view
return(barServiceListView);
}
