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