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 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)
{
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();
}
/// Function Header*******************************************************
/// Function Name: SaveUserRiskStratificationProcessDetails
/// Function Type: Function
/// Functionality: used to save the details of risk stratification process step 1 part A
/// Input:
/// Output:
/// Return Value:
/// Note:
/// *********************************************************************
public int SaveUserRiskStratificationProcessDetailsStepSecond(List<Entity.QuestionnaireInfo> oListQuestionnaireInfo, Guid _guidUserId)
{
using (TLWDALDataContext _db = new TLWDALDataContext())
{
int intRetVal = 1;
var _varQuestion = _db.UserRiskStratificationDetails.Where(x => x.guidUserId.Equals(_guidUserId)
&& x.strStratificationStep.Equals("2")
).ToList();
if (_varQuestion != null)
{
_db.UserRiskStratificationDetails.DeleteAllOnSubmit(_varQuestion);
_db.SubmitChanges();
}
List<DAL.UserRiskStratificationDetail> oListUserRiskStratificationDetailDAL = new List<DAL.UserRiskStratificationDetail>();
foreach (var item in oListQuestionnaireInfo)
{
DAL.UserRiskStratificationDetail oUserRiskStratificationDetail = new UserRiskStratificationDetail();
oUserRiskStratificationDetail.intQuestionnaireId = item.IntQuestionnaireId;
oUserRiskStratificationDetail.strQuestion = item.StrQuestion;
oUserRiskStratificationDetail.strAnswer = item.StrAnswer;
oUserRiskStratificationDetail.dtCreatedOn = item.DtCreatedDate;
oUserRiskStratificationDetail.guidUserId = _guidUserId;
oUserRiskStratificationDetail.strStratificationStep = "2";
oListUserRiskStratificationDetailDAL.Add(oUserRiskStratificationDetail);
oUserRiskStratificationDetail = null;
}
_db.UserRiskStratificationDetails.InsertAllOnSubmit(oListUserRiskStratificationDetailDAL);
_db.SubmitChanges();
UserLib oUserLib = new UserLib();
oUserLib.UpdateUserStratificationStep(_guidUserId, "2");
oUserLib = null;
oListUserRiskStratificationDetailDAL = null;
oListQuestionnaireInfo = null;
return intRetVal;
}
}