public void AddExercise(LogRow Exercise)
{
try
{
NpgsqlConnection connection = new NpgsqlConnection(DbConnection);
connection.Open();
string query = "INSERT INTO fitnesslogger.exercise_log VALUES(@Id, @Date, @Exercise, @Weight, @Repetitions, @Sets, @Rest_time, @Notes)";
int NextId = GetNextId();
NpgsqlCommand command = new NpgsqlCommand(query, connection);
command.Parameters.Add(new NpgsqlParameter("Id", NextId));
command.Parameters.Add(new NpgsqlParameter("Date", Exercise.Date));
command.Parameters.Add(new NpgsqlParameter("Exercise", Exercise.Exercise));
command.Parameters.Add(new NpgsqlParameter("Weight", Exercise.Weight));
command.Parameters.Add(new NpgsqlParameter("Repetitions", Exercise.Repetitions));
command.Parameters.Add(new NpgsqlParameter("Sets", Exercise.Sets));
command.Parameters.Add(new NpgsqlParameter("Rest_time", Exercise.Rest_time));
command.Parameters.Add(new NpgsqlParameter("Notes", Exercise.Notes));
command.ExecuteNonQuery();
connection.Close();
}
catch
{
throw;
}
}
private List <LogRow> ExerciseList()
{
List <LogRow> exercises = new List <LogRow>();
try
{
NpgsqlConnection connection = new NpgsqlConnection(DbConnection);
connection.Open();
NpgsqlCommand command = new NpgsqlCommand("SELECT * FROM fitnesslogger.exercise_log", connection);
NpgsqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
LogRow logrow = new LogRow();
logrow.Id = Convert.ToInt32(dataReader["id"]);
logrow.Date = Convert.ToDateTime(dataReader["date"]);
logrow.Exercise = dataReader["exercise"].ToString();
logrow.Weight = Convert.ToInt32(dataReader["weight"]);
logrow.Repetitions = Convert.ToInt32(dataReader["repetitions"]);
logrow.Sets = Convert.ToInt32(dataReader["sets"]);
logrow.Rest_time = Convert.ToInt32(dataReader["rest_time"]);
logrow.Notes = dataReader["notes"].ToString();
exercises.Add(logrow);
}
connection.Close();
return(exercises);
}
catch (Exception msg)
{
throw;
}
}
static void Main(string[] args)
{
database db = new database();
LogRow logrow = new LogRow()
{
Date = DateTime.Now,
Exercise = "Benchpress",
Weight = 210,
Repetitions = 10,
Sets = 5,
Rest_time = 90,
Notes = "BEASTMODE"
};
//db.AddExercise(logrow);
foreach (LogRow _logrow in db.Exercises)
{
Console.WriteLine(_logrow.Id + ", " + _logrow.Date.ToString("dd-MM-yy") + ", " + _logrow.Exercise + ", " + _logrow.Weight + ", " + _logrow.Repetitions + ", " + _logrow.Sets + ", " + _logrow.Rest_time + ", " + _logrow.Notes);
}
Console.ReadLine();
}
