/// <summary>
///US:1883 Abstract save control method
/// </summary>
/// <returns></returns>
public override CStatus SaveControl()
{
CPatientItemData itemData = new CPatientItemData(BaseMstr.BaseData);
CStatus status = new CStatus();
long lPatItemID = -1;
if (ddlItems.SelectedItem.Text == "[New Result]")
{
//load an item for insert
CPatientItemDataItem di = new CPatientItemDataItem();
di.PatientID = PatientID;
di.ItemID = ItemID;
di.SourceTypeID = (long)k_SOURCE_TYPE_ID.VAPPCT;
//get the date time, which is a combination of the 2 controls
di.EntryDate = CDataUtils.GetDate(txtEntryDate.Text, ucTimePicker.HH, ucTimePicker.MM, ucTimePicker.SS);
// build a list of all the item components in the grid view
CPatientItemCompList PatItemCompList = null;
status = BuildPatItemCompList(out PatItemCompList);
if (!status.Status)
{
return(status);
}
// insert the patient item and all of its item components
status = itemData.InsertPatientItem(di, PatItemCompList, out lPatItemID);
if (!status.Status)
{
return(status);
}
}
else
{
lPatItemID = CDropDownList.GetSelectedLongID(ddlItems);
}
// update the comments if there is a new one
if (!string.IsNullOrEmpty(txtComment.Text))
{
status = itemData.InsertPatientItemComment(lPatItemID, ItemID, txtComment.Text);
if (!status.Status)
{
return(status);
}
}
//show status
return(new CStatus());
}
/// <summary>
/// US:1883 method
/// builds a list of all the item components for an item from the controls on the page
/// </summary>
/// <param name="PatItemCompList"></param>
/// <returns></returns>
private CStatus BuildPatItemCompList(out CPatientItemCompList PatItemCompList)
{
PatItemCompList = new CPatientItemCompList();
//insert components
foreach (GridViewRow gr in gvComponents.Rows)
{
// create patient item component data item for the grid view row
CPatientItemComponentDataItem di = new CPatientItemComponentDataItem();
di.PatientID = PatientID;
di.ItemID = (ItemTypeID == (long)k_ITEM_TYPE_ID.Collection) ? Convert.ToInt64(ddlColItems.SelectedValue) : ItemID;
di.ComponentID = Convert.ToInt64(gvComponents.DataKeys[gr.DataItemIndex][nItemComponentIDIndex]);
RadioButton rbSelect = (RadioButton)gr.FindControl("rbSelComponent");
TextBox txtVal = (TextBox)gr.FindControl("txtValue");
if (rbSelect == null || txtVal == null)
{
return(new CStatus(false, k_STATUS_CODE.Failed, "TODO"));
}
//switch on the type and get the value
switch ((k_ITEM_TYPE_ID)ItemTypeID)
{
// laboratory and question free text components are handled the same
case k_ITEM_TYPE_ID.Laboratory:
case k_ITEM_TYPE_ID.QuestionFreeText:
// get the value from the text box
di.ComponentValue = txtVal.Text;
PatItemCompList.Add(di);
break;
case k_ITEM_TYPE_ID.QuestionSelection:
// get the value from the radio button
di.ComponentValue = Convert.ToInt64((rbSelect.Checked) ? k_TRUE_FALSE_ID.True : k_TRUE_FALSE_ID.False).ToString();
PatItemCompList.Add(di);
break;
default:
PatItemCompList = null;
return(new CStatus(false, k_STATUS_CODE.Failed, "TODO"));
}
}
return(new CStatus(true, k_STATUS_CODE.Success, "TODO"));
}
/// <summary>
/// method
/// inserts a patient item and all of its components
/// if the inserts are successful
/// </summary>
/// <param name="diPatItem"></param>
/// <param name="PatItemCompList"></param>
/// <param name="lPatItemID"></param>
/// <returns></returns>
public CStatus InsertPatientItem(CPatientItemDataItem diPatItem, CPatientItemCompList PatItemCompList, out long lPatItemID)
{
CStatus status = InsertPatientItem(diPatItem, out lPatItemID);
if (!status.Status)
{
return(status);
}
foreach (CPatientItemComponentDataItem diPatItemComp in PatItemCompList)
{
diPatItemComp.PatItemID = lPatItemID;
status = InsertPatientItemComponent(diPatItemComp);
if (!status.Status)
{
return(status);
}
}
return(status);
}
/// <summary>
/// update a patient item and re-run logic
/// </summary>
/// <param name="diPatItem"></param>
/// <param name="PatItemCompList"></param>
/// <returns></returns>
public CStatus UpdatePatientItem(CPatientItemDataItem diPatItem,
CPatientItemCompList PatItemCompList)
{
CStatus status = new CStatus();
//really no reason to update the patient item
//status = UpdatePatientItem(diPatItem);
//if (!status.Status)
//{
// return status;
// }
//loop and update each component
foreach (CPatientItemComponentDataItem diPatItemComp in PatItemCompList)
{
status = UpdatePatientItemComponent(diPatItemComp);
if (!status.Status)
{
return(status);
}
}
return(status);
}
/// <summary>
/// gets the item state id
/// </summary>
/// <param name="lCollItemID"></param>
/// <param name="patItemDI"></param>
/// <returns></returns>
protected k_STATE_ID GetItemStateID(long lCollectionItemID,
long lItemID,
DataSet dsPatItemComps,
CPatientItemDataItem patItemDI)
{
k_STATE_ID kStateID = k_STATE_ID.Unknown;
k_STATE_ID kOverallTSStateID = k_STATE_ID.NotSelected;
k_STATE_ID kOverallOSStateID = k_STATE_ID.NotSelected;
//get the entry date
DateTime dtEntryDate = patItemDI.EntryDate;
//get the checklist collection item di
CChecklistItemDataItem cidDI = null;
CChecklistItemData cid = new CChecklistItemData(BaseMstr.BaseData);
cid.GetCLItemDI(ChecklistID, lCollectionItemID, out cidDI);
//calculate how far the TS can go back
long lTS = cidDI.CLITSTimePeriod;
DateTime dtNow = DateTime.Now;
DateTime dtTSCompare = dtNow.AddDays(-1 * lTS);
//check the TS and set overall TS state
k_COMPARE kTS = CDataUtils.CompareDates(dtEntryDate, dtTSCompare);
if (kTS == k_COMPARE.GREATERTHAN ||
kTS == k_COMPARE.EQUALTO)
{
kOverallTSStateID = k_STATE_ID.Good;
}
else
{
//bad
kOverallTSStateID = k_STATE_ID.Bad;
}
//list to hold the created component items
CPatientItemCompList PatItemCompList = new CPatientItemCompList();
//build a pat item component list loaded with the most recent
//values
foreach (DataTable tableComp in dsPatItemComps.Tables)
{
foreach (DataRow drComp in tableComp.Rows)
{
//values to load the component item
long lCompItemID = CDataUtils.GetDSLongValue(drComp, "ITEM_ID");
long lComponentID = CDataUtils.GetDSLongValue(drComp, "ITEM_COMPONENT_ID");
string strComponentValue = CDataUtils.GetDSStringValue(drComp, "COMPONENT_VALUE");
long lPatItemID = CDataUtils.GetDSLongValue(drComp, "PAT_ITEM_ID");
//only this item
if (lCompItemID == lItemID)
{
CPatientItemComponentDataItem diComp = new CPatientItemComponentDataItem();
diComp.PatientID = PatientID;
diComp.ItemID = lCompItemID;
diComp.ComponentID = lComponentID;
diComp.ComponentValue = strComponentValue;
diComp.PatItemID = lPatItemID;
PatItemCompList.Add(diComp);
}
}
}
//we now have a list of item components for this item
//loop and get status for this item and update the overall status
bool bHasSelectedValue = false;
foreach (CPatientItemComponentDataItem diPatItemComp in PatItemCompList)
{
//get the state id for this component
CICStateDataItem sdi = null;
CItemComponentData icd = new CItemComponentData(BaseMstr.BaseData);
icd.GetICStateDI(lItemID, diPatItemComp.ComponentID, out sdi);
//switch on the type and get the value
switch ((k_ITEM_TYPE_ID)patItemDI.ItemTypeID)
{
case k_ITEM_TYPE_ID.Laboratory:
{
bHasSelectedValue = true;
//get the ranges
CICRangeDataItem rdi = null;
icd.GetICRangeDI(lItemID, diPatItemComp.ComponentID, out rdi);
if (String.IsNullOrEmpty(diPatItemComp.ComponentValue))
{
//does not have a value?
kOverallOSStateID = k_STATE_ID.Unknown;
}
else
{
try
{
double dblValue = Convert.ToDouble(diPatItemComp.ComponentValue);
//max/high check
if (dblValue >= rdi.LegalMax)
{
if (kOverallOSStateID != k_STATE_ID.Bad)
{
kOverallOSStateID = k_STATE_ID.Unknown;
}
}
else
{
if (dblValue >= rdi.High)
{
kOverallOSStateID = k_STATE_ID.Bad;
}
else
{
if (kOverallOSStateID != k_STATE_ID.Bad)
{
kOverallOSStateID = k_STATE_ID.Good;
}
}
}
//min/low check
if (dblValue <= rdi.LegalMin)
{
if (kOverallOSStateID != k_STATE_ID.Bad)
{
kOverallOSStateID = k_STATE_ID.Unknown;
}
}
else
{
if (dblValue <= rdi.Low)
{
kOverallOSStateID = k_STATE_ID.Bad;
}
else
{
if (kOverallOSStateID != k_STATE_ID.Bad)
{
kOverallOSStateID = k_STATE_ID.Good;
}
}
}
}
catch (Exception e)
{
if (kOverallOSStateID != k_STATE_ID.Bad)
{
kOverallOSStateID = k_STATE_ID.Unknown;
}
}
}
break;
}
case k_ITEM_TYPE_ID.NoteTitle:
{
//note titles are excluded from quick entry
//and do not affect default logic. must use custom logic
//for note titles
bHasSelectedValue = true;
kOverallOSStateID = k_STATE_ID.Unknown;
break;
}
case k_ITEM_TYPE_ID.QuestionFreeText:
{
bHasSelectedValue = true;
if (diPatItemComp.ComponentValue.Length < 1)
{
//if they did not enter a value
//then the overall state is bad!
kOverallOSStateID = k_STATE_ID.Bad;
}
else
{
kOverallOSStateID = k_STATE_ID.Good;
}
break;
}
case k_ITEM_TYPE_ID.QuestionSelection:
if (!String.IsNullOrEmpty(diPatItemComp.ComponentValue))
{
//only interested in the one they selected
if ((k_TRUE_FALSE_ID)Convert.ToInt64(diPatItemComp.ComponentValue) != k_TRUE_FALSE_ID.False)
{
bHasSelectedValue = true;
if (kOverallOSStateID != k_STATE_ID.Bad)
{
if ((k_STATE_ID)sdi.StateID == k_STATE_ID.Bad)
{
kOverallOSStateID = k_STATE_ID.Bad;
}
else
{
if ((k_STATE_ID)sdi.StateID == k_STATE_ID.Good)
{
if (kOverallOSStateID != k_STATE_ID.Unknown)
{
kOverallOSStateID = k_STATE_ID.Good;
}
}
else
{
kOverallOSStateID = k_STATE_ID.Unknown;
}
}
}
}
}
break;
}
}//for each
//if there is nothing selected then the overall os state is unk
//and ts state is bad!
if (!bHasSelectedValue)
{
kOverallOSStateID = k_STATE_ID.Unknown;
kOverallTSStateID = k_STATE_ID.Bad;
}
if (kOverallTSStateID == k_STATE_ID.Bad ||
kOverallOSStateID == k_STATE_ID.Bad)
{
kStateID = k_STATE_ID.Bad;
}
else if (kOverallTSStateID == k_STATE_ID.Good &&
kOverallOSStateID == k_STATE_ID.Good)
{
kStateID = k_STATE_ID.Good;
}
else
{
kStateID = k_STATE_ID.Unknown;
}
return(kStateID);
}
/// <summary>
/// method to run logic over a colletion
/// 1. all items in multi select must be have an option selected
/// 2. all free text items must have data entered
/// 3. labs and note titles are ignored
/// 4. items that are not ACTIVE are ignored
/// </summary>
public CStatus RunCollectionLogic(string strPatientID,
long lPatChecklistID,
long lChecklistID,
long lCollectionItemID)
{
//Get the patient checklist item data
CPatChecklistItemData PatChecklistItem = new CPatChecklistItemData(this);
CPatChecklistItemDataItem pdi = null;
PatChecklistItem.GetPatCLItemDI(lPatChecklistID,
lCollectionItemID,
out pdi);
//get all the items in the collection
CItemCollectionData coll = new CItemCollectionData(this);
DataSet dsColl = null;
CStatus status = coll.GetItemCollectionDS(lCollectionItemID, out dsColl);
//get all the patient item components in the collection
DataSet dsPatItemComps = null;
status = coll.GetItemColMostRecentPatICDS(lCollectionItemID, strPatientID, out dsPatItemComps);
//if this collection item is overridden just return and don't update the state
if (pdi.IsOverridden == k_TRUE_FALSE_ID.True)
{
bool bReturn = true;
//check to see if there is a new result and override if there is...
foreach (DataTable tableI in dsColl.Tables)
{
foreach (DataRow drI in tableI.Rows)
{
//get values from the the item in the collection (not the patient items, the collection items)
long lItemID = CDataUtils.GetDSLongValue(drI, "ITEM_ID");
long lItemTypeID = CDataUtils.GetDSLongValue(drI, "ITEM_TYPE_ID");
long lActiveID = CDataUtils.GetDSLongValue(drI, "ACTIVE_ID");
//get the item so we can check entry date against TS etc...
CPatientItemDataItem patItemDI = null;
CPatientItemData patData = new CPatientItemData(this);
patData.GetMostRecentPatientItemDI(strPatientID, lItemID, out patItemDI);
DateTime dtEntryDate = patItemDI.EntryDate;
if (dtEntryDate > pdi.OverrideDate)
{
pdi.OverrideDate = CDataUtils.GetNullDate();
pdi.IsOverridden = k_TRUE_FALSE_ID.False;
PatChecklistItem.UpdatePatChecklistItem(pdi);
bReturn = false;
break;
}
}
}
if (bReturn)
{
//return if this item is overridden and there are no new results
return(new CStatus());
}
}
//get the checklist item di
CChecklistItemDataItem cidDI = null;
CChecklistItemData cid = new CChecklistItemData(this);
cid.GetCLItemDI(lChecklistID, lCollectionItemID, out cidDI);
//calculate how far the TS can go back
long lTS = cidDI.CLITSTimePeriod;
DateTime dtNow = DateTime.Now;
DateTime dtTSCompare = dtNow.AddDays(-1 * lTS);
//keeps the overall OS state of the items
k_STATE_ID kOverallOSStateID = k_STATE_ID.NotSelected;
//keeps the overall TS state of the items
k_STATE_ID kOverallTSStateID = k_STATE_ID.NotSelected;
//loop over the collection items
foreach (DataTable table in dsColl.Tables)
{
foreach (DataRow dr in table.Rows)
{
//get values from the the item in the collection (not the patient items, the collection items)
long lItemID = CDataUtils.GetDSLongValue(dr, "ITEM_ID");
long lItemTypeID = CDataUtils.GetDSLongValue(dr, "ITEM_TYPE_ID");
long lActiveID = CDataUtils.GetDSLongValue(dr, "ACTIVE_ID");
//get the item so we can check entry date against TS etc...
CPatientItemDataItem patItemDI = null;
CPatientItemData patData = new CPatientItemData(this);
patData.GetMostRecentPatientItemDI(strPatientID, lItemID, out patItemDI);
DateTime dtEntryDate = patItemDI.EntryDate;
//only interested in ACTIVE items
if ((k_ACTIVE)lActiveID == k_ACTIVE.ACTIVE)
{
//check the TS and set overall TS state
k_COMPARE kTS = CDataUtils.CompareDates(dtEntryDate, dtTSCompare);
if (kTS == k_COMPARE.GREATERTHAN ||
kTS == k_COMPARE.EQUALTO)
{
//good
if (kOverallTSStateID != k_STATE_ID.Bad)
{
kOverallTSStateID = k_STATE_ID.Good;
}
}
else
{
//bad
kOverallTSStateID = k_STATE_ID.Bad;
}
//list to hold the created component items
CPatientItemCompList PatItemCompList = new CPatientItemCompList();
//build a pat item component list loaded with the most recent
//values
foreach (DataTable tableComp in dsPatItemComps.Tables)
{
foreach (DataRow drComp in tableComp.Rows)
{
//values to load the component item
long lCompItemID = CDataUtils.GetDSLongValue(drComp, "ITEM_ID");
long lComponentID = CDataUtils.GetDSLongValue(drComp, "ITEM_COMPONENT_ID");
string strComponentValue = CDataUtils.GetDSStringValue(drComp, "COMPONENT_VALUE");
long lPatItemID = CDataUtils.GetDSLongValue(drComp, "PAT_ITEM_ID");
//only this item
if (lCompItemID == lItemID)
{
CPatientItemComponentDataItem diComp = new CPatientItemComponentDataItem();
diComp.PatientID = strPatientID;
diComp.ItemID = lCompItemID;
diComp.ComponentID = lComponentID;
diComp.ComponentValue = strComponentValue;
diComp.PatItemID = lPatItemID;
PatItemCompList.Add(diComp);
}
}
//we now have a list of item components for this item
//loop and get status for this item and update the overall status
bool bHasSelectedValue = false;
foreach (CPatientItemComponentDataItem diPatItemComp in PatItemCompList)
{
//get the state id for this component
CICStateDataItem sdi = null;
CItemComponentData icd = new CItemComponentData(this);
icd.GetICStateDI(lItemID, diPatItemComp.ComponentID, out sdi);
//switch on the type and get the value
switch ((k_ITEM_TYPE_ID)lItemTypeID)
{
case k_ITEM_TYPE_ID.Laboratory:
{
bHasSelectedValue = true;
//get the ranges
CICRangeDataItem rdi = null;
icd.GetICRangeDI(lItemID, diPatItemComp.ComponentID, out rdi);
if (String.IsNullOrEmpty(diPatItemComp.ComponentValue))
{
//does not have a value?
kOverallOSStateID = k_STATE_ID.Unknown;
}
else
{
try
{
double dblValue = Convert.ToDouble(diPatItemComp.ComponentValue);
//max/high check
if (dblValue >= rdi.LegalMax)
{
if (kOverallOSStateID != k_STATE_ID.Bad)
{
kOverallOSStateID = k_STATE_ID.Unknown;
}
}
else
{
if (dblValue >= rdi.High)
{
kOverallOSStateID = k_STATE_ID.Bad;
}
else
{
if (kOverallOSStateID != k_STATE_ID.Bad)
{
kOverallOSStateID = k_STATE_ID.Good;
}
}
}
//min/low check
if (dblValue <= rdi.LegalMin)
{
if (kOverallOSStateID != k_STATE_ID.Bad)
{
kOverallOSStateID = k_STATE_ID.Unknown;
}
}
else
{
if (dblValue <= rdi.Low)
{
kOverallOSStateID = k_STATE_ID.Bad;
}
else
{
if (kOverallOSStateID != k_STATE_ID.Bad)
{
kOverallOSStateID = k_STATE_ID.Good;
}
}
}
}
catch (Exception e)
{
if (kOverallOSStateID != k_STATE_ID.Bad)
{
kOverallOSStateID = k_STATE_ID.Unknown;
}
}
}
break;
}
case k_ITEM_TYPE_ID.NoteTitle:
{
//note titles are excluded from quick entry
//so if we have one our os state is unknown
bHasSelectedValue = true;
kOverallOSStateID = k_STATE_ID.Unknown;
break;
}
case k_ITEM_TYPE_ID.QuestionFreeText:
{
bHasSelectedValue = true;
if (diPatItemComp.ComponentValue.Length < 1)
{
//if they did not enter a value
//then the overall state is bad!
kOverallOSStateID = k_STATE_ID.Bad;
}
break;
}
case k_ITEM_TYPE_ID.QuestionSelection:
if (!String.IsNullOrEmpty(diPatItemComp.ComponentValue))
{
//only interested in the one they selected
if ((k_TRUE_FALSE_ID)Convert.ToInt64(diPatItemComp.ComponentValue) != k_TRUE_FALSE_ID.False)
{
bHasSelectedValue = true;
if (kOverallOSStateID != k_STATE_ID.Bad)
{
if ((k_STATE_ID)sdi.StateID == k_STATE_ID.Bad)
{
kOverallOSStateID = k_STATE_ID.Bad;
}
else
{
if ((k_STATE_ID)sdi.StateID == k_STATE_ID.Good)
{
if (kOverallOSStateID != k_STATE_ID.Unknown)
{
kOverallOSStateID = k_STATE_ID.Good;
}
}
else
{
kOverallOSStateID = k_STATE_ID.Unknown;
}
}
}
}
}
break;
}
}//for each
//if there is nothing selected then the
//overall TS state is bad and the OS state is unknown
if (!bHasSelectedValue)
{
kOverallOSStateID = k_STATE_ID.Unknown;
kOverallTSStateID = k_STATE_ID.Bad;
}
}
}
}
}
//
//now update the collection item states.
//
//get the ts,os and ds possible values
CChecklistItemData dCL = new CChecklistItemData(this);
DataSet dsTS = null;
dCL.GetTemporalStateDS(lChecklistID, lCollectionItemID, out dsTS);
long lGoodTSID = dCL.GetTSDefaultStateID(dsTS, k_STATE_ID.Good);
long lBadTSID = dCL.GetTSDefaultStateID(dsTS, k_STATE_ID.Bad);
long lUnknownTSID = dCL.GetTSDefaultStateID(dsTS, k_STATE_ID.Unknown);
DataSet dsOS = null;
dCL.GetOutcomeStateDS(lChecklistID, lCollectionItemID, out dsOS);
long lGoodOSID = dCL.GetOSDefaultStateID(dsOS, k_STATE_ID.Good);
long lBadOSID = dCL.GetOSDefaultStateID(dsOS, k_STATE_ID.Bad);
long lUnknownOSID = dCL.GetOSDefaultStateID(dsOS, k_STATE_ID.Unknown);
DataSet dsDS = null;
dCL.GetDecisionStateDS(lChecklistID, lCollectionItemID, out dsDS);
long lGoodDSID = dCL.GetDSDefaultStateID(dsDS, k_STATE_ID.Good);
long lBadDSID = dCL.GetDSDefaultStateID(dsDS, k_STATE_ID.Bad);
long lUnknownDSID = dCL.GetDSDefaultStateID(dsDS, k_STATE_ID.Unknown);
//update the TS state on the data item
if (kOverallTSStateID == k_STATE_ID.Bad)
{
pdi.TSID = lBadTSID;
}
else if (kOverallTSStateID == k_STATE_ID.Good)
{
pdi.TSID = lGoodTSID;
}
else
{
pdi.TSID = lUnknownTSID;
}
//update the OS state on the data item
if (kOverallOSStateID == k_STATE_ID.Bad)
{
pdi.OSID = lBadOSID;
}
else if (kOverallOSStateID == k_STATE_ID.Good)
{
pdi.OSID = lGoodOSID;
}
else
{
pdi.OSID = lUnknownOSID;
}
//update the ds state on the item data
if (kOverallTSStateID == k_STATE_ID.Good &&
kOverallOSStateID == k_STATE_ID.Good)
{
pdi.DSID = lGoodDSID;
}
else
{
pdi.DSID = lBadDSID;
}
//update the checklist item state
status = PatChecklistItem.UpdatePatChecklistItem(pdi);
return(status);
}
