public async Task <int> UpdateDeleteAtAsync(MessageHistoryFindDto findDto, DateTime dateTime)
{
var where = findDto.ToDictionary();
var query = await _queryService
.CreateMySqlFactory()
.FromTable(TableName)
.Where(where)
.UpdateAsync(new { delete_at = dateTime });
return(query);
}
public async Task <int> DeleteMessageHistoryAsync(MessageHistoryFindDto findDto)
{
var where = findDto.ToDictionary();
var query = await _queryService
.CreateMySqlFactory()
.FromTable(TableName)
.Where(where)
.DeleteAsync();
return(query);
}
public async Task <IEnumerable <MessageHistory> > GetMessageHistoryAsync(MessageHistoryFindDto findDto)
{
var where = findDto.ToDictionary();
var query = await _queryService
.CreateMySqlFactory()
.FromTable(TableName)
.Where(where)
.GetAsync <MessageHistory>();
return(query);
}
