private void tbID_Dish_TextChanged(object sender, EventArgs e)
{
if (dtgvList_Dish.SelectedCells.Count > 0)
{
string id = dtgvList_Dish.SelectedCells[0].OwningRow.Cells["id_type_dish"].Value.ToString();
TypeDish type = TypeDishDAO.Instance.GetTypeDishByID(id);
cbbType_Dish2.SelectedItem = type;
int index = -1;
int i = 0;
foreach (TypeDish item in cbbType_Dish2.Items)
{
if (item.Id_type_dish == type.Id_type_dish)
{
index = i;
break;
}
i++;
}
cbbType_Dish2.SelectedIndex = index;
}
}
public TypeDish GetTypeDishByID(string id)
{
TypeDish list = null;
string query = "EXEC usp_GetTypeDishtoCCB @id = '" + id + "'";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
list = new TypeDish(item);
return(list);
}
return(list);
}
public List <TypeDish> GetListTypeDish()
{
List <TypeDish> list = new List <TypeDish>();
string query = "EXEC usp_GetLishTypeDish";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
TypeDish typedish = new TypeDish(item);
list.Add(typedish);
}
return(list);
}
