internal int UpdateRoles(UserRolesModal obj)
{
int final = 0;
try
{
using (var connection = new OleDbConnection(connString))
{
connection.Open();
using (var cmd = new OleDbCommand())
{
cmd.CommandTimeout = 300;
cmd.Connection = connection;
cmd.CommandText = "UPDATE Roles SET DeleteInd =" + 0 + " , RoleName='" + obj.RoleName + "' , LastUpdatedDt=" + DateTime.Now.ToString("MM/dd/yyyy") + " , RoleDesc='" + obj.RoleDesc + "' WHERE RoleId =" + obj.RoleId;
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 int DeleteRoles(UserRolesModal userRolesModal)
{
int final = 0;
try
{
using (var connection = new OleDbConnection(connString))
{
connection.Open();
using (var cmd = new OleDbCommand())
{
cmd.CommandTimeout = 300;
cmd.Connection = connection;
cmd.CommandText = "UPDATE Roles SET DeleteInd = " + 1 + " WHERE RoleId =" + userRolesModal.RoleId;
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 ManageRoles(UserRolesModal userRolesModal, string action)
{
var result = new RequestResult <bool>()
{
Data = _rolesManager.ManageRoles(userRolesModal, action),
Message = "Success",
Success = true
};
return(Ok(result));
}
public bool ManageRoles(UserRolesModal userRolesModal, string action)
{
if (action.ToLower().Trim() == "add")
{
return(_userRolesDataAccess.AddNewRoles(userRolesModal));
}
if (action.ToLower().Trim() == "edit")
{
return(_userRolesDataAccess.UpdateRoles(userRolesModal));
}
if (action.ToLower().Trim() == "delete")
{
return(_userRolesDataAccess.DeleteRoles(userRolesModal));
}
throw new CustomException("Invalid Action");
}
internal int AddNewRoles(UserRolesModal userRolesModal)
{
int final = 0;
var maxCount = GetModelDetails("select MAX(RoleId) as RoleId from Roles").AsEnumerable().FirstOrDefault().Field <int>("RoleId");
try
{
using (var connection = new OleDbConnection(connString))
{
connection.Open();
using (var cmd = new OleDbCommand(@"INSERT into Roles (RoleId, RoleName, LastUpdatedDt, DeleteInd, RoleDesc) VALUES (@RoleId, @RoleName, @LastUpdatedDt, @DeleteInd, @RoleDesc)", connection))
{
cmd.CommandTimeout = 300;
cmd.Parameters.Add(new OleDbParameter {
ParameterName = "@RoleId", Value = maxCount + 1, OleDbType = OleDbType.Integer
});
cmd.Parameters.Add(new OleDbParameter {
ParameterName = "@RoleName", Value = userRolesModal.RoleName.ToString(), OleDbType = OleDbType.VarWChar
});
cmd.Parameters.Add(new OleDbParameter {
ParameterName = "@LastUpdatedDt", Value = DateTime.Now, OleDbType = OleDbType.Date
});
cmd.Parameters.Add(new OleDbParameter {
ParameterName = "@DeleteInd", Value = 0, OleDbType = OleDbType.Integer
});
cmd.Parameters.Add(new OleDbParameter {
ParameterName = "@RoleDesc", Value = userRolesModal.RoleDesc, OleDbType = OleDbType.VarWChar
});
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 AddNewRoles(UserRolesModal userRolesModal)
{
return(_dbConnection.AddNewRoles(userRolesModal) > 0 ? true : false);
}
internal bool UpdateRoles(UserRolesModal userRolesModal)
{
return(_dbConnection.UpdateRoles(userRolesModal) > 0 ? true : false);
}
