public void DeleteSurveyQuestionOption(SurveyQuestionOption option)
{
var query = from surveyquestionoption in db.SurveyQuestionOptions
select surveyquestionoption;
query = query.Where(sqos => sqos.SurveyQuestionID.Equals(option.SurveyQuestionID));
query = query.OrderBy("SortOrder", false);
List <SurveyQuestionOption> surveyquestionoptions = query.ToList();
bool found = false;
foreach (SurveyQuestionOption sqo in surveyquestionoptions)
{
if (found)
{
sqo.SortOrder -= 1;
db.Entry(sqo).State = EntityState.Modified;
}
if (sqo.SurveyQuestionOptionID == option.SurveyQuestionOptionID)
{
found = true;
db.SurveyQuestionOptions.Remove(sqo);
}
}
db.SaveChanges();
}
public void CreateSurveyQuestionOption(SurveyQuestionOption option)
{
// Get the maximum sort order
var query = from surveyquestionoption in db.SurveyQuestionOptions
select surveyquestionoption;
query = query.Where(sqos => sqos.SurveyQuestionID.Equals(option.SurveyQuestionID));
query = query.OrderBy("SortOrder", true);
List <SurveyQuestionOption> surveyquestionoptions = query.ToList();
int maxsortorder = 0;
if (surveyquestionoptions.Count > 0)
{
maxsortorder = surveyquestionoptions[0].SortOrder;
}
option.SortOrder = maxsortorder + 1;
db.SurveyQuestionOptions.Add(option);
db.SaveChanges();
}
public void UpdateSurveyQuestionOption(SurveyQuestionOption surveyquestionoption)
{
db.Entry(surveyquestionoption).State = EntityState.Modified;
db.SaveChanges();
}
public SurveyQuestionOption GetSurveyQuestionOption(int id)
{
SurveyQuestionOption surveyquestionoption = db.SurveyQuestionOptions.Find(id);
return(surveyquestionoption);
}
public void MoveSurveyQuestionOption(SurveyQuestionOption option, bool ismoveup)
{
var query = from surveyquestionoption in db.SurveyQuestionOptions
select surveyquestionoption;
query = query.Where(sqs => sqs.SurveyQuestionID.Equals(option.SurveyQuestionID));
query = query.OrderBy("SortOrder", false);
List <SurveyQuestionOption> surveyquestionoptions = query.ToList();
// Get the current and max sort orders
int currentsortorder = option.SortOrder;
int maxsortorder = 1;
foreach (SurveyQuestionOption sqo in surveyquestionoptions)
{
if (sqo.SortOrder > maxsortorder)
{
maxsortorder = sqo.SortOrder;
}
}
// Adjust the appropriate sort orders
foreach (SurveyQuestionOption sqo in surveyquestionoptions)
{
if (ismoveup)
{
if (sqo.SurveyQuestionOptionID == option.SurveyQuestionOptionID) // move current question up
{
if (currentsortorder > 1)
{
option.SortOrder -= 1;
}
}
else // find the previous item and increment it
{
if (sqo.SortOrder == currentsortorder - 1)
{
sqo.SortOrder += 1;
db.Entry(sqo).State = EntityState.Modified;
}
}
}
else
{
if (sqo.SurveyQuestionOptionID == option.SurveyQuestionOptionID) // move current question down
{
if (currentsortorder < maxsortorder)
{
option.SortOrder += 1;
}
}
else // find the next item and decrement it
{
if (sqo.SortOrder == currentsortorder + 1)
{
sqo.SortOrder -= 1;
db.Entry(sqo).State = EntityState.Modified;
}
}
}
}
db.SaveChanges();
}