public int GetIDLoaiGiay(string id_giay)
{
string query = "select * from catarogry a, ThongTinGiay b where a.id_loaigiay=b.id_loaigiay and id_giay =N'" + id_giay + "' ";
DataTable datatb = DataProvider.Instance.ExecuteQuery(query);
if (datatb.Rows.Count > 0)
{
Catarogry catarogry = new Catarogry(datatb.Rows[0]);
return(catarogry.ID_LoaiGiay);
}
return(-1);
}
public List <Catarogry> LoadLoaiHang()
{
List <Catarogry> list = new List <Catarogry>();
DataTable datatb = new DataTable();
string query = "select* from catarogry";
datatb = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in datatb.Rows)
{
Catarogry catarogry = new Catarogry(item);
list.Add(catarogry);
}
return(list);
}
