public override DataSet Clone()
{
BranchingRuleData data = (BranchingRuleData)base.Clone();
data.InitVars();
return(data);
}
/// <summary>
/// Add a new branching rule to the survey
/// </summary>
/// <param name="newBranchingRule"></param>
public void AddBranchingRule(BranchingRuleData newBranchingRule)
{
SurveyFactory.Create().AddBranchingRule(newBranchingRule);
}
/// <summary>
/// returns the branching rules for the given page with all
/// their details
/// </summary>
/// <param name="surveyId"></param>
/// <param name="pageNumber"></param>
/// <returns></returns>
public BranchingRuleData GetSurveyPageBranchingRulesDetails(int surveyId, int pageNumber)
{
BranchingRuleData branchingRule = new BranchingRuleData();
//SqlParameter[] spParameters = new SqlParameter[2];
//spParameters[0] = new SqlParameter("@SurveyId", surveyId);
//spParameters[1] = new SqlParameter("@pageNumber", pageNumber);
ArrayList sqlParams = new ArrayList();
{
sqlParams.Add(new SqlParameter("@SurveyId", surveyId).SqlValue);
sqlParams.Add(new SqlParameter("@pageNumber", pageNumber).SqlValue);
}
DbConnection.db.LoadDataSet("vts_spSurveyBranchingRuleGetDetailsForPage", branchingRule, new string[] { "BranchingRules" }, sqlParams.ToArray());
return branchingRule;
}
/// <summary>
/// returns the branching rules for the given survey
/// </summary>
/// <param name="surveyId"></param>
/// <returns></returns>
public BranchingRuleData GetSurveyBranchingRules(int surveyId)
{
BranchingRuleData branchingRule = new BranchingRuleData();
DbConnection.db.LoadDataSet("vts_spSurveyBranchingRuleGetAll", branchingRule, new string[] { "BranchingRules" }, new SqlParameter("@SurveyID", surveyId).SqlValue);
return branchingRule;
}
/// <summary>
/// Add a new branching rule to the survey
/// </summary>
public void AddBranchingRule(BranchingRuleData newBranchingRule)
{
SqlConnection dbConnection = new SqlConnection(DbConnection.NewDbConnectionString);
SqlCommand addNewRule = new SqlCommand("vts_spSurveyBranchingRuleAddNew", dbConnection);
addNewRule.CommandType = CommandType.StoredProcedure;
addNewRule.Parameters.Add(new SqlParameter("@PageNumber", SqlDbType.Int, 4, "PageNumber"));
addNewRule.Parameters.Add(new SqlParameter("@ExpressionOperator", SqlDbType.Int, 4, "ExpressionOperator"));
addNewRule.Parameters.Add(new SqlParameter("@QuestionID", SqlDbType.Int, 4, "QuestionID"));
addNewRule.Parameters.Add(new SqlParameter("@AnswerID", SqlDbType.Int, 4, "AnswerID"));
addNewRule.Parameters.Add(new SqlParameter("@TargetPageNumber", SqlDbType.Int, 4, "TargetPageNumber"));
addNewRule.Parameters.Add(new SqlParameter("@TextFilter", SqlDbType.NVarChar, 4000, "TextFilter"));
addNewRule.Parameters.Add(new SqlParameter("@ConditionalOperator", SqlDbType.Int, 4, "ConditionalOperator"));
addNewRule.Parameters.Add(new SqlParameter("@Score", SqlDbType.Int, 4, "Score"));
addNewRule.Parameters.Add(new SqlParameter("@ScoreMax", SqlDbType.Int, 4, "ScoreMax"));
addNewRule.Parameters.Add(new SqlParameter("@BranchingRuleID", SqlDbType.Int, 4, "BranchingRuleID"));
addNewRule.Parameters["@BranchingRuleID"].Direction = ParameterDirection.Output;
//SqlHelper.UpdateDataset(addNewRule, new SqlCommand(), new SqlCommand(), newBranchingRule, "BranchingRules", true);
DbConnection.db.UpdateDataSet(newBranchingRule, "BranchingRules", addNewRule, new SqlCommand(), new SqlCommand(), UpdateBehavior.Transactional);
}
public BranchingRulesRowChangeEvent(BranchingRuleData.BranchingRulesRow row, DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public void RemoveBranchingRulesRow(BranchingRuleData.BranchingRulesRow row)
{
base.Rows.Remove(row);
}
public void AddBranchingRulesRow(BranchingRuleData.BranchingRulesRow row)
{
base.Rows.Add(row);
}
private void AddRuleButton_Click(object sender, System.EventArgs e)
{
BranchingRuleData branchingRuleData = new BranchingRuleData();
BranchingRuleData.BranchingRulesRow branchingRule = branchingRuleData.BranchingRules.NewBranchingRulesRow();
if ((LogicDropDownList.SelectedValue == "3" ||
LogicDropDownList.SelectedValue == "4" ||
LogicDropDownList.SelectedValue == "5") &&
Information.IsNumeric(ScoreTextbox.Text))
{
branchingRule.Score = int.Parse(ScoreTextbox.Text);
}
else if (LogicDropDownList.SelectedValue == "6" &&
Information.IsNumeric(ScoreTextbox.Text) &&
Information.IsNumeric(ScoreMaxTextbox.Text))
{
branchingRule.Score = int.Parse(ScoreTextbox.Text);
branchingRule.ScoreMax = int.Parse(ScoreMaxTextbox.Text);
}
else if (LogicDropDownList.SelectedValue == "3" ||
LogicDropDownList.SelectedValue == "4" ||
LogicDropDownList.SelectedValue == "5" ||
LogicDropDownList.SelectedValue == "6")
{
((PageBase)Page).ShowErrorMessage(MessageLabel, ((PageBase)Page).GetPageResource("ScoreNotNumericMessage"));
MessageLabel.Visible = true;
return;
}
else
{
int answerId = int.Parse(AnswerFilterDropdownlist.SelectedValue);
if (answerId == 0)
{
branchingRule.SetAnswerIdNull();
}
else if (answerId < 0)
{
branchingRule.AnswerId = -answerId;
}
else
{
branchingRule.AnswerId = answerId;
}
if (TextFilterTextbox.Visible)
{
branchingRule.ExpressionOperator =
int.Parse(ExpressionLogicDropdownlist.SelectedValue);
branchingRule.TextFilter = TextFilterTextbox.Text;
}
}
branchingRule.QuestionId = int.Parse(QuestionFilterDropdownlist.SelectedValue);
branchingRule.TargetPageNumber = int.Parse(PageTargetDropdownlist.SelectedValue);
branchingRule.ConditionalOperator = int.Parse(LogicDropDownList.SelectedValue);
branchingRule.PageNumber = _pageNumber;
branchingRuleData.BranchingRules.AddBranchingRulesRow(branchingRule);
new Survey().AddBranchingRule(branchingRuleData);
MessageLabel.Visible = true;
((PageBase)Page).ShowNormalMessage(MessageLabel, ((PageBase)Page).GetPageResource("BranchingRuleAddedMessage"));
BindFields();
ScoreTextbox.Text = string.Empty;
ScoreMaxTextbox.Text = string.Empty;
}