public DTOItemOdered GetItemOderedById(int idbill)
{
string query = string.Format("SELECT * FROM TableItemOdered WHERE idbill={0} ", idbill);
DataTable dt = DataProvider.Instance.ExecuteQuery(query);
DTOItemOdered gv = new DTOItemOdered(dt.Rows[0]);
return(gv);
}
public List <DTOItemOdered> GetListItemOdered()
{
List <DTOItemOdered> list = new List <DTOItemOdered>();
string query = string.Format("SELECT * FROM TableItemOdered ");
DataTable dt = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in dt.Rows)
{
DTOItemOdered order = new DTOItemOdered(item);
list.Add(order);
}
return(list);
}
