public override void OnEnter() { if (Settings.IsOfflineMode) { MessageBox.Show("Dit scherm is niet beschikbaar in offline mode."); _router.GoBack(); return; } TemplateQuestions.Clear(); if (ViewBag?.Template == null) { Checklist = new Checklist(); return; } Checklist = ViewBag.Template.GetCleanModel(); const string regex = "\\s{1}[Vv]{1}\\d{1,}$"; if (Regex.Match(Checklist.Name, regex).Success) { Checklist.Name = Regex.Replace(Checklist.Name, regex, string.Empty); } Checklist.Name += $" v{Checklist.Version}"; RaisePropertyChanged(nameof(Checklist)); _checklistQuestionRepository.GetChecklistQuestions(Checklist.Parent).ForEach(q => TemplateQuestions.Add(q.GetCleanModel())); _questionRepository.All().ForEach(ExistingQuestions.Add); }
public long AddAuditQuestion(TemplateQuestions addtemp) { using (var db = new SQLiteConnection(_helper.WritableDatabase.Path)) { return(db.Insert(addtemp)); } }
public void SetDefaultTemplate() { AuditTemplate foodAudit = new AuditTemplate(); List <TemplateQuestions> Questions = new List <TemplateQuestions>(); Questions = dbUpdates.GetTemplateQuestions(); AuditTemplate temp1 = dbUpdates.GetAuditTemplate("Food"); try { if (dbUpdates.GetTemplateCount() == 0) { foodAudit.Name = "Food Audit"; foodAudit.Type = "Food"; int id = dbUpdates.AddTemplate(foodAudit); TemplateQuestions question1 = new TemplateQuestions(); question1.TemplateId = id; question1.QuestionDescription = "Is there sufficient storage space? "; dbUpdates.AddAuditQuestion(question1); Questions = dbUpdates.GetTemplateQuestions(); TemplateQuestions question2 = new TemplateQuestions(); question2.TemplateId = id; question2.QuestionDescription = "Are chemicals and cleaning products stored away from food storage areas?"; dbUpdates.AddAuditQuestion(question2); Questions = dbUpdates.GetTemplateQuestions(); TemplateQuestions question3 = new TemplateQuestions(); question3.TemplateId = id; question3.QuestionDescription = "Is all packaging in good condition?"; dbUpdates.AddAuditQuestion(question3); TemplateQuestions question4 = new TemplateQuestions(); question4.TemplateId = id; question4.QuestionDescription = "Have appropriate corrective actions been taken and recorded?"; dbUpdates.AddAuditQuestion(question4); } } catch (Exception ex) { throw; } }
private void SaveTemplate() { if (!CanSave()) { return; } Checklist.Hash = MD5.Crypt($"Checklist {Checklist.Inspections.Count}-{Checklist.Name}"); Checklist.Name = Checklist.Name?.Trim(); Checklist.Remarks = Checklist.Remarks?.Trim() ?? ""; var questions = _checklistQuestionRepository.GetChecklistQuestions(Checklist.Parent); TemplateQuestions .ToList() .ForEach(q => { var question = questions.FirstOrDefault(x => x.Question.ID == q.Question.ID); if (question == null) { Checklist.ChecklistQuestions.Add(q); return; } if (q.Question.Equals(question.Question)) { Checklist.ChecklistQuestions.Add(q); return; } Checklist.ChecklistQuestions.Add(q.GetCleanModel()); }); Checklist.DateTimeCreated = DateTime.Now; _checklistRepository.Add(Checklist); MessageBox.Show($"Template met de naam {Checklist.Name} en {Checklist.ChecklistQuestions.Count} vragen is opgeslagen."); _router.GoBack(); }
private void AddExistingQuestion() { if (SelectedExistingQuestion == null) { return; } if (TemplateQuestions.Any(t => t.Question.Equals(SelectedExistingQuestion))) { return; } var max = TemplateQuestions.Max(t => t.Order); var checklistQuestion = new ChecklistQuestion { Checklist = Checklist, Order = max == null ? 0 : max + 1, Question = SelectedExistingQuestion }; TemplateQuestions.Add(checklistQuestion); SelectedTemplateQuestion = checklistQuestion; }
private void AddNewQuestion() { if (SelectedQuestionType == null) { return; } var newQuestion = new Database.Question { QuestionType = SelectedQuestionType, Hash = MD5.Crypt($"{SelectedQuestionType.Name}-{DateTime.Now}") }; var max = TemplateQuestions.Max(t => t.Order); var checklistQuestion = new ChecklistQuestion { Checklist = Checklist, Order = max == null ? 0 : max + 1, Question = newQuestion }; TemplateQuestions.Add(checklistQuestion); SelectedTemplateQuestion = checklistQuestion; }
public void SetDefaultTemplate() { AuditTemplate foodAudit = new AuditTemplate(); List <TemplateQuestions> Questions = new List <TemplateQuestions>(); Questions = dbUpdates.GetTemplateQuestions(); AuditTemplate temp1 = dbUpdates.GetAuditTemplate("Food"); if (dbUpdates.GetTemplateCount() == 0) { foodAudit.Name = "Appearance Care"; foodAudit.Type = "Food"; int id = dbUpdates.AddTemplate(foodAudit); TemplateQuestions question1 = new TemplateQuestions(); question1.TemplateId = id; question1.QuestionDescription = "Is there sufficient storage space? "; dbUpdates.AddAuditQuestion(question1); Questions = dbUpdates.GetTemplateQuestions(); TemplateQuestions question2 = new TemplateQuestions(); question2.TemplateId = id; question2.QuestionDescription = "Are chemicals and cleaning products stored away from food storage areas?"; dbUpdates.AddAuditQuestion(question2); Questions = dbUpdates.GetTemplateQuestions(); TemplateQuestions question3 = new TemplateQuestions(); question3.TemplateId = id; question3.QuestionDescription = "Is all packaging in good condition?"; dbUpdates.AddAuditQuestion(question3); TemplateQuestions question4 = new TemplateQuestions(); question4.TemplateId = id; question4.QuestionDescription = "Have appropriate corrective actions been taken and recorded?"; dbUpdates.AddAuditQuestion(question4); AuditTemplate foodAudit4 = new AuditTemplate(); foodAudit4.Name = "Pest Inspection"; foodAudit4.Type = "Food"; dbUpdates.AddTemplate(foodAudit4); AuditTemplate foodAudit5 = new AuditTemplate(); foodAudit5.Name = "RestRoom Inspection"; foodAudit5.Type = "Food"; dbUpdates.AddTemplate(foodAudit5); AuditTemplate foodAudit1 = new AuditTemplate(); foodAudit1.Name = "QA Audio Visual Inspection"; foodAudit1.Type = "Food"; dbUpdates.AddTemplate(foodAudit1); AuditTemplate foodAudit2 = new AuditTemplate(); foodAudit2.Name = "Chevron Janitorial Services Survey Form v8"; foodAudit2.Type = "Food"; dbUpdates.AddTemplate(foodAudit2); AuditTemplate foodAudit3 = new AuditTemplate(); foodAudit3.Name = "Chevron Site Services - Service Quality Inspection"; foodAudit3.Type = "Food"; dbUpdates.AddTemplate(foodAudit3); AuditTemplate foodAudit6 = new AuditTemplate(); foodAudit6.Name = "Meeting Room Inspection "; foodAudit6.Type = "Food"; dbUpdates.AddTemplate(foodAudit6); } }
public TemplateSurvey ReadAll(int id) { TemplateSurvey survey = null; TemplateSection section = null; List <TemplateSection> sectionList = new List <TemplateSection>(); List <TemplateQuestions> questionsList = new List <TemplateQuestions>(); _dataProvider.ExecuteCmd( "SurveyTemplate_SSQ_Join", cmd => { cmd.AddWithValue("@Id", id); }, (reader, read) => { survey = new TemplateSurvey() { Id = (int)reader["SurveyId"], Name = (string)reader["Name"], Description = (string)reader["SurveyDescription"], TypeId = (int)reader["SurveyTypeId"], StatusId = (int)reader["SurveyStatusId"], OwnerId = (int)reader["SurveyOwnerId"], }; object version = reader["Version"]; if (version == DBNull.Value) { survey.Version = 0; } else { survey.Version = (int)version; } TemplateSection sectionTemplate = new TemplateSection() { Id = (int)reader["SectionId"], Title = (string)reader["Title"], Description = (string)reader["SectionDescription"], SortOrder = (int)reader["SectionSortOrder"] }; TemplateQuestions question = new TemplateQuestions() { Id = (int)reader["QuestionId"], Question = (string)reader["Question"], SortOrder = (int)reader["QuestionSortOrder"], HelpText = (string)reader["HelpText"], IsRequired = (bool)reader["IsRequired"], IsMultipleAllowed = (bool)reader["IsMultipleAllowed"], QuestionTypeId = (int)reader["QuestionTypeId"], StatusId = (int)reader["StatusId"], UserId = (int)reader["UserId"], AnswerOptions = new List <TemplateAnswerOption>() }; questionsList.Add(question); sectionTemplate.Questions = questionsList; section = sectionTemplate; }); sectionList.Add(section); survey.Sections = sectionList; return(survey); }
private void RemoveSelectedQuestion() { TemplateQuestions.Remove(SelectedTemplateQuestion); SelectedTemplateQuestion = TemplateQuestions.Count > 0 ? TemplateQuestions[0] : null; }