public ActionResult Create(MDTModel model)//FormCollection collection)
{
try
{
using (var db = new MyDbContext("Name=MDTDbConn"))
{
Guid rowid = Guid.NewGuid();
var mdt = db.Set <MdtEpisode>();
mdt.Add(new MdtEpisode
{
Comorbidities = model.Comorbidities,
History = model.History,
MdtDate = model.MDTDate,
MdtDiscussion = model.MDTDiscussion,
MdtPatientId = model.MDTPatientId,
RowGuid = rowid,
DateCreated = DateTime.Now,
UserId = 1
});
db.SaveChanges();
model.MdtId = db.MdtEpisodes.Where(x => x.RowGuid == rowid).FirstOrDefault().MdtId;
};
return(RedirectToAction("Details", "MDT", new { id = model.MdtId }));
}
catch (Exception ex)
{
return(View());
}
}
// GET: PatientInformation/Details/5
public ActionResult Details(int?id = 0)
{
MDTModel model = new MDTModel();
if (id != null && id > 0)
{
if (id != null && id != 0)
{
model.MDTPatientId = Convert.ToInt32(id);
}
using (var db = new MyDbContext("Name=MDTDbConn"))
{
var patient = db.PatientInformations.FirstOrDefault(x => x.PatientId == id);
if (patient != null)
{
model.Patient.FirstName = patient.FirstName;
model.Patient.LastName = patient.LastName;
model.Patient.NhsNo = patient.NhsNo;
model.Patient.PatientId = patient.PatientId;
model.Patient.AddressLine1 = patient.AddressLine1;
model.Patient.AddressLine2 = patient.AddressLine2;
model.Patient.City = patient.City;
model.Patient.DateofBirth = patient.DateofBirth;
model.Patient.GpAddressLine1 = patient.GpAddressLine1;
model.Patient.GpAddressLine2 = patient.GpAddressLine2;
model.Patient.GpCity = patient.GpCity;
model.Patient.GpName = patient.GpName;
model.Patient.GpPostcode = patient.GpPostcode;
model.Patient.HospitalNo = patient.HospitalNo;
model.Patient.Postcode = patient.Postcode;
}
var mdt = db.MdtEpisodes.OrderByDescending(x => x.MdtDate).FirstOrDefault(x => x.MdtPatientId == id);
if (mdt != null)
{
model.Comorbidities = mdt.Comorbidities;
model.History = mdt.History;
model.MDTDate = mdt.MdtDate;
model.MDTDiscussion = mdt.MdtDiscussion;
model.MdtId = mdt.MdtId;
}
IList <MDTDetails> mDTDetails = new List <MDTDetails>();
var MdtDetails = db.MdtEpisodes.Where(x => x.MdtPatientId == patient.PatientId).OrderByDescending(x => x.MdtDate).ToList();
if (MdtDetails != null)
{
foreach (var mdtdetail in MdtDetails)
{
mDTDetails.Add(new MDTDetails {
MDTId = mdtdetail.MdtId, MDTDate = mdtdetail.MdtDate
});
}
}
model.MDTEpisode = mDTDetails;
}
return(View(model));
}
return(View(model));
}
