protected void DeleteImage_Click(object sender, EventArgs e)
{
DnnImageButton deleteImage = (DnnImageButton)sender;
int surveyID = Convert.ToInt32(deleteImage.CommandArgument);
int[] surveyIDs = (from p in Request.Form["SurveyID"].Split(',')
select int.Parse(p)).ToArray();
int viewOrder = 1;
List <SurveysInfo> surveys = Surveys;
SurveysInfo survey;
foreach (int sID in surveyIDs)
{
survey = surveys.Find(x => x.SurveyID == sID);
if (sID == surveyID)
{
surveys.Remove(survey);
}
else
{
survey.ViewOrder = viewOrder;
survey.LastModifiedByUserID = UserId;
viewOrder++;
}
}
Surveys = surveys;
QuestionsGrid.DataSource = Surveys;
QuestionsGrid.DataBind();
}
protected override void OnLoad(EventArgs e)
{
if (!(Page.IsPostBack))
{
Surveys = SurveysController.GetAll(ModuleId);
QuestionsGrid.DataSource = Surveys;
QuestionsGrid.DataBind();
}
base.OnLoad(e);
}
/// <summary>
/// Load SQL querry restult into grid
/// </summary>
protected void LoadQuestions()
{
var select = "select question from dbo.Questions";
var c = new SqlConnection(connectionString);
SqlDataAdapter dataAdapter = new SqlDataAdapter(select, c);
var commandBuilder = new SqlCommandBuilder(dataAdapter);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);
var dt = ds.Tables[0];
numberOfQuestions = dt.Rows.Count;
QuestionsGrid.DataSource = dt;
QuestionsGrid.DataBind();
}
/// <summary>
/// Updates Questionnaire grid and title
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SaveQuestionnaireClick(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(MetadataSurveyId.Value))
{
// get survey id
int metadataSurveyId = int.Parse(MetadataSurveyId.Value);
// update MetadataSurvey record if needed
if (surveyDirty)
{
UpdateMetadataSurvey(metadataSurveyId);
}
// update Questions grid
QuestionsGrid.Save(metadataSurveyId);
// rebuild grid
BuildEligibilityQuestionnaire(metadataSurveyId);
}
}
