public static bool RemoveTime(int intTotalMinsToSubtract, int intUserID, int intDayID)
{
int exerciseLeft = DayDAL.GetExerciseLeftByDayAndUser(intUserID, intDayID);
int updateValue = exerciseLeft - intTotalMinsToSubtract;
NpgsqlConnection conn = DatabaseConnection.GetConnection();
conn.Open();
// define a query
string query = "UPDATE \"day\"" +
" SET \"intExMinsLeft\" = @updateValue" +
" WHERE \"intUserID\" = @intUserID" +
" AND \"intDayID\" = @intDayID";
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
cmd.Parameters.AddWithValue("updateValue", updateValue);
cmd.Parameters.AddWithValue("intUserID", intUserID);
cmd.Parameters.AddWithValue("intDayID", intDayID);
int result = cmd.ExecuteNonQuery();
conn.Close();
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
public static bool AddCals(int intTotalCalsToAdd, int intUserID, int intDayID)
{
int originalCals = DayDAL.GetCalsLeftByDayAndUser(intUserID, intDayID);
int updateValue = originalCals + intTotalCalsToAdd;
NpgsqlConnection conn = DatabaseConnection.GetConnection();
conn.Open();
// define a query
string query = "UPDATE \"day\"" +
" SET \"intCalsLeft\" = @updateValue" +
" WHERE \"intUserID\" = @intUserID" +
" AND \"intDayID\" = @intDayID";
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
cmd.Parameters.AddWithValue("updateValue", updateValue);
cmd.Parameters.AddWithValue("intUserID", intUserID);
cmd.Parameters.AddWithValue("intDayID", intDayID);
int result = cmd.ExecuteNonQuery();
conn.Close();
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
private static bool SubtractCals(List <FoodItem> lstContents, int intUserID, int intDayID)
{
int totalCalsToSubtract = 0;
foreach (var foodItem in lstContents)
{
totalCalsToSubtract += foodItem.intCalories;
}
int originalCals = DayDAL.GetCalsLeftByDayAndUser(intUserID, intDayID);
int updateValue = originalCals - totalCalsToSubtract;
NpgsqlConnection conn = DatabaseConnection.GetConnection();
conn.Open();
// define a query
string query = "UPDATE \"day\"" +
" SET \"intCalsLeft\" = @updateValue" +
" WHERE \"intUserID\" = @intUserID" +
" AND \"intDayID\" = @intDayID";
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
cmd.Parameters.AddWithValue("updateValue", updateValue);
cmd.Parameters.AddWithValue("intUserID", intUserID);
cmd.Parameters.AddWithValue("intDayID", intDayID);
int result = cmd.ExecuteNonQuery();
conn.Close();
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
