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); }