public async Task UpdateAsync(Job job)
{
var entry = _db.Entry(job);
entry.State = EntityState.Modified;
await _db.SaveChangesAsync();
}
public async Task <Item> AddAsync(string collectionName, string data, string userId, DateTimeOffset datetime)
{
using (var tran = await _db.Database.BeginTransactionAsync())
{
var item = new Item
{
Id = Helper.CreateKey(),
CollectionName = collectionName,
CreatedAt = datetime,
UpdatedAt = datetime,
CreatedBy = userId,
UpdatedBy = userId,
IsValid = true,
};
await _db.AddAsync(item);
await _db.SaveChangesAsync();
var record = new ItemRecord
{
Id = Helper.CreateKey(),
ItemId = item.Id,
Data = data,
CreatedAt = datetime,
CreatedBy = userId,
};
item.Data = data;
item.CurrentId = record.Id;
await _db.AddAsync(record);
await _db.SaveChangesAsync();
tran.Commit();
_db.Entry(item).State = EntityState.Detached;
return(item);
}
}
public async Task <File> AddAsync(string folderId, string name, string binaryPath, string contentType, long size, string userId, DateTimeOffset datetime)
{
var file = new File
{
Id = Helper.CreateKey(),
FolderId = folderId,
Name = name,
BinaryPath = binaryPath,
ContentType = contentType,
Size = size,
LastModifiedAt = datetime,
LastModifiedBy = userId
};
await _db.Files.AddAsync(file);
await _db.SaveChangesAsync();
_db.Entry(file).State = EntityState.Detached;
return(file);
}
