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