public ActionResult Create([Bind(Include = "Id,SurveyTitle,DateCreated")] Survey survey)
{
if (ModelState.IsValid)
{
db.Surveys.Add(survey);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(survey));
}
public ActionResult Save(Survey survey)
{
//TODO: Save logic
try
{
if (ModelState.IsValid)
{
if (survey.Id > 0)
{
var surveyToUpdate = db.Surveys.Find(survey.Id);
surveyToUpdate.Name = survey.Name;
}
else
{
db.Surveys.Add(survey);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (RetryLimitExceededException dex)
{
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator.");
}
return(View(survey));
//return View();
}
public static void CreateSeedData(this SurveyDBContext context)
{
if (context.Surveys.Any())
{
return;
}
var surveys = new List <Survey>()
{
new Survey()
{
Survey_Name = "Survey",
Survey_Options = "[]",
Survey_Finished_Users = "[]",
}
};
context.AddRange(surveys);
context.SaveChanges();
}
public void AddUserToSurveyFinishedUsersColumn(int userId, int surveyId, JObject json)
{
var survey = _context.Surveys.Find(surveyId);
if (survey == null)
{
throw new Exception("Survey not found");
}
MarkAsFinished(userId, surveyId);
dynamic finish_user_json = JsonConvert.DeserializeObject(survey.Survey_Finished_Users);
var array = finish_user_json;
finish_user_json.Add(json);
string json_string = JsonConvert.SerializeObject(finish_user_json);
Console.WriteLine(finish_user_json);
Console.WriteLine(json_string);
survey.Survey_Finished_Users = json_string;
_context.Surveys.Update(survey);
_context.SaveChanges();
}
public void Save()
{
_dbContext.SaveChanges();
}
