private void txtMaVacxin_TextChanged(object sender, EventArgs e)
{
if (dtgVacxin.SelectedCells.Count > 0)
{
String id = dtgVacxin.SelectedCells[0].OwningRow.Cells["MaLoai"].Value.ToString();
LoaiVacxin loai = LoaiVacxinDAO.Instance.getLoaiVacxinByMa(id);
cbxLoaiVacxin.SelectedItem = loai;
int index = -1;
int i = 0;
foreach (LoaiVacxin item in cbxLoaiVacxin.Items)
{
if (item.MaLoai == loai.MaLoai)
{
index = i;
break;
}
i++;
}
cbxLoaiVacxin.SelectedIndex = index;
}
}
public List <LoaiVacxin> SearchLoaiVacxinByID(string id)
{
List <LoaiVacxin> list = new List <LoaiVacxin>();
String query = string.Format("EXEC timLoaiVxTheoMaLoai @maLoai='{0}'", "%" + id + "%");
DataTable data = DataProvider.Instance.ExcuteQuery(query);
foreach (DataRow item in data.Rows)
{
LoaiVacxin vx = new LoaiVacxin(item);
list.Add(vx);
}
return(list);
}
public List <LoaiVacxin> getListLoaiVacxin()
{
List <LoaiVacxin> loaiVx = new List <LoaiVacxin>();
DataTable data = DataProvider.Instance.ExcuteQuery("EXEC USP_GetLoai");
foreach (DataRow item in data.Rows)
{
LoaiVacxin loai = new LoaiVacxin(item);
loaiVx.Add(loai);
}
return(loaiVx);
}
public LoaiVacxin getLoaiVacxinByMa(String id)
{
LoaiVacxin loai = null;
string query = String.Format("EXEC dbo.chonVacxinTheoMaLoai @maLoai = '{0}'", id);
DataTable data = DataProvider.Instance.ExcuteQuery(query);
foreach (DataRow item in data.Rows)
{
loai = new LoaiVacxin(item);
return(loai);
}
return(loai);
}
public LoaiVacxin getLoaiVacxinByMa(String id)
{
LoaiVacxin loai = null;
string query = String.Format("select * from LoaiVacxin where MaLoai='{0}'", id);
DataTable data = DataProvider.Instance.ExcuteQuery(query);
foreach (DataRow item in data.Rows)
{
loai = new LoaiVacxin(item);
return(loai);
}
return(loai);
}
