/// <summary>
/// Create data in database
/// </summary>
/// <param name="sequencer">Data</param>
/// <returns>insert data</returns>
public Sequencer Create(Sequencer sequencer)
{
if (sequencer == null)
{
return(null);
}
var sequencerRow = new SequencerRow();
SequencerTransformer.ToRow(sequencer, sequencerRow);
_dbContext.Sequencer.Add(sequencerRow);
_dbContext.SaveChanges();
return(SequencerTransformer.ToBean(sequencerRow));
}
/// <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);
}
/// <summary>
/// Update data in database
/// </summary>
/// <param name="sequencer">data</param>
/// <returns>updated data</returns>
public Sequencer Update(Sequencer sequencer)
{
if (sequencer == null || sequencer.Id == 0)
{
return(null);
}
var sequencerRow = _dbContext.Sequencer.Where(m => m.Id == sequencer.Id && m.Name == sequencer.Name).FirstOrDefault();
if (sequencerRow == null)
{ // No data in database
return(Create(sequencer));
}
else
{ //Modify Data in database
SequencerTransformer.ToRow(sequencer, sequencerRow);
_dbContext.SaveChanges();
return(SequencerTransformer.ToBean(sequencerRow));
}
}
