// GET: mains/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BBSPATIENT Patient = bbs.PATIENTS.Find(id);
if (Patient == null)
{
return(HttpNotFound());
}
//Test requests
var testrequests = (
from rq in bbs.REQUESTS
join test in bbs.TESTS
on rq.ACCESSNUMBER equals test.ACCESSNUMBER
where rq.PATNUMBER == id
orderby rq.REQDATE descending
select new
{
RequestDate = rq.REQDATE,
AccessNumber = rq.ACCESSNUMBER,
TestCode = test.TESTCODE,
TestResult = test.RESULT
}
).ToList();
//Create array for populating results table
int ireq = testrequests.Select(x => x.AccessNumber).Distinct().Count();
ViewBag.TestCount = ireq;
string abo = "", rh = "", reqvaliddate = "none";
int aboerr = 0, rherr = 0, abserr = 0, abonum = 0, absnum = 0, reqvalid = 0;
if (ireq > 0)
{
int j = 0;
string[,] res = new string[ireq, 8];
string accnum = testrequests.First().AccessNumber;
for (int i = 0; i < testrequests.Count(); i++)
{
if (accnum != testrequests[i].AccessNumber)
{
j = j + 1;
accnum = testrequests[i].AccessNumber;
}
res[j, 0] = testrequests[i].AccessNumber;
res[j, 1] = testrequests[i].RequestDate.Value.ToString("HH:mm dd MMM yyyy");
switch (testrequests[i].TestCode)
{
case "RJ":
res[j, 2] = testrequests[i].TestResult;
break;
case "GROUP":
case "ABO":
res[j, 3] = testrequests[i].TestResult;
//Check for any abo discrepancies
if (abo == "" && testrequests[i].TestResult != null)
{
abo = testrequests[i].TestResult;
abonum = abonum + 1;
}
else
{
abonum = abonum + 1;
}
if (testrequests[i].TestResult != abo && testrequests[i].TestResult != null)
{
aboerr = 1;
}
//Check if any sample with ABO determination within last 3 days
if (testrequests[i].RequestDate != null && (DateTime.Today - testrequests[i].RequestDate).Value.Days < 7)
{
reqvalid = reqvalid + 1;
reqvaliddate = testrequests[i].RequestDate.ToString();
}
break;
case "RH":
res[j, 4] = testrequests[i].TestResult;
//Check for any rh discrepancies
if (rh == "" && testrequests[i].TestResult != null)
{
rh = testrequests[i].TestResult;
}
if (testrequests[i].TestResult != rh && testrequests[i].TestResult != null)
{
rherr = 1;
}
break;
case "DAT":
res[j, 5] = testrequests[i].TestResult;
break;
case "ABS":
res[j, 6] = testrequests[i].TestResult;
//Count number of abs with neg results
if (testrequests[i].TestResult != null && testrequests[i].TestResult.Contains("ABNEG"))
{
absnum = absnum + 1;
}
//Check for any abs positives
if (testrequests[i].TestResult != null && testrequests[i].TestResult.Contains("ABPOS"))
{
abserr = abserr + 1;
}
break;
case "ABID":
res[j, 7] = testrequests[i].TestResult;
break;
}
}
ViewData["TestResults"] = res;
ViewBag.AboErr = aboerr; ViewBag.RhErr = rherr; ViewBag.AbsErr = abserr; ViewBag.Abonum = abonum; ViewBag.Absnum = absnum;
ViewBag.ReqValid = reqvalid; ViewBag.ReqValidDate = reqvaliddate;
}
//Product requests
var prodrequests = (
from p in bbs.PATIENTS
join r in bbs.REQUESTS on p.PATNUMBER equals r.PATNUMBER into List1
from r in List1.DefaultIfEmpty()
join rp in bbs.REQUEST_PRODUCT on r.ACCESSNUMBER equals rp.ACCESSNUMBER into List2
from rp in List2.DefaultIfEmpty()
join pr in bbs.PRODUCTS on rp.PRODUCTID equals pr.PRODUCTID into List3
from pr in List3.DefaultIfEmpty()
where p.PATNUMBER == id
orderby r.REQDATE descending
select new
{
Patnumber = p.PATNUMBER,
PatName = p.NAME,
BirthDate = p.BIRTHDATE,
Sex = p.SEX,
Patgroup = p.PATGROUP,
Abo = p.ABO,
Rh = p.RHFACTOR,
Rhpheno = p.RHPHENO,
Ab = p.ANTIBODIES,
Accessno = r.ACCESSNUMBER,
Reqdate = r.REQDATE,
Prodcode = pr.PRODCODE,
Prodnum = pr.PRODNUM,
Mstatus = rp.MSTATUS,
Pstatus = rp.PSTATUS,
Reservdate = rp.RESERVDATE,
Xmatchdate = rp.XMATCHDATE,
Issuedate = rp.ISSUEDATE,
Returndate = rp.RETURNDATE,
Transreaction = rp.TRANSREACTION
}).ToList()
.Select(x => new PatientDetailViewModel()
{
PATNUMBER = x.Patnumber,
NAME = x.PatName,
BIRTHDATE = x.BirthDate,
SEX = x.Sex,
PATGROUP = x.Patgroup,
ABO = x.Abo,
RHFACTOR = x.Rh,
RHPHENO = x.Rhpheno,
ANTIBODIES = x.Ab,
ACCESSNUMBER = x.Accessno,
REQDATE = x.Reqdate,
PRODCODE = x.Prodcode,
PRODNUM = x.Prodnum,
MSTATUS = x.Mstatus,
PSTATUS = x.Pstatus,
RESERVDATE = x.Reservdate,
XMATCHDATE = x.Xmatchdate,
ISSUEDATE = x.Issuedate,
RETURNDATE = x.Returndate,
TRANSREACTION = x.Transreaction
});
if (prodrequests.Count(x => x.PRODNUM != null) > 0)
{
ViewBag.Rccount = prodrequests.Count(x => x.PRODNUM != null && x.PRODCODE.Substring(0, 2) == "RC");
ViewBag.Xm = prodrequests.Count(x => x.PRODNUM != null && x.PRODCODE.Substring(0, 2) == "RC" && x.MSTATUS == 2);
ViewBag.Reserved = prodrequests.Count(x => x.PRODNUM != null && x.PRODCODE.Substring(0, 2) == "RC" && x.PSTATUS == 2);
ViewBag.Issued = prodrequests.Count(x => x.PRODNUM != null && x.PRODCODE.Substring(0, 2) == "RC" && x.PSTATUS == 3);
ViewBag.Transfused = prodrequests.Count(x => x.PRODNUM != null && x.PRODCODE.Substring(0, 2) == "RC" && x.PSTATUS == 4);
ViewBag.Returned = prodrequests.Count(x => x.PRODNUM != null && x.PRODCODE.Substring(0, 2) == "RC" && x.PSTATUS == 6);
ViewBag.Reaction = prodrequests.Count(x => x.PRODNUM != null && x.PRODCODE.Substring(0, 2) == "RC" && x.PSTATUS == 9);
ViewBag.InReserve = prodrequests.Count(x => x.PRODNUM != null && x.PRODCODE.Substring(0, 2) == "RC" && x.PSTATUS == 2 && (DateTime.Today - x.XMATCHDATE).Value.Days < 3);
ViewBag.Plcount = prodrequests.Count(x => x.PRODNUM != null && x.PRODCODE.Substring(0, 2) == "PL");
ViewBag.PlIssued = prodrequests.Count(x => x.PRODNUM != null && x.PRODCODE.Substring(0, 2) == "PL" && x.PSTATUS == 3);
ViewBag.PlTransfused = prodrequests.Count(x => x.PRODNUM != null && x.PRODCODE.Substring(0, 2) == "PL" && x.PSTATUS == 4);
ViewBag.PlReturned = prodrequests.Count(x => x.PRODNUM != null && x.PRODCODE.Substring(0, 2) == "PL" && x.PSTATUS == 6);
ViewBag.Fpcount = prodrequests.Count(x => x.PRODNUM != null && (x.PRODCODE.Substring(0, 2) == "FF" || x.PRODCODE.Substring(0, 2) == "CR"));
ViewBag.FpIssued = prodrequests.Count(x => x.PRODNUM != null && (x.PRODCODE.Substring(0, 2) == "FF" || x.PRODCODE.Substring(0, 2) == "CR") && x.PSTATUS == 3);
ViewBag.FpTransfused = prodrequests.Count(x => x.PRODNUM != null && (x.PRODCODE.Substring(0, 2) == "FF" || x.PRODCODE.Substring(0, 2) == "CR") && x.PSTATUS == 4);
ViewBag.FpReturned = prodrequests.Count(x => x.PRODNUM != null && (x.PRODCODE.Substring(0, 2) == "FF" || x.PRODCODE.Substring(0, 2) == "CR") && x.PSTATUS == 6);
}
else
{
ViewBag.Rccount = 0;
ViewBag.Plcount = 0;
ViewBag.Fpcount = 0;
}
ViewBag.Tcount = prodrequests.Count();
//LMD results for chart
var result = (
from tst in lmd.TESTS
join rq in lmd.REQUESTS
on tst.REQUESTID equals rq.REQUESTID
join pt in lmd.PATIENTS
on rq.PATID equals pt.PATID
where pt.PATNUMBER == id && (tst.CHAPID == 36 | tst.CHAPID == 40) &&
tst.RESVALUE != null && rq.COLLECTIONDATE != null
orderby rq.COLLECTIONDATE ascending
select new
{
Interval = DbFunctions.DiffDays(DateTime.Now, rq.COLLECTIONDATE),
Resvalue = tst.RESVALUE,
TestId = tst.TESTID
}
).ToList();
//Hgb
var hgb = result.Where(i => i.TestId == 2719).ToList();
int iHgb = hgb.Count;
ViewBag.iHgb = iHgb;
string cHgb = "";
if (iHgb > 0)
{
double[] y = new double[iHgb];
string[] x = new string[iHgb];
for (int i = 0; i < iHgb; i++)
{
if (double.TryParse(hgb[i].Resvalue, out double temp))
{
y[i] = temp;
x[i] = hgb[i].Interval.ToString();
}
}
ViewBag.xHb = x;
ViewBag.yHb = y;
int UHgb = x.GetUpperBound(0);
ViewBag.UHgb = UHgb;
switch (x[UHgb])
{
case "0":
cHgb = "The patient's last Hb result was " + y[UHgb] + "g/L checked today.";
break;
case "-1":
case "-2":
case "-3":
cHgb = "The patient's last Hb result was " + y[UHgb] + " g/L checked " + x[UHgb] + " days ago.";
break;
default:
cHgb = "The patient's last Hb result was " + y[UHgb] + " g/L checked " + x[UHgb] + " days ago. " +
"Please ensure a recent Hb level has been determined " +
"before proceeding to order red cells.";
break;
}
}
else
{
cHgb = "No Hb results are available for this patient. Please ensure that the Hb level has been determined " +
"before proceeding to order red cells.";
double[] y = { 0 };
ViewBag.yHb = y;
ViewBag.UHgb = 0;
}
ViewBag.cHgb = cHgb;
//Mcv
var mcv = result.Where(i => i.TestId == 1848).ToList();
int iMcv = mcv.Count;
ViewBag.iMcv = iMcv;
string cMcv = "";
if (iMcv > 0)
{
int[] y = new int[iMcv];
string[] x = new string[iMcv];
for (int i = 0; i < iMcv; i++)
{
if (int.TryParse(mcv[i].Resvalue, out int temp))
{
y[i] = temp;
x[i] = mcv[i].Interval.ToString();
if (y[i] < 76)
{
cMcv = "The patient's MCV is " + y[i] + " fL which is low. " +
"Investigations to exclude iron deficiency or thalassaemia would be advised, if not already done. " +
"Iron therapy would be warranted before an elective red cell transfusion, if there is evidence to indicate iron deficiency.";
}
else
{
cMcv = "";
}
}
}
ViewBag.xMcv = x;
ViewBag.yMcv = y;
}
ViewBag.cMcv = cMcv;
//Platelet
var plt = result.Where(i => i.TestId == 1999).ToList();
int iPlt = plt.Count;
string cPlt = "";
ViewBag.iPlt = iPlt;
if (iPlt > 0)
{
double[] y = new double[iPlt];
string[] x = new string[iPlt];
for (int i = 0; i < iPlt; i++)
{
if (double.TryParse(plt[i].Resvalue, out double temp))
{
y[i] = temp;
x[i] = plt[i].Interval.ToString();
}
}
ViewBag.xPlt = x;
ViewBag.yPlt = y;
int UPlt = x.GetUpperBound(0);
ViewBag.UPlt = UPlt;
switch (x[UPlt])
{
case "0":
cPlt = "The patient's last platelet count was " + y[UPlt] + " x 10^9/L checked today.";
break;
case "-1":
cPlt = "The patient's last platelet count was " + y[UPlt] + " x 10^9/L checked yesterday.";
break;
default:
cPlt = "The patient's last platelet count was " + y[UPlt] + " x 10^9/L checked " + x[UPlt] + " days ago. " +
"Please ensure a recent platelet count has been determined " +
"before proceeding to order platelets.";
break;
}
}
else
{
cPlt = "No platelet counts are available for this patient. Please ensure that the platelet count has been determined " +
"before proceeding to order platelets.";
double[] y = { 0 };
ViewBag.yPlt = y;
ViewBag.UPlt = 0;
}
ViewBag.cPlt = cPlt;
//INR
var inr = result.Where(i => i.TestId == 2761).ToList();
int iInr = inr.Count;
string cInr = "";
ViewBag.iInr = iInr;
if (iInr > 0)
{
double[] y = new double[iInr];
string[] x = new string[iInr];
for (int i = 0; i < iInr; i++)
{
if (double.TryParse(inr[i].Resvalue, out double temp))
{
y[i] = temp;
x[i] = inr[i].Interval.ToString();
}
}
ViewBag.xInr = x;
ViewBag.yInr = y;
int UInr = x.GetUpperBound(0);
ViewBag.UInr = UInr;
switch (x[UInr])
{
case "0":
cInr = "The patient's last INR was " + y[UInr] + " checked today.";
break;
case "-1":
cInr = "The patient's last INR was " + y[UInr] + " checked yesterday.";
break;
default:
cInr = "The patient's last INR was " + y[UInr] + " checked " + x[UInr] + " days ago. " +
"Please ensure a recent INR has been determined " +
"before proceeding to order ffp or plasma derivatives.";
break;
}
}
else
{
cInr = "No INR results available for this patient. Please ensure that the INR has been determined " +
"before proceeding to order FFP or plasma derivatives.";
double[] y = { 0 };
ViewBag.yInr = y;
ViewBag.UInr = 0;
}
ViewBag.cInr = cInr;
//APTT
var apt = result.Where(i => i.TestId == 2704).ToList();
int iApt = apt.Count;
ViewBag.iApt = iApt;
if (iApt > 0)
{
double[] y = new double[iApt];
string[] x = new string[iApt];
for (int i = 0; i < iApt; i++)
{
if (double.TryParse(apt[i].Resvalue, out double temp))
{
y[i] = temp;
x[i] = apt[i].Interval.ToString();
}
}
ViewBag.xApt = x;
ViewBag.yApt = y;
int UApt = x.GetUpperBound(0);
ViewBag.UApt = UApt;
}
else
{
double[] y = { 0 };
ViewBag.yApt = y;
ViewBag.UApt = 0;
}
//Fibrinogen
var fbg = result.Where(i => i.TestId == 1451).ToList();
int iFbg = fbg.Count;
ViewBag.iFbg = iFbg;
if (iFbg > 0)
{
double[] y = new double[iFbg];
string[] x = new string[iFbg];
for (int i = 0; i < iFbg; i++)
{
if (double.TryParse(fbg[i].Resvalue, out double temp))
{
y[i] = temp;
x[i] = fbg[i].Interval.ToString();
}
}
ViewBag.xFbg = x;
ViewBag.yFbg = y;
int UFbg = x.GetUpperBound(0);
ViewBag.UFbg = UFbg;
ViewBag.FbgInterval = x[UFbg];
}
else
{
double[] y = { 0 };
ViewBag.yFbg = y;
ViewBag.UFbg = 0;
}
//Create table for choosing blood products
ProductInfoModel productInfoModel = new ProductInfoModel();
ViewBag.ProductInfo = productInfoModel.ProductInfoAll();
//Create dropdown for indications
ProductInfoModel IndicationModel = new ProductInfoModel();
ViewBag.Indications = IndicationModel.IndicationAll();
//return View("Details",Patient);
return(View("Details", prodrequests));
}
