public async Task <int> GetLastNonce(IDbConnection context, Guid Id) { try { SignatureNotice ans = await GetByBallotId(context, Id); return((ans == null) ? 0 : ans.Nonce); } catch (Exception ex) { throw; } }
public async Task <SignatureNotice> NotifyPendingSubmittal(IDbConnection context, SignatureNotice notice) { SignatureNotice result = null; try { result = await this.signatureService.NotifyPendingSubmittal(context, notice); } catch (Exception ex) { throw; } return(result); }
public async Task <SignatureNotice> NotifyPending([FromBody] SignatureNotice notice) { SignatureNotice result = null; try { result = await this.signatureRepository.NotifyPendingSubmittal(Context, notice); } catch (Exception ex) { string err = ex.Message; } finally { } return(result); }
private async Task <SignatureNotice> GetByBallotId(IDbConnection context, Guid Id) { SignatureNotice result = null; try { var p = new DynamicParameters(); p.Add("@ballotid", Id, System.Data.DbType.Guid, System.Data.ParameterDirection.Input); result = await context.QuerySingleAsync <SignatureNotice>(sql : "SignatureNotice_GetByBallot", param : p, commandType : System.Data.CommandType.StoredProcedure); } catch (Exception ex) { throw; } return(result); }
public async Task <SignatureNotice> Insert(IDbConnection context, SignatureNotice notice) { try { var p = new DynamicParameters(); p.Add("@id", Guid.NewGuid(), DbType.Guid, ParameterDirection.Input); p.Add("@nonce", notice.Nonce, DbType.Int32, ParameterDirection.Input); p.Add("@ballotid", notice.BallotId, DbType.Guid, ParameterDirection.Input); SignatureNotice ans = await context.QuerySingleAsync <SignatureNotice>(sql : "SignatureNotice_Insert", param : p, commandType : System.Data.CommandType.StoredProcedure); return(ans); } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
public async Task <SignatureNotice> NotifyPendingSubmittal(IDbConnection context, SignatureNotice notice) { SignatureNotice result = null; try { var p = new DynamicParameters(); p.Add("@id", Guid.NewGuid(), DbType.Guid, ParameterDirection.Input); p.Add("@ballotid", notice.BallotId, DbType.Guid, ParameterDirection.Input); p.Add("@nonce", notice.Nonce, DbType.Int32, ParameterDirection.Input); p.Add("@ballotrequestid", notice.BallotRequestId, DbType.Guid, ParameterDirection.Input); result = await context.QuerySingleAsync <SignatureNotice>(sql : "SignatureNotice_Insert", param : p, commandType : System.Data.CommandType.StoredProcedure); } catch (Exception ex) { throw; } return(result); }