public ActionResult Create(InstructorEditViewmodel instructor)
{
try
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO Instructor (FirstName, LastName, SlackHandle, Specialty, CohortId)
OUTPUT INSERTED.Id
VALUES (@firstName, @lastName, @slackHandle, @specialty, @cohortId)";
cmd.Parameters.Add(new SqlParameter("@firstName", instructor.FirstName));
cmd.Parameters.Add(new SqlParameter("@lastName", instructor.LastName));
cmd.Parameters.Add(new SqlParameter("@slackHandle", instructor.SlackHandle));
cmd.Parameters.Add(new SqlParameter("@specialty", instructor.Specialty));
cmd.Parameters.Add(new SqlParameter("@cohortId", instructor.CohortId));
var id = (int)cmd.ExecuteScalar();
instructor.Id = id;
// TODO: Add insert logic here
return(RedirectToAction(nameof(Index)));
}
}
}
catch
{
return(View());
}
}
// GET: Students/Create
public ActionResult Create()
{
var cohortOptions = GetCohortOptions();
var viewModel = new InstructorEditViewmodel()
{
CohortOptions = cohortOptions
};
return(View(viewModel));
}
// GET: Instructors/Edit/5
public ActionResult Edit(int id)
{
var instructor = GetInstructorById(id);
var cohortOptions = GetCohortOptions();
var viewModel = new InstructorEditViewmodel()
{
Id = instructor.Id,
FirstName = instructor.FirstName,
LastName = instructor.LastName,
CohortId = instructor.CohortId,
SlackHandle = instructor.SlackHandle,
Specialty = instructor.Specialty,
CohortOptions = cohortOptions
};
return(View(viewModel));
}
public ActionResult Edit(int id, InstructorEditViewmodel instructor)
{
try
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"UPDATE Instructor
SET FirstName = @firstName,
LastName = @lastName,
SlackHandle = @slackHandle,
Specialty = @specialty,
CohortId = @cohortId
WHERE Id = @id";
cmd.Parameters.Add(new SqlParameter("@firstName", instructor.FirstName));
cmd.Parameters.Add(new SqlParameter("@lastName", instructor.LastName));
cmd.Parameters.Add(new SqlParameter("@slackHandle", instructor.SlackHandle));
cmd.Parameters.Add(new SqlParameter("@specialty", instructor.Specialty));
cmd.Parameters.Add(new SqlParameter("@cohortId", instructor.CohortId));
cmd.Parameters.Add(new SqlParameter("@id", id));
var rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected < 1)
{
return(NotFound());
}
}
}
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
