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 }); } }