private FullDataModel convertRecordToModel(SqlDataReader reader)
{
FullDataModel dataRecord = new FullDataModel();
// Set values in model record
dataRecord.IncidentId = reader.GetInt64(0);
dataRecord.CaseNumber = reader.GetString(1);
dataRecord.DayOfWeek = reader.GetString(2);
dataRecord.HourOfDay = reader.GetInt32(3);
dataRecord.IncidentDateTime = reader.GetString(4);
dataRecord.ParentIncidentType = reader.GetString(5);
dataRecord.IncidentType = reader.GetString(6);
dataRecord.Latitude = reader.GetDouble(7);
dataRecord.Longitude = reader.GetDouble(8);
dataRecord.Description = reader.GetString(9);
return(dataRecord);
}
private void exportButton_Click(object sender, EventArgs e)
{
var saveFileDialog = new SaveFileDialog
{
Filter = "JSON files (*.json)|*.json",
FilterIndex = 1,
RestoreDirectory = true,
};
if (saveFileDialog.ShowDialog() != DialogResult.OK)
{
return;
}
var fullData = new FullDataModel
{
Teachers = TeachersRepository.Teachers,
Subjects = SubjectsRepository.Subjects,
TeacherSubjects = TeacherSubjectRepository.TeacherSubjects,
};
File.WriteAllText(saveFileDialog.FileName, JsonConvert.SerializeObject(fullData));
}
