public List <GradeVm> GetList(GradeVm p, ref string msg) { List <GradeVm> items = new List <GradeVm>(); DataTable dt = db.GetList(MapProperties(p), ref msg); if (msg != "") { return(new List <GradeVm>()); } try { foreach (DataRow row in dt.Rows) { GradeVm item = new GradeVm(); item.Id = row["gradeId"].GetString(); item.Title = row["title"].GetString(); item.Details = row["details"].GetString(); item.CreatedById = row["createdById"].GetString(); item.CreatedBy = row["createdByName"].GetString(); item.CreatedOn = row["createdOn"].GetDateTime().GetString(); item.ModifiedById = row["modifiedById"].GetString(); item.ModifiedBy = row["modifiedByName"].GetString(); item.ModifiedOn = row["modifiedOn"].GetNullableDateTime().GetString(); items.Add(item); } return(items); } catch (Exception ex) { msg = ef.GetExceptionMessage(ex, msg); return(new List <GradeVm>()); } }