public void CreateClass(WorkoutClass workoutClass)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO workoutClass " +
"(Name, InstructorName, AvailableSpots, Description, StartTime, EndTime, isActive)" +
"VALUES (@Name, @InstructorName, @AvailableSpots, @Description, @ClassStart, @ClassEnd, 'true');", conn);
cmd.Parameters.AddWithValue("@Name", workoutClass.Name);
cmd.Parameters.AddWithValue("@InstructorName", workoutClass.InstructorName);
cmd.Parameters.AddWithValue("@AvailableSpots", workoutClass.AvailableSpots);
cmd.Parameters.AddWithValue("@Description", workoutClass.Description);
cmd.Parameters.AddWithValue("@ClassStart", workoutClass.StartTime);
cmd.Parameters.AddWithValue("@ClassEnd", workoutClass.EndTime);
cmd.ExecuteNonQuery();
return;
}
}
catch (SqlException ex)
{
throw ex;
}
}
public void UpdateClass(WorkoutClass workoutClass)
{
workoutClass.InstructorName = workoutClass.InstructorName == null ? "" : workoutClass.InstructorName;
workoutClass.Description = workoutClass.Description == null ? "" : workoutClass.Description;
workoutClass.InstructorName = workoutClass.InstructorName == null ? "" : workoutClass.InstructorName;
workoutClass.InstructorName = workoutClass.InstructorName == null ? "" : workoutClass.InstructorName;
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("UPDATE workoutClass SET Name = @Name, InstructorName = @InstructorName, " +
"AvailableSpots = @AvailableSpots, Description = @Description, StartTime = @ClassStart, EndTime = @ClassEnd," +
" isActive = 1 WHERE classId = @id;", conn);
cmd.Parameters.AddWithValue("@Name", workoutClass.Name);
cmd.Parameters.AddWithValue("@InstructorName", workoutClass.InstructorName);
cmd.Parameters.AddWithValue("@AvailableSpots", workoutClass.AvailableSpots);
cmd.Parameters.AddWithValue("@Description", workoutClass.Description);
cmd.Parameters.AddWithValue("@ClassStart", workoutClass.StartTime);
cmd.Parameters.AddWithValue("@ClassEnd", workoutClass.EndTime);
cmd.Parameters.AddWithValue("@id", workoutClass.classId);
cmd.ExecuteNonQuery();
return;
}
}
catch (SqlException ex)
{
throw ex;
}
}
public IActionResult ClassList()
{
WorkoutClass newClass = new WorkoutClass();
newClass.Classes = new List <WorkoutClass>();
newClass.Classes = classDAL.GetAllClasses();
return(View(newClass));
}
public WorkoutClass GetClass(string userName)
{
WorkoutClass output = null;
string SQL_String = @"Select TOP 1 * from workoutClass WHERE name = @name";
Dictionary <string, object> dynamicParameterArgs = new Dictionary <string, object>();
dynamicParameterArgs.Add("@name", userName);
using (SqlConnection myConnection = new SqlConnection(connectionString))
{
myConnection.Open();
output = myConnection.Query <WorkoutClass>(SQL_String, new DynamicParameters(dynamicParameterArgs)).ToList().FirstOrDefault();
}
return(output);
}
public void DeleteClass(WorkoutClass workoutClass)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("UPDATE workoutClass SET IsActive = 'false' WHERE classId = @id;", conn);
cmd.Parameters.AddWithValue("@id", workoutClass.classId);
cmd.ExecuteNonQuery();
return;
}
}
catch (SqlException ex)
{
throw ex;
}
}
public IActionResult RemoveClass(WorkoutClass removed)
{
classDAL.DeleteClass(removed);
return(RedirectToAction("ClassList", "Classes"));
}
