/// <summary>
/// Returns a list of answer types list
/// </summary>
public AnswerTypeData GetAnswerTypesList()
{
AnswerTypeData dataSet = new AnswerTypeData();
DbConnection.db.LoadDataSet("vts_spAnswerTypeGetList", dataSet, new string[] { "AnswerTypes" });
return(dataSet);
}
private AnswerTypeData CreateXmlTypeFromForm()
{
AnswerTypeData answerTypeData = null;
if (XmlFileNameTextbox.Text.Length == 0)
{
MessageLabel.Visible = true;
((PageBase)Page).ShowErrorMessage(MessageLabel, ((PageBase)Page).GetPageResource("MissingXmlDataSourceMessage"));
}
else
{
answerTypeData = new AnswerTypeData();
AnswerTypeData.AnswerTypesRow newAnswerType = answerTypeData.AnswerTypes.NewAnswerTypesRow();
newAnswerType.Description = TitleTextBox.Text;
newAnswerType.TypeMode = (int)AnswerTypeMode.DataSource;
newAnswerType.TypeMode += (int)AnswerTypeMode.Publisher;
newAnswerType.TypeMode += (int)AnswerTypeMode.Mandatory;
newAnswerType.XmlDataSource = XmlFileNameTextbox.Text;
newAnswerType.TypeAssembly = "Votations.NSurvey.WebControls";
newAnswerType.TypeNameSpace = "Votations.NSurvey.WebControls.UI.AnswerXmlListItem";
answerTypeData.AnswerTypes.AddAnswerTypesRow(newAnswerType);
}
return(answerTypeData);
}
private AnswerTypeData CreateTypeFromForm()
{
int TypeMode = 0;
AnswerTypeData answerTypeData = new AnswerTypeData();
AnswerTypeData.AnswerTypesRow newAnswerType = answerTypeData.AnswerTypes.NewAnswerTypesRow();
newAnswerType.Description = TitleTextBox.Text;
if (SelectionTypeCheckBox.Checked)
{
TypeMode += (int)AnswerTypeMode.Selection;
newAnswerType.TypeAssembly = "Votations.NSurvey.WebControls";
newAnswerType.TypeNameSpace = "Votations.NSurvey.WebControls.UI.AnswerSelectionItem";
}
if (FieldTypeCheckBox.Checked)
{
if (!ValidateFieldOptions())
{
return(null);
}
TypeMode += (int)AnswerTypeMode.Field;
TypeMode += (int)AnswerTypeMode.Publisher;
TypeMode += (int)AnswerTypeMode.RegExValidator;
TypeMode += (int)AnswerTypeMode.Mandatory;
if (SelectionTypeCheckBox.Checked)
{
newAnswerType.TypeAssembly = "Votations.NSurvey.WebControls";
newAnswerType.TypeNameSpace = "Votations.NSurvey.WebControls.UI.AnswerOtherFieldItem";
}
else if (RichFieldCheckBox.Checked)
{
TypeMode += (int)AnswerTypeMode.ExtendedType;
newAnswerType.TypeAssembly = "Votations.NSurvey.WebControls";
newAnswerType.TypeNameSpace = "Votations.NSurvey.WebControls.ThirdPartyItems.FreeTextBoxAnswerItem";
}
else
{
newAnswerType.TypeAssembly = "Votations.NSurvey.WebControls";
newAnswerType.TypeNameSpace = "Votations.NSurvey.WebControls.UI.AnswerFieldItem";
}
}
newAnswerType.TypeMode = TypeMode;
newAnswerType.FieldHeight = int.Parse(FieldHeightTextBox.Text);
newAnswerType.FieldWidth = int.Parse(FieldWidthTextBox.Text);
newAnswerType.FieldLength = int.Parse(FieldMaxLengthTextBox.Text);
newAnswerType.PublicFieldResults = FieldShownInResultsCheckBox.Checked;
newAnswerType.JavascriptFunctionName = JavascriptFunctionNameTextBox.Text;
newAnswerType.JavascriptErrorMessage = JavascriptErrorMessageTextBox.Text;
newAnswerType.JavascriptCode = JavascriptTextBox.Text;
answerTypeData.AnswerTypes.AddAnswerTypesRow(newAnswerType);
return(answerTypeData);
}
/// <summary>
/// Return an answer type object that reflects the database answer type
/// </summary>
/// <param name="answerTypeId">Id of the answer type you need</param>
/// <returns>An answer type object with the current database values</returns>
public AnswerTypeData GetAnswerTypeById(int answerTypeId)
{
AnswerTypeData dataSet = new AnswerTypeData();
ArrayList commandParameters = new ArrayList();
{
commandParameters.Add(new SqlParameter("@AnswerTypeId", answerTypeId).SqlValue);
}
DbConnection.db.LoadDataSet("vts_spAnswerTypeGetDetails", dataSet, new string[] { "AnswerTypes" }, commandParameters.ToArray());
return(dataSet);
}
/// <summary>
/// Returns a list of answer types available to the user and that can
/// be edited from the admin interface
/// </summary>
public AnswerTypeData GetEditableAssignedAnswerTypesList(int userId)
{
AnswerTypeData dataSet = new AnswerTypeData();
ArrayList commandParameters = new ArrayList();
{
commandParameters.Add(new SqlParameter("@UserId", userId).SqlValue);
}
DbConnection.db.LoadDataSet("vts_spAnswerTypeGetEditableListForUser", dataSet, new string[] { "AnswerTypes" }, commandParameters.ToArray());
return(dataSet);
}
/// <summary>
/// Returns a list of answer types available to the user
/// </summary>
public AnswerTypeData GetAssignedAnswerTypesList(int userId, int surveyId)
{
//SqlParameter[] commandParameters = new SqlParameter[]
//{ new SqlParameter("@UserId", userId),
// new SqlParameter("@SurveyId", surveyId) };
ArrayList commandParameters = new ArrayList();
{
commandParameters.Add(new SqlParameter("@UserId", userId).SqlValue);
commandParameters.Add(new SqlParameter("@SurveyId", surveyId).SqlValue);
}
AnswerTypeData dataSet = new AnswerTypeData();
DbConnection.db.LoadDataSet("vts_spAnswerTypeGetListForUser", dataSet, new string[] { "AnswerTypes" }, commandParameters.ToArray());
return(dataSet);
}
private void ApplyChangesButton_Click(object sender, System.EventArgs e)
{
AnswerTypeData answerTypeData = null;
if (TitleTextBox.Text.Length == 0)
{
MessageLabel.Visible = true;
((PageBase)Page).ShowErrorMessage(MessageLabel, ((PageBase)Page).GetPageResource("MissingAnswerTypeTitleMessage"));
}
else if (!SelectionTypeCheckBox.Checked && DataSourceDropDownList.SelectedValue == "1" &&
!FieldTypeCheckBox.Checked)
{
MessageLabel.Visible = true;
((PageBase)Page).ShowErrorMessage(MessageLabel, ((PageBase)Page).GetPageResource("MissingTypeMessage"));
}
else
{
if (DataSourceDropDownList.SelectedValue == "2")
{
answerTypeData = CreateXmlTypeFromForm();
}
else if (DataSourceDropDownList.SelectedValue == "3" &&
GlobalConfig.SqlBasedAnswerTypesAllowed &&
((PageBase)Page).CheckRight(NSurveyRights.SqlAnswerTypesEdition, false))
{
answerTypeData = CreateSqlTypeFromForm();
}
else if (DataSourceDropDownList.SelectedValue == "1")
{
answerTypeData = CreateTypeFromForm();
}
}
if (answerTypeData != null)
{
answerTypeData.AnswerTypes[0].AnswerTypeId = AnswerTypeId;
new AnswerType().UpdateAnswerType(answerTypeData);
OnOptionChanged();
MessageLabel.Visible = true;
((PageBase)Page).ShowNormalMessage(MessageLabel, ((PageBase)Page).GetPageResource("AnswerTypeUpdatedMessage"));
}
InitUserInterface();
}
private AnswerTypeData CreateSqlTypeFromForm()
{
AnswerTypeData answerTypeData = null;
if (SqlQueryTextbox.Text.Length == 0)
{
MessageLabel.Visible = true;
((PageBase)Page).ShowErrorMessage(MessageLabel, ((PageBase)Page).GetPageResource("MissingQueryDataSourceMessage"));
}
else if (SqlQueryTextbox.Text.IndexOf("update") > -1 ||
SqlQueryTextbox.Text.IndexOf("delete") > -1 || SqlQueryTextbox.Text.IndexOf("create") > -1 ||
SqlQueryTextbox.Text.IndexOf("truncate") > -1 || SqlQueryTextbox.Text.IndexOf("fetch") > -1 ||
SqlQueryTextbox.Text.IndexOf("grant") > -1 || SqlQueryTextbox.Text.IndexOf("insert") > -1 ||
SqlQueryTextbox.Text.IndexOf("revoke") > -1 || SqlQueryTextbox.Text.IndexOf("open") > -1 ||
SqlQueryTextbox.Text.IndexOf("alter") > -1)
{
MessageLabel.Visible = true;
((PageBase)Page).ShowErrorMessage(MessageLabel, ((PageBase)Page).GetPageResource("OnlySelectQueryAllowedMessage"));
}
else
{
answerTypeData = new AnswerTypeData();
AnswerTypeData.AnswerTypesRow newAnswerType = answerTypeData.AnswerTypes.NewAnswerTypesRow();
newAnswerType.Description = TitleTextBox.Text;
newAnswerType.TypeMode = (int)AnswerTypeMode.DataSource;
newAnswerType.TypeMode += (int)AnswerTypeMode.Publisher;
newAnswerType.TypeMode += (int)AnswerTypeMode.Mandatory;
SqlQueryTextbox.Text.Replace("delete ", "");
SqlQueryTextbox.Text.Replace("update ", "");
SqlQueryTextbox.Text.Replace("truncate ", "");
newAnswerType.DataSource = SqlQueryTextbox.Text;
newAnswerType.TypeAssembly = "Votations.NSurvey.WebControls";
newAnswerType.TypeNameSpace = "Votations.NSurvey.WebControls.UI.AnswerSqlListItem";
answerTypeData.AnswerTypes.AddAnswerTypesRow(newAnswerType);
}
return(answerTypeData);
}
private void CreateTypeButton_Click(object sender, System.EventArgs e)
{
AnswerTypeData answerTypeData = null;
if (TitleTextBox.Text.Length == 0)
{
MessageLabel.Visible = true;
((PageBase)Page).ShowErrorMessage(MessageLabel, ((PageBase)Page).GetPageResource("MissingAnswerTypeTitleMessage"));
}
else if (!SelectionTypeCheckBox.Checked && DataSourceDropDownList.SelectedValue == "1" && !FieldTypeCheckBox.Checked)
{
MessageLabel.Visible = true;
((PageBase)Page).ShowErrorMessage(MessageLabel, ((PageBase)Page).GetPageResource("MissingTypeMessage"));
}
else
{
if (DataSourceDropDownList.SelectedValue == "2")
{
answerTypeData = CreateXmlTypeFromForm();
}
else if (DataSourceDropDownList.SelectedValue == "3" &&
GlobalConfig.SqlBasedAnswerTypesAllowed &&
((PageBase)Page).CheckRight(NSurveyRights.SqlAnswerTypesEdition, false))
{
answerTypeData = CreateSqlTypeFromForm();
}
else if (DataSourceDropDownList.SelectedValue == "1")
{
answerTypeData = CreateTypeFromForm();
}
}
if (answerTypeData != null)
{
MessageLabel.Visible = true;
new AnswerType().AddAnswerType(answerTypeData, ((PageBase)Page).NSurveyUser.Identity.UserId);
UINavigator.NavigateToTypeEditor(((PageBase)Page).MenuIndex);
}
}
/// <summary>
/// Update the answer type in the database
/// </summary>
/// <param name="updatedAnswerType">Answer type to update, must specify the answer type id</param>
public void UpdateAnswerType(AnswerTypeData updatedAnswerType)
{
SqlConnection connection = new SqlConnection(DbConnection.NewDbConnectionString);
SqlCommand insertCommand = new SqlCommand("vts_spAnswerTypeUpdate", connection);
insertCommand.CommandType = CommandType.StoredProcedure;
insertCommand.Parameters.Add(new SqlParameter("@AnswerTypeID", SqlDbType.Int, 4, "AnswerTypeID"));
insertCommand.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 200, "Description"));
insertCommand.Parameters.Add(new SqlParameter("@XmlDataSource", SqlDbType.VarChar, 200, "XmlDataSource"));
insertCommand.Parameters.Add(new SqlParameter("@DataSource", SqlDbType.NVarChar, 0xfa0, "DataSource"));
insertCommand.Parameters.Add(new SqlParameter("@TypeMode", SqlDbType.Int, 4, "TypeMode"));
insertCommand.Parameters.Add(new SqlParameter("@FieldWidth", SqlDbType.Int, 4, "FieldWidth"));
insertCommand.Parameters.Add(new SqlParameter("@FieldHeight", SqlDbType.Int, 4, "FieldHeight"));
insertCommand.Parameters.Add(new SqlParameter("@FieldLength", SqlDbType.Int, 4, "FieldLength"));
insertCommand.Parameters.Add(new SqlParameter("@PublicFieldResults", SqlDbType.Bit, 1, "PublicFieldResults"));
insertCommand.Parameters.Add(new SqlParameter("@JavascriptFunctionName", SqlDbType.VarChar, 0x3e8, "JavascriptFunctionName"));
insertCommand.Parameters.Add(new SqlParameter("@JavascriptErrorMessage", SqlDbType.VarChar, 0x3e8, "JavascriptErrorMessage"));
insertCommand.Parameters.Add(new SqlParameter("@JavascriptCode", SqlDbType.VarChar, 0x1f40, "JavascriptCode"));
insertCommand.Parameters.Add(new SqlParameter("@TypeAssembly", SqlDbType.VarChar, 200, "TypeAssembly"));
insertCommand.Parameters.Add(new SqlParameter("@TypeNameSpace", SqlDbType.VarChar, 200, "TypeNameSpace"));
DbConnection.db.UpdateDataSet(updatedAnswerType, "AnswerTypes", insertCommand, new SqlCommand(), insertCommand, UpdateBehavior.Transactional);
}
/// <summary>
/// Update the answer type in the database
/// </summary>
/// <param name="updatedAnswerType">Answer type to update, must specify the answer type id</param>
public void UpdateAnswerType(AnswerTypeData updatedAnswerType)
{
AnswerTypeFactory.Create().UpdateAnswerType(updatedAnswerType);
}
/// <summary>
/// Adds a new answer type in the database
/// </summary>
/// <param name="newAnswerType">Answer type object with information about what to add. Only Id must be ommited</param>
public void AddAnswerType(AnswerTypeData newAnswerType, int userId)
{
AnswerTypeFactory.Create().AddAnswerType(newAnswerType, userId);
}
/// <summary>
/// Adds a new answer type in the database
/// </summary>
/// <param name="newAnswerType">Answer type object with information about what to add. Only Id must be ommited</param>
public void AddAnswerType(AnswerTypeData newAnswerType, int userId)
{
SqlConnection sqlConnection = new SqlConnection(DbConnection.NewDbConnectionString);
DbConnection.db.UpdateDataSet(newAnswerType, "AnswerTypes", this.GetInsertAnswerTypeCommand(sqlConnection, null, userId), new SqlCommand(), new SqlCommand(), UpdateBehavior.Transactional);
}
