internal int BatchItemByStatus(Guid tenantId, Guid batchTypeId, BatchItemTypeEnum status)
{
var itemCount = 0;
try
{
SqlProcedureCommand cmd = CreateProcedureCommand("dbo.BatchItem_GetByStatus");
cmd.AppendGuid("@guidTenantId", tenantId);
cmd.AppendGuid("@guidBatchTypeId", batchTypeId);
cmd.AppendTinyInt("@tiStatus", (byte)status);
using (SqlDataReader reader = ExecuteCommandAndReturnReader(cmd))
{
while (reader.Read())
{
itemCount = reader.IsDBNull(0) ? 0 : reader.GetInt32(0);
}
}
}
catch (SqlException e)
{
throw ReportAndTranslateException(e, "DataBatchItem::BatchItem_GetByStatus");
}
return(itemCount);
}
public IActionResult Get(Guid batchTypeId, [FromQuery] BatchItemTypeEnum itemType)
{
try
{
var stopwatch = StopwatchLogger.Start(_log);
_log.Info("Called BatchItemController Get {0}=", JsonConvert.SerializeObject(batchTypeId));
var items = _managerBatchItem.GetBatchItemListByStatus(TenantCode, batchTypeId, itemType);
foreach (var item in items)
{
item.EntityId = _iMetadataManager.GetEntityNameByEntityContext(item.EntityId);
item.RetryCount = item.RetryCount > 0 ? (item.RetryCount - 1) : item.RetryCount;
}
stopwatch.StopAndLog("End BatchItemController Get");
return(Ok(items));
}
catch (Exception ex)
{
_log.Error(ExceptionFormatter.SerializeToString(ex));
return(StatusCode((int)HttpStatusCode.InternalServerError, ApiConstant.CustomErrorMessage));
}
}
List <BatchItem> IReviewBatchItem.GetBatchItemListByStatus(Guid tenantId, Guid batchTypeId, BatchItemTypeEnum status)
{
return(_data.GetBatchItemListByStatus(tenantId, batchTypeId, status));
}
int IReviewBatchItem.BatchItemByStatus(Guid tenantId, Guid batchTypeId, BatchItemTypeEnum status)
{
return(_data.BatchItemByStatus(tenantId, batchTypeId, status));
}
internal List <BatchItem> GetBatchItemListByStatus(Guid tenantId, Guid batchTypeId, BatchItemTypeEnum status)
{
List <BatchItem> batches = new List <BatchItem>();
try
{
SqlProcedureCommand cmd = CreateProcedureCommand("dbo.BatchItem_GetList_ByStatus");
cmd.AppendGuid("@guidTenantId", tenantId);
cmd.AppendGuid("@guidBatchTypeId", batchTypeId);
cmd.AppendTinyInt("@tiStatus", (byte)status);
using (SqlDataReader reader = ExecuteCommandAndReturnReader(cmd))
{
while (reader.Read())
{
batches.Add(ReadInfo(reader));
}
}
}
catch (SqlException e)
{
throw ReportAndTranslateException(e, "DataBatchItem::BatchItem_GetList_ByStatus");
}
return(batches);
}
List <BatchItem> IManagerBatchItem.GetBatchItemListByStatus(Guid tenantId, Guid batchTypeId, BatchItemTypeEnum status)
{
return(_review.GetBatchItemListByStatus(tenantId, batchTypeId, status));
}
int IManagerBatchItem.BatchItemByStatus(Guid tenantId, Guid batchTypeId, BatchItemTypeEnum status)
{
return(_review.BatchItemByStatus(tenantId, batchTypeId, status));
}
