private void cbxMaVx_SelectionChangeCommitted(object sender, EventArgs e)
{
String maVx = (cbxMaVx.SelectedItem as Vacxin).MaVacxin;
String query = String.Format("EXEC dbo.chonVacxinTheoMaVX @maVX = '{0}'", maVx);
DataTable dt = DataProvider.Instance.ExcuteQuery(query);
Vacxin vx = new Vacxin(dt.Rows[0]);
txtDonGia.Text = (Int32.Parse(vx.GiaThanh) * 1.1).ToString();
}
public List <Vacxin> LoadVacxinList()
{
List <Vacxin> list = new List <Vacxin>();
DataTable data = DataProvider.Instance.ExcuteQuery("EXEC USP_GetVacxin");
foreach (DataRow item in data.Rows)
{
Vacxin vx = new Vacxin(item);
list.Add(vx);
}
return(list);
}
public List <String> loadMaVacxin()
{
List <String> list = new List <String>();
DataTable data = DataProvider.Instance.ExcuteQuery("EXEC dbo.getVacxin");
foreach (DataRow item in data.Rows)
{
Vacxin vx = new Vacxin(item);
list.Add(vx.MaVacxin);
}
return(list);
}
public List <Vacxin> SearchVacxinByName(string name)
{
List <Vacxin> list = new List <Vacxin>();
String query = string.Format("select * from Vacxin where TenVacxin like N'%{0}%'", name);
DataTable data = DataProvider.Instance.ExcuteQuery(query);
foreach (DataRow item in data.Rows)
{
Vacxin vx = new Vacxin(item);
list.Add(vx);
}
return(list);
}
public List <Vacxin> getVacxinByLoai(string name)
{
List <Vacxin> list = new List <Vacxin>();
String query = string.Format(" EXEC layVacxinTheoMaLoai @maLoai='{0}'", name);
DataTable data = DataProvider.Instance.ExcuteQuery(query);
foreach (DataRow item in data.Rows)
{
Vacxin vx = new Vacxin(item);
list.Add(vx);
}
return(list);
}
public List <Vacxin> SearchVacxinByID(string id)
{
List <Vacxin> list = new List <Vacxin>();
String query = string.Format("EXEC timVacxinTheoMaVx @maVx='{0}'", "%" + id + "%");
DataTable data = DataProvider.Instance.ExcuteQuery(query);
foreach (DataRow item in data.Rows)
{
Vacxin vx = new Vacxin(item);
list.Add(vx);
}
return(list);
}
