public void SyncLeave(Guid leaveId) { var leave = EventStore.Get(leaveId); using (var conn = ReadModelDbContext.GetConnection()) { conn.Execute(@" begin tran delete LeaveReadModel where Id = @Id insert into LeaveReadModel(Id, Applicant, Evaluator, StartDate, EndDate, ApplicantComment, EvaluatorComment, Reason, Status, AppliedOn, EvaluatedOn, WorkingDays) values(@Id, @Applicant, @Evaluator, @StartDate, @EndDate, @ApplicantComment, @EvaluatorComment, @Reason, @Status, @AppliedOn, @EvaluatedOn, @WorkingDays) commit tran " , leave); } }
public void Init() { using (var conn = ReadModelDbContext.GetConnection()) conn.Execute(@" if not exists (select * from sys.tables where name='leaveReadModel') begin create table leaveReadModel ( Id uniqueidentifier primary key, Applicant varchar(200), Evaluator varchar(200), StartDate datetime2, EndDate datetime2, Reason int, Status int, AppliedOn datetime2, EvaluatedOn datetime2, ApplicantComment varchar(1024), EvaluatorComment varchar(1024), WorkingDays int ) end " ); }