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();
}
/// <summary>
///
/// </summary>
/// <param name="metaSurveyId"></param>
protected void BuildEligibilityQuestionnaire(int metaSurveyId)
{
QuestionsGrid.Visible = true;
MetadataSurveyId.Value = metaSurveyId.ToString();
MetadataSurvey biz = new MetadataSurvey();
biz.Get(metaSurveyId);
SurveyType.Value = biz[MetadataSurvey.SurveyType].ToString();
//MetadataSurveyQuestion questionsBiz = new MetadataSurveyQuestion();
//questionsBiz.GetByParent(metaSurveyId);
//QuestionsGrid.DataSource = questionsBiz.DataSourceView;
QuestionsGrid.DataSource = BusinessObject.GetByParentAsDataView <MetadataSurveyQuestion>(metaSurveyId);
QuestionsGrid.DataBind();
DataEntryPanel.Visible = true;
// Detmerine if assoication exits
DataTable versionsToSurvey = ProtocolMgmtDa.GetProtocolVersionsBySurvey(metaSurveyId);
// can edit survey when 0 associations or 1 association exists
bool isGridEditable = !(versionsToSurvey.Rows.Count > 1);
// Grid is disabled, as well as text fields and buttons for data entry
QuestionsGrid.Enabled = isGridEditable;
SurveyType.Enabled = isGridEditable;
SaveBtn.Visible = isGridEditable;
AddRowBtn.Visible = isGridEditable;
ReadOnlyMessage.Visible = !isGridEditable;
}
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();
}
