Exemplo n.º 1
0
        public async Task <long> InsertRFAResponse(Model.RFA rfa)
        {
            await Task.CompletedTask;
            DataTable dtLineItemAttachments      = null;
            DataTable dtLineItemReply            = null;
            DataTable dtLineItemReplyAttachments = new DataTable();

            var dr = DataConverter.ToRFAData(rfa);
            //var da = DataConverter.ToAttachmentData(rfa);
            var dl = DataConverter.ToRFALineItemData(rfa, out dtLineItemAttachments,
                                                     out dtLineItemReply, out dtLineItemReplyAttachments);

            var param = new DynamicParameters();

            param.Add("@RFA", dr.AsTableValuedParameter("dbo.RFAType"));
            param.Add("@RFALineItemReply",
                      dtLineItemReply.AsTableValuedParameter("dbo.RFALineItemReplyType"));
            param.Add("@LineItemReplyAttachments",
                      dtLineItemReplyAttachments.AsTableValuedParameter("dbo.LineItemReplyAttachmentsType"));
            param.Add("@RFAID", rfa.ID, dbType: DbType.Int64, direction: ParameterDirection.Input);

            SqlMapper.Execute(_unitOfWork.Connection,
                              "InsertRFAResponse",
                              param,
                              commandType: CommandType.StoredProcedure,
                              transaction: _unitOfWork.Transaction);

            return(param.Get <long>("@RFAID"));
        }
Exemplo n.º 2
0
 public async Task <Model.RFA> Submit(Model.RFA rfa)
 {
     return(await _apiClient.RFASdk.Submit(rfa));
 }