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