public WKF_CASE ParseReaderComplete(DataRow row)
{
WKF_CASE objReturn = ParseReaderCustom(row);
if (objReturn != null)
{
if (objReturn.PATIENT_ID > 0)
{
PATIENTDB pATIENTDB = new PATIENTDB();
objReturn.PATIENT = pATIENTDB.ParseReaderCustom(row);
}
if (objReturn.STD_WKFCASETYPE_ID > 0)
{
STD_WKFCASETYPEDB sTD_WKFCASETYPEDB = new STD_WKFCASETYPEDB();
objReturn.STD_WKFCASETYPE = sTD_WKFCASETYPEDB.ParseReaderCustom(row);
}
if (objReturn.STD_WKFCASESTS_ID > 0)
{
STD_WKFCASESTSDB sTD_WKFCASESTSDB = new STD_WKFCASESTSDB();
objReturn.STD_WKFCASESTS = sTD_WKFCASESTSDB.ParseReaderCustom(row);
}
if (objReturn.REFERRAL_ID > 0)
{
REFERRALDB rEFERRALDB = new REFERRALDB();
objReturn.REFERRAL = rEFERRALDB.ParseReaderCustom(row);
}
}
return(objReturn);
}
public static Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, WKF_CASE objSave)
{
Int32 objReturn = 0;
WKF_CASEDB objDB = new WKF_CASEDB();
objReturn = objDB.Save(CURRENT_USER, CURRENT_REGISTRY_ID, objSave);
return(objReturn);
}
public static WKF_CASE GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 WKF_CASE_ID)
{
WKF_CASE objReturn = null;
WKF_CASEDB objDB = new WKF_CASEDB();
objReturn = objDB.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, WKF_CASE_ID);
return(objReturn);
}
protected void LinkEdit_Click(object sender, EventArgs e)
{
ServiceInterfaceManager.LogInformation("POSTBACK_EVENT", String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId);
try
{
UserSession.RefreshCommon();
LinkButton lb = (LinkButton)sender;
if (lb != null)
{
int id = 0;
int.TryParse(lb.CommandArgument, out id);
if (id > 0)
{
WKF_CASE_ACTIVITY a = ServiceInterfaceManager.WKF_CASE_ACTIVITY_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
if (a != null)
{
UserSession.CurrentActivityId = a.WKF_CASE_ACTIVITY_ID;
WKF_CASE c = ServiceInterfaceManager.WKF_CASE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, a.WKF_CASE_ID);
if (c != null)
{
UserSession.CurrentWorkstreamId = c.WKF_CASE_ID;
if (c.REFERRAL_ID != null)
{
UserSession.CurrentReferralId = c.REFERRAL_ID.Value;
}
UserSession.CurrentPatientId = c.PATIENT_ID;
}
pnlActivities.Visible = false;
pnlActivity.Visible = true;
LoadForm(id);
}
}
}
}
catch (Exception ex)
{
ServiceInterfaceManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId);
throw ex;
}
}
private void ResetForm()
{
hideActivityId.Value = string.Empty;
listActivityName.ClearSelection();
listActivityName.Items.Clear();
listActivityName.Enabled = true;
WKF_CASE workstream = ServiceInterfaceManager.WKF_CASE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, UserSession.CurrentWorkstreamId);
if (workstream != null)
{
hideWorkstreamId.Value = workstream.WKF_CASE_ID.ToString();
STD_WKFCASETYPE type = ServiceInterfaceManager.STD_WKFCASETYPE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, workstream.STD_WKFCASETYPE_ID);
if (type != null)
{
txtWorkstreamName.Text = type.Name;
List <STD_WKFACTIVITYTYPE> cases = ServiceInterfaceManager.STD_WKFACTIVITYTYPE_GET_ALL_BY_WORKSTREAM(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, type.ID);
listActivityName.Items.Add(new ListItem("", "0"));
listActivityName.AppendDataBoundItems = true;
if (cases != null)
{
listActivityName.DataSource = cases;
listActivityName.DataBind();
}
}
}
txtContactName.Text = string.Empty;
txtContactEmail.Text = string.Empty;
txtContactPhone.Text = string.Empty;
txtBestCallBackTime.Text = string.Empty;
txtAddressLine1.Text = string.Empty;
txtAddressLine2.Text = string.Empty;
txtAddressLine3.Text = string.Empty;
txtCity.Text = string.Empty;
txtState.Text = string.Empty;
txtPostalCode.Text = string.Empty;
txtCountry.Text = string.Empty;
txtInfoConveyed.Text = string.Empty;
txtInfoReceived.Text = string.Empty;
}
public void LoadForm(int id)
{
ResetForm();
WKF_CASE wkfCase = ServiceInterfaceManager.WKF_CASE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
if (wkfCase != null)
{
wkfCase.STD_WKFCASETYPE = ServiceInterfaceManager.STD_WKFCASETYPE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, wkfCase.STD_WKFCASETYPE_ID);
if (wkfCase.STD_WKFCASETYPE != null)
{
lblWorkstreamName.Text = wkfCase.STD_WKFCASETYPE.Name;
}
wkfCase.STD_WKFCASESTS = ServiceInterfaceManager.STD_WKFCASESTS_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, wkfCase.STD_WKFCASESTS_ID);
if (wkfCase.STD_WKFCASESTS != null)
{
lblStatus.Text = wkfCase.STD_WKFCASESTS.NAME;
}
lblCaseNumber.Text = wkfCase.CASE_NUMBER;
if (wkfCase.CASE_START_DATE != null)
{
lblCaseStartDate.Text = wkfCase.CASE_START_DATE.Value.ToString("MM/dd/yyyy");
}
if (wkfCase.CASE_DUE_DATE != null)
{
lblCaseDueDate.Text = wkfCase.CASE_DUE_DATE.Value.ToString("MM/dd/yyyy");
}
lblCreatedBy.Text = wkfCase.CREATEDBY;
lblCreated.Text = wkfCase.CREATED.ToString("MM/dd/yyyy");
lblUpdatedBy.Text = wkfCase.UPDATEDBY;
lblUpdated.Text = wkfCase.UPDATED.ToString("MM/dd/yyyy");
}
else
{
linkViewDetails.Visible = false;
}
}
public WKF_CASE ParseReaderCustom(DataRow row)
{
WKF_CASE objReturn = new WKF_CASE
{
CASE_DUE_DATE = (DateTime?)GetNullableObject(row.Field <object>("WKF_CASE_CASE_DUE_DATE")),
CASE_NUMBER = (string)GetNullableObject(row.Field <object>("WKF_CASE_CASE_NUMBER")),
CASE_START_DATE = (DateTime?)GetNullableObject(row.Field <object>("WKF_CASE_CASE_START_DATE")),
CREATED = (DateTime)GetNullableObject(row.Field <object>("WKF_CASE_CREATED")),
CREATEDBY = (string)GetNullableObject(row.Field <object>("WKF_CASE_CREATEDBY")),
PARENT_CASE_ID = (Int32?)GetNullableObject(row.Field <object>("WKF_CASE_PARENT_CASE_ID")),
PATIENT_ID = (Int32)GetNullableObject(row.Field <object>("WKF_CASE_PATIENT_ID")),
REFERRAL_ID = (Int32?)GetNullableObject(row.Field <object>("WKF_CASE_REFERRAL_ID")),
STD_WKFCASETYPE_ID = (Int32)GetNullableObject(row.Field <object>("WKF_CASE_STD_WKFCASETYPE_ID")),
UPDATED = (DateTime)GetNullableObject(row.Field <object>("WKF_CASE_UPDATED")),
UPDATEDBY = (string)GetNullableObject(row.Field <object>("WKF_CASE_UPDATEDBY")),
WKF_CASE_ID = (Int32)GetNullableObject(row.Field <object>("WKF_CASE_WKF_CASE_ID")),
STD_WKFCASESTS_ID = (Int32)GetNullableObject(row.Field <object>("WKF_CASE_STD_WKFCASESTS_ID"))
};
return(objReturn);
}
protected void LinkSelectWorkstream_Click(object sender, EventArgs e)
{
ServiceInterfaceManager.LogInformation("POSTBACK_EVENT", String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId);
try
{
UserSession.RefreshCommon();
LinkButton lb = (LinkButton)sender;
if (lb != null)
{
int id = 0;
int.TryParse(lb.CommandArgument, out id);
if (id > 0)
{
WKF_CASE w = ServiceInterfaceManager.WKF_CASE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
if (w != null)
{
UserSession.CurrentWorkstreamId = w.WKF_CASE_ID;
if (w.REFERRAL_ID != null)
{
UserSession.CurrentReferralId = w.REFERRAL_ID.Value;
}
UserSession.CurrentPatientId = w.PATIENT_ID;
Response.Redirect("~/Common/Workstream.aspx", false);
}
}
}
}
catch (Exception ex)
{
ServiceInterfaceManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId);
throw ex;
}
}
public WKF_CASE GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 WKF_CASE_ID)
{
WKF_CASE objReturn = null;
SqlConnection sConn = null;
SqlCommand sCmd = null;
SqlDataAdapter sAdapter = null;
DataSet objTemp = null;
try
{
sConn = new SqlConnection(SqlConnectionString);
sConn.Open();
sCmd = new SqlCommand("CRS.usp_WKF_CASE_getitem", sConn);
sCmd.CommandTimeout = SqlCommandTimeout;
sCmd.CommandType = CommandType.StoredProcedure;
sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER);
sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID);
sCmd.Parameters.AddWithValue("@WKF_CASE_ID", WKF_CASE_ID);
objTemp = new DataSet();
sAdapter = new SqlDataAdapter(sCmd);
LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
sAdapter.Fill(objTemp);
LogManager.LogTiming(logDetails);
CheckDataSet(objTemp);
if (objTemp != null && objTemp.Tables.Count > 0 && objTemp.Tables[0].Rows.Count > 0)
{
objReturn = ParseReader(objTemp.Tables[0].Rows[0]);
}
sConn.Close();
}
catch (Exception ex)
{
LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
throw ex;
}
finally
{
if (sAdapter != null)
{
sAdapter.Dispose();
sAdapter = null;
}
if (sCmd != null)
{
sCmd.Dispose();
sCmd = null;
}
if (sConn != null)
{
if (sConn.State != ConnectionState.Closed)
{
sConn.Close();
}
sConn.Dispose();
sConn = null;
}
}
return(objReturn);
}
public Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, WKF_CASE objSave)
{
Int32 objReturn = 0;
SqlConnection sConn = null;
SqlCommand sCmd = null;
SqlParameter p = null;
SqlDataAdapter sAdapter = null;
DataSet objTemp = null;
try
{
sConn = new SqlConnection(SqlConnectionString);
sConn.Open();
sCmd = new SqlCommand("CRS.usp_WKF_CASE_save", sConn);
sCmd.CommandTimeout = SqlCommandTimeout;
sCmd.CommandType = CommandType.StoredProcedure;
sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER);
sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID);
p = new SqlParameter("@CASE_DUE_DATE", SqlDbType.DateTime, 8);
p.Precision = 23;
p.Scale = 3;
AddParameter(ref sCmd, ref p, objSave.CASE_DUE_DATE);
p = new SqlParameter("@CASE_NUMBER", SqlDbType.VarChar, 30);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.CASE_NUMBER);
p = new SqlParameter("@CASE_START_DATE", SqlDbType.DateTime, 8);
p.Precision = 23;
p.Scale = 3;
AddParameter(ref sCmd, ref p, objSave.CASE_START_DATE);
p = new SqlParameter("@CREATED", SqlDbType.DateTime, 8);
p.Precision = 23;
p.Scale = 3;
AddParameter(ref sCmd, ref p, objSave.CREATED);
p = new SqlParameter("@CREATEDBY", SqlDbType.VarChar, 30);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.CREATEDBY);
p = new SqlParameter("@PARENT_CASE_ID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.PARENT_CASE_ID);
p = new SqlParameter("@PATIENT_ID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.PATIENT_ID);
p = new SqlParameter("@REFERRAL_ID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.REFERRAL_ID);
p = new SqlParameter("@STD_WKFCASETYPE_ID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.STD_WKFCASETYPE_ID);
p = new SqlParameter("@UPDATED", SqlDbType.DateTime, 8);
p.Precision = 23;
p.Scale = 3;
AddParameter(ref sCmd, ref p, objSave.UPDATED);
p = new SqlParameter("@UPDATEDBY", SqlDbType.VarChar, 30);
p.Precision = 0;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.UPDATEDBY);
p = new SqlParameter("@WKF_CASE_ID", SqlDbType.Int, 4);
p.Direction = ParameterDirection.InputOutput;
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.WKF_CASE_ID);
p = new SqlParameter("@STD_WKFCASESTS_ID", SqlDbType.Int, 4);
p.Precision = 10;
p.Scale = 0;
AddParameter(ref sCmd, ref p, objSave.STD_WKFCASESTS_ID);
objTemp = new DataSet();
sAdapter = new SqlDataAdapter(sCmd);
LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
//int cnt = sCmd.ExecuteNonQuery();
sAdapter.Fill(objTemp);
LogManager.LogTiming(logDetails);
CheckDataSet(objTemp);
objReturn = (Int32)sCmd.Parameters["@WKF_CASE_ID"].Value;
sConn.Close();
}
catch (Exception ex)
{
LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID);
throw ex;
}
finally
{
if (sAdapter != null)
{
sAdapter.Dispose();
sAdapter = null;
}
if (sCmd != null)
{
sCmd.Dispose();
sCmd = null;
}
if (sConn != null)
{
if (sConn.State != ConnectionState.Closed)
{
sConn.Close();
}
sConn.Dispose();
sConn = null;
}
}
return(objReturn);
}
public static Boolean Delete(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, WKF_CASE objDelete)
{
return(Delete(CURRENT_USER, CURRENT_REGISTRY_ID, objDelete.WKF_CASE_ID));
}
private void LoadForm(int id)
{
ResetForm();
listWorkstreamName.Enabled = false;
WKF_CASE workstream = ServiceInterfaceManager.WKF_CASE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
if (workstream != null)
{
hideWorkstreamId.Value = workstream.WKF_CASE_ID.ToString();
//TODO: Patient ID should not be null or 0 here, but may need to add logic
//here at some point in case it is.
if (workstream.PATIENT_ID > 0)
{
PATIENT p = ServiceInterfaceManager.PATIENT_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, workstream.PATIENT_ID);
if (p != null)
{
hidePatientId.Value = p.PATIENT_ID.ToString();
if (!string.IsNullOrEmpty(p.LAST_NAME) && !string.IsNullOrEmpty(p.FIRST_NAME))
{
txtPatientName.Text = p.LAST_NAME + ", " + p.FIRST_NAME;
}
else if (!string.IsNullOrEmpty(p.LAST_NAME))
{
txtPatientName.Text = p.LAST_NAME;
}
else if (!string.IsNullOrEmpty(p.FIRST_NAME))
{
txtPatientName.Text = p.FIRST_NAME;
}
}
}
if (workstream.REFERRAL_ID != null && workstream.REFERRAL_ID > 0)
{
REFERRAL r = ServiceInterfaceManager.REFERRAL_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, workstream.REFERRAL_ID.Value);
if (r != null)
{
hideReferralId.Value = r.REFERRAL_ID.ToString();
if (r.REFERRAL_DATE != null)
{
txtReferralDate.Text = r.REFERRAL_DATE.Value.ToString("MM/dd/yyyy");
}
}
}
foreach (ListItem li in listWorkstreamName.Items)
{
if (li.Value == workstream.STD_WKFCASETYPE_ID.ToString())
{
li.Selected = true;
break;
}
}
txtCaseNumber.Text = workstream.CASE_NUMBER;
if (workstream.CASE_START_DATE != null)
{
txtCaseStartDate.Text = workstream.CASE_START_DATE.Value.ToString("MM/dd/yyyy");
}
if (workstream.CASE_DUE_DATE != null)
{
txtCaseDueDate.Text = workstream.CASE_DUE_DATE.Value.ToString("MM/dd/yyyy");
}
}
}
private bool SaveForm(ref string strResult)
{
WKF_CASE workstream = null;
if (listWorkstreamName.SelectedIndex > 0)
{
if (ValidateDates())
{
if (string.IsNullOrEmpty(txtCaseNumber.Text))
{
strResult = "Case Number is Required<br /><br />";
}
else
{
int id = 0;
if (!string.IsNullOrEmpty(hideWorkstreamId.Value))
{
int.TryParse(hideWorkstreamId.Value, out id);
}
if (id > 0)
{
workstream = ServiceInterfaceManager.WKF_CASE_GET(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, id);
}
if (workstream == null)
{
workstream = new WKF_CASE();
}
workstream.CREATED = workstream.UPDATED = DateTime.Now;
workstream.CREATEDBY = workstream.UPDATEDBY = HttpContext.Current.User.Identity.Name;
int patientId = 0;
int.TryParse(hidePatientId.Value, out patientId);
workstream.PATIENT_ID = patientId;
int referralId = 0;
int.TryParse(hideReferralId.Value, out referralId);
workstream.REFERRAL_ID = referralId;
int typeId = 0;
int.TryParse(listWorkstreamName.SelectedValue, out typeId);
workstream.STD_WKFCASETYPE_ID = typeId;
workstream.CASE_NUMBER = txtCaseNumber.Text;
DateTime dtStart = DateTime.MinValue;
if (DateTime.TryParse(txtCaseStartDate.Text, out dtStart))
{
workstream.CASE_START_DATE = dtStart;
}
else
{
workstream.CASE_START_DATE = null;
}
DateTime dtDue = DateTime.MinValue;
if (DateTime.TryParse(txtCaseDueDate.Text, out dtDue))
{
workstream.CASE_DUE_DATE = dtDue;
}
else
{
workstream.CASE_DUE_DATE = null;
}
workstream.WKF_CASE_ID = ServiceInterfaceManager.WKF_CASE_SAVE(HttpContext.Current.User.Identity.Name, UserSession.CurrentRegistryId, workstream);
if (workstream.WKF_CASE_ID > 0)
{
hideWorkstreamId.Value = workstream.WKF_CASE_ID.ToString();
strResult = "Save successful<br /><br />";
return(true);
}
else
{
strResult = "Error saving Work Stream, please try again<br /><br />";
}
}
}
else
{
strResult = lblResult.Text;
}
}
else
{
strResult = "<ul><li>Please select an available Work Stream</li></ul>";
}
return(false);
}
