/// <summary>
/// Create row in EntityStateHistory table for current transaction.
/// </summary>
/// <param name="dbContext">Database context.</param>
/// <param name="mode">EntityProcessMode mode. Udtraek/Update/DAGI.</param>
/// <param name="entity">Entity name.</param>
/// <param name="txidTil">Transaction ID for updating the table up to.</param>
/// <returns>DateTime to synchronize between EntityState tables.</returns>
public static DateTime SetEntityStateHistoryStart(DawaReplicationDBContext dbContext, EntityProcessMode mode, string entity, long?txidTil)
{
if (dbContext == null)
{
throw new ArgumentNullException(nameof(dbContext));
}
if (entity == null)
{
throw new ArgumentNullException(nameof(entity));
}
entity = entity.ToLower();
EntitystateHistory row = new EntitystateHistory
{
Entity = entity,
};
row.TxidFra = (mode == EntityProcessMode.Udtraek || mode == EntityProcessMode.Dagi) ? -1 : dbContext.EntitystateHistory.Where(c => c.Entity == entity && c.Success == true).OrderByDescending(c => c.Starttime).First().TxidTil;
row.TxidTil = mode == EntityProcessMode.Dagi ? null : txidTil;
row.Success = null;
row.Starttime = DateTime.Now;
row.Finishtime = null;
row.InsertUpdateCount = null;
row.DeleteCount = null;
row.Message = null;
dbContext.Add(row);
dbContext.SaveChanges();
return(row.Starttime);
}
/// <summary>
/// Create a new row in Entitystate for given entity.
/// </summary>
/// <param name="dbContext">Database context.</param>
/// <param name="mode">EntityProcessMode. Udtraek/Update/Dagi.</param>
/// <param name="entity">Entity name.</param>
/// <param name="txid">Transaction ID.</param>
public static void SetEntityStateStart(DawaReplicationDBContext dbContext, EntityProcessMode mode, string entity, long txid)
{
if (dbContext == null)
{
throw new ArgumentNullException(nameof(dbContext));
}
if (entity == null)
{
throw new ArgumentNullException(nameof(entity));
}
entity = entity.ToLower();
// Create entity if missing:
if (!dbContext.Entitystate.Any(c => c.Entity == entity))
{
var entitystate = new Entitystate
{
Entity = entity,
};
dbContext.Add(entitystate);
dbContext.SaveChanges();
}
var row = dbContext.Entitystate.Single(c => c.Entity == entity);
row.Txid = mode == EntityProcessMode.Update ? row.Txid : txid;
row.Success = null;
row.Successtime = null;
row.SuccesstimeChange = row.SuccesstimeChange;
row.Starttime = DateTime.Now;
row.Finishtime = null;
row.Count = null;
row.Message = null;
dbContext.Update(row);
dbContext.SaveChanges();
}
