/// <summary>
/// Create data in database
/// </summary>
/// <param name="bodyExercise">Data</param>
/// <returns>insert data</returns>
public BodyExercise Create(BodyExercise bodyExercise)
{
if (bodyExercise == null)
{
return(null);
}
if (bodyExercise.Id == 0)
{
var key = new BodyExerciseKey();
var sequencerManager = new SequencerManager();
do
{
key.Id = sequencerManager.GetNextValue(_dbContext, 2, "bodyExercise");
}while (Get(key) != null); // Test Record exist
bodyExercise.Id = key.Id;
}
if (bodyExercise.Id == 0)
{
return(null);
}
var bodyExerciseRow = new BodyExerciseRow();
BodyExerciseTransformer.ToRow(bodyExercise, bodyExerciseRow);
_dbContext.BodyExercise.Add(bodyExerciseRow);
_dbContext.SaveChanges();
return(BodyExerciseTransformer.ToBean(bodyExerciseRow));
}
/// <summary>
/// Create data in database
/// </summary>
/// <param name="bodyExercise">Data</param>
/// <returns>insert data</returns>
public BodyExercise Create(BodyExercise bodyExercise)
{
if (bodyExercise == null)
{
return(null);
}
if (bodyExercise.Id == 0)
{
return(null);
}
var bodyExerciseRow = new BodyExerciseRow();
BodyExerciseTransformer.ToRow(bodyExercise, bodyExerciseRow);
_dbContext.Insert(bodyExerciseRow);
return(BodyExerciseTransformer.ToBean(bodyExerciseRow));
}
/// <summary>
/// Update data in database
/// </summary>
/// <param name="bodyExercise">data</param>
/// <returns>updated data</returns>
public BodyExercise Update(BodyExercise bodyExercise)
{
if (bodyExercise == null || bodyExercise.Id == 0)
{
return(null);
}
var bodyExerciseRow = _dbContext.BodyExercise.Where(m => m.Id == bodyExercise.Id).FirstOrDefault();
if (bodyExerciseRow == null)
{ // No data in database
return(Create(bodyExercise));
}
else
{ //Modify Data in database
BodyExerciseTransformer.ToRow(bodyExercise, bodyExerciseRow);
_dbContext.SaveChanges();
return(BodyExerciseTransformer.ToBean(bodyExerciseRow));
}
}
/// <summary>
/// Update data in database
/// </summary>
/// <param name="bodyExercise">data</param>
/// <returns>updated data</returns>
public BodyExercise Update(BodyExercise bodyExercise)
{
if (bodyExercise == null || bodyExercise.Id == 0)
{
return(null);
}
var bodyExerciseRow = _dbContext.Table <BodyExerciseRow>().Where(m => m.Id == bodyExercise.Id).FirstOrDefault();
if (bodyExerciseRow == null)
{ // No data in database
return(Create(bodyExercise));
}
else
{ //Modify Data in database
BodyExerciseTransformer.ToRow(bodyExercise, bodyExerciseRow);
_dbContext.Delete(bodyExerciseRow); //Update don't work... need delete and insert
_dbContext.Insert(bodyExerciseRow);
return(BodyExerciseTransformer.ToBean(bodyExerciseRow));
}
}