//public ViewEquipmentMember GetEquipmentPhotoPath(int id)
//{
// ViewEquipmentMember equip = new ViewEquipmentMember();
// try
// {
// using (SqlConnection conn = new SqlConnection(connectionString))
// {
// conn.Open();
// SqlCommand cmd = new SqlCommand("Select photo_path From gym_equipment WHERE id = @id ", conn);
// cmd.Parameters.AddWithValue("@id", id);
// SqlDataReader reader = cmd.ExecuteReader();
// while (reader.Read())
// {
// equip = MapRowToEquipment(reader);
// }
// return equip;
// }
// }
// catch (SqlException ex)
// {
// throw;
// }
//}
public bool AddGymUsage(GymUsageModel model)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO gym_equipment_usage (equipment_id, member_id, date_time, reps, weight) " +
"VALUES (@equipment_id, @member_id, @date_time, @reps, @weight)", conn);
cmd.Parameters.AddWithValue("@equipment_id", model.Equipment_id);
cmd.Parameters.AddWithValue("@member_id", model.Member_id);
cmd.Parameters.AddWithValue("@date_time", model.Date_time);
cmd.Parameters.AddWithValue("@reps", model.Reps);
cmd.Parameters.AddWithValue("@weight", model.Weight);
cmd.ExecuteNonQuery();
return(true);
}
}
catch (SqlException ex)
{
return(false);
throw;
}
}
public IActionResult SetMemberEquipmentUsage(GymUsageModel model)
{
if (ModelState.IsValid)
{
gymDAL.AddGymUsage(model);
}
return(RedirectToAction(nameof(ViewEquipmentMember)));
}
public IActionResult SetMemberEquipmentUsage(int id)
{
GymUsageModel model = new GymUsageModel();
User currentUser = authProvider.GetCurrentUser();
model.Member_id = currentUser.Id;
model.Equipment_id = id;
model.Date_time = DateTime.Today;
return(View(model));
}