Hi, first time here on this platform. Anyway, I am working on a c# project at school, where you create a database in SQL and work on that database to create an application for a restaurant. All the code is kept in separate layers. I created a windows form in the UI layer and I want to select a row. After selecting a row, I wanna edit the information in the row but not all columns at once.
How can I make it possible to select a row item and then edit it? Thanks in advance.
DAL Layer:
public List<Item> Get_All_Items_DB()
{
String query = "select itemID, [name], price, stock, category, Course, VATRate from ITEMS";
SqlParameter[] parameters = new SqlParameter[0];
return ReadItems(ExecuteSelectQuery(query, parameters));
}
DAO Layer:
ItemDAL itemDAO = new ItemDAL();
public List<Item> GetItems()
{
return itemDAO.Get_All_Items_DB();
}
UI code:
private void GetItemList()
{
itemService = new Item_Service();
List<Item> menuItems = itemService.GetItems();
listViewDisplayForm.Items.Clear();
foreach (Item i in menuItems)
{
lvItem = new ListViewItem(i.ItemID.ToString(), 0);
lvItem.SubItems.Add(i.Name);
lvItem.SubItems.Add(i.Price.ToString("0.00"));
lvItem.SubItems.Add(i.Stock.ToString("0"));
lvItem.SubItems.Add(i.Category.ToString());
lvItem.SubItems.Add(i.Course.ToString());
lvItem.SubItems.Add(i.VATRate.ToString("0.00"));
listViewDisplayForm.Items.Add(lvItem);
}
}
private void butDisplay_Click(object sender, EventArgs e)
{
GetItemList();
}