public void DeleteSurveyQuestion(SurveyQuestion question)
{
var query = from surveyquestion in db.SurveyQuestions
select surveyquestion;
query = query.Where(sqs => sqs.SurveyID.Equals(question.SurveyID));
query = query.OrderBy("SortOrder", false);
List<SurveyQuestion> surveyquestions = query.ToList();
bool found = false;
foreach (SurveyQuestion sq in surveyquestions)
{
if (found)
{
sq.SortOrder -= 1;
db.Entry(sq).State = EntityState.Modified;
}
if (sq.SurveyQuestionID == question.SurveyQuestionID)
{
found = true;
db.SurveyQuestions.Remove(sq);
}
}
db.SaveChanges();
}
public void DeleteSurveyQuestion(SurveyQuestion question)
{
var query = from surveyquestion in db.SurveyQuestions
select surveyquestion;
query = query.Where(sqs => sqs.SurveyID.Equals(question.SurveyID));
query = query.OrderBy("SortOrder", false);
List <SurveyQuestion> surveyquestions = query.ToList();
bool found = false;
foreach (SurveyQuestion sq in surveyquestions)
{
if (found)
{
sq.SortOrder -= 1;
db.Entry(sq).State = EntityState.Modified;
}
if (sq.SurveyQuestionID == question.SurveyQuestionID)
{
found = true;
db.SurveyQuestions.Remove(sq);
}
}
db.SaveChanges();
}
public void CreateSurveyQuestion(SurveyQuestion question)
{
// Get the maximum sort order
var query = from surveyquestion in db.SurveyQuestions
select surveyquestion;
query = query.Where(sqs => sqs.SurveyID.Equals(question.SurveyID));
query = query.OrderBy("SortOrder", true);
List<SurveyQuestion> surveyquestions = query.ToList();
int maxsortorder = 0;
if (surveyquestions.Count > 0)
maxsortorder = surveyquestions[0].SortOrder;
question.SortOrder = maxsortorder + 1;
db.SurveyQuestions.Add(question);
db.SaveChanges();
}
public void CreateSurveyQuestion(SurveyQuestion question)
{
// Get the maximum sort order
var query = from surveyquestion in db.SurveyQuestions
select surveyquestion;
query = query.Where(sqs => sqs.SurveyID.Equals(question.SurveyID));
query = query.OrderBy("SortOrder", true);
List <SurveyQuestion> surveyquestions = query.ToList();
int maxsortorder = 0;
if (surveyquestions.Count > 0)
{
maxsortorder = surveyquestions[0].SortOrder;
}
question.SortOrder = maxsortorder + 1;
db.SurveyQuestions.Add(question);
db.SaveChanges();
}
public SurveyQuestion GetSurveyQuestion(int id)
{
SurveyQuestion surveyquestion = db.SurveyQuestions.Find(id);
return(surveyquestion);
}
public void UpdateSurveyQuestion(SurveyQuestion surveyquestion)
{
db.Entry(surveyquestion).State = EntityState.Modified;
db.SaveChanges();
}
public void MoveSurveyQuestion(SurveyQuestion question, bool ismoveup)
{
var query = from surveyquestion in db.SurveyQuestions
select surveyquestion;
query = query.Where(sqs => sqs.SurveyID.Equals(question.SurveyID));
query = query.OrderBy("SortOrder", false);
List <SurveyQuestion> surveyquestions = query.ToList();
// Get the current and max sort orders
int currentsortorder = question.SortOrder;
int maxsortorder = 1;
foreach (SurveyQuestion sq in surveyquestions)
{
if (sq.SortOrder > maxsortorder)
{
maxsortorder = sq.SortOrder;
}
}
// Adjust the appropriate sort orders
foreach (SurveyQuestion sq in surveyquestions)
{
if (ismoveup)
{
if (sq.SurveyQuestionID == question.SurveyQuestionID) // move current question up
{
if (currentsortorder > 1)
{
question.SortOrder -= 1;
}
}
else // find the previous item and increment it
{
if (sq.SortOrder == currentsortorder - 1)
{
sq.SortOrder += 1;
db.Entry(sq).State = EntityState.Modified;
}
}
}
else
{
if (sq.SurveyQuestionID == question.SurveyQuestionID) // move current question down
{
if (currentsortorder < maxsortorder)
{
question.SortOrder += 1;
}
}
else // find the next item and decrement it
{
if (sq.SortOrder == currentsortorder + 1)
{
sq.SortOrder -= 1;
db.Entry(sq).State = EntityState.Modified;
}
}
}
}
db.SaveChanges();
}
public void MoveSurveyQuestion(SurveyQuestion question, bool ismoveup)
{
var query = from surveyquestion in db.SurveyQuestions
select surveyquestion;
query = query.Where(sqs => sqs.SurveyID.Equals(question.SurveyID));
query = query.OrderBy("SortOrder", false);
List<SurveyQuestion> surveyquestions = query.ToList();
// Get the current and max sort orders
int currentsortorder = question.SortOrder;
int maxsortorder = 1;
foreach (SurveyQuestion sq in surveyquestions)
{
if (sq.SortOrder > maxsortorder)
maxsortorder = sq.SortOrder;
}
// Adjust the appropriate sort orders
foreach (SurveyQuestion sq in surveyquestions)
{
if (ismoveup)
{
if (sq.SurveyQuestionID == question.SurveyQuestionID) // move current question up
{
if (currentsortorder > 1)
question.SortOrder -= 1;
}
else // find the previous item and increment it
{
if (sq.SortOrder == currentsortorder - 1)
{
sq.SortOrder += 1;
db.Entry(sq).State = EntityState.Modified;
}
}
}
else
{
if (sq.SurveyQuestionID == question.SurveyQuestionID) // move current question down
{
if (currentsortorder < maxsortorder)
question.SortOrder += 1;
}
else // find the next item and decrement it
{
if (sq.SortOrder == currentsortorder + 1)
{
sq.SortOrder -= 1;
db.Entry(sq).State = EntityState.Modified;
}
}
}
}
db.SaveChanges();
}
public void UpdateSurveyQuestion(SurveyQuestion surveyquestion)
{
db.Entry(surveyquestion).State = EntityState.Modified;
db.SaveChanges();
}