public int UpdatePoll(PollQuestionModel _model)
{
try
{
using (StratasFairDBEntities context = new StratasFairDBEntities())
{
var _poll = context.tblPollQuestions.Where(x => x.PollId == _model.PollId && x.StrataBoardId == ClientSessionData.ClientStrataBoardId).FirstOrDefault();
if (_poll != null)
{
_poll.Status = _model.Status;
_poll.ModifiedBy = _model.ModifiedBy;
_poll.ModifiedOn = DateTime.UtcNow;
_poll.ModifiedFromIP = HttpContext.Current.Request.UserHostAddress;
context.tblPollQuestions.Attach(_poll);
context.Entry(_poll).Property(x => x.Status).IsModified = true;
context.Entry(_poll).Property(x => x.ModifiedBy).IsModified = true;
context.Entry(_poll).Property(x => x.ModifiedOn).IsModified = true;
context.Entry(_poll).Property(x => x.ModifiedFromIP).IsModified = true;
return(context.SaveChanges());
}
else
{
return(-1);
}
}
}
catch (Exception ex)
{
return(-1);
}
}
public ActionResult Index()
{
PollQuestionModel model = new PollQuestionModel()
{
pollOption = new string[8]
};
return(View());
}
public long Index(PollQuestionModel model)
{
try
{
return(PollHelper.Instance.AddNewPoll(model));
}
catch
{
return(-1);
}
}
public long AddNewPoll(PollQuestionModel _model)
{
try
{
_model.CreatedBy = ClientSessionData.UserClientId;
using (StratasFairDBEntities context = new StratasFairDBEntities())
{
tblPollQuestion _pollModel = new tblPollQuestion();
_pollModel.PollHeader = _model.PollHeader;
_pollModel.EndDate = _model.EndDate;
_pollModel.CreatedBy = _model.CreatedBy;
_pollModel.CreatedOn = _model.CreatedOn;
_pollModel.CreatedFromIP = _model.CreatedFromIP;
_pollModel.Status = 1;
_pollModel.StrataBoardId = ClientSessionData.ClientStrataBoardId;
context.tblPollQuestions.Add(_pollModel);
if (context.SaveChanges() > 0)
{
List <tblPollOption> _optionModel = new List <tblPollOption>();
foreach (var item in _model.pollOption)
{
_optionModel.Add(new tblPollOption()
{
OptionText = item,
PollId = _pollModel.PollId,
CreatedBy = _model.CreatedBy,
CreatedOn = _model.CreatedOn,
CreatedFromIP = _model.CreatedFromIP,
Status = 1
});
}
context.tblPollOptions.AddRange(_optionModel);
context.SaveChanges();
}
return(0);
}
}
catch (Exception)
{
return(-1);
}
}
public JsonResult Delete(long pollid)
{
try
{
PollQuestionModel _model = new PollQuestionModel()
{
PollId = pollid,
Status = 2
};
if (PollHelper.Instance.UpdatePoll(_model) > 0)
{
return(Json(0));
}
else
{
return(Json(-1));
}
}
catch
{
return(Json(-1));
}
}
