public static Snack Find(int id)
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM snack WHERE id = (@searchId);";
MySqlParameter searchId = new MySqlParameter();
searchId.ParameterName = "@searchId";
searchId.Value = id;
cmd.Parameters.Add(searchId);
var rdr = cmd.ExecuteReader() as MySqlDataReader;
int SnackId = 0;
string food = "";
DateTime stampTime = new DateTime();
float sugar = 0;
float carb = 0;
int userId = 0;
while (rdr.Read())
{
SnackId = rdr.GetInt32(0);
food = rdr.GetString(1);
stampTime = rdr.GetDateTime(2);
sugar = rdr.GetFloat(3);
carb = rdr.GetFloat(4);
userId = rdr.GetInt32(5);
}
Snack newSnack = new Snack(food, stampTime, sugar, carb, userId, SnackId);
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(newSnack);
}
public List <Snack> GetSnacks()
{
List <Snack> allLoginSnacks = new List <Snack> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM snack WHERE user_id = @user_id;";
MySqlParameter userId = new MySqlParameter();
userId.ParameterName = "@user_id";
userId.Value = this._id;
cmd.Parameters.Add(userId);
var rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
int snackId = rdr.GetInt32(0);
string food = rdr.GetString(1);
DateTime stampTime = rdr.GetDateTime(2);
float sugar = rdr.GetFloat(3);
float carb = rdr.GetFloat(4);
int user_id = rdr.GetInt32(5);
Snack newSnack = new Snack(food, stampTime, sugar, carb, user_id);
allLoginSnacks.Add(newSnack);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allLoginSnacks);
}