// GET: InstructorsClass/Edit/5
public ActionResult Edit(int id)
{
InstructorsClass instructorsClasses = GetInstructorsClassById(id);
List <CohortOne> cohorts = GetAllCohorts();
InstructorsClassEditViewModel viewModel = new InstructorsClassEditViewModel();
viewModel.instructorsClass = instructorsClasses;
viewModel.AvailableCohorts = cohorts;
return(View(viewModel));
}
// GET: InstructorsClass/Details/5
public ActionResult Details(int id)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT ins.Id,
ins.FirstName,
ins.LastName,
ins.SlackHandle,
ins.CohortOneId
FROM InstructorsClass ins";
cmd.Parameters.Add(new SqlParameter("@id", id));
SqlDataReader reader = cmd.ExecuteReader();
InstructorsClass instructorsClass = null;
if (reader.Read())
{
instructorsClass = new InstructorsClass
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
FirstName = reader.GetString(reader.GetOrdinal("FirstName")),
LastName = reader.GetString(reader.GetOrdinal("LastName")),
SlackHandle = reader.GetString(reader.GetOrdinal("SlackHandle")),
CohortOneId = reader.GetInt32(reader.GetOrdinal("CohortOneId"))
};
reader.Close();
return(View(instructorsClass));
}
else
{
return(new StatusCodeResult(StatusCodes.Status404NotFound));
}
}
}
}
public ActionResult Edit(int id, InstructorsClassEditViewModel viewModel)
{
InstructorsClass instructorsClasses = viewModel.instructorsClass;
try
{
// TODO: Add update logic here
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
UPDATE InstructorsClass
SET
FirstName = @FirstName,
LastName = @LastName,
SlackHandle = @SlackHandle,
CohortOneId = @CohortOneId
Where Id = @id";
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.Parameters.Add(new SqlParameter("@FirstName", instructorsClasses.FirstName));
cmd.Parameters.Add(new SqlParameter("@LastName", instructorsClasses.LastName));
cmd.Parameters.Add(new SqlParameter("@SlackHandle", instructorsClasses.SlackHandle));
cmd.Parameters.Add(new SqlParameter("@CohortOneId", instructorsClasses.CohortOneId));
cmd.ExecuteNonQuery();
return(RedirectToAction(nameof(Index)));
}
}
}
catch
{
return(View());
}
}
// GET: InstructorsClass
public ActionResult Index()
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT ins.Id,
ins.FirstName,
ins.LastName,
ins.SlackHandle,
ins.CohortOneId
FROM InstructorsClass ins";
SqlDataReader reader = cmd.ExecuteReader();
List <InstructorsClass> instructorsClasses = new List <InstructorsClass>();
while (reader.Read())
{
InstructorsClass instructorsClass = new InstructorsClass
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
FirstName = reader.GetString(reader.GetOrdinal("FirstName")),
LastName = reader.GetString(reader.GetOrdinal("LastName")),
SlackHandle = reader.GetString(reader.GetOrdinal("SlackHandle")),
CohortOneId = reader.GetInt32(reader.GetOrdinal("CohortOneId"))
};
instructorsClasses.Add(instructorsClass);
}
reader.Close();
return(View(instructorsClasses));
}
}
}
private InstructorsClass GetInstructorsClassById(int id)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT ins.Id,
ins.FirstName,
ins.LastName,
ins.SlackHandle,
ins.CohortOneId
FROM InstructorsClass ins
WHERE ins.Id=@id
";
cmd.Parameters.Add(new SqlParameter("@id", id));
SqlDataReader reader = cmd.ExecuteReader();
InstructorsClass instructorsClasses = null;
if (reader.Read())
{
instructorsClasses = new InstructorsClass
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
FirstName = reader.GetString(reader.GetOrdinal("FirstName")),
LastName = reader.GetString(reader.GetOrdinal("LastName")),
SlackHandle = reader.GetString(reader.GetOrdinal("SlackHandle")),
CohortOneId = reader.GetInt32(reader.GetOrdinal("CohortOneId"))
};
}
reader.Close();
return(instructorsClasses);
}
}
}
// GET: InstructorsClass/Delete/5
public ActionResult Delete(int id)
{
InstructorsClass instructorsClasses = GetInstructorsClassById(id);
return(View(instructorsClasses));
}
