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