public int GetNextValue(ApplicationDbContext dbContext, int sequencerId, string sequencerName)
{
int result = 0;
lock (_locker)
{
var sequencerModule = new SequencerModule(new ApplicationDbContext());
var key = new SequencerKey()
{
Id = sequencerId, Name = sequencerName
};
var sequencer = sequencerModule.Get(key);
if (sequencer == null)
{
sequencer = new Sequencer()
{
Id = sequencerId, Name = sequencerName, Value = 1
};
sequencer = sequencerModule.Create(sequencer);
}
else
{
sequencer.Value++;
sequencer = sequencerModule.Update(sequencer);
}
result = sequencer.Value;
}
return(result);
}
/// <summary>
/// Delete data in database
/// </summary>
/// <param name="key">Primary Key</param>
public void Delete(SequencerKey key)
{
if (key == null || key.Id == 0)
{
return;
}
var sequencerRow = _dbContext.Sequencer.Where(m => m.Id == key.Id && m.Name == key.Name).FirstOrDefault();
if (sequencerRow != null)
{
_dbContext.Sequencer.Remove(sequencerRow);
_dbContext.SaveChanges();
}
}
/// <summary>
/// Get data in database
/// </summary>
/// <param name="key">Primary Key</param>
/// <returns>read data</returns>
public Sequencer Get(SequencerKey key)
{
if (key == null || key.Id == 0)
{
return(null);
}
var sequencerRow = _dbContext.Sequencer.Where(m => m.Id == key.Id && m.Name == key.Name).FirstOrDefault();
if (sequencerRow != null)
{
return(SequencerTransformer.ToBean(sequencerRow));
}
return(null);
}
