public async Task <IActionResult> Create([Bind("DeadlineId,SubjectID,DeadlineTypeID,DeadlineDate,DeadlineNotes")] New_Deadline New_Deadline) { if (ModelState.IsValid) { _context.Database.ExecuteSqlRaw("EXEC New_Deadline @SubjectID,@DeadlineTypeID,@DeadlineDate, @DeadlineNotes", new Microsoft.Data.SqlClient.SqlParameter("@SubjectID", Int32.Parse(New_Deadline.SubjectID.ToString())), new Microsoft.Data.SqlClient.SqlParameter("@DeadlineTypeID", Int32.Parse(New_Deadline.DeadlineTypeID.ToString())), new Microsoft.Data.SqlClient.SqlParameter("@DeadlineDate", DateTime.Parse(New_Deadline.DeadlineDate.ToString())), new Microsoft.Data.SqlClient.SqlParameter("@DeadlineNotes", New_Deadline.DeadlineNotes.ToString())); await _context.SaveChangesAsync(); return(RedirectToAction("Index", "Child")); } ViewData["DeadlineTypeId"] = new SelectList(_context.DeadlineTypes, "DeadlineTypeId", "DeadlineTypeName", New_Deadline.DeadlineTypeID); ViewData["SubjectId"] = new SelectList(_context.Subjects, "SubjectId", "SubjectName", New_Deadline.SubjectID); return(View(New_Deadline)); }
public async Task <IActionResult> Create([Bind("FamilyMemberID,AppointmentTypeID,AppointmentDate,AppointmentNotes")] New_Appointment appointment) { if (ModelState.IsValid) { _context.Database.ExecuteSqlRaw("EXEC New_Appointment @FamilyMemberID, @AppointmentTypeID, @AppointmentDate, @AppointmentNotes", new Microsoft.Data.SqlClient.SqlParameter("@FamilyMemberID", Int32.Parse(appointment.FamilyMemberID.ToString())), new Microsoft.Data.SqlClient.SqlParameter("@AppointmentTypeID", Int32.Parse(appointment.AppointmentTypeID.ToString())), new Microsoft.Data.SqlClient.SqlParameter("@AppointmentDate", DateTime.Parse(appointment.AppointmentDate.ToString())), new Microsoft.Data.SqlClient.SqlParameter("@AppointmentNotes", appointment.AppointmentNotes.ToString())); await _context.SaveChangesAsync(); TempData["IsValid"] = true; return(RedirectToAction("Index", "Parent")); } ViewData["AppointmentTypeId"] = new SelectList(_context.AppointmentTypes, "AppointmentTypesId", "AppointmentTypeName", appointment.AppointmentTypeID); ViewData["FamilyMemberId"] = new SelectList(_context.FamilyMembers, "FamilyMemberId", "FamilyMemberName", appointment.FamilyMemberID); return(View(appointment)); }