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