public DC_UnprocessedExecuterData getScalerCount(DC_UnprocessedExecuterData QueryID)
{
using (BL_SchedulerServices obj = new BL_SchedulerServices())
{
return(obj.getScalerCount(QueryID));
}
}
public DC_UnprocessedExecuterData getScalerCount(DC_UnprocessedExecuterData QueryID)
{
DC_UnprocessedExecuterData RunningData = new DC_UnprocessedExecuterData();
try
{
StringBuilder sb = new StringBuilder();
switch (QueryID.TotalCount)
{
case 1:
sb.Append(" DECLARE @CountOfRunning int;DECLARE @default uniqueidentifier = cast(cast(0 as binary) as uniqueidentifier);select @CountOfRunning = count(0) from Supplier_ApiCallLog where status = 'RUNNING';");
sb.Append(" select @CountOfRunning TotalCount; ");
break;
default:
break;
}
using (ConsumerEntities context = new ConsumerEntities())
{
context.Database.CommandTimeout = 0;
RunningData = context.Database.SqlQuery <DC_UnprocessedExecuterData>(sb.ToString()).ToList().FirstOrDefault();
}
}
catch (Exception ex)
{
throw new FaultException <DataContracts.DC_ErrorStatus>(new DataContracts.DC_ErrorStatus
{
ErrorMessage = "Error while fetching Logger Tasks",
ErrorStatusCode = System.Net.HttpStatusCode.InternalServerError
});
}
return(RunningData);
}