protected void lbDel_Click(object sender, EventArgs e)
{
surveyQuestionMultiPage.SelectedIndex = 1;
surveyDataClassDataContext.hitbl_Survey_Answer_Row_SARs.DeleteOnSubmit(currentRowAnswer);
surveyDataClassDataContext.SubmitChanges();
Visible = false;
}
public bool SaveSubStep()
{
currentQuestion.QuestionText = txtQ.Content;
litQ.Text = txtQ.Content;
surveyDataClassDataContext.SubmitChanges();
return(true);
}
protected void lbOK_Click(object sender, EventArgs e)
{
if (currentTestResult == null)
{
currentTestResult = new hitbl_Survey_TestResult_STR
{
STR_ID = Guid.NewGuid()
};
currentTestResult.OBJ_ID = survey.ObjectID.Value;
surveyDataClassDataContext.hitbl_Survey_TestResult_STRs.InsertOnSubmit(currentTestResult);
}
currentTestResult.ResultText = txtT.Text;
double value;
currentTestResult.ValueFrom = double.TryParse(txtPS.Text, out value) ? value : 0;
currentTestResult.ValueTo = double.TryParse(txtPE.Text, out value) ? value : 0;
surveyDataClassDataContext.SubmitChanges();
}
private void FillEditForm()
{
FillHiddenFields();
//Add the "AddNewPage" Tab
RadPageView rpAddNew = new RadPageView
{
ID = "NewPage"
};
radMultiPage.PageViews.Add(rpAddNew);
radTab.Tabs.Add(new RadTab(GuiLanguage.GetGuiLanguage("DataObjectSurvey").GetString("TabAddNewPage"), "NewPage"));
var allSurveyPages = from allPages in surveyDataClassDataContext.hitbl_Survey_Page_SPGs.Where(x => x.OBJ_ID == survey.ObjectID)
orderby allPages.SortNumber ascending
select allPages;
if (allSurveyPages.Count() == 0)
{
//One Page schould allways exits.. so createit
hitbl_Survey_Page_SPG firstPage = new hitbl_Survey_Page_SPG
{
OBJ_ID = survey.ObjectID.Value,
Title = GuiLanguage.GetGuiLanguage("DataObjectSurvey").GetString("StartPageName"),
SortNumber = 0,
SPG_ID = Guid.NewGuid()
};
surveyDataClassDataContext.hitbl_Survey_Page_SPGs.InsertOnSubmit(firstPage);
surveyDataClassDataContext.SubmitChanges();
allSurveyPages = from allPages in surveyDataClassDataContext.hitbl_Survey_Page_SPGs.Where(x => x.OBJ_ID == survey.ObjectID)
orderby allPages.SortNumber ascending
select allPages;
}
int i = 0;
foreach (hitbl_Survey_Page_SPG surveyPage in allSurveyPages)
{
CreateTabContext(i++, surveyPage);
}
}
protected void lbtnNT_OnClick(object sender, EventArgs e)
{
if (numberOfResultTexts == 0)
{
phTextResults.Controls.Add(new LiteralControl(headerText));
}
hitbl_Survey_TestResult_STR testResult = new hitbl_Survey_TestResult_STR
{
OBJ_ID = survey.ObjectID.Value,
STR_ID = Guid.NewGuid()
};
surveyDataClassDataContext.hitbl_Survey_TestResult_STRs.InsertOnSubmit(testResult);
surveyDataClassDataContext.SubmitChanges();
LoadTestResultsControl(testResult);
}
private void lbtnFinish_Click(object sender, EventArgs e)
{
bool isInputComplete = true;
StringBuilder sbMailText = new StringBuilder();
double calculatePoints = 0.0;
var surveyPages = from allPages in surveyDataClassDataContext.hitbl_Survey_Page_SPGs.Where(x => x.OBJ_ID == dataObjectSurvey.ObjectID.Value)
orderby allPages.SortNumber ascending
select allPages;
countSurveyPages = surveyPages.Count();
string answerKey = string.Empty;
//Save The Test for The user
hitbl_Survey_User_Result_SUR hitblSurveyUserResult = new hitbl_Survey_User_Result_SUR
{
SUR_ID = Guid.NewGuid(),
OBJ_ID = dataObjectSurvey.ObjectID.Value,
TestTitle = dataObjectSurvey.Title,
TestDate = DateTime.Now,
Status = 1,
IsContest = dataObjectSurvey.IsContest
};
if (Request.IsAuthenticated && !dataObjectSurvey.ShowForm)
{
DataObjectUser dataObjectSurveyUser = DataObject.Load <DataObjectUser>(UserDataContext.GetUserDataContext().UserID);
if (dataObjectSurveyUser.State != ObjectState.Added)
{
hitblSurveyUserResult.Email = dataObjectSurveyUser.GetMail;
hitblSurveyUserResult.Name = dataObjectSurveyUser.Name;
hitblSurveyUserResult.Vorname = dataObjectSurveyUser.Vorname;
hitblSurveyUserResult.USR_ID = dataObjectSurveyUser.ObjectID.Value;
}
}
surveyDataClassDataContext.hitbl_Survey_User_Result_SURs.InsertOnSubmit(hitblSurveyUserResult);
foreach (hitbl_Survey_Page_SPG surveyPage in surveyPages)
{
foreach (hitbl_Survey_Question_SQU surveyQuestion in surveyPage.hitbl_Survey_Question_SQUs.OrderBy(x => x.SortNumber))
{
sbMailText.AppendFormat("{0} <br/>", surveyQuestion.QuestionText);
if (surveyQuestion.QuestionType != SurveyAnswersType.NotSelected && surveyQuestion.QuestionType != SurveyAnswersType.NoAnswers)
{
hitbl_Survey_User_ResultItem_SUI hitblSurveyUserResultItem = new hitbl_Survey_User_ResultItem_SUI
{
SUI_ID = Guid.NewGuid(),
SQU_ID = surveyQuestion.SQU_ID,
QuestionText = surveyQuestion.QuestionText,
Answer = string.Empty,
AnswerWeight = 0.0
};
switch (surveyQuestion.QuestionType)
{
case SurveyAnswersType.SingleTextbox:
answerKey = string.Format("txt_{0}", surveyQuestion.SQU_ID);
TextBox txtAnswer = AnswerControls[answerKey] as TextBox;
if (txtAnswer.Text.Trim().Length > 0)
{
try
{
hitblSurveyUserResultItem.AnswerWeight = (surveyQuestion.hitbl_Survey_Answer_Row_SARs[0].AnswerWeight.HasValue ? surveyQuestion.hitbl_Survey_Answer_Row_SARs[0].AnswerWeight.Value : 0.0);
calculatePoints = calculatePoints + hitblSurveyUserResultItem.AnswerWeight.Value;
hitblSurveyUserResultItem.Answer = txtAnswer.Text;
sbMailText.AppendFormat("{0} <br/><hr/>", txtAnswer.Text);
}
catch (Exception exception)
{
}
}
break;
case SurveyAnswersType.Textarea:
answerKey = string.Format("txtArea_{0}", surveyQuestion.SQU_ID);
TextBox txtAreaAnswer = AnswerControls[answerKey] as TextBox;
if (txtAreaAnswer.Text.Trim().Length > 0)
{
try
{
hitblSurveyUserResultItem.AnswerWeight = (surveyQuestion.hitbl_Survey_Answer_Row_SARs[0].AnswerWeight.HasValue ? surveyQuestion.hitbl_Survey_Answer_Row_SARs[0].AnswerWeight.Value : 0.0);
calculatePoints = calculatePoints + hitblSurveyUserResultItem.AnswerWeight.Value;
hitblSurveyUserResultItem.Answer = txtAreaAnswer.Text;
sbMailText.AppendFormat("{0} <br/><hr/>", txtAreaAnswer.Text);
}
catch (Exception exception)
{
}
}
break;
case SurveyAnswersType.MultipleChoiceMultipleAnswers:
answerKey = string.Format("cbl{0}", surveyQuestion.SQU_ID);
CheckBoxList cbl = AnswerControls[answerKey] as CheckBoxList;
foreach (ListItem item in cbl.Items)
{
if (item.Selected)
{
try
{
hitblSurveyUserResultItem.AnswerWeight = +Convert.ToDouble(item.Value.Split('_')[0]);
calculatePoints = calculatePoints + hitblSurveyUserResultItem.AnswerWeight.Value;
hitblSurveyUserResultItem.Answer += item.Text + ",";
}
catch (Exception exception)
{
}
}
}
hitblSurveyUserResultItem.Answer = hitblSurveyUserResultItem.Answer.TrimEnd(',');
sbMailText.AppendFormat("{0} <br/><hr/>", hitblSurveyUserResultItem.Answer);
break;
case SurveyAnswersType.MultipleChoiceOnlyOneAnswer:
answerKey = string.Format("rbl{0}", surveyQuestion.SQU_ID);
RadioButtonList rbl = AnswerControls[answerKey] as RadioButtonList;
if (rbl.SelectedIndex >= 0)
{
try
{
hitblSurveyUserResultItem.AnswerWeight = +Convert.ToDouble(rbl.SelectedValue.Split('_')[0]);
calculatePoints = calculatePoints + Convert.ToDouble(rbl.SelectedValue.Split('_')[0]);
hitblSurveyUserResultItem.Answer += rbl.SelectedItem.Text;
sbMailText.AppendFormat("{0} <br/><hr/>", rbl.SelectedItem.Text);
}
catch (Exception exception)
{
}
}
else
{
isInputComplete = false;
}
break;
default:
break;
}
hitblSurveyUserResult.hitbl_Survey_User_ResultItem_SUIs.Add(hitblSurveyUserResultItem);
}
}
}
if (isInputComplete)
{
hitblSurveyUserResult.TotalTestResult = calculatePoints;
if (dataObjectSurvey.PunkteGruen > dataObjectSurvey.PunkteRot)
{
//The more points the "greener"
if (calculatePoints >= 0.0 && calculatePoints <= dataObjectSurvey.PunkteRot)
{
hitblSurveyUserResult.Light = SurveySemaphore.Red.ToString();
}
else if (calculatePoints > dataObjectSurvey.PunkteRot && calculatePoints <= dataObjectSurvey.PunkteGelb)
{
hitblSurveyUserResult.Light = SurveySemaphore.Yellow.ToString();
}
else
{
hitblSurveyUserResult.Light = SurveySemaphore.Green.ToString();
}
}
else
{
//The more points the "reder"
if (calculatePoints >= 0.0 && calculatePoints <= dataObjectSurvey.PunkteGruen)
{
hitblSurveyUserResult.Light = SurveySemaphore.Red.ToString();
}
else if (calculatePoints > dataObjectSurvey.PunkteGruen && calculatePoints <= dataObjectSurvey.PunkteGelb)
{
hitblSurveyUserResult.Light = SurveySemaphore.Yellow.ToString();
}
else
{
hitblSurveyUserResult.Light = SurveySemaphore.Green.ToString();
}
}
radMP.Visible = false;
pager.Controls.Clear();
litHeader.Controls.Clear();
litFooter.Controls.Clear();
var surveyResult = (from allResults in surveyDataClassDataContext.hitbl_Survey_TestResult_STRs.Where(x => x.OBJ_ID == dataObjectSurvey.ObjectID.Value && calculatePoints >= x.ValueFrom && calculatePoints <= x.ValueTo)
orderby allResults.ValueFrom ascending
select allResults).SingleOrDefault();
if (surveyResult != null)
{
litHeader.Text = surveyResult.ResultText;
}
else
{
litHeader.Text = !dataObjectSurvey.IsContest ? string.Format(GuiLanguage.GetGuiLanguage("DataObjectSurvey").GetString("DefaultTestResult"), dataObjectSurvey.Title) : string.Format(GuiLanguage.GetGuiLanguage("DataObjectSurvey").GetString("DefaultContestResult"), dataObjectSurvey.Title);
}
if (dataObjectSurvey.ShowForm)
{
hidResult.Value = litHeader.Text;
hidQA.Value = sbMailText.ToString();
hidSURID.Value = hitblSurveyUserResult.SUR_ID.ToString();
pnlFormular.Visible = true;
RevEMail.ValidationExpression = Constants.REGEX_EMAIL;
FillFormData();
litHeader.Text = string.Empty;
}
hitblSurveyUserResult.TestResultText = litHeader.Text;
surveyDataClassDataContext.SubmitChanges(ConflictMode.FailOnFirstConflict);
}
else
{
litFooter.Text = "<div class=\"errorText\" style=\"margin-top:10px;\">Bitte beantworten Sie alle Fragen!</div>";
}
}