public async Task <GetAvailPlatesTestsResult> GetAvailPlatesTestsAsync(GetAvailPlatesTestsRequestArgs request)
{
var p1 = DbContext.CreateOutputParameter("@DisplayPlannedWeek", DbType.String, 100);
var p2 = DbContext.CreateOutputParameter("@ExpectedDate", DbType.DateTime);
var p3 = DbContext.CreateOutputParameter("@DisplayExpectedWeek", DbType.String, 100);
var p4 = DbContext.CreateOutputParameter("@AvailPlates", DbType.Int32);
var p5 = DbContext.CreateOutputParameter("@AvailTests", DbType.Int32);
await DbContext.ExecuteReaderAsync(DataConstants.PR_PLAN_PLAN_GET_AVAIL_PLATES_TESTS,
CommandType.StoredProcedure,
args =>
{
args.Add("@MaterialTypeID", request.MaterialTypeID);
args.Add("@CropCode", request.CropCode);
args.Add("@Isolated", request.Isolated);
args.Add("@PlannedDate", request.PlannedDate.ToDateTime());
args.Add("@ExpectedDateIn", request.ExpectedDate.ToNDateTime());
args.Add("@DisplayPlannedWeek", p1);
args.Add("@ExpectedDate", p2);
args.Add("@DisplayExpectedWeek", p3);
args.Add("@AvailPlates", p4);
args.Add("@AvailTests", p5);
});
var data = new GetAvailPlatesTestsResult()
{
DisplayPlannedWeek = p1.Value.ToString(),
ExpectedDate = p2.Value.ToDateTime(),
DisplayExpectedWeek = p3.Value.ToString()
};
if (int.TryParse(p4.Value.ToString(), out var availPlates))
{
data.AvailPlates = availPlates;
}
if (int.TryParse(p5.Value.ToString(), out var availTests))
{
data.AvailTests = availTests;
}
return(data);
}
public async Task <GetAvailPlatesTestsResult> GetAvailPlatesTestsAsync(GetAvailPlatesTestsRequestArgs args)
{
return(await _repository.GetAvailPlatesTestsAsync(args));
}
public async Task <IHttpActionResult> GetAvailPlatesTests([FromUri] GetAvailPlatesTestsRequestArgs args)
{
var data = await slotService.GetAvailPlatesTestsAsync(args);
return(Ok(data));
}
