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