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); }