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