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); }