protected void PatientListGridView_CellEditorInitialize(object sender, DevExpress.Web.ASPxGridViewEditorEventArgs e) { try { e.Editor.ReadOnly = false; if (e.Column.Name == "colPrimaryPhysician") { ASPxComboBox cmb = e.Editor as ASPxComboBox; if (Session["PhysicianDS"] != null) { cmb.DataSource = Session["PhysicianDS"]; cmb.DataBindItems(); } else { GetPhysicianList(); cmb.DataSource = Session["PhysicianDS"]; cmb.DataBindItems(); } } } catch (Exception ex) { CommonHelpers.writeLogToFile("PatientListGridView_CellEditorInitialize: PatientList.aspx", ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack && !IsCallback) { securityAgent = new CryptoProvider(); if (Request.QueryString["UID"] != null && Request.QueryString["UN"] != null) { txtUserName.Text = securityAgent.decryptText(Request.QueryString["UN"].Replace(" ", "+")); txtPassword.Focus(); } else { Response.Redirect("Logout.aspx"); } } } catch (Exception ex) { lblErr.Text = "There was a problem processing your request. Please contact IT."; lblErr.Visible = true; CommonHelpers.writeLogToFile("Page_Load: ResetPassword.aspx.aspx", ex.Message); } }
protected void gvAssignedQuestionnaire_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e) { try { e.Editor.ReadOnly = false; if (e.Column.Name == "colQuestionnaireName") { ASPxComboBox cmb = e.Editor as ASPxComboBox; if (Session["QuestionnaireDS"] != null) { cmb.DataSource = Session["QuestionnaireDS"]; cmb.DataBindItems(); } else { GetQuestionnaireList(); cmb.DataSource = Session["QuestionnaireDS"]; cmb.DataBindItems(); } } } catch (Exception ex) { CommonHelpers.writeLogToFile("gvAssignedQuestionnaire_CellEditorInitialize: PatientList.aspx", ex.Message); } }
protected void gvQuestionnaireHistory_HtmlRowPrepared(object sender, ASPxGridViewTableRowEventArgs e) { try { if (e != null && e.GetValue("RiskCategory") != null) { if (e.GetValue("RiskCategory").ToString().Equals("High")) { //Flat - rgb(231, 76, 60) //Light - rgb(255,158,128) e.Row.BackColor = System.Drawing.Color.FromArgb(255, 158, 128); } else if (e.GetValue("RiskCategory").ToString().Equals("Medium")) { //Flat - rgb(241, 196, 15) //Light - rgb(255, 255, 141) e.Row.BackColor = System.Drawing.Color.FromArgb(255, 255, 141); } else if (e.GetValue("RiskCategory").ToString().Equals("Low")) { //Flat - rgb(46, 204, 113) //Light - rgb(204, 255, 144) e.Row.BackColor = System.Drawing.Color.FromArgb(204, 255, 144); } } } catch (Exception ex) { CommonHelpers.writeLogToFile("gvQuestionnaireHistory_HtmlRowPrepared: PatientList.aspx", ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack && !IsCallback) { int QuestionnaireID = 0; securityAgent = new CryptoProvider(); if (Request.QueryString.Count > 0) { QuestionnaireID = int.Parse(securityAgent.decryptText(Request.QueryString["QID"].Replace(' ', '+'))); //QuestionnaireID = int.Parse(Request.QueryString["QID"]); ViewState["CurrentQuestionnaire"] = QuestionnaireID; } LoadQuestionnaireList(); AnswerListGridView.DataBind(); if (QuestionnaireID > 0) { ConfigGridView.DataBind(); QuestionsGridView.DataBind(); } } } catch (Exception ex) { CommonHelpers.writeLogToFile("Page_Load: EditQuestionnaire.aspx", ex.Message); } }
protected void gvAssignedQuestionnaire_DataBinding(object sender, EventArgs e) { try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamPatientID", Session["CurrentPatientID"]); string data = DBAgent.ExecuteStoredProcedure("dbo.spGetPatientQuestionnaireList"); if (!String.IsNullOrEmpty(data)) { DataSet ds = CommonHelpers.GetDataSetFromXml(data); if (ds.Tables.Count > 0) { gvAssignedQuestionnaire.DataSource = ds.Tables[0]; } else { } GetQuestionnaireList(); } } catch (Exception ex) { CommonHelpers.writeLogToFile("gvAssignedQuestionnaire_DataBinding: PatientList.aspx", ex.Message); } }
protected void PatientDetailsPanel_Callback(object sender, CallbackEventArgsBase e) { try { gvAssignedQuestionnaire.Enabled = true; DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamPatientID", e.Parameter); string data = DBAgent.ExecuteStoredProcedure("dbo.spGetPatientDetails"); if (!String.IsNullOrEmpty(data)) { DataSet ds = CommonHelpers.GetDataSetFromXml(data); if (ds.Tables.Count > 0) { txtPatientAccount.Text = ds.Tables[0].Rows[0]["PatientAccountNumber"].ToString(); txtPatientName.Text = ds.Tables[0].Rows[0]["PatientFullName"].ToString(); Session["CurrentPatientID"] = e.Parameter; gvAssignedQuestionnaire.DataBind(); gvQuestionnaireHistory.DataBind(); } } } catch (Exception ex) { CommonHelpers.writeLogToFile("PatientDetailsPanel_Callback: PatientList.aspx", ex.Message); } }
protected void cmdSubmit_Click(object sender, EventArgs e) { try { if (txtNewPassword.Text.Equals(txtConfirm.Text)) { securityAgent = new CryptoProvider(); DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamLoginID", securityAgent.decryptText(Request.QueryString["UID"].Replace(" ", "+"))); DBAgent.AddParameter("@ParamNewPassword", securityAgent.EncryptText(txtNewPassword.Text)); DBAgent.AddParameter("@ParamIsTempPassword", 0); DBAgent.ExecuteNonQuery("dbo.spUpdatePassword"); Session["Username"] = securityAgent.decryptText(Request.QueryString["UN"].Replace(" ", "+")); Session["LoginID"] = securityAgent.decryptText(Request.QueryString["UID"].Replace(" ", "+")); Response.Redirect("Dashboard.aspx"); } } catch (Exception ex) { lblErr.Text = "There was a problem processing your request. Please contact IT."; lblErr.Visible = true; CommonHelpers.writeLogToFile("cmdSubmit_Click: ResetPassword.aspx.aspx", ex.Message); } }
protected void gvConfig_RowDeleted(object sender, DevExpress.Web.Data.ASPxDataDeletedEventArgs e) { try { gvConfig.DataBind(); } catch (Exception ex) { CommonHelpers.writeLogToFile("gvConfig_RowDeleted: NewQuestionnaire.aspx", ex.Message); } }
protected void gvConfig_DataBinding(object sender, EventArgs e) { try { gvConfig.DataSource = Session["ConfigurationValues"]; } catch (Exception ex) { CommonHelpers.writeLogToFile("gvConfig_DataBinding: NewQuestionnaire.aspx", ex.Message); } }
protected void cmbRiskType_DataBinding(object sender, EventArgs e) { try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); ConfigDataSource.DataSourceMode = SqlDataSourceMode.DataSet; ConfigDataSource.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; ConfigDataSource.SelectCommand = "dbo.spGetAllConfigTypes"; ConfigDataSource.ConnectionString = DBAgent.GetConnectionString(); } catch (Exception ex) { CommonHelpers.writeLogToFile("cmbRiskType_DataBinding: NewQuestionnaire.aspx", ex.Message); } }
protected void UserGridView_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamLoginID", e.Keys[0]); DBAgent.AddParameter("@ParamUpdatedBy", Session["LoginID"]); DBAgent.ExecuteNonQuery("dbo.spDeleteUser"); e.Cancel = true; UserGridView.DataBind(); } catch (Exception ex) { CommonHelpers.writeLogToFile("UserGridView_RowDeleting: UserManagement.aspx", ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { try { PatientListGridView.ForceDataRowType(typeof(ClarityDBSet.PatientDSRow)); gvAssignedQuestionnaire.ForceDataRowType(typeof(ClarityDBSet.PatientAssignedQuestionnaireRow)); if (!IsPostBack && !IsCallback) { PatientListGridView.DataBind(); } } catch (Exception ex) { CommonHelpers.writeLogToFile("Page_Load: PatientList.aspx", ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack && !IsCallback) { cmbRiskType.DataBind(); listDataSource = new BindingList <Record>(); Session["ConfigurationValues"] = null; } } catch (Exception ex) { CommonHelpers.writeLogToFile("Page_Load: NewQuestionnaire.aspx", ex.Message); } }
protected void gvQuestionnaireHistory_CustomButtonCallback(object sender, ASPxGridViewCustomButtonCallbackEventArgs e) { try { securityAgent = new CryptoProvider(); ASPxGridView gv = (ASPxGridView)sender; object PQID = gv.GetRowValues(e.VisibleIndex, "PQID"); if (PQID != null) { gvQuestionnaireHistory.JSProperties["cpReportPQID"] = securityAgent.EncryptText(PQID.ToString()); } } catch (Exception ex) { CommonHelpers.writeLogToFile("gvQuestionnaireHistory_CustomButtonCallback: PatientList.aspx", ex.Message); } }
protected void gvAssignedQuestionnaire_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamPQID", e.Keys["PQID"]); DBAgent.AddParameter("@ParamLoginID", Session["LoginID"]); DBAgent.ExecuteNonQuery("dbo.spDeletePatientQuestionnaire"); e.Cancel = true; gvAssignedQuestionnaire.CancelEdit(); gvAssignedQuestionnaire.DataBind(); } catch (Exception ex) { CommonHelpers.writeLogToFile("gvAssignedQuestionnaire_RowDeleting: PatientList.aspx", ex.Message); } }
protected void UserGridView_DataBinding(object sender, EventArgs e) { try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); string data = DBAgent.ExecuteStoredProcedure("dbo.spGetAllUsers"); DataSet ds = CommonHelpers.GetDataSetFromXml(data); if (ds.Tables.Count > 0) { UserGridView.DataSource = ds.Tables[0]; } } catch (Exception ex) { CommonHelpers.writeLogToFile("UserGridView_DataBinding: UserManagement.aspx", ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { try { if (Request.QueryString["Type"] != null) { switch (Request.QueryString["Type"]) { case "QuestionnaireResponse": if (Request.QueryString["PQID"] != null) { QuestionnaireResponse report = new QuestionnaireResponse(); securityAgent = new CryptoProvider(); report.Parameters["@PQID"].Value = securityAgent.decryptText(Request.QueryString["PQID"].Replace(" ", "+")); ReportViewerControl.Report = report; } break; case "PatientReport": if (Request.QueryString["PatientID"] != null) { ConsolidatedReport report = new ConsolidatedReport(); securityAgent = new CryptoProvider(); report.Parameters["@PatientID"].Value = securityAgent.decryptText(Request.QueryString["PatientID"].Replace(" ", "+")); ReportViewerControl.Report = report; } break; case "VisitDetails": if (Request.QueryString["PatientID"] != null) { TestSummaryReport report = new TestSummaryReport(); securityAgent = new CryptoProvider(); report.Parameters["@PatientID"].Value = securityAgent.decryptText(Request.QueryString["PatientID"].Replace(" ", "+")); ReportViewerControl.Report = report; } break; } } } catch (Exception ex) { CommonHelpers.writeLogToFile("Page_Load: ReportViewer.aspx", ex.Message); } }
protected void PhysicianGridView_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamFirstName", e.NewValues["PhysicianFirstName"]); DBAgent.AddParameter("@ParamLastName", e.NewValues["PhysicianLastName"]); DBAgent.AddParameter("@ParamModifiedBy", Session["LoginID"]); DBAgent.ExecuteNonQuery("dbo.spAddPhysician"); e.Cancel = true; PhysicianGridView.CancelEdit(); PhysicianGridView.DataBind(); } catch (Exception ex) { CommonHelpers.writeLogToFile("PhysicianGridView_RowInserting: Physician.aspx", ex.Message); } }
protected void QuestionsGridView_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { e.Cancel = true; try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamQuestionnaireID", cmbQuestionnaireList.SelectedItem.Value); DBAgent.AddParameter("@ParamQID", e.Keys[0]); DBAgent.AddParameter("@ParamLoginID", Session["LoginID"]); DBAgent.ExecuteNonQuery("dbo.spDeleteQuestionForQuestionnaire"); QuestionsGridView.DataBind(); } catch (Exception ex) { CommonHelpers.writeLogToFile("QuestionsGridView_DataBinding: EditQuestionnaire.aspx", ex.Message); } }
protected void QuestionsGridView_DataBinding(object sender, EventArgs e) { try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamQuestionnaireID", cmbQuestionnaireList.SelectedItem.Value); string data = DBAgent.ExecuteStoredProcedure("dbo.spGetAllQuestionsForQuestionnaire"); DataSet ds = CommonHelpers.GetDataSetFromXml(data); if (ds.Tables.Count > 0) { QuestionsGridView.DataSource = ds.Tables[0]; } } catch (Exception ex) { CommonHelpers.writeLogToFile("QuestionsGridView_DataBinding: EditQuestionnaire.aspx", ex.Message); } }
protected void gvAssignedQuestionnaire_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamPatientID", Session["CurrentPatientID"]); DBAgent.AddParameter("@ParamQuestionnaireID", 0); DBAgent.AddParameter("@ParamNewQuestionnaireID", e.NewValues["QuestionnaireName"]); DBAgent.AddParameter("@ParamNewAssignedDate", e.NewValues["ScheduledDate"]); DBAgent.AddParameter("@ParamAssignedBy", Session["LoginID"]); DBAgent.ExecuteNonQuery("dbo.spAddEditPatientQuestionnaire"); e.Cancel = true; gvAssignedQuestionnaire.CancelEdit(); } catch (Exception ex) { CommonHelpers.writeLogToFile("gvAssignedQuestionnaire_RowInserting: PatientList.aspx", ex.Message); } }
protected void AnswerListGridView_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { try { e.Cancel = true; DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamAnswerText", e.NewValues[0]); object o = DBAgent.ExecuteScalar("dbo.spAddAnswer"); if (o != null) { ViewState["NewAnswerID"] = o; } AnswerListGridView.CancelEdit(); } catch (Exception ex) { CommonHelpers.writeLogToFile("AnswerListGridView_RowInserting: EditQuestionnaire.aspx", ex.Message); } }
protected void ConfigGridView_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { try { e.Cancel = true; DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamQuestionnaireID", cmbQuestionnaireList.SelectedItem.Value); DBAgent.AddParameter("@ParamConfigID", e.Keys[0]); DBAgent.AddParameter("@ParamConfigMinValue", e.NewValues[1]); DBAgent.AddParameter("@ParamConfigMaxValue", e.NewValues[2]); DBAgent.ExecuteNonQuery("dbo.spEditQuestionnaireConfig"); ConfigGridView.CancelEdit(); ConfigGridView.DataBind(); } catch (Exception ex) { CommonHelpers.writeLogToFile("ConfigGridView_RowUpdating: EditQuestionnaire.aspx", ex.Message); } }
protected void UserGridView_CustomButtonCallback(object sender, DevExpress.Web.ASPxGridViewCustomButtonCallbackEventArgs e) { try { securityAgent = new CryptoProvider(); DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamLoginID", UserGridView.GetRowValues(e.VisibleIndex, "LoginID")); DBAgent.AddParameter("@ParamNewPassword", securityAgent.GetTemporaryPassword()); DBAgent.AddParameter("@ParamIsTempPassword", 1); DBAgent.AddParameter("@ParamComment", "Password reset by Admin"); DBAgent.ExecuteNonQuery("dbo.spUpdatePassword"); UserGridView.DataBind(); } catch (Exception ex) { CommonHelpers.writeLogToFile("UserGridView_CustomButtonCallback: UserManagement.aspx", ex.Message); } }
protected void gvConfig_CustomCallback(object sender, DevExpress.Web.ASPxGridViewCustomCallbackEventArgs e) { try { if (Session["ConfigurationValues"] != null) { listDataSource = (BindingList <Record>)Session["ConfigurationValues"]; } else { listDataSource = new BindingList <Record>(); } Record newRecord = new Record(cmbRiskType.Text, int.Parse(cmbRiskType.Value.ToString()), int.Parse(txtMinValue.Text), int.Parse(txtMaxValue.Text)); bool ConfigType = false; foreach (Record r in listDataSource) { if (r.ConfigName.ToLower().Equals(cmbRiskType.Text.ToLower())) { ConfigType = true; break; } } if (!ConfigType) { listDataSource.Add(newRecord); Session["ConfigurationValues"] = listDataSource; } cmbRiskType.SelectedIndex = -1; cmbRiskType.Value = null; txtMinValue.Value = ""; txtMaxValue.Value = ""; txtMinValue.Text = ""; txtMaxValue.Text = ""; gvConfig.DataBind(); } catch (Exception ex) { CommonHelpers.writeLogToFile("gvConfig_CustomCallback: NewQuestionnaire.aspx", ex.Message); } }
private void LoadQuestionnaireList() { try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); string data = DBAgent.ExecuteStoredProcedure("dbo.spGetQuestionnaierList"); DataSet ds = CommonHelpers.GetDataSetFromXml(data); if (ds.Tables.Count > 0) { cmbQuestionnaireList.DataSource = ds.Tables[0]; cmbQuestionnaireList.TextField = "QuestionnaireName"; cmbQuestionnaireList.ValueField = "QuestionnaireID"; cmbQuestionnaireList.DataBind(); } } catch (Exception ex) { CommonHelpers.writeLogToFile("LoadQuestionList: EditQuestionnaire.aspx", ex.Message); } }
protected void PatientListGridView_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamPatientID", 0); DBAgent.AddParameter("@ParamFirstName", e.NewValues["PatientFirstName"]); DBAgent.AddParameter("@ParamLastName", e.NewValues["PatientLastName"]); DBAgent.AddParameter("@ParamAccount", e.NewValues["PatientAccountNumber"]); DBAgent.AddParameter("@ParamDOB", e.NewValues["PatientDOB"]); DBAgent.AddParameter("@ParamPrimaryPhysicianID", e.NewValues["PhysicianName"]); DBAgent.AddParameter("@ParamLoginID", Session["LoginID"]); DBAgent.ExecuteNonQuery("spAddEditPatient"); e.Cancel = true; PatientListGridView.CancelEdit(); } catch (Exception ex) { CommonHelpers.writeLogToFile("PatientListGridView_RowInserting: PatientList.aspx", ex.Message); } }
protected void cmdSaveQuestion_Click(object sender, EventArgs e) { try { int QuestionID = 0; DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamQuestionText", txtQuestion.Text); object o = DBAgent.ExecuteScalar("dbo.spAddQuestion"); if (o != null) { QuestionID = int.Parse(o.ToString()); if (QuestionID > 0) { int AnswerSortOrder = 1; foreach (ListEditItem li in lbSelectedAnswers.Items) { DBAgent.ClearParams(); DBAgent.AddParameter("@ParamQuestionID", QuestionID); DBAgent.AddParameter("@ParamAnswerID", li.Value); DBAgent.AddParameter("@ParamAnswerSortOrder", AnswerSortOrder); DBAgent.ExecuteNonQuery("dbo.spAddQuestionAnswerMapping"); AnswerSortOrder++; } DBAgent.ClearParams(); DBAgent.AddParameter("@ParamQuestionnaireID", cmbQuestionnaireList.SelectedItem.Value); DBAgent.AddParameter("@ParamQuestionID", QuestionID); DBAgent.ExecuteNonQuery("dbo.spAddQuestionnaireQuestionMapping"); QuestionsGridView.DataBind(); RefreshForm(); } } QuestionsGridView.DataBind(); } catch (Exception ex) { CommonHelpers.writeLogToFile("cmdSaveQuestion_Click: EditQuestionnaire.aspx", ex.Message); } }
private void GetPhysicianList() { try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.ClearParams(); DBAgent.AddParameter("@ParamShowDeleted", 1); string data = DBAgent.ExecuteStoredProcedure("dbo.spGetallPhysicians"); if (!String.IsNullOrEmpty(data)) { DataSet ds = CommonHelpers.GetDataSetFromXml(data); if (ds.Tables.Count > 0) { Session["PhysicianDS"] = ds.Tables[0]; } } } catch (Exception ex) { CommonHelpers.writeLogToFile("GetPhysicianList: PatientList.aspx", ex.Message); } }