public void UpdateRecently(PrjSettings settings) { var conn = this.connectionFactory.Create(); var trn = this.connectionFactory.GetCurrentTransaction(); conn.Execute(@" update M_PRJSETTINGS set START_DATE = @Start, END_DATE = @End " , new { Start = settings.StartDate, End = settings.EndDate }, trn); }
public void Insert(PrjSettings settings) { var conn = this.connectionFactory.Create(); var trn = this.connectionFactory.GetCurrentTransaction(); conn.Execute(@" insert into M_PRJSETTINGS ( START_DATE, END_DATE ) values ( @Start, @End ) " , new [] { new { Start = settings.StartDate, End = settings.EndDate } }, trn); }