Example #1
0
        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>());
            }
        }