public bool AddProcedure(PatientRecordProcedure PatientProcedure)
{
using (var sql = new NpgsqlConnection(strConnection))
{
sql.Execute(@"INSERT INTO PatientsRecordProcedure (PatientRecordID,ProcedureID,DentistID,Description,Value,Date)
VALUES (@PatientRecordID,@ProcedureID,@DentistID,@Description,@Value,@Date)",
new
{
PatientRecordID = PatientProcedure.PatientRecordID,
ProcedureID = PatientProcedure.ProcedureID,
DentistID = PatientProcedure.DentistID,
Description = PatientProcedure.Description,
Value = PatientProcedure.Value,
Date = PatientProcedure.Date,
});
return(true);
}
}
public IActionResult AddProcedure(PatientRecordProcedure Model)
{
if (!ModelState.IsValid)
{
var patient = PatientsDAO.GetById(Model.PatientRecordID);
ViewData["Section"] = "Pacientes";
ViewData["Action"] = "Criar Novo Procedimento";
ViewBag.Procedures = ProceduresDAO.GetAll(Convert.ToInt32(HttpContext.Session.GetInt32("clinicId")));
ViewBag.Dentists = DentistsDAO.GetAll(Convert.ToInt32(HttpContext.Session.GetInt32("clinicId")));
ViewBag.PatientName = patient.Name;
return(View(Model));
}
PatientRecordDAO.AddProcedure(Model);
return(RedirectToAction("Records", new { id = Model.PatientRecordID }));
}
public IActionResult AddProcedure(int id)
{
var patient = PatientsDAO.GetById(id);
if (patient == null)
{
return(RedirectToAction("Index", "Dashboard"));
}
var procedure = new PatientRecordProcedure();
procedure.PatientRecordID = id;
ViewData["Section"] = "Pacientes";
ViewData["Action"] = "Criar Novo Procedimento";
ViewBag.Procedures = ProceduresDAO.GetAll(Convert.ToInt32(HttpContext.Session.GetInt32("clinicId")));
ViewBag.Dentists = DentistsDAO.GetAll(Convert.ToInt32(HttpContext.Session.GetInt32("clinicId")));
ViewBag.PatientName = patient.Name;
return(View(procedure));
}
