private static EntitySecurityInfo ReadData(SqlDataReader reader)
{
var role = new EntitySecurityInfo
{
EntitySecurityId = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0),
EntityId = reader.IsDBNull(1) ? string.Empty : reader.GetString(1),
RoleId = reader.IsDBNull(2) ? Guid.Empty : reader.GetGuid(2),
SecurityCode = reader.IsDBNull(3) ? 0 : reader.GetInt32(3),
FunctionContext = reader.IsDBNull(4) ? Guid.Empty : reader.GetGuid(4),
};
return(role);
}
internal bool Update(Guid tenantId, EntitySecurityInfo entitySecurityInfo)
{
try
{
var cmd = CreateProcedureCommand("dbo.EntitySecurity_Update");
cmd.AppendGuid("@guidTenantId", tenantId);
cmd.AppendGuid("@guidEntitySecurityId", entitySecurityInfo.EntitySecurityId);
cmd.AppendXSmallText("@strEntityId", entitySecurityInfo.EntityId);
cmd.AppendGuid("@guidRoleId", entitySecurityInfo.RoleId);
cmd.AppendInt("@intSecurityCode", entitySecurityInfo.SecurityCode);
ExecuteCommand(cmd);
return(true);
}
catch (SqlException e)
{
throw ReportAndTranslateException(e, "Entity_Security::EntitySecurity_Update");
}
}
internal EntitySecurityInfo GetEntitySecurity(Guid tenantId, string entityId, Guid roleId)
{
EntitySecurityInfo entitiesLst = null;
try
{
var cmd = CreateProcedureCommand("dbo.EntitySecurity_Get");
cmd.AppendGuid("@guidTenantId", tenantId);
cmd.AppendXSmallText("@strEntityId", entityId);
cmd.AppendGuid("@guidRoleId", roleId);
using (SqlDataReader reader = ExecuteCommandAndReturnReader(cmd))
{
while (reader.Read())
{
entitiesLst = ReadData(reader);
}
}
}
catch (SqlException e)
{
throw ReportAndTranslateException(e, "Entity_Security::EntitySecurity_Get");
}
return(entitiesLst);
}
public IActionResult Post(string entityname, [FromBody] EntitySecurityInfo entitySecurity)
{
try
{
if (entitySecurity == null)
{
return(BadRequest("Invalid parameter"));
}
var stopwatch = StopwatchLogger.Start(_log);
_log.Info("Called EntitySecurityController Post {0}=", JsonConvert.SerializeObject(entitySecurity));
entitySecurity.EntityId = _iMetadataManager.GetEntityContextByEntityName(entityname);
var retVal = _managerEntitySecurity.Create(TenantCode, entitySecurity);
retVal.EntityId = string.Empty;
_securityCacheManager.Clear(TenantCode, UserId, EntityCacheType.Entity);
stopwatch.StopAndLog("End EntitySecurityController Post");
return(Ok(retVal));
}
catch (Exception ex)
{
_log.Error(ExceptionFormatter.SerializeToString(ex));
return(StatusCode((int)HttpStatusCode.InternalServerError, ApiConstant.CustomErrorMessage));
}
}
EntitySecurityInfo IManagerEntitySecurity.Update(Guid tenantId, EntitySecurityInfo info)
{
_adminEntitySecurity.Update(tenantId, info);
return(info);
}
EntitySecurityInfo IManagerEntitySecurity.Create(Guid tenantId, EntitySecurityInfo info)
{
info.EntitySecurityId = Guid.NewGuid();
_adminEntitySecurity.Create(tenantId, info);
return(info);
}
bool IAdminEntitySecurity.Update(Guid tenantId, EntitySecurityInfo info)
{
return(_dataEntitySecurity.Update(tenantId, info));
}
