public List <MuscularGroup> FindMuscularGroups(MuscularGroupCriteria muscularGroupCriteria = null)
{
var muscularGroupList = _module.Find(muscularGroupCriteria);
if (muscularGroupList != null)
{
foreach (var muscularGroup in muscularGroupList)
{
if (muscularGroup != null)
{
muscularGroup.Name = Translation.GetInDB(MuscularGroupTransformer.GetTranslationKey(muscularGroup.Id));
}
}
}
return(muscularGroupList);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <MuscularGroup> Find(MuscularGroupCriteria muscularGroupCriteria = null)
{
List <MuscularGroup> resultList = null;
TableQuery <MuscularGroupRow> muscularGroupRowList = _dbContext.Table <MuscularGroupRow>();
CriteriaTransformer.CompleteQuery(ref muscularGroupRowList, muscularGroupCriteria);
if (muscularGroupRowList != null && muscularGroupRowList.Count() > 0)
{
resultList = new List <MuscularGroup>();
foreach (var muscularGroupRow in muscularGroupRowList)
{
resultList.Add(MuscularGroupTransformer.ToBean(muscularGroupRow));
}
}
return(resultList);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <MuscularGroup> Find(MuscularGroupCriteria muscularGroupCriteria = null)
{
List <MuscularGroup> resultList = null;
IQueryable <MuscularGroupRow> rowList = _dbContext.MuscularGroup;
CriteriaTransformer.CompleteQuery(ref rowList, muscularGroupCriteria);
if (rowList != null)
{
foreach (var muscularGroupRow in rowList)
{
if (resultList == null)
{
resultList = new List <MuscularGroup>();
}
resultList.Add(MuscularGroupTransformer.ToBean(muscularGroupRow));
}
}
return(resultList);
}
/// <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));
}
}
internal void DeleteMuscularGroup(MuscularGroupKey key)
{
//Update Translation Name
Translation.DeleteInDB(MuscularGroupTransformer.GetTranslationKey(key.Id), DbContext);
_muscularGroupModule.Delete(key);
}
