/// <summary>
/// Update data in database
/// </summary>
/// <param name="trainingJournalDay">data</param>
/// <returns>updated data</returns>
public TrainingDay Update(TrainingDay trainingJournalDay)
{
if (trainingJournalDay == null || string.IsNullOrWhiteSpace(trainingJournalDay.UserId) ||
trainingJournalDay.Year == 0 || trainingJournalDay.WeekOfYear == 0 ||
trainingJournalDay.DayOfWeek < 0 || trainingJournalDay.DayOfWeek > 6 || trainingJournalDay.TrainingDayId == 0)
{
return(null);
}
var trainingJournalRow = _dbContext.Table <TrainingDayRow>().Where(t => t.UserId == trainingJournalDay.UserId &&
t.Year == trainingJournalDay.Year &&
t.WeekOfYear == trainingJournalDay.WeekOfYear &&
t.DayOfWeek == trainingJournalDay.DayOfWeek &&
t.TrainingDayId == trainingJournalDay.TrainingDayId).FirstOrDefault();
if (trainingJournalRow == null)
{ // No data in database
return(Create(trainingJournalDay));
}
else
{ //Modify Data in database
TrainingDayTransformer.ToRow(trainingJournalDay, trainingJournalRow);
_dbContext.Delete(trainingJournalRow); //Update don't work... need delete and insert
_dbContext.Insert(trainingJournalRow);
return(TrainingDayTransformer.ToBean(trainingJournalRow));
}
}
/// <summary>
/// Update data in database
/// </summary>
/// <param name="trainingDay">data</param>
/// <returns>updated data</returns>
public TrainingDay Update(TrainingDay trainingDay, TUnitType userUnit)
{
if (trainingDay == null || string.IsNullOrWhiteSpace(trainingDay.UserId) ||
trainingDay.Year == 0 || trainingDay.WeekOfYear == 0 ||
trainingDay.DayOfWeek < 0 || trainingDay.DayOfWeek > 6 || trainingDay.TrainingDayId == 0)
{
return(null);
}
var trainingJournalRow = _dbContext.TrainingDay.Where(t => t.UserId == trainingDay.UserId &&
t.Year == trainingDay.Year &&
t.WeekOfYear == trainingDay.WeekOfYear &&
t.DayOfWeek == trainingDay.DayOfWeek &&
t.TrainingDayId == trainingDay.TrainingDayId).FirstOrDefault();
if (trainingJournalRow == null)
{ // No data in database
return(Create(trainingDay, userUnit));
}
else
{ //Modify Data in database
TrainingDayTransformer.ToRow(trainingDay, trainingJournalRow);
_dbContext.SaveChanges();
return(TrainingDayTransformer.ToBean(trainingJournalRow, userUnit));
}
}
/// <summary>
/// Create data in database
/// </summary>
/// <param name="trainingJournalDay">Data</param>
/// <returns>insert data</returns>
public TrainingDay Create(TrainingDay trainingJournalDay)
{
if (trainingJournalDay == null || string.IsNullOrWhiteSpace(trainingJournalDay.UserId) ||
trainingJournalDay.Year == 0 || trainingJournalDay.WeekOfYear == 0 ||
trainingJournalDay.DayOfWeek < 0 || trainingJournalDay.DayOfWeek > 6 || trainingJournalDay.TrainingDayId == 0)
{
return(null);
}
var row = new TrainingDayRow();
TrainingDayTransformer.ToRow(trainingJournalDay, row);
_dbContext.Insert(row);
return(TrainingDayTransformer.ToBean(row));
}
/// <summary>
/// Create data in database
/// </summary>
/// <param name="trainingDay">Data</param>
/// <returns>insert data</returns>
public TrainingDay Create(TrainingDay trainingDay, TUnitType userUnit)
{
if (trainingDay == null || string.IsNullOrWhiteSpace(trainingDay.UserId) ||
trainingDay.Year == 0 || trainingDay.WeekOfYear == 0 ||
trainingDay.DayOfWeek < 0 || trainingDay.DayOfWeek > 6 || trainingDay.TrainingDayId == 0)
{
return(null);
}
var row = new TrainingDayRow();
TrainingDayTransformer.ToRow(trainingDay, row);
_dbContext.TrainingDay.Add(row);
_dbContext.SaveChanges();
return(TrainingDayTransformer.ToBean(row, userUnit));
}
/// <summary>
/// Find datas
/// </summary>
/// <returns></returns>
public List <TrainingDay> Find(TrainingDayCriteria trainingDayCriteria = null)
{
List <TrainingDay> resultList = null;
TableQuery <TrainingDayRow> rowList = _dbContext.Table <TrainingDayRow>();
CriteriaTransformer.CompleteQuery(ref rowList, trainingDayCriteria);
rowList = rowList.OrderBy(t => t.DayOfWeek).OrderBy(t => t.BeginHour);
if (rowList != null && rowList.Count() > 0)
{
resultList = new List <TrainingDay>();
foreach (var trainingJournalDayRow in rowList)
{
resultList.Add(TrainingDayTransformer.ToBean(trainingJournalDayRow));
}
}
return(resultList);
}
/// <summary>
/// Get data in database
/// </summary>
/// <param name="key">Primary Key</param>
/// <returns>read data</returns>
public TrainingDay Get(TrainingDayKey key, TUnitType userUnit)
{
if (key == null || string.IsNullOrWhiteSpace(key.UserId) ||
key.Year == 0 || key.WeekOfYear == 0 || key.DayOfWeek < 0 || key.DayOfWeek > 6 || key.TrainingDayId == 0)
{
return(null);
}
var row = _dbContext.TrainingDay.Where(t => t.UserId == key.UserId &&
t.Year == key.Year &&
t.WeekOfYear == key.WeekOfYear &&
t.DayOfWeek == key.DayOfWeek &&
t.TrainingDayId == key.TrainingDayId).FirstOrDefault();
if (row != null)
{
return(TrainingDayTransformer.ToBean(row, userUnit));
}
return(null);
}
/// <summary>
/// Find datas
/// </summary>
/// <returns></returns>
public List <TrainingDay> Find(TUnitType userUnit, TrainingDayCriteria trainingDayCriteria = null)
{
List <TrainingDay> resultList = null;
IQueryable <TrainingDayRow> rowList = _dbContext.TrainingDay;
CriteriaTransformer.CompleteQuery(ref rowList, trainingDayCriteria);
rowList = rowList.OrderBy(t => t.DayOfWeek).OrderBy(t => t.BeginHour);
if (rowList != null)
{
foreach (var trainingJournalDayRow in rowList)
{
if (resultList == null)
{
resultList = new List <TrainingDay>();
}
resultList.Add(TrainingDayTransformer.ToBean(trainingJournalDayRow, userUnit));
}
}
return(resultList);
}
