public ActionResult Edit(ExaminationResultViewModel[] examResults)
{
var formModel = examResults.Single();
ExaminationResult dbObject;
if (formModel.Id == null)
{
dbObject = new ExaminationResult
{
CreatedOn = this.GetUtcNow(),
PatientId = formModel.PatientId.Value,
PracticeId = this.DbUser.PracticeId,
};
this.db.ExaminationResults.AddObject(dbObject);
}
else
{
var practiceId = this.DbUser.PracticeId;
dbObject = this.db.ExaminationResults
.Where(r => r.Id == formModel.Id)
.FirstOrDefault(r => r.Patient.Doctor.Users.FirstOrDefault().PracticeId == practiceId);
// If modelObj is null, we must tell the user that this object does not exist.
if (dbObject == null)
{
return(View("NotFound", formModel));
}
// Security issue... must check current user practice against the practice of the edited objects.
var currentUser = this.DbUser;
if (currentUser.PracticeId != dbObject.Patient.Doctor.Users.First().PracticeId)
{
return(View("NotFound", formModel));
}
}
if (this.ModelState.IsValid)
{
dbObject.Patient.IsBackedUp = false;
dbObject.Text = formModel.Text;
dbObject.MedicalProcedureName = formModel.MedicalProcedureName;
dbObject.MedicalProcedureCode = formModel.MedicalProcedureId.HasValue
? this.db.SYS_MedicalProcedure.Where(mp => mp.Id == formModel.MedicalProcedureId).Select(mp => mp.Code).FirstOrDefault()
: formModel.MedicalProcedureCode;
dbObject.ExaminationDate = this.ConvertToUtcDateTime(formModel.ExaminationDate.Value);
dbObject.ReceiveDate = this.ConvertToUtcDateTime(formModel.ReceiveDate.Value);
this.db.SaveChanges();
return(this.View("Details", GetViewModel(dbObject, this.GetToLocalDateTimeConverter())));
}
return(this.View("Edit", formModel));
}
public void updateExaminationResult(ExaminationResult ExaminationResult)
{
var record = db.ExaminationResults.Where(x => x.ExaminationResultID == ExaminationResult.ExaminationResultID).FirstOrDefault();
// record.DoctorID = ExaminationResult.DoctorID;
record.DispenserID = ExaminationResult.DispenserID;
// record.Time = ExaminationResult.Time;
// record.Result = ExaminationResult.Result;
// record.PatientID = ExaminationResult.PatientID;
// record.Description = ExaminationResult.Description;
db.SubmitChanges();
}
public void Delete_WhenTheresAnExamResult()
{
PatientsController controller;
int patientId;
Patient patient;
try
{
var doctor = Firestarter.Create_CrmMg_Psiquiatria_DrHouse_Andre(this.db);
var mr = new MockRepository(true);
controller = mr.CreateController <PatientsController>();
Firestarter.CreateFakePatients(doctor, this.db, 1);
// we now have 1 patient
patient = this.db.Patients.FirstOrDefault();
Assert.IsNotNull(patient);
patientId = patient.Id;
var examResult = new ExaminationResult()
{
MedicalProcedureCode = "mcode",
MedicalProcedureName = "mname",
PatientId = patientId,
CreatedOn = DateTime.UtcNow,
Text = "tudo deu certo",
PracticeId = doctor.PracticeId,
};
this.db.SYS_MedicalProcedure.AddObject(
new SYS_MedicalProcedure()
{
Code = "mcode",
Name = "mname"
});
this.db.ExaminationResults.AddObject(examResult);
this.db.SaveChanges();
}
catch
{
Assert.Inconclusive("Test initialization has failed.");
return;
}
controller.Delete(patientId);
// this patient must have been deleted
patient = this.db.Patients.FirstOrDefault(p => p.Id == patientId);
Assert.IsNull(patient);
}
public static ExaminationResultViewModel GetViewModel(ExaminationResult examResult, Func <DateTime, DateTime> toLocal)
{
return(new ExaminationResultViewModel
{
Id = examResult.Id,
PatientId = examResult.PatientId,
Text = examResult.Text,
MedicalProcedureCode = examResult.MedicalProcedureCode,
MedicalProcedureName = examResult.MedicalProcedureName,
ExaminationDate = toLocal(examResult.ExaminationDate),
ReceiveDate = toLocal(examResult.ReceiveDate),
});
}
public bool updateExaminationResult(eExaminationResult e)
{
try
{
ExaminationResult temp = new ExaminationResult();
temp.Description = e.Description;
temp.DispenserID = Convert.ToInt32(e.DispenserID);
temp.DoctorID = e.DoctorID;
temp.ExaminationResultID = e.ExaminationResultID;
temp.PatientID = e.PatientID;
temp.Time = e.Time;
temp.Result = e.Result;
erdal.updateExaminationResult(temp);
return(true);
}
catch
{
return(false);
}
}
public int insertExaminationResult(eExaminationResult e)
{
try
{
ExaminationResult temp = new ExaminationResult();
temp.Description = e.Description;
temp.DispenserID = null;
temp.DoctorID = e.DoctorID;
temp.PatientID = e.PatientID;
temp.Time = DateTime.Now;
temp.Result = e.Result;
int id = erdal.insertExaminationResult(temp);
PartientOfDay pod = new PartientOfDay();
pod.PartientID = temp.PatientID;
pod.Status = true;
potdal.updatePartientOfDay(pod);
return(id);
}
catch
{
return(0);
}
}
public int insertExaminationResult(ExaminationResult ExaminationResult)
{
db.ExaminationResults.InsertOnSubmit(ExaminationResult);
db.SubmitChanges();
return(ExaminationResult.ExaminationResultID);
}
public Task AddAsync(ExaminationResult result)
{
resultsDataSet.Add(result);
return(dbContext.SaveChangesAsync());
}
public void insertExaminationResult(ExaminationResult ExaminationResult)
{
db.ExaminationResults.InsertOnSubmit(ExaminationResult);
db.SubmitChanges();
}