/// <summary>
/// Updates data of body user values based on selected date
/// </summary>
public static bool UpdateRecord(ProgressModel progressModel, DateTime calendarDate)
{
try
{
// get connection string from Connections Helper Class
SqlConnection conn = new SqlConnection(Connections.ConnectionString);
string sql = "UPDATE dbo.UserBodyValues " +
"SET Weight=@Weight,Neck=@Neck, Chest=@Chest, Stomach=@Stomach, Waist=@Waist, Hips=@Hips, Thigh=@Thigh, Calf=@Calf, Biceps=@Biceps" +
" WHERE UserId=@UserId AND DateAdded=@DateAdded";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = progressModel.UserId;
cmd.Parameters.Add("@Weight", SqlDbType.Decimal).Value = progressModel.Weight;
cmd.Parameters.Add("@Neck", SqlDbType.Decimal).Value = progressModel.Neck;
cmd.Parameters.Add("@Chest", SqlDbType.Decimal).Value = progressModel.Chest;
cmd.Parameters.Add("@Stomach", SqlDbType.Decimal).Value = progressModel.Stomach;
cmd.Parameters.Add("@Waist", SqlDbType.Decimal).Value = progressModel.Waist;
cmd.Parameters.Add("@Hips", SqlDbType.Decimal).Value = progressModel.Hips;
cmd.Parameters.Add("@Thigh", SqlDbType.Decimal).Value = progressModel.Thigh;
cmd.Parameters.Add("@Calf", SqlDbType.Decimal).Value = progressModel.Calf;
cmd.Parameters.Add("@Biceps", SqlDbType.Decimal).Value = progressModel.Biceps;
cmd.Parameters.Add("@DateAdded", SqlDbType.DateTime).Value = calendarDate;
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
MessageBox.Show("Data Updated!");
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
string errorMessage = $"Error: {ex}";
MessageBox.Show(errorMessage);
return(true);
}
}
public static ProgressModel GetUserProgress(int userId, DateTime calendarDate)
{
var progress = new ProgressModel();
try
{
SqlConnection conn = new SqlConnection(Connections.ConnectionString);
string sql = "SELECT * FROM dbo.UserBodyValues WHERE UserId=@UserId AND DateAdded=@DateAdded";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = userId;
cmd.Parameters.Add("@DateAdded", SqlDbType.DateTime).Value = calendarDate;
using (SqlDataReader reader = cmd.ExecuteReader())
{
// if the result set is not NULL
if (reader.HasRows)
{
while (reader.Read())
{
progress.Weight = reader.GetDecimal(4);
progress.Neck = reader.GetDecimal(5);
progress.Chest = reader.GetDecimal(6);
progress.Stomach = reader.GetDecimal(7);
progress.Waist = reader.GetDecimal(8);
progress.Hips = reader.GetDecimal(9);
progress.Thigh = reader.GetDecimal(10);
progress.Calf = reader.GetDecimal(11);
progress.Biceps = reader.GetDecimal(12);
}
}
}
conn.Close();
}
catch (SqlException ex)
{
string errorMessage = $"Error: {ex}";
MessageBox.Show(errorMessage);
}
return(progress);
}
public static bool AddNewRecord(ProgressModel progress)
{
try
{
// get connection string from Connections Helper Class
SqlConnection conn = new SqlConnection(Connections.ConnectionString);
string sql = "INSERT INTO dbo.UserBodyValues (UserId,DateAdded,Weight,Neck,Chest,Stomach,Waist,Hips,Thigh,Calf,Biceps) values (@UserId,@DateAdded,@Weight,@Neck,@Chest,@Stomach,@Waist,@Hips,@Thigh,@Calf,@Biceps)";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = progress.UserId;
cmd.Parameters.Add("@Weight", SqlDbType.Decimal).Value = progress.Weight;
cmd.Parameters.Add("@Neck", SqlDbType.Decimal).Value = progress.Neck;
cmd.Parameters.Add("@Chest", SqlDbType.Decimal).Value = progress.Chest;
cmd.Parameters.Add("@Stomach", SqlDbType.Decimal).Value = progress.Stomach;
cmd.Parameters.Add("@Waist", SqlDbType.Decimal).Value = progress.Waist;
cmd.Parameters.Add("@Hips", SqlDbType.Decimal).Value = progress.Hips;
cmd.Parameters.Add("@Thigh", SqlDbType.Decimal).Value = progress.Thigh;
cmd.Parameters.Add("@Calf", SqlDbType.Decimal).Value = progress.Calf;
cmd.Parameters.Add("@Biceps", SqlDbType.Decimal).Value = progress.Biceps;
cmd.Parameters.Add("@DateAdded", SqlDbType.DateTime).Value = progress.DateAdded;
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
return(true);
}
}
catch (SqlException ex)
{
string errorMessage = $"Error: {ex}";
MessageBox.Show(errorMessage);
return(false);
}
return(false);
}
public ProgressViewModel()
{
ComboBoxChoices = new ObservableCollection <ComboBoxHistory>();
ComboBoxChoices.Add(new ComboBoxHistory()
{
Symbol = "-----"
});
ComboBoxChoices.Add(new ComboBoxHistory()
{
Symbol = "Add new record"
});
ComboBoxChoices.Add(new ComboBoxHistory()
{
Symbol = "Edit Record"
});
ComboBoxChoices.Add(new ComboBoxHistory()
{
Symbol = "View Values"
});
SelectedItem = ComboBoxChoices[0];
CurrentProgress = new ProgressModel();
}
public void AddRecord()
{
var progress = new ProgressModel();
progress = CurrentProgress;
progress.UserId = UserId;
progress.DateAdded = CalendarDate;
bool isAdded = Queries.AddNewRecord(progress);
if (isAdded)
{
MessageBox.Show("Record Added!");
TextBlockVisibility = Visibility.Visible;
EditBoxVisibility = Visibility.Hidden;
AddButtonVisibility = Visibility.Hidden;
}
else
{
MessageBox.Show("Record Not Added!");
}
}
