// GET: Questionnaire/Update/id
public ActionResult Update(int id)
{
try
{
using (var dataContext = new HuntingEntities())
{
var user = AclUserContext.GetDetail(dataContext, User.Identity.Name);
if (user == null)
{
ContextUtils.CreateActionStateCookie(Response, ActionTypeEnum.Warning, GlobalRes.ERROR_NOT_ALLOWED);
return(RedirectToAction("Index", "Home"));
}
var questionnaire = QuestionnaireContext.GetDetail(dataContext, id);
if (questionnaire == null)
{
ContextUtils.CreateActionStateCookie(Response, ActionTypeEnum.Warning, GlobalRes.ERROR_NOT_FOUND);
return(RedirectToAction("Index", "Home"));
}
if (user.CanUpdateTerritory(questionnaire.MapItemType.Territory) == false)
{
ContextUtils.CreateActionStateCookie(Response, ActionTypeEnum.Warning, GlobalRes.ERROR_NOT_ALLOWED);
return(RedirectToAction("Index", "Territory", new { id = questionnaire.MapItemType.TerritoryId }));
}
var model = new QuestionnaireUpdateModel(questionnaire);
return(View(model));
}
}
catch (Exception exception)
{
logger.Error(exception, "QuestionnaireController");
ContextUtils.CreateActionStateCookie(Response, ActionTypeEnum.Danger, GlobalRes.ERROR_EXCEPTION);
return(RedirectToAction("Index", "Home"));
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, QuestionnaireContext questionnaireContext)
{
questionnaireContext.Database.Migrate();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseStaticFiles();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints => {
endpoints.MapRazorPages();
});
}
private static MailContent createVendorReportEmail(Vendor vendor, String recipient, UserPurchase user, int categoryId)
{
MailContent mailContent = new MailContent();
mailContent.MailFrom = vendorsContactEmail;
mailContent.MailingAdress = recipient;
QuestionnaireContext _context = new QuestionnaireContext();
String sectionName = (categoryId != 0) ? _context.Categories.Where(x => x.Id == categoryId).First().Title
: "General List of ‘Suggested Service Providers’";
mailContent.Subject = "Referral from AFFI-FSMA Assessments – Request for Information";
mailContent.HtmlText = "<table border=\"0\" cellpadding=\"1\" cellspacing=\"1\" style=\"width: 600px;\">"
+ "<tbody><tr><td>"
+ "<img alt=\"\" src=\"http://affi-fsma.seneca.com/Content/img/affi_logo.jpg\" style=\"width: 100px; height: 73px;\" /></td>"
+ "<td><div><span style=\"font-size:18px;\"><strong>Responses from the AFFI – FSMA Self Assessment</strong></span></div>"
+ "<div><span style=\"font-size:18px;\"><strong>Request for Information to “Suggested Service Provider”</strong></span></div>"
+ "</td></tr></tbody></table><br/>"
+ "<span style=\"font-size:16px;\">TO: " + vendor.Name + "<br/><br/>"
+ "The following person has clicked on the “Contact Me” button while taking the AFFI – FSMA Self-Assessment:<br/><br/>"
+ "Name of person: " + user.Name + "<br/>"
+ "Facility name: " + user.FacilityName + "<br/>"
+ "Email address: " + user.Email + "<br/>"
+ "Date and time: " + DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToShortTimeString() + "<br/><br/>"
+ "Section of the AFFI – FSMA Self-Assessment Report: " + sectionName + "<br/><br/>"
+ "By clicking on the Contact Me button the person anticipates that they will receive information about your company’s services related to the section of the FSMA Self-Assessment Report as referenced above.<br/><br/>"
+ "If you have any questions about this email, please “Reply” to this email with your questions.<br/><br/>"
+ "Thank you – <br/>"
+ "Seneca Corporation</span>";
return(mailContent);
}
public UnitOfWork(string connectionString)
{
context = new QuestionnaireContext(connectionString);
UserManager = new ApplicationUserManager(new UserStore <ApplicationUser>(context));
RoleManager = new ApplicationRoleManager(new RoleStore <ApplicationRole>(context));
UserManager.PasswordValidator = passwordValidator;
UserManager.UserValidator = new AppUserValidator(UserManager);
}
public AnswersController(QuestionnaireContext context)
{
// To init database withTest data do this
//foreach (var q in Question.Init())
//{
// context.Add(q);
//}
//context.SaveChanges();
_context = context;
}
public static void Seed(QuestionnaireContext dbContext)
{
var questionnaire = ReadQuestionnaireData();
AddQuestionnaire(dbContext, questionnaire);
AddSubjects(questionnaire, dbContext);
AddQuestions(questionnaire, dbContext);
AddAnswers(questionnaire, dbContext);
dbContext.SaveChanges();
}
private static void AddSubjects(Questionnaire questionnaire, QuestionnaireContext dbContext)
{
var subjects = questionnaire.QuestionnaireItems
.Select(x => new Subject
{
SubjectId = x.SubjectId,
OrderNumber = x.OrderNumber,
Texts = ToTranslations(x.Texts)
}).ToArray();
dbContext.Subjects.AddRange(subjects);
}
public IHttpActionResult CheckIn(CreateCheckInModel model)
{
try
{
using (var dataContext = new HuntingEntities())
{
var session = GetSession();
if (session == null)
{
return(Content(HttpStatusCode.Unauthorized, SESSION_INVALID_MESSAGE));
}
var userSession = AclUserContext.GetUserSession(dataContext, session);
if (userSession == null)
{
return(Content(HttpStatusCode.Unauthorized, SESSION_INVALID_MESSAGE));
}
var mapItem = MapItemContext.GetDetail(dataContext, model.MapItemId);
if (mapItem == null)
{
return(Content(HttpStatusCode.NotFound, NOT_FOUND_MESSAGE));
}
if (userSession.AclUser.CanViewTerritory(mapItem.Territory) == false)
{
return(Content(HttpStatusCode.Forbidden, FORBIDDEN_MESSAGE));
}
Questionnaire questionnaire = null;
if (model.QuestionnaireId.HasValue)
{
questionnaire = QuestionnaireContext.GetDetail(dataContext, model.QuestionnaireId.Value);
}
if (model.IsValid(dataContext, questionnaire) == false)
{
return(Content(HttpStatusCode.BadRequest, BAD_REQUEST_MESSAGE));
}
var updateModel = new CheckInUpdateModel(model, questionnaire);
var pointId = CheckInContext.Update(dataContext, null, updateModel, userSession.AclUser, null);
if (pointId == null)
{
return(Content(HttpStatusCode.InternalServerError, FAILED_MESSAGE));
}
return(Ok(pointId.Value.ToString()));
}
}
catch (Exception exception)
{
logger.Error(exception, "MobileController");
return(InternalServerError());
}
}
public ActionResult Create(QuestionUpdateModel model)
{
try
{
using (var dataContext = new HuntingEntities())
{
int languageId = (int)Session[LocalizationAttribute.SESSION_LANGUAGE_ID];
var user = AclUserContext.GetDetail(dataContext, User.Identity.Name);
if (user == null)
{
ContextUtils.CreateActionStateCookie(Response, ActionTypeEnum.Warning, GlobalRes.ERROR_NOT_ALLOWED);
return(RedirectToAction("Index", "Home"));
}
var questionnaire = QuestionnaireContext.GetDetail(dataContext, model.QuestionnaireId);
if (questionnaire == null)
{
ContextUtils.CreateActionStateCookie(Response, ActionTypeEnum.Warning, GlobalRes.ERROR_NOT_FOUND);
return(RedirectToAction("Index", "Home"));
}
if (user.CanUpdateTerritory(questionnaire.MapItemType.Territory) == false)
{
ContextUtils.CreateActionStateCookie(Response, ActionTypeEnum.Warning, GlobalRes.ERROR_NOT_ALLOWED);
return(RedirectToAction("Index", "Territory", new { id = questionnaire.MapItemType.TerritoryId }));
}
if (ModelState.IsValid)
{
var newItemId = QuestionContext.Update(dataContext, null, model, user);
if (newItemId.HasValue)
{
ContextUtils.CreateActionStateCookie(Response, ActionTypeEnum.Success, QuestionRes.SUCCESS_CREATE);
return(RedirectToAction("Index", "Question", new { id = model.QuestionnaireId }));
}
else
{
ContextUtils.CreateActionStateCookie(Response, ActionTypeEnum.Warning, QuestionRes.ERROR_CREATE);
}
}
model.FillCodeList(languageId);
return(View(model));
}
}
catch (Exception exception)
{
logger.Error(exception, "QuestionController");
ContextUtils.CreateActionStateCookie(Response, ActionTypeEnum.Danger, GlobalRes.ERROR_EXCEPTION);
return(RedirectToAction("Index", "Home"));
}
}
private static void AddQuestions(Questionnaire questionnaire, QuestionnaireContext dbContext)
{
var questions = questionnaire.QuestionnaireItems
.SelectMany(x => x.QuestionnaireItems)
.Select(x => new Question
{
SubjectId = x.SubjectId,
QuestionId = x.QuestionId,
OrderNumber = x.OrderNumber,
QuestionnaireId = questionnaire.QuestionnaireId,
AnswerCategoryType = x.AnswerCategoryType,
Texts = ToTranslations(x.Texts)
})
.ToArray();
dbContext.Questions.AddRange(questions);
}
private static void AddAnswers(Questionnaire questionnaire, QuestionnaireContext dbContext)
{
var answers = questionnaire.QuestionnaireItems
.SelectMany(x => x.QuestionnaireItems)
.SelectMany(x => x.QuestionnaireItems)
.Where(x => x.AnswerId.HasValue)
.Select(x => new Answer
{
AnswerId = x.AnswerId.Value,
QuestionId = x.QuestionId,
OrderNumber = x.OrderNumber,
AnswerType = x.AnswerType,
Texts = ToTranslations(x.Texts)
})
.ToArray();
dbContext.Answers.AddRange(answers);
}
public void FillCodeLists(HuntingEntities dataContext, MapItem mapItem)
{
if (mapItem != null)
{
this.QuestionnaireSelectList = QuestionnaireContext.GetSelectList(dataContext, mapItem.MapItemTypeRecord, this.QuestionnaireId);
}
if (this.QuestionList != null)
{
foreach (var questionModel in this.QuestionList)
{
if (questionModel.QuestionType == QuestionTypeEnum.DropDown)
{
var question = dataContext.Questions.First(item => item.Id == questionModel.Id);
var optionList = question.Options.
Where(item => item.IsDeleted == false).
OrderBy(item => item.Order).
ToList();
questionModel.OptionList = new SelectList(optionList, "Id", "Name", questionModel.OptionId);
}
}
}
}
private static void Main(string[] args)
{
CreateAdminAndCheckLogin();
AddQuestionsToDb();
return;
SubjectRepository subjectRepo = new SubjectRepository();
Subject subject = new Subject()
{
Nickname = "Zoli",
Age = 22,
Gender = Gender.Female,
QuestionAnswers = new List <QuestionAnswer>(),
SessionStartDate = DateTime.Now
};
subjectRepo.Create(subject);
using QuestionManager questionManager = new QuestionManager();
Question[] questions = questionManager.GetQuestionsForSubject(subject).ToArray();
var answers = questions.Select(q => new QuestionAnswer()
{
Answer = true,
Question = q
});
subject.QuestionAnswers.AddRange(answers);
subjectRepo.SaveChanges();
Console.WriteLine("FINISHED");
Console.ReadKey();
using var context = new QuestionnaireContext();
context.Questions.RemoveRange(context.Questions);
context.QuestionAnswers.RemoveRange(context.QuestionAnswers);
context.Subjects.RemoveRange(context.Subjects);
context.SaveChanges();
}
public ActionResult SelectQuestionnaireAjax(CheckInUpdateModel model)
{
try
{
using (var dataContext = new HuntingEntities())
{
int languageId = (int)Session[LocalizationAttribute.SESSION_LANGUAGE_ID];
var language = LanguageContext.GetLanguage(languageId);
var user = AclUserContext.GetDetail(dataContext, User.Identity.Name);
if (user == null)
{
return(PartialView(@"AjaxError", GlobalRes.ERROR_NOT_ALLOWED));
}
ModelState.Clear();
if (model.QuestionnaireId.HasValue)
{
var questionnaire = QuestionnaireContext.GetDetail(dataContext, model.QuestionnaireId.Value);
if (questionnaire == null)
{
return(PartialView(@"AjaxError", GlobalRes.ERROR_NOT_FOUND));
}
if (user.CanViewTerritory(questionnaire.MapItemType.Territory) == false)
{
return(PartialView(@"AjaxError", GlobalRes.ERROR_NOT_ALLOWED));
}
model.FillQuestionnaire(null, questionnaire, language);
model.FillCodeLists(dataContext, null);
}
return(PartialView(model));
}
}
catch (Exception exception)
{
logger.Error(exception, "CheckInController");
return(PartialView(@"AjaxError", GlobalRes.ERROR_EXCEPTION));
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, QuestionnaireContext dbContext)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
dbContext.Database.EnsureCreated();
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseSpaStaticFiles();
app.UseRouting();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller}/{action=Index}/{id?}");
});
app.UseSpa(spa =>
{
spa.Options.SourcePath = "ClientApp";
if (env.IsDevelopment())
{
spa.UseReactDevelopmentServer(npmScript: "start");
}
});
}
public static List <Category> getCategoriesList()
{
QuestionnaireContext context = new QuestionnaireContext();
return(context.Categories.ToList());
}
public QuestionService(QuestionnaireContext questionnaireContext)
{
_questionnaireContext = questionnaireContext;
}
public DropMenuDatasController(QuestionnaireContext context)
{
_context = context;
}
public static void Seed(QuestionnaireContext context)
{
context.Database.EnsureCreated();
if (context.Results.Any())
{
return;
}
var resultList = new List <Result>
{
new Result {
Text = "Возрастное ограничение данной игры: +18"
},
new Result {
Text = "Возрастное ограничение данной игры: +16"
},
new Result {
Text = "Возрастное ограничение данной игры: +12"
},
new Result {
Text = "Возрастное ограничение данной игры: +6"
},
new Result {
Text = "Возрастное ограничение данной игры: +0"
},
};
context.Results.AddRange(resultList);
context.SaveChanges();
context.BinaryQuestions.AddRange(new List <BinaryQuestion>
{
new BinaryQuestion
{
Text = "Присутствует ли в сюжете игры натуралистические сцены половых отношений или сексуального насилия?",
DeterminateAnswer = true,
Result = resultList.FirstOrDefault(r => r.Id == 1),
Order = 1
},
new BinaryQuestion
{
Text = "Встречаются ли в игре отдельные бранные слова и (или) выражения, относящиеся к нецензурной брани?",
DeterminateAnswer = true,
Result = resultList.FirstOrDefault(r => r.Id == 1),
Order = 2
},
new BinaryQuestion
{
Text = "Игра содержит изображение или описание, побуждающие к совершению антиобщественных действий (в том числе к потреблению алкогольной и спиртосодержащей продукции, участию в азартных играх, занятию бродяжничеством или попрошайничеством)?",
DeterminateAnswer = true,
Result = resultList.FirstOrDefault(r => r.Id == 2),
Order = 3
},
new BinaryQuestion
{
Text = "Содержит ли игра натуралистические изображение или описание несчастного случая, аварии, катастрофы либо ненасильственной смерти без демонстрации их последствий, которые могут вызывать у детей страх, ужас или панику?",
DeterminateAnswer = true,
Result = resultList.FirstOrDefault(r => r.Id == 3),
Order = 4
},
new BinaryQuestion
{
Text = "Игра содержит информацию, причиняющую вреда здоровью и (или) развитию детей (в том числе информационная продукция, содержащая оправданные ее жанром и (или) сюжетом эпизодические ненатуралистические изображение или описание физического и (или) психического насилия (за исключением сексуального насилия) при условии торжества добра над злом и выражения сострадания к жертве насилия и (или) осуждения насилия)?",
DeterminateAnswer = true,
Result = resultList.FirstOrDefault(r => r.Id == 4),
Order = 5
}
});
context.SaveChanges();
}
public QuestionnaireController(QuestionnaireContext context)
{
db = context;
}
public BaseRepository(QuestionnaireContext context)
{
Context = context;
DbSet = context.Set <T>();
}
public HomeController(QuestionnaireContext context)
{
_context = context;
}
private static void InitizeData(QuestionnaireContext context)
{
//throw new NotImplementedException();
}
public PartialRepository(QuestionnaireContext context)
{
questionnaireContext = context;
DbSet = context.Set <T>();
}
public QuestionnaireService(QuestionnaireContext _questionnaireContext)
{
questionnaireContext = _questionnaireContext;
}
public AdminLoginManager()
{
dbContext = new QuestionnaireContext();
}
