protected void Page_Load(object sender, EventArgs e)
{
MembershipUser currentUser = Membership.GetUser();
AccountClass objAccountClass;
objAccountClass = new AccountClass(objSqlConnClass.sqlConnection);
BackofficeClass objBackOfficeClass;
objBackOfficeClass = new BackofficeClass(objSqlConnClass.OpenConnection());
DataSet DS = objBackOfficeClass.Mem_GET_UserInfo(currentUser.UserName);
if (DS != null)
{
if (DS.Tables[0].Rows.Count > 0)
{
if (DS.Tables[0].Rows[0]["ROLENAME"].ToString().Equals("User"))
{
string strTemp = DS.Tables[0].Rows[0]["strRiskStratificationProcessStep"].ToString();
if (DS.Tables[0].Rows[0]["strRiskStratificationProcessStep"].ToString().Equals(string.Empty) || DS.Tables[0].Rows[0]["strRiskStratificationProcessStep"].ToString() != "6")
Response.Redirect(AppConfig.GetBaseSiteUrl() + "Users/RiskStratificationProcessStep1.aspx?id=" + AppLib.Encrypt(currentUser.UserName), true);
}
}
}
DS = null;
objTemplateClass = new TemplateClass(objSqlConnClass.OpenConnection());
}
protected void lnkBtnSubmit_Click(object sender, EventArgs e)
{
try
{
/*if (!chkWaiverAgreement.Checked)
{
lblError.Text = "Please accept the waiver agreement";
return;
}
else
{*/
SqlConnClass objSqlConnClass = new SqlConnClass();
BackofficeClass objBackOfficeClass = new BackofficeClass();
PALClass objPALClass;
objPALClass = new PALClass(objSqlConnClass.OpenConnection());
objBackOfficeClass = new BackofficeClass(objSqlConnClass.sqlConnection);
DataSet DS1 = objBackOfficeClass.Mem_GET_UserInfo(AppLib.GetLoggedInUserName());
if (DS1 != null)
{
if (DS1.Tables[0].Rows.Count > 0)
{
BLL.UserLib oUserLib = new BLL.UserLib();
oUserLib.UpdateUserStratificationStep(new Guid(DS1.Tables[0].Rows[0]["USER_ID"].ToString()), "3");
oUserLib = null;
Response.Redirect(AppConfig.GetBaseSiteUrl() + "Users/RiskStratificationProcessStep4.aspx?id=" + Request.QueryString["id"].ToString() + "&c=" + Request.QueryString["c"].ToString() + "&sc=" + Request.QueryString["sc"].ToString());
}
}
//}
}
catch { }
}
protected void lnkBtnSubmit_Click(object sender, EventArgs e)
{
try
{
SqlConnClass objSqlConnClass = new SqlConnClass();
BackofficeClass objBackOfficeClass = new BackofficeClass();
DDClass objDDClass;
objDDClass = new DDClass(objSqlConnClass.OpenConnection());
objBackOfficeClass = new BackofficeClass(objSqlConnClass.sqlConnection);
DataSet DS1 = objBackOfficeClass.Mem_GET_UserInfo(AppLib.GetLoggedInUserName());
if (DS1 != null)
{
if (DS1.Tables[0].Rows.Count > 0)
{
DataSet DS = objDDClass.DD_INSERT_DdUsers(DS1.Tables[0].Rows[0]["USER_ID"].ToString(), txtCalories.Text.Trim());
objSqlConnClass.CloseConnection();
objBackOfficeClass = null;
objDDClass = null;
}
}
BLL.UserLib oUserLib = new BLL.UserLib();
oUserLib.UpdateUserStratificationStep(new Guid(DS1.Tables[0].Rows[0]["USER_ID"].ToString()), "5");
oUserLib = null;
Response.Redirect(AppConfig.GetBaseSiteUrl() + "Users/RiskStratificationProcessStep6.aspx?id=" + Request.QueryString["id"].ToString() + "&c=" + Request.QueryString["c"].ToString() + "&sc=" + Request.QueryString["sc"].ToString());
}
catch { }
}
protected void lnkbtnSave_Click(object sender, EventArgs e)
{
BackofficeClass objBackOfficeClass = new BackofficeClass();
DataSet DS = objBackOfficeClass.Mem_GET_UserInfo(AppLib.GetLoggedInUserName());
BLL.HotSectionDetailsLib oHotSectionDetailsLib = null;
Entity.HotSectionDetailsInfo oHotSectionDetailsInfo = null;
try
{
oHotSectionDetailsInfo = new Entity.HotSectionDetailsInfo();
if (txtHeading.Text.Length > 500)
oHotSectionDetailsInfo.StrHeading = txtHeading.Text.Substring(0, 498);
else
oHotSectionDetailsInfo.StrHeading = txtHeading.Text.Trim();
oHotSectionDetailsInfo.StrDescription = txtDescription.Text.Trim();
oHotSectionDetailsInfo.DtCreatedOn = DateTime.Now;
oHotSectionDetailsInfo.StrLink = string.Empty;
oHotSectionDetailsInfo.ChrIsDeleted = 'N';
oHotSectionDetailsInfo.ChrDisplayOnDashboard = 'Y';
oHotSectionDetailsInfo.GuidUserId = new Guid(DS.Tables[0].Rows[0]["USER_ID"].ToString());
oHotSectionDetailsLib = new BLL.HotSectionDetailsLib();
if (ViewState["IntHotSectionId"] != null)
{
oHotSectionDetailsInfo.IntHotSectionId = Convert.ToInt32(ViewState["IntHotSectionId"]);
ViewState["IntHotSectionId"] = null;
if (oHotSectionDetailsLib.UpdateHotSectionDetails(oHotSectionDetailsInfo) > 0)
Response.Redirect(AppConfig.GetBaseSiteUrl() + "BackOffice/UserUtilities/ManageHotLinks.aspx?msg=up");
else
lblMsg.Text = "Record already exists.";
}
else
{
if (oHotSectionDetailsLib.SaveHotSectionDetails(oHotSectionDetailsInfo) > 0)
Response.Redirect(AppConfig.GetBaseSiteUrl() + "BackOffice/UserUtilities/ManageHotLinks.aspx?msg=ins");
else
lblMsg.Text = "Record already exists.";
}
}
catch (Exception ex) { lblMsg.Text = ex.Message; }
finally
{
DS = null;
objBackOfficeClass = null;
oHotSectionDetailsInfo = null;
oHotSectionDetailsLib = null;
}
}
protected void lnkBtnSubmit_Click(object sender, EventArgs e)
{
if (hfCategoryId.Value.ToString() == null)
{
lblError.Text = "Please accept the waiver agreement";
return;
}
else
{
try
{
SqlConnClass objSqlConnClass = new SqlConnClass();
BackofficeClass objBackOfficeClass = new BackofficeClass();
PALClass objPALClass;
objPALClass = new PALClass(objSqlConnClass.OpenConnection());
objBackOfficeClass = new BackofficeClass(objSqlConnClass.sqlConnection);
DataSet DS1 = objBackOfficeClass.Mem_GET_UserInfo(AppLib.GetLoggedInUserName());
if (DS1 != null)
{
if (DS1.Tables[0].Rows.Count > 0)
{
DataSet DS = objPALClass.PAL_INSERTMULTIPLE_PalStarts(DS1.Tables[0].Rows[0]["USER_ID"].ToString(), hfCategoryId.Value, DateTime.Now.ToString("MM/dd/yyyy"), "1");
objSqlConnClass.CloseConnection();
objBackOfficeClass = null;
objPALClass = null;
BLL.UserLib oUserLib = new BLL.UserLib();
oUserLib.UpdateUserStratificationStep(new Guid(DS1.Tables[0].Rows[0]["USER_ID"].ToString()), "4");
oUserLib = null;
DS = null;
Response.Redirect(AppConfig.GetBaseSiteUrl() + "Users/RiskStratificationProcessStep5.aspx?id=" + Request.QueryString["id"].ToString() + "&c=" + Request.QueryString["c"].ToString() + "&sc=" + Request.QueryString["sc"].ToString());
}
}
objSqlConnClass.CloseConnection();
objBackOfficeClass = null;
objPALClass = null;
}
catch { }
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Session["strUserName"] = "******";
if (!AppLib.IsLoggedinSessionExists())
{
lblError.Text = "Your session has been expired. Please login again";
return;
}
//AppLib.GetLoggedInUserName());
#region Insert visited log details
AppLib.InsertVisitedSectionDetails("Risk Stratification Process Step 6");
#endregion
if (!Page.IsPostBack)
{
SqlConnClass objSqlConnClass = new SqlConnClass();
BackofficeClass objBackOfficeClass = new BackofficeClass();
DDClass objDDClass;
objDDClass = new DDClass(objSqlConnClass.OpenConnection());
objBackOfficeClass = new BackofficeClass(objSqlConnClass.sqlConnection);
DataSet DS1 = objBackOfficeClass.Mem_GET_UserInfo(AppLib.GetLoggedInUserName());
if (DS1 != null)
{
if (DS1.Tables[0].Rows.Count > 0)
{
BLL.UserLib oUserLib = new BLL.UserLib();
oUserLib.UpdateUserStratificationStep(new Guid(DS1.Tables[0].Rows[0]["USER_ID"].ToString()), "6");
oUserLib = null;
}
}
objBackOfficeClass = null;
objDDClass = null;
DS1 = null;
}
BindCMSText();
}
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser currentUser = Membership.GetUser();
if (!AppLib.IsLoggedinSessionExists() || currentUser == null)
Response.Redirect(AppConfig.GetBaseSiteUrl() + "Welcome/main_frame.aspx", true);
objSqlConnClass.OpenConnection();
AccountClass objAccountClass;
objAccountClass = new AccountClass(objSqlConnClass.sqlConnection);
BackofficeClass objBackOfficeClass;
objBackOfficeClass = new BackofficeClass(objSqlConnClass.sqlConnection);
#region Insert visited log details
//AppLib.InsertVisitedSectionDetails("Dashboard Page");
#endregion
DataSet DS = objBackOfficeClass.Mem_GET_UserInfo(currentUser.UserName);
if (DS != null)
{
if (DS.Tables[0].Rows.Count > 0)
{
if (DS.Tables[0].Rows[0]["ROLENAME"].ToString().Equals("User"))
{
if (DS.Tables[0].Rows[0]["strRiskStratificationProcessStep"].ToString().Equals(string.Empty) || DS.Tables[0].Rows[0]["strRiskStratificationProcessStep"].ToString() != "6")
{
DS = null;
Response.Redirect(AppConfig.GetBaseSiteUrl() + "Users/RiskStratificationProcessStep1.aspx?id=" + AppLib.Encrypt(currentUser.UserName), true);
}
}
}
}
DS = null;
objTemplateClass = new TemplateClass(objSqlConnClass.sqlConnection);
objPALClass = new PALClass(objSqlConnClass.sqlConnection);
}
private void UpdatePersonalSummaryDetails()
{
BackofficeClass objBackOfficeClass = new BackofficeClass();
DataSet DS = objBackOfficeClass.Mem_GET_UserInfo(AppLib.GetLoggedInUserName());
BLL.PersonalSummaryLib oPersonalSummaryLib = null;
Entity.PersonalSummaryInfo oPersonalSummaryInfo = null;
try
{
oPersonalSummaryLib = new BLL.PersonalSummaryLib();
oPersonalSummaryInfo = new Entity.PersonalSummaryInfo();
oPersonalSummaryInfo.DecBMI = Convert.ToDecimal(txtCurrentBMI.Text);
oPersonalSummaryInfo.DecBodyFATPercentage = Convert.ToDecimal(txtCurrentBodyFAT.Text);
oPersonalSummaryInfo.DecWaist = Convert.ToDecimal(txtCurrentWaist.Text);
oPersonalSummaryInfo.DecWaistToHeight = Convert.ToDecimal(txtCurrentWaistToHeight.Text);
oPersonalSummaryInfo.DecWaistToHip = Convert.ToDecimal(txtCurrentWaistToHips.Text);
oPersonalSummaryInfo.DecWeight = Convert.ToDecimal(txtCurrentWeight.Text);
oPersonalSummaryInfo.DtCreatedOn = DateTime.Now;
oPersonalSummaryInfo.GuidUserId = new Guid(DS.Tables[0].Rows[0]["USER_ID"].ToString());
oPersonalSummaryLib.SavePersonalSummaryDetails(oPersonalSummaryInfo);
Response.Redirect(AppConfig.GetBaseSiteUrl() + "Main/MyNutrition.aspx?msg=up");
}
catch (Exception ex) { throw ex; }
finally
{
oPersonalSummaryInfo = null;
oPersonalSummaryLib = null;
objBackOfficeClass = null;
DS = null;
}
}
/// <summary>
/// following function is used to bind the personal summary details.
/// </summary>
private void BindPersonalSummaryDetails()
{
lblCurrentPersonalSummary.Text = DateTime.Now.ToShortDateString();
BLL.PersonalSummaryLib oPersonalSummaryLib = null;
Entity.PersonalSummaryInfo oPersonalSummaryInfo = null;
BackofficeClass objBackOfficeClass = new BackofficeClass();
DataSet DS = objBackOfficeClass.Mem_GET_UserInfo(AppLib.GetLoggedInUserName());
try
{
oPersonalSummaryLib = new BLL.PersonalSummaryLib();
oPersonalSummaryInfo = new Entity.PersonalSummaryInfo();
oPersonalSummaryInfo = oPersonalSummaryLib.GetPersonalSummaryDetailsByUserId(new Guid(DS.Tables[0].Rows[0]["USER_ID"].ToString()));
if (oPersonalSummaryInfo != null)
{
ViewState["isExists"] = "1";
lblStartDatePersonalSummary.Text = oPersonalSummaryInfo.DtModifiedOn.ToShortDateString();
txtStartWeight.Text = oPersonalSummaryInfo.DecWeight.ToString("00.00");
txtStartWaistToHips.Text = oPersonalSummaryInfo.DecWaistToHip.ToString("00.00");
txtStartWaistToHeight.Text = oPersonalSummaryInfo.DecWaistToHeight.ToString("00.00");
txtStartWaist.Text = oPersonalSummaryInfo.DecWaist.ToString("00.00");
txtStartBodyFAT.Text = oPersonalSummaryInfo.DecBodyFATPercentage.ToString("00.00");
txtStartBMI.Text = oPersonalSummaryInfo.DecBMI.ToString("00.00");
}
else
ViewState["isExists"] = "0";
}
catch (Exception ex) { throw ex; }
finally
{
oPersonalSummaryLib = null;
oPersonalSummaryInfo = null;
objBackOfficeClass = null;
DS = null;
}
}
protected void lnkBtnSubmit_Click(object sender, EventArgs e)
{
try
{
bool blnIsChecked = false;
foreach (GridViewRow gvRow in GVQuestionnaire.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvRow.FindControl("rdoListAnswer");
if (!blnIsChecked)
{
if (rdoListAnswer != null)
{
if (rdoListAnswer.SelectedValue.Equals("Yes"))
{
blnIsChecked = true;
break;
}
}
}
else
{
break;
}
}
if (blnIsChecked)
{
if (!chkWaiverAgreement.Checked)
{
lblError.Text = "Please accept the waiver agreement";
return;
}
else
{
List<Entity.QuestionnaireInfo> oListQuestionnaireInfo = new List<Entity.QuestionnaireInfo>();
foreach (GridViewRow gvr in GVQuestionnaire.Rows)
{
Entity.QuestionnaireInfo oQuestionnaireInfo = new Entity.QuestionnaireInfo();
oQuestionnaireInfo.DtCreatedDate = DateTime.Now;
Label lblQuestionId = (Label)gvr.FindControl("lblQuestionId");
Label lblQuestion = (Label)gvr.FindControl("lblQuestion");
RadioButtonList rdoListAnswer = (RadioButtonList)gvr.FindControl("rdoListAnswer");
if (lblQuestionId != null && lblQuestion != null)
{
oQuestionnaireInfo.IntQuestionnaireId = Convert.ToInt32(lblQuestionId.Text);
oQuestionnaireInfo.StrQuestion = lblQuestion.Text;
oQuestionnaireInfo.StrAnswer = rdoListAnswer.SelectedValue;
}
oListQuestionnaireInfo.Add(oQuestionnaireInfo);
oQuestionnaireInfo = null;
}
BackofficeClass objBackOfficeClass = new BackofficeClass();
DataSet DS = objBackOfficeClass.Mem_GET_UserInfo(AppLib.GetLoggedInUserName());
if (DS != null)
{
if (DS.Tables[0].Rows.Count > 0)
{
BLL.QuestionnaireLib oQuestionnaireLib = new BLL.QuestionnaireLib();
oQuestionnaireLib.SaveUserRiskStratificationProcessDetailsPartB(oListQuestionnaireInfo, new Guid(DS.Tables[0].Rows[0]["USER_ID"].ToString()));
DS = null;
objBackOfficeClass = null;
oListQuestionnaireInfo = null;
Response.Redirect(AppConfig.GetBaseSiteUrl() + "Users/RiskStratificationProcessStep2.aspx?id=" + Request.QueryString["id"].ToString());
}
}
}
}
else
{
Response.Redirect(AppConfig.GetBaseSiteUrl() + "Users/RiskStratificationProcessStep2.aspx?id=" + Request.QueryString["id"].ToString());
}
}
catch (Exception ex) { lblError.Text = ex.Message; }
}
protected void lnkBtnSubmit_Click(object sender, EventArgs e)
{
BLL.QuestionnaireLib oQuestionnaireLib = new BLL.QuestionnaireLib();
try
{
bool bolIsPositiveRiskFactor = false;
int intPositiveRiskFactor = 0;
int intNegativeRiskFactor = 0;
//Response.Redirect(AppConfig.GetBaseSiteUrl() + "Users/RiskStratificationProcessStep3.aspx?id=" + Request.QueryString["id"].ToString());
foreach (GridViewRow gvr in GVQuestionnaireHeading.Rows)
{
Label lblQuestionHeading = (Label)gvr.FindControl("lblQuestionHeading");
GridView GVQuestion = (GridView)gvr.FindControl("GVQuestion");
string strQuestHeading = lblQuestionHeading.Text;
if (lblQuestionHeading != null)
{
if (!strQuestHeading.ToLower().Equals("age"))
{
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
Label lblQuestionId = (Label)gvrQuestions.FindControl("lblQuestionId");
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (lblQuestionId.Text.Equals("18"))
{
//18 means 45 old
}
else if (lblQuestionId.Text.Equals("19"))
{
//19 means 55 old
}
}
}
if (strQuestHeading.ToLower().Equals("positive risk factor"))
{
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (rdoListAnswer != null)
{
if (rdoListAnswer.SelectedValue.Equals("Yes"))
bolIsPositiveRiskFactor = true;
}
}
}
else if (strQuestHeading.ToLower().Equals("cholesterol"))
{
bool blnIsAdded = false;
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (rdoListAnswer.SelectedValue.Equals("Yes"))
{
if (!blnIsAdded)
{
blnIsAdded = true;
intNegativeRiskFactor = intNegativeRiskFactor + 1;
}
}
}
}
else if (strQuestHeading.ToLower().Equals("hypertension"))
{
bool blnIsAdded = false;
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (rdoListAnswer.SelectedValue.Equals("Yes"))
{
if (!blnIsAdded)
{
blnIsAdded = true;
intNegativeRiskFactor = intNegativeRiskFactor + 1;
}
}
}
}
else if (strQuestHeading.ToLower().Equals("smoking"))
{
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (rdoListAnswer.SelectedValue.Equals("Yes"))
{
//Response.Write("smoking=" + intNegativeRiskFactor);
intNegativeRiskFactor = intNegativeRiskFactor + 1;
}
}
}
else if (strQuestHeading.ToLower().Equals("pre-diabetes"))
{
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (rdoListAnswer.SelectedValue.Equals("Yes"))
intNegativeRiskFactor = intNegativeRiskFactor + 1;
}
}
else if (strQuestHeading.ToLower().Equals("weight"))
{
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (rdoListAnswer.SelectedValue.Equals("Yes"))
intNegativeRiskFactor = intNegativeRiskFactor + 1;
}
}
else if (strQuestHeading.ToLower().Equals("activity factor"))
{
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (rdoListAnswer.SelectedValue.Equals("Yes"))
intNegativeRiskFactor = intNegativeRiskFactor + 1;
}
}
}
}
if (bolIsPositiveRiskFactor)
intNegativeRiskFactor = intNegativeRiskFactor - 1;
int intScore = 0;
int intCategory = 0;
//intScore = intNegativeRiskFactor - intPositiveRiskFactor;
intScore = intNegativeRiskFactor;
objBackOfficeClass = new BackofficeClass();
string strEmailId = AppLib.Decrypt(Request.QueryString["id"].ToString());
if (!oQuestionnaireLib.HasUserGivenYesAnswerinFirstRiskStratificationStep(strEmailId))
{
oQuestionnaireLib = null;
DataSet DS = objBackOfficeClass.Mem_GET_UserInfo(strEmailId);
if (DS != null)
{
if (DS.Tables[0].Rows.Count > 0)
{
int intCurrentYear = DateTime.Now.Year;
int intBirthYear = Convert.ToDateTime(DS.Tables[0].Rows[0]["DATE_BIRTH"]).Year;
int intPresentAge = intCurrentYear - intBirthYear;
int intGenderCode = Convert.ToInt32(DS.Tables[0].Rows[0]["GENDER_ID"]);
if ((intGenderCode.Equals(1) && intPresentAge <= 45) || (intGenderCode.Equals(2) && intPresentAge <= 55))
{///1 = male, 2= female
if (intScore <= 1)
{
/*Well category Low Risk*/
intCategory = 0;
category = "Well";
}
if (intScore >= 2)
{
/*Living category Medium Risk*/
intCategory = 2;
category = "Living";
}
}
else if ((intGenderCode.Equals(1) && intPresentAge > 45) || (intGenderCode.Equals(2) && intPresentAge > 55))
{///1 = male, 2= female
if (intScore >= 2)
{
/*Living category Medium Risk*/
intCategory = 2;
category = "Living";
}
if (intScore <= 1)
{
/*Well category Low Risk*/
intCategory = 0;
category = "Well";
}
}
else
{
intCategory = 1;
category = "Tri";
//try and high risk
/*if user given any yes answer at the step 1 questions*/
}
}
}
DS = null;
objBackOfficeClass = null;
}
else
{ //try and high risk
intCategory = 1;
category = "Tri";
/*Means user given any yes answer at the step 1 questions*/
}
List<Entity.QuestionnaireInfo> oListQuestionnaireInfo = new List<Entity.QuestionnaireInfo>();
foreach (GridViewRow gvr in GVQuestionnaireHeading.Rows)
{
GridView GVQuestion = (GridView)gvr.FindControl("GVQuestion");
if (GVQuestion != null)
{
foreach (GridViewRow gvrQuestion in GVQuestion.Rows)
{
Entity.QuestionnaireInfo oQuestionnaireInfo = new Entity.QuestionnaireInfo();
oQuestionnaireInfo.DtCreatedDate = DateTime.Now;
Label lblQuestionId = (Label)gvrQuestion.FindControl("lblQuestionId");
Label lblQuestion = (Label)gvrQuestion.FindControl("lblQuestion");
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestion.FindControl("rdoListAnswer");
if (lblQuestionId != null && lblQuestion != null)
{
oQuestionnaireInfo.IntQuestionnaireId = Convert.ToInt32(lblQuestionId.Text);
oQuestionnaireInfo.StrQuestion = lblQuestion.Text;
oQuestionnaireInfo.StrAnswer = rdoListAnswer.SelectedValue;
}
oListQuestionnaireInfo.Add(oQuestionnaireInfo);
oQuestionnaireInfo = null;
}
}
}
objBackOfficeClass = new BackofficeClass();
DataSet DS1 = objBackOfficeClass.Mem_GET_UserInfo(AppLib.GetLoggedInUserName());
if (DS1 != null)
{
if (DS1.Tables[0].Rows.Count > 0)
{
oQuestionnaireLib = new BLL.QuestionnaireLib();
oQuestionnaireLib.SaveUserRiskStratificationProcessDetailsStepSecond(oListQuestionnaireInfo, new Guid(DS1.Tables[0].Rows[0]["USER_ID"].ToString()));
BLL.UserLib oUserLib = new BLL.UserLib();
if (!oUserLib.CheckUserAssessmentAlreadyExists(new Guid(DS1.Tables[0].Rows[0]["USER_ID"].ToString())))
objBackOfficeClass.Mem_INSERT_UserAssessments(DS1.Tables[0].Rows[0]["USER_ID"].ToString(), "1", intScore.ToString());
objBackOfficeClass = null;
oListQuestionnaireInfo = null;
DS1 = null;
oUserLib = null;
Response.Redirect(AppConfig.GetBaseSiteUrl() + "Users/RiskStratificationProcessStep3.aspx?id=" + Request.QueryString["id"].ToString() + "&sc=" + AppLib.Encrypt(intScore.ToString()) + "&c=" + AppLib.Encrypt(intCategory.ToString()) + "&cat=" + category.ToString());
}
}
}
catch (Exception ex) { lblError.Text = ex.Message; }
finally { oQuestionnaireLib = null; }
}
/// <summary>
/// following function is used to check whether the current logged in user is male or female
/// </summary>
private void FindLoggedInUserGender()
{
string strEmailId = AppLib.Decrypt(Request.QueryString["id"].ToString());
objBackOfficeClass = new BackofficeClass();
DataSet DS = objBackOfficeClass.Mem_GET_UserInfo(strEmailId);
if (DS != null)
{
if (DS.Tables[0].Rows.Count > 0)
intGenderID = Convert.ToInt32(DS.Tables[0].Rows[0]["GENDER_ID"]);
}
DS = null;
objBackOfficeClass = null;
}
protected void lnkCalculateScore_Click(object sender, EventArgs e)
{
try
{
bool bolIsPositiveRiskFactor = false;
int intPositiveRiskFactor = 0;
int intNegativeRiskFactor = 0;
//Response.Redirect(AppConfig.GetBaseSiteUrl() + "Users/RiskStratificationProcessStep3.aspx?id=" + Request.QueryString["id"].ToString());
foreach (GridViewRow gvr in GVQuestionnaireHeading.Rows)
{
Label lblQuestionHeading = (Label)gvr.FindControl("lblQuestionHeading");
GridView GVQuestion = (GridView)gvr.FindControl("GVQuestion");
string strQuestHeading = lblQuestionHeading.Text;
if (lblQuestionHeading != null)
{
if (!strQuestHeading.ToLower().Equals("age"))
{
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
Label lblQuestionId = (Label)gvrQuestions.FindControl("lblQuestionId");
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (lblQuestionId.Text.Equals("18"))
{
//18 means 45 old
}
else if (lblQuestionId.Text.Equals("19"))
{
//19 means 55 old
}
}
}
if (strQuestHeading.ToLower().Equals("positive risk factor"))
{
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (rdoListAnswer != null)
{
if (rdoListAnswer.SelectedValue.Equals("Yes"))
bolIsPositiveRiskFactor = true;
}
}
}
else if (strQuestHeading.ToLower().Equals("cholesterol"))
{
bool blnIsAdded = false;
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (rdoListAnswer.SelectedValue.Equals("Yes"))
{
if (!blnIsAdded)
{
blnIsAdded = true;
intNegativeRiskFactor = intNegativeRiskFactor + 1;
}
}
}
}
else if (strQuestHeading.ToLower().Equals("hypertension"))
{
bool blnIsAdded = false;
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (rdoListAnswer.SelectedValue.Equals("Yes"))
{
if (!blnIsAdded)
{
blnIsAdded = true;
intNegativeRiskFactor = intNegativeRiskFactor + 1;
}
}
}
}
else if (strQuestHeading.ToLower().Equals("smoking"))
{
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (rdoListAnswer.SelectedValue.Equals("Yes"))
{
//Response.Write("smoking=" + intNegativeRiskFactor);
intNegativeRiskFactor = intNegativeRiskFactor + 1;
}
}
}
else if (strQuestHeading.ToLower().Equals("pre-diabetes"))
{
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (rdoListAnswer.SelectedValue.Equals("Yes"))
intNegativeRiskFactor = intNegativeRiskFactor + 1;
}
}
else if (strQuestHeading.ToLower().Equals("weight"))
{
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (rdoListAnswer.SelectedValue.Equals("Yes"))
intNegativeRiskFactor = intNegativeRiskFactor + 1;
}
}
else if (strQuestHeading.ToLower().Equals("activity factor"))
{
foreach (GridViewRow gvrQuestions in GVQuestion.Rows)
{
RadioButtonList rdoListAnswer = (RadioButtonList)gvrQuestions.FindControl("rdoListAnswer");
if (rdoListAnswer.SelectedValue.Equals("Yes"))
intNegativeRiskFactor = intNegativeRiskFactor + 1;
}
}
}
}
// Response.Write(intNegativeRiskFactor.ToString());
if (bolIsPositiveRiskFactor)
intNegativeRiskFactor = intNegativeRiskFactor - 1;
int intScore = 0;
int intCategory = 0;
//intScore = intNegativeRiskFactor - intPositiveRiskFactor;
intScore = intNegativeRiskFactor;
objBackOfficeClass = new BackofficeClass();
string strEmailId = AppLib.Decrypt(Request.QueryString["id"].ToString());
DataSet DS = objBackOfficeClass.Mem_GET_UserInfo(strEmailId);
if (DS != null)
{
if (DS.Tables[0].Rows.Count > 0)
{
int intCurrentYear = DateTime.Now.Year;
int intBirthYear = Convert.ToDateTime(DS.Tables[0].Rows[0]["DATE_BIRTH"]).Year;
int intPresentAge = intCurrentYear - intBirthYear;
int intGenderCode = Convert.ToInt32(DS.Tables[0].Rows[0]["GENDER_ID"]);
if ((intGenderCode.Equals(1) && intPresentAge <= 45) || (intGenderCode.Equals(2) && intPresentAge <= 55))
{///1 = male, 2= female
if (intScore <= 1)
{
/*Well category Low Risk*/
intCategory = 0;
category = "Well";
}
if (intScore >= 2)
{
/*Living category Medium Risk*/
intCategory = 2;
category = "Living";
}
}
else if ((intGenderCode.Equals(1) && intPresentAge > 45) || (intGenderCode.Equals(2) && intPresentAge > 55))
{///1 = male, 2= female
if (intScore >= 2)
{
/*Living category Medium Risk*/
intCategory = 2;
category = "Living";
}
if (intScore <= 1)
{
/*Well category Low Risk*/
intCategory = 0;
category = "Well";
}
}
else
{
intCategory = 1;
category = "Tri";
//try and high risk
/*if user given any yes answer at the step 1 questions*/
}
}
}
DS = null;
objBackOfficeClass = null;
//lblTotalScore.Text = "Your Score:" + " " + intScore.ToString();
}
catch { }
finally { }
}
protected void Page_Load(object sender, EventArgs e)
{
objPALClass = new PALClass(objSqlConnClass.OpenConnection());
gsUserID = Membership.GetUser().ProviderUserKey.ToString();
MembershipUser currentUser = Membership.GetUser();
if (!AppLib.IsLoggedinSessionExists() || currentUser == null)
Response.Redirect(AppConfig.GetBaseSiteUrl() + "Welcome/main_frame.aspx", true);
AccountClass objAccountClass;
objAccountClass = new AccountClass(objSqlConnClass.sqlConnection);
BackofficeClass objBackOfficeClass;
objBackOfficeClass = new BackofficeClass(objSqlConnClass.OpenConnection());
#region Insert visited log details
AppLib.InsertVisitedSectionDetails("Dashboard Page");
#endregion
DataSet DS = objBackOfficeClass.Mem_GET_UserInfo(currentUser.UserName);
if (DS != null)
{
if (DS.Tables[0].Rows.Count > 0)
{
if (DS.Tables[0].Rows[0]["ROLENAME"].ToString().Equals("User"))
{
if (DS.Tables[0].Rows[0]["strRiskStratificationProcessStep"].ToString().Equals(string.Empty) || DS.Tables[0].Rows[0]["strRiskStratificationProcessStep"].ToString() != "6")
{
DS = null;
Response.Redirect(AppConfig.GetBaseSiteUrl() + "Users/RiskStratificationProcessStep1.aspx?id=" + AppLib.Encrypt(currentUser.UserName), true);
}
}
}
}
BindNutritionalJournal();
DS = null;
objTemplateClass = new TemplateClass(objSqlConnClass.OpenConnection());
int ileftMargin = 0;
string sTriangleImg = "triangle1.jpg";
int iMET = 0;
string sLastWorkout = "";
DataSet entries = objPALClass.PAL_GET_PalEntries_BY_UserId(gsUserID, "", "");
foreach (DataRow DR in entries.Tables[0].Rows)
{
iMET += Convert.ToInt32(DR["MET_EQUIVALENT"]);
sLastWorkout = DR["PAL_ENTRY_DATE"].ToString();
}
labelLastWorkout.Text = sLastWorkout;
iMET = 100;
// 0
if (iMET <= 0)
{
ileftMargin = 7;
sTriangleImg = "triangle1.jpg";
}
// 1
else if (iMET <= 100)
{
ileftMargin = 32;
sTriangleImg = "triangle1.jpg";
}
// 2
else if (iMET <= 200)
{
ileftMargin = 52;
sTriangleImg = "triangle2.jpg";
}
// 3
else if (iMET <= 300)
{
ileftMargin = 72;
sTriangleImg = "triangle3.jpg";
}
// 4
else if (iMET <= 400)
{
ileftMargin = 92;
sTriangleImg = "triangle4.jpg";
}
// 5
else if (iMET <= 500)
{
ileftMargin = 112;
sTriangleImg = "triangle5.jpg";
}
// 6
else if (iMET <= 600)
{
ileftMargin = 132;
sTriangleImg = "triangle6.jpg";
}
// 7
else if (iMET <= 700)
{
ileftMargin = 152;
sTriangleImg = "triangle7.jpg";
}
// 8
else if (iMET <= 800)
{
ileftMargin = 172;
sTriangleImg = "triangle8.jpg";
}
// 9
else if (iMET <= 900)
{
ileftMargin = 192;
sTriangleImg = "triangle9.jpg";
}
// 10
else if (iMET > 900)
{
ileftMargin = 212;
sTriangleImg = "triangle10.jpg";
}
literalTriangle.Text = "<img style='margin-left:20px;' src='" + AppConfig.GetBaseSiteUrl() + "Images/dashboard/" + sTriangleImg + "' />";
literalMetsMarker.Text = "<div style='width:30px;margin-left:" + ileftMargin.ToString() + "px;margin-top:-7px;font-weight:bold;font-size:larger;font-color:Black;text-align:center;line-height:80%'>▲<br />" + iMET.ToString() + "</div>";
getActivitiesData();
}
private void BindDetails()
{
BackofficeClass objBackOfficeClass = new BackofficeClass();
DataSet DS = objBackOfficeClass.Mem_GET_UserInfo(AppLib.GetLoggedInUserName());
BLL.HotSectionDetailsLib oHotSectionDetailsLib = null;
try
{
oHotSectionDetailsLib = new BLL.HotSectionDetailsLib();
Guid _guidUserID = new Guid(DS.Tables[0].Rows[0]["USER_ID"].ToString());
GVLinks.DataSource = oHotSectionDetailsLib.GetAllHotSectionsByUserId(_guidUserID);
GVLinks.DataBind();
}
catch (Exception ex) { lblMsg.Text = ex.Message; }
finally
{
DS = null;
objBackOfficeClass = null;
oHotSectionDetailsLib = null;
}
}