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