public async static Task<CourseTypeModel> getCourseTypeByTypeName(string typeName)
{
CourseTypeModel model = new CourseTypeModel();
await Task.Run(() =>
{
string sql = string.Format(Select_CourseType_getCourseTypeByTypeName, typeName);
List<object> lists = DbService.ExecSelect(sql);
foreach (List<object> list in lists)
{
model.TypeId = Convert.ToInt32(list[0]);
model.TypeName = list[1].ToString().Trim();
}
});
return model;
}
/// <summary>
/// Load all CourseType
/// </summary>
/// <returns></returns>
public async static Task<List<CourseTypeModel>> getAllCourseType()
{
CourseTypes.Clear();
await Task.Run(() =>
{
List<object> lists = DbService.ExecSelect(Select_CourseType_getAllCourseType);
foreach (List<object> item in lists)
{
CourseTypeModel model = new CourseTypeModel();
model.TypeId = Convert.ToInt32(item[0]);
model.TypeName = item[1].ToString().Trim();
CourseTypes.Add(model);
}
});
return CourseTypes;
}
