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)); }