private void txtIDthucuong_TextChanged(object sender, EventArgs e)
{
try
{
if (dtgvThucuong.SelectedCells.Count > 0)
{
int id = (int)dtgvThucuong.SelectedCells[0].OwningRow.Cells["TypeDrink"].Value;
ClsTypeDrink typedrink = TypeDrink.Instance.loadTypeDrinkbyId(id);
cobLoaithucuong.SelectedItem = typedrink;
int index = -1;
int i = 0;
foreach (ClsTypeDrink item in cobLoaithucuong.Items)
{
if (item.Id == typedrink.Id)
{
index = i;
break;
}
i++;
}
cobLoaithucuong.SelectedIndex = index;
}
}
catch
{
}
}
//tim kiem
public List <ClsTypeDrink> search(string name)
{
List <ClsTypeDrink> list = new List <ClsTypeDrink>();
DataTable data = DataProvider.Instance.ExcuteQuery("SELECT * FROM TypeDrink WHERE dbo.GetUnsignString(name) LIKE N'%' + dbo.GetUnsignString(N'" + name + "') + '%'");
foreach (DataRow item in data.Rows)
{
ClsTypeDrink typedrink = new ClsTypeDrink(item);
list.Add(typedrink);
}
return(list);
}
public List <ClsTypeDrink> ListTypeDrink()
{
List <ClsTypeDrink> listTypeDrink = new List <ClsTypeDrink>();
DataTable data = DataProvider.Instance.ExcuteQuery("EXEC SP_LoaiDrink");
foreach (DataRow item in data.Rows)
{
ClsTypeDrink typedrink = new ClsTypeDrink(item);
listTypeDrink.Add(typedrink);
}
return(listTypeDrink);
}
public ClsTypeDrink loadTypeDrinkbyId(int id)
{
ClsTypeDrink name = null;
DataTable data = DataProvider.Instance.ExcuteQuery("EXEC SP_LoaiDrinkId @id", new object[] { id });
foreach (DataRow item in data.Rows)
{
name = new ClsTypeDrink(item);
return(name);
}
return(name);
}
//Load danh sach comboBox khi Selected item
private void cobLoaidrink_SelectedIndexChanged(object sender, EventArgs e)
{
int id = 0;
ComboBox cob = sender as ComboBox;
if (cob.SelectedItem == null)
{
return;
}
ClsTypeDrink selected = cob.SelectedItem as ClsTypeDrink;
id = selected.Id;
LoadDrink(id);
}
