static public DataRowCollection getRowsToArray(string table, SR2DDataset ds, out List <int> ids)
{
List <int> tempIds = new List <int>();
foreach (DataRow dr in ds.Dataset.Tables[table].Rows)
{
tempIds.Add(int.Parse(dr.ItemArray[0].ToString()));
}
ids = tempIds;
return(ds.Dataset.Tables[table].Rows);
}
static public DataRow getVarFromId(string id, SR2DDataset ds)
{
/*int i;
*
* for (i = 0; i < ds.Dataset.Tables["vars"].Rows.Count; i++)
* {
* if (ds.Dataset.Tables["vars"].Rows[i].ItemArray[0].ToString() == id)
* {
* return ds.Dataset.Tables["vars"].Rows[i];
* }
* }
*
* return null;*/
return(ds.Dataset.Tables["vars"].Rows.Find(int.Parse(id)));
}
static public DataRowCollection getExcludedFromFoodType(DataRow dr, SR2DDataset ds)
{
DataRowCollection drC = ds.Dataset.Tables["excluded_food_types_join"].Rows;
DataTable drT = ds.Dataset.Tables["excluded_food_types_join"].Clone();
foreach (DataRow r in drC)
{
if (r.ItemArray[1].ToString() == dr.ItemArray[0].ToString())
{
drT.Rows.Add(r.ItemArray);
}
}
return(drT.Rows);
}
static public DataRowCollection getFoodTypeFromFood(DataRow dr, SR2DDataset ds)
{
DataRowCollection drC = ds.Dataset.Tables["food"].Rows;
DataTable drT = ds.Dataset.Tables["food"].Clone();
foreach (DataRow r in drC)
{
if (r.ItemArray[3].ToString() == dr.ItemArray[0].ToString())
{
drT.Rows.Add(r.ItemArray);
}
}
return(drT.Rows);
}
static public DataRow getExcludedFromId(string id, SR2DDataset ds)
{
return(ds.Dataset.Tables["excluded_food_types_join"].Rows.Find(int.Parse(id)));
}
static public DataRow getFoodTypeFromId(string id, SR2DDataset ds)
{
return(ds.Dataset.Tables["food_types"].Rows.Find(int.Parse(id)));
}
static public void removeFoodTypeByID(string id, SR2DDataset ds)
{
ds.Dataset.Tables["food_types"].Rows.Find(int.Parse(id)).Delete();
}
