internal int UnassignRoles(UpdateRolesModal updateRolesModal)
{
int final = 1;
try
{
using (var connection = new OleDbConnection(connString))
{
connection.Open();
using (var cmd = new OleDbCommand())
{
cmd.Connection = connection;
cmd.CommandTimeout = 300;
for (int i = 0; i < updateRolesModal.RolesDetailsList.Count; i++)
{
cmd.CommandText = "DELETE * FROM Users_Roles WHERE UserId ='" + updateRolesModal.UidNo + "' and RoleId = " + updateRolesModal.RolesDetailsList[i].RoleId + " and AccessType = '" + updateRolesModal.RolesDetailsList[i].AccessType + "'";
cmd.ExecuteNonQuery();
final = final + cmd.ExecuteNonQuery();
}
}
return(final);
}
}
catch (Exception ex)
{
_logger.LogError($"$$$SaveActivityAttend$$$####Error Message ->>>{ex} && {ex.Message}###### + StackTrace {ex.StackTrace}######## + InnerEx{ex.InnerException}#####");
return(0);
}
}
public IActionResult AssignUnassignRoles(UpdateRolesModal updateRolesModal, string action)
{
var result = new RequestResult <bool>()
{
Data = _rolesManager.AssignUnassignRoles(updateRolesModal, action),
Message = "Success",
Success = true
};
return(Ok(result));
}
public bool AssignUnassignRoles(UpdateRolesModal updateRolesModal, string action)
{
if (action.ToLower().Trim() == "add")
{
return(_userRolesDataAccess.AssignRoles(updateRolesModal, action));
}
if (action.ToLower().Trim() == "delete")
{
return(_userRolesDataAccess.UnassignRoles(updateRolesModal, action));
}
throw new CustomException("Invalid Action");
}
internal int AssignRoles(UpdateRolesModal updateRolesModal)
{
int final = 0;
try
{
using (var connection = new OleDbConnection(connString))
{
connection.Open();
using (var cmd = new OleDbCommand(@"Insert into Users_Roles (UserId, RoleId, AccessType) VALUES (@UserId, @RoleId, @AccessType)", connection))
{
cmd.CommandTimeout = 300;
for (int i = 0; i < updateRolesModal.RolesDetailsList.Count; i++)
{
cmd.Parameters.Clear();
cmd.Parameters.AddRange(new OleDbParameter[]
{
new OleDbParameter {
ParameterName = "@UserId", Value = updateRolesModal.UidNo
},
new OleDbParameter {
ParameterName = "@RoleId", Value = updateRolesModal.RolesDetailsList[i].RoleId
},
new OleDbParameter {
ParameterName = "@AccessType", Value = updateRolesModal.RolesDetailsList[i].AccessType
},
});
final = final + cmd.ExecuteNonQuery();
}
}
return(final);
}
}
catch (Exception ex)
{
_logger.LogError($"$$$SaveActivityAttend$$$####Error Message ->>>{ex} && {ex.Message}###### + StackTrace {ex.StackTrace}######## + InnerEx{ex.InnerException}#####");
return(0);
}
}
internal bool AssignRoles(UpdateRolesModal updateRolesModal, string action)
{
return(_dbConnection.AssignRoles(updateRolesModal) > 0 ? true : false);
}
