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 AnswersGridView_Init(object sender, EventArgs e)
{
ASPxGridView childGrid = sender as ASPxGridView;
object key = childGrid.GetMasterRowKeyValue();
DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]);
DBAgent.AddParameter("@ParamQID", key);
string data = DBAgent.ExecuteStoredProcedure("dbo.spGetQuestionDetails");
DataSet ds = CommonHelpers.GetDataSetFromXml(data);
if (ds.Tables.Count > 0)
{
childGrid.DataSource = ds.Tables[0];
}
}
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 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);
}
}
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);
}
}
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);
}
}
protected void cmdLogin_Click(object sender, EventArgs e)
{
try
{
lblErr.Text = "";
bool ValidUser = false;
bool TempPassword = false;
securityAgent = new CryptoProvider();
DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]);
DBAgent.AddParameter("@ParamUserName", txtUserName.Value);
string data = DBAgent.ExecuteStoredProcedure("dbo.spGetUserDetails");
if (string.IsNullOrEmpty(data))
{
ValidUser = false;
lblErr.Text = "Invalid Username/Password conbination. Please try again";
DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]);
DBAgent.AddParameter("@ParamRefID", 0);
DBAgent.AddParameter("@ParamRefType", "Users");
DBAgent.AddParameter("@ParamAction", "FL");
DBAgent.AddParameter("@ParamComment", "Login Failed - " + txtUserName.Value);
DBAgent.ExecuteNonQuery("dbo.spAddUserAction");
}
else
{
DataSet ds = CommonHelpers.GetDataSetFromXml(data);
if (ds.Tables.Count > 0)
{
DataRow dRow = ds.Tables[0].Rows[0];
string upassword = "";
if ((bool.Parse(dRow["IsTempPassword"].ToString())))
{
upassword = dRow["Password"].ToString();
TempPassword = true;
}
else
{
TempPassword = false;
string test = securityAgent.EncryptText("ClarityApp");
upassword = securityAgent.decryptText(dRow["Password"].ToString().Replace(" ", "+"));
}
if (upassword.Equals(txtPassword.Value))
{
DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]);
DBAgent.AddParameter("@ParamRefID", dRow["LoginID"].ToString());
DBAgent.AddParameter("@ParamRefType", "Users");
DBAgent.AddParameter("@ParamAction", "LI");
DBAgent.ExecuteNonQuery("dbo.spAddUserAction");
ValidUser = true;
Session["FullName"] = String.Format("{0}, {1}", dRow["LastName"], dRow["FirstName"]);
if (!TempPassword)
{
Session["LoginID"] = dRow["LoginID"].ToString();
Session["UserName"] = dRow["Username"].ToString();
Response.Redirect("Dashboard.aspx", true);
}
else
{
Response.Redirect(String.Format("ResetPassword.aspx?UN={0}&UID={1}", securityAgent.EncryptText(txtUserName.Text), securityAgent.EncryptText(dRow["LoginID"].ToString())), true);
}
}
else
{
ValidUser = false;
lblErr.Text = "Invalid Username/Password conbination. Please try again";
DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]);
DBAgent.AddParameter("@ParamRefID", 0);
DBAgent.AddParameter("@ParamRefType", "Users");
DBAgent.AddParameter("@ParamAction", "FL");
DBAgent.AddParameter("@ParamComment", "Login Failed - " + txtUserName.Value);
DBAgent.ExecuteNonQuery("dbo.spAddUserAction");
}
}
}
}
catch (Exception ex)
{
lblErr.Text = "There was a problem processing your request. Please contact IT.";
lblErr.Visible = true;
CommonHelpers.writeLogToFile("cmdLogin_Click: Login.aspx", ex.Message);
}
}
