protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
// Set our view from the "main" layout resource
SetContentView(Resource.Layout.Main);
foods = new ListFood();
recyclerView = FindViewById <RecyclerView>(Resource.Id.recyclerView);
layoutManager = new LinearLayoutManager(this);
recyclerView.SetLayoutManager(layoutManager);
foodViewAdapter = new FoodViewAdapter(foods);
recyclerView.SetAdapter(foodViewAdapter);
}
public List <ListFood> SearchFood(string namefood)
{
List <ListFood> Listfood = new List <ListFood>();
string query = "EXECUTE dbo.USP_getListFoodBySearching @nameFood";
DataTable data = DataProvider.Instance.ExecuteQuery(query, new object[] { namefood });
foreach (DataRow item in data.Rows)
{
ListFood food = new ListFood(item);
Listfood.Add(food);
}
return(Listfood);
}
public List <ListFood> getListFood()
{
List <ListFood> Listfood = new List <ListFood>();
string query = "EXECUTE dbo.USP_getListFood";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
ListFood food = new ListFood(item);
Listfood.Add(food);
}
return(Listfood);
}
/*=============================================================*/
public List <ListFood> GetFoods()
{
List <ListFood> list = new List <ListFood>();
string query = "USP_GetListFood";
DataTable data = DataProvaider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
ListFood food = new ListFood(item);
list.Add(food);
}
return(list);
}
public FoodViewAdapter(ListFood foods)
{
Foods = foods;
}
