public List <productitem> GetLog(string user)
{
List <productitem> Items = new List <productitem>();
OpenDBConnection();
SqlCommand ucommand;
ucommand = new SqlCommand("SELECT * from cb_log WHERE fld_user = @user order by fld_date DESC", conn);
ucommand.Parameters.Add(new SqlParameter("user", user));
using (SqlDataReader reader = ucommand.ExecuteReader())
{
while (reader.Read())
{
productitem item = new productitem();
item.exercise1 = reader["fld_exercise1"].ToString();
item.exercise2 = reader["fld_exercise2"].ToString();
item.exercise3 = reader["fld_exercise3"].ToString();
item.exercise4 = reader["fld_exercise4"].ToString();
item.exercise5 = reader["fld_exercise5"].ToString();
item.date = reader["fld_date"].ToString();
item.rating = reader["fld_rating"].ToString();
item.session = reader["fld_session"].ToString();
item.weight = reader["fld_weight"].ToString();
item.LogID = Convert.ToInt32(reader["fld_logid"].ToString());
Items.Add(item);
}
}
return(Items);
}
public List <productitem> GetGroups(string owner)
{
List <productitem> Items = new List <productitem>();
OpenDBConnection();
SqlCommand ucommand;
ucommand = new SqlCommand("SELECT * from dash_group where fld_owner = @owner order by fld_groupname", conn);
ucommand.Parameters.Add(new SqlParameter("owner", owner));
using (SqlDataReader reader = ucommand.ExecuteReader())
{
while (reader.Read())
{
productitem item = new productitem();
item.groups = reader["fld_groupname"].ToString();
Items.Add(item);
}
}
return(Items);
}
