public UserSalaryRateRequestsResponse(SalaryRateRequest srr)
{
SuggestedRate = srr.SuggestedRate;
SalaryRateRequestStatus = srr.SalaryRateRequestStatus;
CreatedAt = srr.CreatedAt;
ReviewerId = srr.ReviewerId;
SenderId = srr.SenderId;
ReviewerComment = srr.ReviewerComment;
Reason = srr.Reason;
}
public static async Task InsertSalaryRequest(this IDbConnectionFactory db, SalaryRateRequest req)
{
var sql = $@"INSERT INTO {SalaryRequestSchema.Table}
({SalaryRequestSchema.RequestChainId}, {SalaryRequestSchema.SuggestedRate},
{SalaryRequestSchema.SalaryRateRequestStatus},
{SalaryRequestSchema.CreatedAt}, {SalaryRequestSchema.ReviewerId},
{SalaryRequestSchema.SenderId},{SalaryRequestSchema.ReviewerComment},
{SalaryRequestSchema.InternalComment}, {SalaryRequestSchema.Reason})
values (@{nameof(req.RequestChainId)}, @{nameof(req.SuggestedRate)},
@{nameof(req.SalaryRateRequestStatus)}, @{nameof(req.CreatedAt)},
@{nameof(req.ReviewerId)}, @{nameof(req.SenderId)}, @{nameof(req.ReviewerComment)},
@{nameof(req.InternalComment)}, @{nameof(req.Reason)});";
using (var conn = db.GetOpenedConnection())
{
await conn.ExecuteAsync(sql, req);
}
}
