public List <RolesEntity> GetAllRoles() { string strSql = @"SELECT * FROM [Roles] WHERE [Status]=0 OR [Status]=1 ORDER BY [RoleID] DESC"; List <RolesEntity> list = new List <RolesEntity>(); Database db = DatabaseFactory.CreateDatabase(); using (DbCommand dbCommand = db.GetSqlStringCommand(strSql)) { try { using (IDataReader dataReader = db.ExecuteReader(dbCommand)) while (dataReader.Read()) { list.Add(RolesEntity.ReaderBind(dataReader)); } } catch (Exception ex) { WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]" , strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message)); return(null); } } return(list); }
/// <summary> /// Get an object entity /// </summary> public RolesEntity Get(int RoleID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select RoleID,RoleName,Description,Status,CreatedOn,CreatedBy from Roles "); strSql.Append(" where RoleID=@RoleID "); Database db = DatabaseFactory.CreateDatabase(); using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString())) { try { db.AddInParameter(dbCommand, "RoleID", DbType.Int32, RoleID); RolesEntity model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = RolesEntity.ReaderBind(dataReader); } } return(model); } catch (Exception ex) { WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]" , strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message)); return(null); } } }