/// <summary>
/// Connects to database and returns roles details by role name.
/// </summary>
/// <param name="RoleName">Role name.</param>
/// <returns>Role details.</returns>
public RolesManagementInfo GetRoleIDByRoleName(string RoleName)
{
SqlDataReader reader = null;
try
{
SQLHandler SQLH = new SQLHandler();
List <KeyValuePair <string, object> > ParamCollInput = new List <KeyValuePair <string, object> >();
ParamCollInput.Add(new KeyValuePair <string, object>("@RoleName", RoleName));
reader = SQLH.ExecuteAsDataReader("[dbo].[sp_GetRoleIDByRoleName]", ParamCollInput);
RolesManagementInfo objList = new RolesManagementInfo();
while (reader.Read())
{
objList.ApplicationId = new Guid(reader["ApplicationId"].ToString());
objList.RoleId = new Guid(reader["RoleId"].ToString());
objList.RoleName = reader["RoleName"].ToString();
objList.LoweredRoleName = reader["LoweredRoleName"].ToString();
objList.Description = reader["Description"].ToString();
}
reader.Close();
return(objList);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
/// <summary>
/// Connects to database and returns roles details by role name.
/// </summary>
/// <param name="RoleName">Role name.</param>
/// <returns>Role details.</returns>
public RolesManagementInfo GetRoleIDByRoleName(string RoleName)
{
SqlDataReader reader = null;
try
{
SQLHandler SQLH = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@RoleName", RoleName));
reader = SQLH.ExecuteAsDataReader("[dbo].[sp_GetRoleIDByRoleName]", ParamCollInput);
RolesManagementInfo objList = new RolesManagementInfo();
while (reader.Read())
{
objList.ApplicationId = new Guid(reader["ApplicationId"].ToString());
objList.RoleId = new Guid(reader["RoleId"].ToString());
objList.RoleName = reader["RoleName"].ToString();
objList.LoweredRoleName = reader["LoweredRoleName"].ToString();
objList.Description = reader["Description"].ToString();
}
reader.Close();
return objList;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}