public async Task<LocalIssue> CreateOrUpdateIssueAsync(LocalIssue issue)
{
using (context = new SqliteContext(BaseConnstr))
{
var existed = context.Issue
.AsNoTracking()
.Include(i => i.Row)
.Include(i => i.Column)
.FirstOrDefault(iss => iss.Id == issue.Id);
mapper.Map(issue, existed);
if (existed == null)
{
var newiss = mapper.Map<SqliteIssue>(issue);
context.Attach(newiss.Row);
context.Attach(newiss.Column);
await context.AddAsync(newiss);
await context.SaveChangesAsync();
context.Update(newiss.Column);
context.Update(newiss.Row);
await context.SaveChangesAsync();
return mapper.Map<LocalIssue>(newiss);
}
context.Update(existed);
await context.SaveChangesAsync();
return issue;
}
}
/// <summary>
/// Save <see cref="OzonProductPriceHistory"/> data into DB
/// </summary>
/// <param name="productHistoryRecord"></param>
/// <returns></returns>
public async Task <int> SaveProductHistoryAsync(OzonProductPriceHistory productHistoryRecord)
{
if (productHistoryRecord == null)
{
logger.Debug($"{nameof(productHistoryRecord)} is null!");
return(0);
}
using (var client = new SqliteContext(_connectionString))
{
if (productHistoryRecord.Id == 0)
{
client.OzonProductPriceHistories.Add(productHistoryRecord);
await client.SaveChangesAsync();
}
else
{
client.Update(productHistoryRecord);
await client.SaveChangesAsync();
}
return(productHistoryRecord.Id);
}
}
public async Task<RowInfo> CreateOrUpdateRowAsync(RowInfo row)
{
using (context = new SqliteContext(BaseConnstr))
{
if (row.Id == 0 || context.Row.Find(row.Id) == null)
await context.AddAsync(row);
else context.Update(row);
await context.SaveChangesAsync();
return row;
}
}
public async Task<ColumnInfo> CreateOrUpdateColumnAsync(ColumnInfo column)
{
using (context = new SqliteContext(BaseConnstr))
{
if (column.Id == 0 || context.Column.AsNoTracking()
.FirstOrDefault(c => c.Id == column.Id) == null)
await context.AddAsync(column);
else context.Update(column);
await context.SaveChangesAsync();
return column;
}
}
public async Task <BoardInfo> CreateOrUpdateBoardInfoAsync(BoardInfo info)
{
using (context = new SqliteContext(BaseConnstr))
{
if (info.Id == 0 || context.Board.AsNoTracking()
.FirstOrDefault(c => c.Id == info.Id) == null)
{
await context.AddAsync(info);
}
else
{
context.Update(info);
}
await context.SaveChangesAsync();
return(info);
}
}
public async Task <RowInfo> CreateOrUpdateRowAsync(RowInfo row)
{
using (context = new SqliteContext(BaseConnstr))
{
if (row.Id == 0 || context.Row.AsNoTracking()
.FirstOrDefault(c => c.Id == row.Id) == null)
{
context.Attach(row.Board);
await context.AddAsync(row);
}
else
{
context.Update(row);
}
await context.SaveChangesAsync();
return(row);
}
}
public void Update(NavLink page)
{
_context.Update(page);
_context.SaveChanges();
}
public void Update(RelatedPages page)
{
_context.Update(page);
_context.SaveChanges();
}