public async Task <bool> PackageIsRunning(string packageName)
{
var result = await _ctx.ExecuteStoredProcedureScalar <object>("USP_Select_SSISExecution",
"@package".WithValue(packageName)
);
if (result == null || Convert.ToInt32(result) <= 0)
{
return(false);
}
return(true);
}
public async Task <bool> InsertRoute(Entities.DTO.BaseRoute baseRoute)
{
var result = await _ctx.ExecuteStoredProcedureScalar <object>("USP_Insert_Route",
"fromCode".WithValue(baseRoute.From),
"toCode".WithValue(baseRoute.To),
"price".WithValue(baseRoute.Price)
);
if (result == null || Convert.ToInt32(result) <= 0)
{
return(false);
}
return(true);
}