/// <summary>
/// Create data in database
/// </summary>
/// <param name="trainingJournal">Data</param>
/// <returns>insert data</returns>
public TrainingWeek Create(TrainingWeek trainingJournal)
{
if (trainingJournal == null || string.IsNullOrWhiteSpace(trainingJournal.UserId) ||
trainingJournal.Year == 0 || trainingJournal.WeekOfYear == 0)
{
return(null);
}
var row = new TrainingWeekRow();
TrainingWeekTransformer.ToRow(trainingJournal, row);
_dbContext.Insert(row);
return(TrainingWeekTransformer.ToBean(row));
}
/// <summary>
/// Get data in database
/// </summary>
/// <param name="key">Primary Key</param>
/// <returns>read data</returns>
public TrainingWeek Get(TrainingWeekKey key)
{
if (key == null || string.IsNullOrWhiteSpace(key.UserId) ||
key.Year == 0 || key.WeekOfYear == 0)
{
return(null);
}
var row = _dbContext.TrainingWeek.Where(t => t.UserId == key.UserId && t.Year == key.Year &&
t.WeekOfYear == key.WeekOfYear).FirstOrDefault();
if (row != null)
{
return(TrainingWeekTransformer.ToBean(row));
}
return(null);
}
/// <summary>
/// Find datas
/// </summary>
/// <returns></returns>
public List <TrainingWeek> Find(TrainingWeekCriteria trainingWeekCriteria = null)
{
List <TrainingWeek> resultList = null;
TableQuery <TrainingWeekRow> rowList = _dbContext.Table <TrainingWeekRow>();
CriteriaTransformer.CompleteQuery(ref rowList, trainingWeekCriteria);
rowList = rowList.OrderBy(t => t.UserId).OrderByDescending(t => t.Year).ThenByDescending(t => t.WeekOfYear);
if (rowList != null && rowList.Count() > 0)
{
resultList = new List <TrainingWeek>();
foreach (var trainingJournalRow in rowList)
{
resultList.Add(TrainingWeekTransformer.ToBean(trainingJournalRow));
}
}
return(resultList);
}
/// <summary>
/// Update data in database
/// </summary>
/// <param name="trainingJournal">data</param>
/// <returns>updated data</returns>
public TrainingWeek Update(TrainingWeek trainingJournal)
{
if (trainingJournal == null || string.IsNullOrWhiteSpace(trainingJournal.UserId) ||
trainingJournal.Year == 0 || trainingJournal.WeekOfYear == 0)
{
return(null);
}
var trainingJournalRow = _dbContext.TrainingWeek.Where(t => t.UserId == trainingJournal.UserId && t.Year == trainingJournal.Year &&
t.WeekOfYear == trainingJournal.WeekOfYear).FirstOrDefault();
if (trainingJournalRow == null)
{ // No data in database
return(Create(trainingJournal));
}
else
{ //Modify Data in database
TrainingWeekTransformer.ToRow(trainingJournal, trainingJournalRow);
_dbContext.SaveChanges();
return(TrainingWeekTransformer.ToBean(trainingJournalRow));
}
}
/// <summary>
/// Update data in database
/// </summary>
/// <param name="trainingWeek">data</param>
/// <returns>updated data</returns>
public TrainingWeek Update(TrainingWeek trainingWeek)
{
if (trainingWeek == null || string.IsNullOrWhiteSpace(trainingWeek.UserId) ||
trainingWeek.Year == 0 || trainingWeek.WeekOfYear == 0)
{
return(null);
}
var trainingWeekRow = _dbContext.Table <TrainingWeekRow>().Where(t => t.UserId == trainingWeek.UserId && t.Year == trainingWeek.Year &&
t.WeekOfYear == trainingWeek.WeekOfYear).FirstOrDefault();
if (trainingWeekRow == null)
{ // No data in database
return(Create(trainingWeek));
}
else
{ //Modify Data in database
TrainingWeekTransformer.ToRow(trainingWeek, trainingWeekRow);
_dbContext.Delete(trainingWeekRow); //Update don't work... need delete and insert
_dbContext.Insert(trainingWeekRow);
return(TrainingWeekTransformer.ToBean(trainingWeekRow));
}
}