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