public static List <Lunch> GetAllLunch()
{
List <Lunch> allDatas = new List <Lunch> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT * FROM lunch;";
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
int lunchId = rdr.GetInt32(0);
string food = rdr.GetString(1);
DateTime stampTimeB = rdr.GetDateTime(2);
float sugar = rdr.GetFloat(3);
float carb = rdr.GetFloat(4);
int user_id = rdr.GetInt32(5);
Lunch newLunch = new Lunch(food, stampTimeB, sugar, carb, user_id, lunchId);
allDatas.Add(newLunch);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allDatas);
}
public static Lunch Find(int id)
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM lunch WHERE id = (@searchId);";
MySqlParameter searchId = new MySqlParameter();
searchId.ParameterName = "@searchId";
searchId.Value = id;
cmd.Parameters.Add(searchId);
var rdr = cmd.ExecuteReader() as MySqlDataReader;
int LunchId = 0;
string food = "";
DateTime stampTime = new DateTime();
float sugar = 0;
float carb = 0;
int userId = 0;
while (rdr.Read())
{
LunchId = rdr.GetInt32(0);
food = rdr.GetString(1);
stampTime = rdr.GetDateTime(2);
sugar = rdr.GetFloat(3);
carb = rdr.GetFloat(4);
userId = rdr.GetInt32(5);
}
Lunch newLunch = new Lunch(food, stampTime, sugar, carb, userId, LunchId);
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(newLunch);
}
public List <Lunch> GetLunchs()
{
List <Lunch> allLoginLunchs = new List <Lunch> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM lunch 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 lunchId = 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);
Lunch newLunch = new Lunch(food, stampTime, sugar, carb, user_id);
allLoginLunchs.Add(newLunch);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allLoginLunchs);
}