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;
}
