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