public ActionResult Create(InstructorCreateViewModel model)
{
try
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO Instructor
( InstFirstName, InstLastName, InstSlackHandle, InstCohort, InstSpeciality )
VALUES
( @instFirstName, @instLastName, @instSlackHandle, @instCohort, @instSpeciality )";
cmd.Parameters.Add(new SqlParameter("@instFirstName", model.instructor.InstFirstName));
cmd.Parameters.Add(new SqlParameter("@instLastName", model.instructor.InstLastName));
cmd.Parameters.Add(new SqlParameter("@instSlackHandle", model.instructor.InstSlackHandle));
cmd.Parameters.Add(new SqlParameter("@instCohort", model.instructor.InstCohort));
cmd.Parameters.Add(new SqlParameter("@instSpeciality", model.instructor.InstSpeciality));
cmd.ExecuteNonQuery();
return(RedirectToAction(nameof(Index)));
}
}
}
catch
{
return(View());
}
}
public ActionResult Edit(int id, InstructorCreateViewModel viewModel)
{
try
{
var updatedInstructor = viewModel.Instructor;
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"UPDATE Instructors
SET FirstName = @firstname, LastName = @lastname, SlackHandle = @slackhandle, Speciality = @specialty, CohortId = @cohortId
WHERE Id = @id";
cmd.Parameters.Add(new SqlParameter("@firstname", updatedInstructor.FirstName));
cmd.Parameters.Add(new SqlParameter("@lastname", updatedInstructor.LastName));
cmd.Parameters.Add(new SqlParameter("@slackhandle", updatedInstructor.SlackHandle));
cmd.Parameters.Add(new SqlParameter("@specialty", updatedInstructor.Speciality));
cmd.Parameters.Add(new SqlParameter("@cohortId", updatedInstructor.CohortId));
cmd.Parameters.Add(new SqlParameter("@id", id));
cmd.ExecuteNonQuery();
}
return(RedirectToAction(nameof(Index)));
}
}
catch
{
return(View());
}
}
// GET: Instructors/Create
public ActionResult Create()
{
var viewModel = new InstructorCreateViewModel();
viewModel.Cohorts = cohortList();
return(View(viewModel));
}
public async Task <ActionResult> Create(InstructorCreateViewModel model)
{
try
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO instructors
( first_name, last_name, slack_handle, specialty, cohort_id )
VALUES
( @first_name, @last_name, @slack_handle, @specialty, @cohort_id )";
cmd.Parameters.Add(new SqlParameter("@first_name", model.instructor.FirstName));
cmd.Parameters.Add(new SqlParameter("@last_name", model.instructor.LastName));
cmd.Parameters.Add(new SqlParameter("@slack_handle", model.instructor.SlackHandle));
cmd.Parameters.Add(new SqlParameter("@specialty", model.instructor.Specialty));
cmd.Parameters.Add(new SqlParameter("@cohort_id", model.instructor.CohortId));
await cmd.ExecuteNonQueryAsync();
return(RedirectToAction(nameof(Index)));
}
}
}
catch
{
return(View());
}
}
public async Task <ActionResult> Edit(int id, InstructorCreateViewModel model)
{
try
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"UPDATE instructors
SET first_name = @first,
last_name = @last,
slack_handle = @slack,
specialty = @specialty,
cohort_id = @cohort
WHERE id = @id";
cmd.Parameters.Add(new SqlParameter("@first", model.instructor.FirstName));
cmd.Parameters.Add(new SqlParameter("@last", model.instructor.LastName));
cmd.Parameters.Add(new SqlParameter("@slack", model.instructor.SlackHandle));
cmd.Parameters.Add(new SqlParameter("@specialty", model.instructor.Specialty));
cmd.Parameters.Add(new SqlParameter("@cohort", model.instructor.CohortId));
cmd.Parameters.Add(new SqlParameter("@id", id));
await cmd.ExecuteNonQueryAsync();
return(RedirectToAction(nameof(Index)));
}
}
}
catch
{
return(View());
}
}
public async Task <ActionResult> Create(InstructorCreateViewModel viewModel)
{
try
{
var newInstructor = viewModel.Instructor;
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO Instructor
( FirstName, LastName, SlackHandle, CohortId )
VALUES
( @firstName, @lastName, @slackHandle, @cohortId )";
cmd.Parameters.Add(new SqlParameter("@firstName", newInstructor.FirstName));
cmd.Parameters.Add(new SqlParameter("@lastName", newInstructor.LastName));
cmd.Parameters.Add(new SqlParameter("@slackHandle", newInstructor.SlackHandle));
cmd.Parameters.Add(new SqlParameter("@cohortId", newInstructor.CohortId));
await cmd.ExecuteNonQueryAsync();
}
}
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
// GET: Instructors/Create
public ActionResult Create()
{
List <Cohort> cohorts = GetAllCohorts();
var viewModel = new InstructorCreateViewModel(cohorts);
return(View(viewModel));
}
public ActionResult Create(InstructorCreateViewModel viewModel)
{
try
{
// TODO: Add insert logic here
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = $@"INSERT INTO Instructor(FirstName, LastName, Slack, Specialty, CohortId)
VALUES(@firstname, @lastname, @slack, @specialty, @cohortId);";
cmd.Parameters.Add(new SqlParameter("@firstname", viewModel.Instructor.FirstName));
cmd.Parameters.Add(new SqlParameter("@lastname", viewModel.Instructor.LastName));
cmd.Parameters.Add(new SqlParameter("@slack", viewModel.Instructor.Slack));
cmd.Parameters.Add(new SqlParameter("@specialty", viewModel.Instructor.Specialty));
cmd.Parameters.Add(new SqlParameter("@cohortId", viewModel.Instructor.CohortId));
cmd.ExecuteNonQuery();
return(RedirectToAction(nameof(Index)));
}
}
}
catch
{
return(View());
}
}
// GET: Instructors/Create
public ActionResult Create()
{
InstructorCreateViewModel viewModel =
new InstructorCreateViewModel(_configuration.GetConnectionString("DefaultConnection"));
return(View(viewModel));
}
public ActionResult Create(InstructorCreateViewModel viewModel)
{
try
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO instructor (firstname, lastname, slackhandle, cohortid)
VALUES (@firstname, @lastname, @slackhandle, @cohortid)";
cmd.Parameters.Add(new SqlParameter("@firstname", viewModel.Instructor.FirstName));
cmd.Parameters.Add(new SqlParameter("@lastname", viewModel.Instructor.LastName));
cmd.Parameters.Add(new SqlParameter("@slackhandle", viewModel.Instructor.SlackHandle));
cmd.Parameters.Add(new SqlParameter("@cohortid", viewModel.Instructor.CohortId));
cmd.ExecuteNonQuery();
return(RedirectToAction(nameof(Index)));
}
}
}
catch
{
return(View(viewModel));
}
}
// GET: Instructor/Edit/5
public ActionResult Edit(int id)
{
using (SqlConnection conn = Connection)
{
var viewModel = new InstructorCreateViewModel();
var cohorts = GetAllCohorts();
var instructor = GetInstructor(id);
var selectItems = cohorts
.Select(cohort => new SelectListItem
{
Text = cohort.Name,
Value = cohort.Id.ToString()
})
.ToList();
selectItems.Insert(0, new SelectListItem
{
Text = "Choose cohort...",
Value = "0"
});
viewModel.Cohorts = selectItems;
viewModel.Instructor = instructor;
return(View(viewModel));
}
}
public ActionResult Create([FromForm] InstructorCreateViewModel model)
{
try
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO Instructor (FirstName, LastName, SlackHandle, CohortId, Specialty)
OUTPUT INSERTED.Id
VALUES (@firstName, @lastName, @slackHandle, @cohortId, @specialty)";
cmd.Parameters.Add(new SqlParameter("@firstName", model.Instructor.FirstName));
cmd.Parameters.Add(new SqlParameter("@lastName", model.Instructor.LastName));
cmd.Parameters.Add(new SqlParameter("@slackHandle", model.Instructor.SlackHandle));
cmd.Parameters.Add(new SqlParameter("@cohortId", model.Instructor.CohortId));
cmd.Parameters.Add(new SqlParameter("@specialty", model.Instructor.Specialty));
int newId = (int)cmd.ExecuteScalar();
model.Instructor.Id = newId;
return(RedirectToAction(nameof(Index)));
}
}
}
catch
{
return(View());
}
}
// GET: Instructors/Create
public ActionResult Create()
{
InstructorCreateViewModel viewModel = new InstructorCreateViewModel
{
Cohorts = GetAllCohorts()
};
return(View(viewModel));
}
// GET: Instructors/Create
public ActionResult Create()
{
var cohorts = GetAllCohorts();
var viewModel = new InstructorCreateViewModel()
{
Cohorts = cohorts
};
return(View(viewModel));
}
// GET: Instructors/Create
public async Task <IActionResult> Create()
{
var viewModel = new InstructorCreateViewModel()
{
Instructor = new Instructor(),
Cohorts = RenderSelectOptions(await GetAllCohorts())
};
return(View(viewModel));
}
public ActionResult Create(InstructorCreateViewModel viewModel)
{
try
{
InstructorRepository.CreateInstructor(viewModel);
return(View(viewModel));
}
catch
{
return(View());
}
}
//// GET: instructor/Create
public ActionResult Create(IFormCollection collection)
{
try
{
var model = new InstructorCreateViewModel(_config);
return(View(model));
}
catch
{
return(View());
}
}
// GET: Instructors/Edit/5
public ActionResult Edit(int id)
{
var cohorts = GetAllCohorts();
var instructor = GetInstructorById(id);
var viewModel = new InstructorCreateViewModel()
{
Cohorts = cohorts,
Instructor = instructor
};
return(View(viewModel));
}
// GET: Instructors/Create
public ActionResult Create()
{
{
// Create a new instance of a CreateStudentViewModel
// If we want to get all the cohorts, we need to use the constructor that's expecting a connection string.
// When we create this instance, the constructor will run and get all the cohorts.
InstructorCreateViewModel instructorViewModel = new InstructorCreateViewModel(_config.GetConnectionString("DefaultConnection"));
// Once we've created it, we can pass it to the view
return(View(instructorViewModel));
}
}
// GET: Instructors/Edit/5
public async Task <IActionResult> Edit(int id)
{
var viewModel = new InstructorCreateViewModel();
List <Task> tasks = new List <Task>()
{
Task.Run(async() => viewModel.Instructor = await GetOneInstructor(id)),
Task.Run(async() => viewModel.Cohorts = RenderSelectOptions(await GetAllCohorts()))
};
await Task.WhenAll(tasks);
return(View(viewModel));
}
// GET: Instructors/Edit/5
public ActionResult Edit(int id)
{
var viewModel = new InstructorCreateViewModel();
var cohorts = GetAllCohorts();
var selectItems = cohorts
.Select(cohort => new SelectListItem
{
Text = cohort.Name,
Value = cohort.Id.ToString()
})
.ToList();
selectItems.Insert(0, new SelectListItem
{
Text = "Choose cohort...",
Value = "0"
});
viewModel.Cohorts = selectItems;
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT i.Id, i.firstName, i.lastName, i.slackHandle, i.speciality, i.cohortId
FROM Instructor i
WHERE @id = i.id
";
cmd.Parameters.Add(new SqlParameter("@id", id));
SqlDataReader reader = cmd.ExecuteReader();
Instructor instructor = new Instructor();
while (reader.Read())
{
instructor = new Instructor
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
FirstName = reader.GetString(reader.GetOrdinal("firstName")),
LastName = reader.GetString(reader.GetOrdinal("lastName")),
SlackHandle = reader.GetString(reader.GetOrdinal("slackHandle")),
Specialty = reader.GetString(reader.GetOrdinal("speciality")),
CohortId = reader.GetInt32(reader.GetOrdinal("cohortId"))
};
viewModel.Instructor = instructor;
}
reader.Close();
}
}
return(View(viewModel));
}
public async Task <ActionResult> Create(InstructorCreateViewModel model)
{
string sql = $@"INSERT INTO Instructor
(FirstName, LastName, SlackHandle, CohortId)
VALUES
(
'{model.instructor.FirstName}'
,'{model.instructor.LastName}'
,'{model.instructor.SlackHandle}'
,{model.instructor.CohortId}
);";
using (IDbConnection conn = Connection)
{
var newId = await conn.ExecuteAsync(sql);
return(RedirectToAction(nameof(Index)));
}
}
public ActionResult Create()
{
var viewModel = new InstructorCreateViewModel();
var cohorts = GetAllCohorts();
var selectItems = cohorts
.Select(cohort => new SelectListItem
{
Text = cohort.Name,
Value = cohort.Id.ToString()
})
.ToList();
selectItems.Insert(0, new SelectListItem
{
Text = "Choose cohort...",
Value = "0"
});
viewModel.Cohorts = selectItems;
return(View(viewModel));
}
// GET: Instructor/Create
public ActionResult Create()
{
InstructorCreateViewModel model = new InstructorCreateViewModel(Connection);
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT i.Id,
i.FirstName,
i.LastName,
i.SlackHandle,
i.CohortId,
i.Specialty
FROM Instructor i
";
SqlDataReader reader = cmd.ExecuteReader();
Instructor instructor = null;
if (reader.Read())
{
instructor = new Instructor
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
FirstName = reader.GetString(reader.GetOrdinal("FirstName")),
LastName = reader.GetString(reader.GetOrdinal("LastName")),
SlackHandle = reader.GetString(reader.GetOrdinal("SlackHandle")),
CohortId = reader.GetInt32(reader.GetOrdinal("CohortId")),
Specialty = reader.GetString(reader.GetOrdinal("Specialty"))
};
}
reader.Close();
return(View(model));
}
}
}
public async Task <ActionResult> Create(InstructorCreateViewModel model)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO Instructor
( firstName, lastName, slackHandle, cohortId )
VALUES
( @firstName, @lastName, @slackHandle, @cohortId )";
cmd.Parameters.Add(new SqlParameter("@firstName", model.Instructor.firstName));
cmd.Parameters.Add(new SqlParameter("@lastName", model.Instructor.lastName));
cmd.Parameters.Add(new SqlParameter("@slackHandle", model.Instructor.slackHandle));
cmd.Parameters.Add(new SqlParameter("@cohortId", model.Instructor.cohortId));
cmd.ExecuteNonQuery();
return(RedirectToAction(nameof(Index)));
}
}
}
public async Task <ActionResult> Create(InstructorCreateViewModel model)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO Instructors
( InstructorName, SlackHandle, Specialty, CohortId )
VALUES
( @InstructorName, @SlackHandle, @Specialty, @CohortId )";
cmd.Parameters.Add(new SqlParameter("@InstructorName", model.Instructor.InstructorName));
cmd.Parameters.Add(new SqlParameter("@SlackHandle", model.Instructor.SlackHandle));
cmd.Parameters.Add(new SqlParameter("@Specialty", model.Instructor.Specialty));
cmd.Parameters.Add(new SqlParameter("@CohortId", model.Instructor.CohortId));
await cmd.ExecuteNonQueryAsync();
return(RedirectToAction(nameof(Index)));
}
}
}
public async Task <ActionResult> Create(InstructorCreateViewModel model)
{
// TODO: Add insert logic here
string sql = $@"
INSERT INTO Instructor
(FirstName, LastName, SlackHandle, Specialty, CohortId)
VALUES
(
'{model.instructor.FirstName}',
'{model.instructor.LastName}',
'{model.instructor.SlackHandle}',
'{model.instructor.Specialty}',
{model.instructor.CohortId}
)";
using (IDbConnection conn = Connection)
{
await conn.ExecuteAsync(sql);
return(RedirectToAction(nameof(Index)));
}
}
// create a new instance of an instructor using a view model to join separate tables of information
public static InstructorCreateViewModel CreateInstructor(InstructorCreateViewModel viewModel)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO Instructor (FirstName, LastName, SlackName, Specialty, CohortId)
OUTPUT INSERTED.Id
VALUES (@FirstName, @LastName, @SlackName, @Specialty, @CohortId)";
cmd.Parameters.Add(new SqlParameter("@FirstName", viewModel.Instructor.FirstName));
cmd.Parameters.Add(new SqlParameter("@LastName", viewModel.Instructor.LastName));
cmd.Parameters.Add(new SqlParameter("@SlackName", viewModel.Instructor.SlackName));
cmd.Parameters.Add(new SqlParameter("@Specialty", viewModel.Instructor.Specialty));
cmd.Parameters.Add(new SqlParameter("@CohortId", viewModel.Instructor.CohortId));
int newId = (int)cmd.ExecuteScalar();
viewModel.Instructor.Id = newId;
return(viewModel);
}
}
}
public ActionResult Create()
{
var viewModel = new InstructorCreateViewModel()
{
Cohorts = GetAllCohorts()
};
//var cohorts = GetAllCohorts();
//var selectItems = cohorts
// .Select(cohort => new SelectListItem
// {
// Text = cohort.CohortName,
// Value = cohort.Id.ToString()
// })
// .ToList();
//selectItems.Insert(0, new SelectListItem
//{
// Text = "Choose cohort...",
// Value = "0"
//});
//viewModel.Cohorts = selectItems;
return(View(viewModel));
}
// GET: Instructors/Create
public ActionResult Create()
{
var model = new InstructorCreateViewModel(_config);
return(View(model));
}
