public void EditQuestion(TQuestion model)
{
try
{
using (var dbContext = new QuestionsDBEntities())
{
var modelToUpdate = dbContext.TQuestions.Include(x => x.TChoices).SingleOrDefault(x => x.ID == model.ID);
modelToUpdate.Question = model.Question;
modelToUpdate.Image_url = model.Image_url;
modelToUpdate.Thumb_url = model.Thumb_url;
modelToUpdate.Published_at = model.Published_at;
var index = Math.Min(model.TChoices.Count(), modelToUpdate.TChoices.Count());
for (int i = 0; i < index; i++)
{
modelToUpdate.TChoices.ElementAt(i).Choice = model.TChoices.ElementAt(i).Choice;
modelToUpdate.TChoices.ElementAt(i).Votes = model.TChoices.ElementAt(i).Votes;
}
dbContext.SaveChanges();
}
}
catch (Exception exception)
{
log.Error(exception);
}
}
public TQuestion GetQuestion(int id)
{
try
{
using (var dbContext = new QuestionsDBEntities())
{
return(dbContext.TQuestions.Include(x => x.TChoices).SingleOrDefault(x => x.ID == id));
}
}
catch (Exception exception)
{
log.Error(exception);
return(new TQuestion());
}
}
public int GetTotal()
{
try
{
using (var dbContext = new QuestionsDBEntities())
{
return(dbContext.TQuestions.Count());
}
}
catch (Exception exception)
{
log.Error(exception);
return(-1);
}
}
public bool Exists(int id)
{
try
{
using (var dbContext = new QuestionsDBEntities())
{
return(dbContext.TQuestions.Any(x => x.ID == id));
}
}
catch (Exception exception)
{
log.Error(exception);
return(false);
}
}
public IEnumerable <TQuestion> GetQuestions(int limit, int offset, string filter)
{
try
{
using (var dbContext = new QuestionsDBEntities())
{
return(dbContext.TQuestions.Include(x => x.TChoices)
.Where(x => x.Question.ToLower().Contains(filter) || x.TChoices.Any(y => y.Choice.ToLower().Contains(filter)))
.OrderBy(x => x.ID).Skip(offset).Take(limit).ToList());
}
}
catch (Exception exception)
{
return(new List <TQuestion>());
}
}
public int CreateQuestion(TQuestion model)
{
try
{
using (var dbContext = new QuestionsDBEntities())
{
dbContext.TQuestions.Add(model);
dbContext.SaveChanges();
return(model.ID);
}
}
catch (Exception exception)
{
log.Error(exception);
return(-1);
}
}