/// <summary>
/// This method is used to load data from the database.
/// <param name="defaultLoad">This specifies whether to use this function for loading default data or custom data.</param>
/// </summary>
private void LoadData(bool defaultLoad = true)
{
var conditions = CreateCondition(defaultLoad);
var data = viewModelDataService.GetRecords(DatabaseTable.Relationship, conditions);
// Convert datatable data to a list, sort it by name.
List <ExamRelationViewModel> modelData = (from DataRow row in data.Rows
select new ExamRelationViewModel
{
Id = Convert.ToInt32(row[TableColumns.COMMON_ID]),
SubjectName = row[TableColumns.SUBJECT_SUBJECT_NAME].ToString(),
TopicName = row[TableColumns.TOPIC_TOPIC_NAME].ToString(),
ExamName = row[TableColumns.EXAM_EXAM_NAME].ToString()
})
.ToList();
modelData = modelData
.OrderBy(x => x.SubjectName)
.ThenBy(x => x.TopicName)
.ThenBy(x => x.ExamName)
.ToList();
dgvSyllabusDetails.AutoGenerateColumns = false;
dgvSyllabusDetails.DataSource = modelData;
}
/// <summary>
/// This method is used to load the exam data in the table.
/// </summary>
private void LoadData()
{
var conditions = new JoinConditions
{
LogicalOperator = LogicalOperators.AND,
Conditions = new List <Condition>
{
new Condition
{
BaseTable = DatabaseTable.Subject,
JoinTable = DatabaseTable.Topic,
JoinTableColumnName = TableColumns.TOPIC_PARENT_SUBJECT
}
}
};
var data = viewModelDataService.GetRecords(DatabaseTable.Topic, conditions);
// Convert datatable data to a list, sort it by name.
List <TopicSubjectViewModel> modelData = (from DataRow row in data.Rows
select new TopicSubjectViewModel
{
Id = Convert.ToInt32(row[TableColumns.COMMON_ID]),
SubjectName = row[TableColumns.SUBJECT_SUBJECT_NAME].ToString(),
TopicName = row[TableColumns.TOPIC_TOPIC_NAME].ToString()
})
.ToList();
modelData = modelData.OrderBy(x => x.SubjectName).ThenBy(x => x.TopicName).ToList();
dgvTopicDetails.AutoGenerateColumns = false;
dgvTopicDetails.DataSource = modelData;
}