public void Update(ReportDto reportDto)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Execute("UPDATE [dbo].[Report] SET [ReportingData] = @ReportingData,[Submitted] = @Submitted where Id = @Id",
new { reportDto.ReportingData, reportDto.Submitted, reportDto.Id });
}
}
public void UpdateTime(ReportDto reportDto)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Execute("UPDATE [dbo].[Report] SET [UpdatedUtc] = @UpdatedUtc, [AuditWindowStartUtc] = @AuditWindowStartUtc WHERE Id = @Id",
new { reportDto.UpdatedUtc, reportDto.AuditWindowStartUtc, reportDto.Id });
}
}
public void Create(ReportDto report)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Execute(@"
INSERT INTO [dbo].[Report] ([Id], [EmployerId], [ReportingPeriod], [ReportingData], [Submitted], [UpdatedUtc], [AuditWindowStartUtc], [UpdatedBy])
VALUES (@Id, @EmployerId, @ReportingPeriod, @ReportingData, @Submitted, @UpdatedUtc, @AuditWindowStartUtc, @UpdatedBy)",
new { report.Id, report.EmployerId, report.ReportingData, report.ReportingPeriod, report.Submitted, report.UpdatedUtc, report.AuditWindowStartUtc, report.UpdatedBy });
}
}