private static TenantSubscriptionEntityInfo ReadInfo(SqlDataReader reader)
{
var role = new TenantSubscriptionEntityInfo
{
TenantSubscriptionEntityId = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0),
TenantSubscriptionId = reader.IsDBNull(1) ? Guid.Empty : reader.GetGuid(1),
EntityId = reader.IsDBNull(2) ? string.Empty : reader.GetString(2),
LimtNumber = reader.IsDBNull(3) ? (int?)null : reader.GetInt32(3),
LimitType = reader.IsDBNull(4) ? LimitTypes.TotalCount : (LimitTypes)reader.GetByte(4)
};
return(role);
}
internal bool Create(Guid tenantId, TenantSubscriptionEntityInfo info)
{
try
{
var cmd = CreateProcedureCommand("dbo.TenantSubscriptionEntity_Create");
cmd.AppendGuid("@guidTenantId", tenantId);
cmd.AppendGuid("@guidTenantSubscriptionEntityId", info.TenantSubscriptionEntityId);
cmd.AppendGuid("@guidTenantSubscriptionId", info.TenantSubscriptionId);
cmd.AppendXSmallText("@strEntityId", info.EntityId);
ExecuteCommand(cmd);
return(true);
}
catch (SqlException e)
{
throw ReportAndTranslateException(e, "TenantSubscriptionEntity::TenantSubscriptionEntity_Create");
}
}
internal bool Update(Guid tenantId, TenantSubscriptionEntityInfo info)
{
try
{
var cmd = CreateProcedureCommand("dbo.TenantSubscriptionEntity_Update");
cmd.AppendGuid("@guidTenantId", tenantId);
cmd.AppendGuid("@guidTenantSubscriptionEntityId", info.TenantSubscriptionEntityId);
cmd.AppendGuid("@guidTenantSubscriptionId", info.TenantSubscriptionId);
cmd.AppendXSmallText("@strEntityId", info.EntityId);
if (info.LimtNumber.HasValue && info.LimtNumber.Value > 0)
{
cmd.AppendInt("@intLimitNumber", info.LimtNumber.Value);
cmd.AppendTinyInt("@tinyintLimitType", (byte)info.LimitType);
}
ExecuteCommand(cmd);
return(true);
}
catch (SqlException e)
{
throw ReportAndTranslateException(e, "TenantSubscriptionEntity::TenantSubscriptionEntity_Update");
}
}
public IActionResult Post([FromBody] TenantSubscriptionEntityInfo info)
{
try
{
if (info == null)
{
return(BadRequest("Invalid parameter"));
}
var stopwatch = StopwatchLogger.Start(_log);
_log.Info("Called SubscriptionEntityController Post {0}=", JsonConvert.SerializeObject(info));
info.EntityId = _iMetadataManager.GetEntityContextByEntityName(info.EntityId);
var subscriptionEntityId = _managerSubscriptionEntity.Create(TenantCode, info);
stopwatch.StopAndLog("End SubscriptionEntityController Post");
return(Ok(subscriptionEntityId));
}
catch (Exception ex)
{
_log.Error(ExceptionFormatter.SerializeToString(ex));
return(StatusCode((int)HttpStatusCode.InternalServerError, ApiConstant.CustomErrorMessage));
}
}
internal TenantSubscriptionEntityInfo TenantSubscriptionEntity(Guid tenantId, Guid tenantSubscriptionEntityId)
{
TenantSubscriptionEntityInfo info = null;
try
{
var cmd = CreateProcedureCommand("dbo.TenantSubscriptionEntity_Get");
cmd.AppendGuid("@guidTenantId", tenantId);
cmd.AppendGuid("@guidTenantSubscriptionEntityId", tenantSubscriptionEntityId);
using (SqlDataReader reader = ExecuteCommandAndReturnReader(cmd))
{
while (reader.Read())
{
info = ReadInfo(reader);
}
}
}
catch (SqlException e)
{
throw ReportAndTranslateException(e, "TenantSubscriptionEntity::TenantSubscriptionEntity_Get");
}
return(info);
}
bool IManagerTenantSubscriptionEntity.Update(Guid tenantId, TenantSubscriptionEntityInfo info)
{
return(_adminTenantSubscriptionEntity.Update(tenantId, info));
}
Guid IManagerTenantSubscriptionEntity.Create(Guid tenantId, TenantSubscriptionEntityInfo info)
{
info.TenantSubscriptionEntityId = Guid.NewGuid();
_adminTenantSubscriptionEntity.Create(tenantId, info);
return(info.TenantSubscriptionEntityId);
}
bool IAdminTenantSubscriptionEntity.Update(Guid tenantId, TenantSubscriptionEntityInfo info)
{
return(_data.Update(tenantId, info));
}
