public List <RoleEntities> GetRoles()
{
List <RoleEntities> roleInfo = new List <RoleEntities>();
try
{
SqlDataReader dr = SqlHelper.ExecuteReader(
sqlConnectionString
, CommandType.StoredProcedure, "usp_GetRoleDetails");
if (dr.HasRows)
{
while (dr.Read())
{
RoleEntities entities = new RoleEntities();
entities.RoleId = Convert.ToInt32(dr["RoleId"]);
entities.RoleName = Convert.ToString(dr["RoleName"]);
entities.AccessLevelId = Convert.ToInt32(dr["AccessLevelId"]);
entities.AccessLevelName = Convert.ToString(dr["AccessLevelName"]);
roleInfo.Add(entities);
}
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(roleInfo);
}
public bool AddRole(RoleEntities roleItem)
{
bool insertStatus = false;
SqlConnection conn = null;
try
{
using (conn = new SqlConnection(sqlConnectionString))
{
using (SqlCommand cmd = new SqlCommand("usp_RoleInsert", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RoleName", SqlDbType.VarChar).Value = roleItem.RoleName;
cmd.Parameters.Add("@AccessLevelId", SqlDbType.Int).Value = roleItem.AccessLevelId;
conn.Open();
cmd.ExecuteNonQuery();
insertStatus = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(insertStatus);
}
public bool AddRole(string roleName, int accessLevel)
{
bool addStatus = false;
RoleEntities role = new RoleEntities();
role.RoleName = roleName;
role.AccessLevelId = accessLevel;
DAO.AddRole(role);
return(addStatus);
}
