// Method Delete
public int Delete(RolesModel role)
{
int execute = 0;
DataTable dt = DataProvider.Instance.Query(RolesQuerys.GetRoleIdByName(role.Name));
if (dt != null)
{
int roleId = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
execute = DataProvider.Instance.Execute(UsersQuery.DeleteByRoleId(roleId));
execute += DataProvider.Instance.Execute(RolesQuerys.Delete(roleId));
}
return(execute);
}
// Method GetRoleIdByRoleName
public int GetRoleIdByName(string roleName)
{
DataTable dt = DataProvider.Instance.Query(RolesQuerys.GetRoleIdByName(roleName));
return(dt == null ? 0 : Convert.ToInt32(dt.Rows[0]["ID"].ToString()));
}