public async Task <IActionResult> Post([FromBody] UserHabitRecord record)
{
if (!ModelState.IsValid)
{
foreach (var value in ModelState.Values)
{
foreach (var err in value.Errors)
{
System.Diagnostics.Debug.WriteLine(err.Exception?.Message);
}
}
return(BadRequest());
}
// Find out the matched rule
var habits = (from habit in this._context.UserHabits where habit.ID == record.HabitID select habit).ToList <UserHabit>();
if (habits.Count != 1)
{
return(BadRequest("Invalid Habit"));
}
// Date range for checking
if (record.RecordDate >= habits[0].ValidTo || record.RecordDate < habits[0].ValidFrom)
{
return(BadRequest("Invalid time"));
}
DateTime dtbgn = record.RecordDate;
switch (habits[0].Frequency)
{
case HabitFrequency.Weekly:
dtbgn = HabitWeeklyTrace.getDBSelectionDate((DayOfWeek)habits[0].StartDate, record.RecordDate);
break;
case HabitFrequency.Monthly:
dtbgn = HabitMonthlyTrace.getDBSelectionDate(habits[0].StartDate.Value, record.RecordDate);
break;
case HabitFrequency.Daily:
default:
dtbgn = record.RecordDate - TimeSpan.FromDays(1);
break;
}
// Basic check on the record itself
switch (habits[0].CompleteCategory)
{
case HabitCompleteCategory.NumberOfCount:
{
if (record.CompleteFact.GetValueOrDefault() <= 0)
{
return(BadRequest("Record must provide complete fact"));
}
var checkrecord = (from dbrecord in _context.UserHabitRecords
where dbrecord.RecordDate > record.RecordDate && dbrecord.HabitID == record.HabitID
select dbrecord).Count();
if (checkrecord > 0)
{
return(BadRequest("Record in the past!"));
}
checkrecord = (from dbrecord in _context.UserHabitRecords
where dbrecord.RecordDate == record.RecordDate && dbrecord.HabitID == record.HabitID &&
dbrecord.SubID == record.SubID
select dbrecord).Count();
if (checkrecord > 0)
{
return(BadRequest("Conflicted Sub ID!"));
}
}
break;
case HabitCompleteCategory.NumberOfTimes:
default:
{
var checkrecord = (from dbrecord in _context.UserHabitRecords
where dbrecord.RecordDate >= record.RecordDate && dbrecord.HabitID == record.HabitID
select dbrecord).Count();
if (checkrecord > 0)
{
return(BadRequest("Record in the past!"));
}
}
break;
}
// Find out all rules
var rules = (from rule in this._context.UserHabitRules
where rule.HabitID == record.HabitID
orderby rule.ContinuousRecordFrom
ascending select rule).ToList <UserHabitRule>();
if (rules.Count > 0)
{
}
else
{
return(BadRequest("No rule defined"));
}
// Find related records
var oldrecords = (from dbrecord in _context.UserHabitRecords
where dbrecord.HabitID == record.HabitID && dbrecord.RecordDate >= dtbgn && dbrecord.RecordDate <= record.RecordDate
select dbrecord).ToList <UserHabitRecord>();
record.ContinuousCount = 1; // Default is 1
// Now calculate the rule and the points
switch (habits[0].Frequency)
{
case HabitFrequency.Weekly:
{
HabitWeeklyTrace firstWeek = new HabitWeeklyTrace();
HabitWeeklyTrace secondWeek = new HabitWeeklyTrace();
HabitWeeklyTrace.analyzeUserRecord(oldrecords, dtbgn, firstWeek, secondWeek);
// First week
int?firstweekrule = firstWeek.getRuleID();
int firstweekcontcnt = 0;
if (firstweekrule.HasValue)
{
firstweekcontcnt = firstWeek.getRuleContinuousCount().GetValueOrDefault();
}
// Second week
int?secondweekrule = secondWeek.getRuleID();
if (firstweekrule.HasValue)
{
// Start since last week
switch (habits[0].CompleteCategory)
{
case HabitCompleteCategory.NumberOfCount:
{
int nexistcnt = secondWeek.getNumberOfCount().GetValueOrDefault();
if (secondweekrule.HasValue)
{
// Already has rule assigned, move the rule ID to new created one
var existRecord = secondWeek.getRecordWithRule();
var existDBRecord = _context.UserHabitRecords
.SingleOrDefaultAsync(x => x.HabitID == existRecord.HabitID && x.RecordDate == existRecord.RecordDate && x.SubID == existRecord.SubID);
record.RuleID = existDBRecord.Result.RuleID;
record.ContinuousCount = existDBRecord.Result.ContinuousCount;
existDBRecord.Result.RuleID = null;
existDBRecord.Result.ContinuousCount = 0;
}
else
{
if (nexistcnt + record.CompleteFact.GetValueOrDefault() >= habits[0].CompleteCondition)
{
// Workout the new rule (maybe) then
var ncontcnt = firstweekcontcnt + 1;
var ridx = rules.FindIndex(ruleitem => ncontcnt >= ruleitem.ContinuousRecordFrom && ruleitem.ContinuousRecordTo > ncontcnt);
if (ridx != -1)
{
record.ContinuousCount = ncontcnt;
record.RuleID = rules[ridx].RuleID;
}
}
}
}
break;
case HabitCompleteCategory.NumberOfTimes:
default:
{
int nexistcnt = secondWeek.getNumberOfTimes();
if (secondweekrule.HasValue)
{
// Already has rule assigned, move the rule ID to new created one
var existRecord = secondWeek.getRecordWithRule();
var existDBRecord = _context.UserHabitRecords
.SingleOrDefaultAsync(x => x.HabitID == existRecord.HabitID && x.RecordDate == existRecord.RecordDate && x.SubID == existRecord.SubID);
record.RuleID = existDBRecord.Result.RuleID;
record.ContinuousCount = existDBRecord.Result.ContinuousCount;
existDBRecord.Result.RuleID = null;
existDBRecord.Result.ContinuousCount = 0;
}
else
{
if (nexistcnt + 1 == habits[0].CompleteCondition)
{
// Workout the rule then
var ncontcnt = firstweekcontcnt + 1;
var ridx = rules.FindIndex(ruleitem => ncontcnt >= ruleitem.ContinuousRecordFrom && ruleitem.ContinuousRecordTo > ncontcnt);
if (ridx != -1)
{
record.ContinuousCount = ncontcnt;
record.RuleID = rules[ridx].RuleID;
}
}
}
}
break;
}
}
else
{
// New start in this week
switch (habits[0].CompleteCategory)
{
case HabitCompleteCategory.NumberOfCount:
{
int nexistcnt = secondWeek.getNumberOfCount().GetValueOrDefault();
if (secondweekrule.HasValue)
{
// Already has rule assigned, move the rule ID to new created one
var existRecord = secondWeek.getRecordWithRule();
var existDBRecord = _context.UserHabitRecords
.SingleOrDefaultAsync(x => x.HabitID == existRecord.HabitID && x.RecordDate == existRecord.RecordDate && x.SubID == existRecord.SubID);
record.RuleID = existDBRecord.Result.RuleID;
record.ContinuousCount = existDBRecord.Result.ContinuousCount;
existDBRecord.Result.RuleID = null;
existDBRecord.Result.ContinuousCount = 0;
}
else
{
if (nexistcnt + record.CompleteFact.GetValueOrDefault() >= habits[0].CompleteCondition)
{
// Workout the rule then
var ridx = rules.FindIndex(ruleitem => record.ContinuousCount >= ruleitem.ContinuousRecordFrom && record.ContinuousCount < ruleitem.ContinuousRecordTo);
if (ridx != -1)
{
record.RuleID = rules[ridx].RuleID;
}
}
}
}
break;
case HabitCompleteCategory.NumberOfTimes:
default:
{
int nexistcnt = secondWeek.getNumberOfTimes();
if (secondweekrule.HasValue)
{
// Already has rule assigned, move the rule ID to new created one
var existRecord = secondWeek.getRecordWithRule();
var existDBRecord = _context.UserHabitRecords
.SingleOrDefaultAsync(x => x.HabitID == existRecord.HabitID && x.RecordDate == existRecord.RecordDate && x.SubID == existRecord.SubID);
record.RuleID = existDBRecord.Result.RuleID;
record.ContinuousCount = existDBRecord.Result.ContinuousCount;
existDBRecord.Result.RuleID = null;
existDBRecord.Result.ContinuousCount = 0;
}
else
{
if (nexistcnt + 1 == habits[0].CompleteCondition)
{
// Workout the rule then
var ridx = rules.FindIndex(ruleitem => record.ContinuousCount >= ruleitem.ContinuousRecordFrom && record.ContinuousCount < ruleitem.ContinuousRecordTo);
if (ridx != -1)
{
record.RuleID = rules[ridx].RuleID;
}
}
}
}
break;
}
}
}
break;
case HabitFrequency.Monthly:
{
HabitMonthlyTrace firstMonth = new HabitMonthlyTrace();
HabitMonthlyTrace secondMonth = new HabitMonthlyTrace();
HabitMonthlyTrace.analyzeUserRecord(oldrecords, dtbgn, firstMonth, secondMonth);
int?firstMonthRule = firstMonth.getRuleID();
int firstMonthContCount = 0;
if (firstMonthRule.HasValue)
{
firstMonthContCount = firstMonth.getRuleContinuousCount().GetValueOrDefault();
}
int?secondMonthRule = secondMonth.getRuleID();
if (firstMonthRule.HasValue)
{
// Start since last month
switch (habits[0].CompleteCategory)
{
case HabitCompleteCategory.NumberOfCount:
{
int nexistcnt = secondMonth.getNumberOfCount().GetValueOrDefault();
if (secondMonthRule.HasValue)
{
// Already has rule assigned, move the rule ID to new created one
var existRecord = secondMonth.getRecordWithRule();
var existDBRecord = _context.UserHabitRecords
.SingleOrDefaultAsync(x => x.HabitID == existRecord.HabitID && x.RecordDate == existRecord.RecordDate && x.SubID == existRecord.SubID);
record.RuleID = existDBRecord.Result.RuleID;
record.ContinuousCount = existDBRecord.Result.ContinuousCount;
existDBRecord.Result.RuleID = null;
existDBRecord.Result.ContinuousCount = 0;
}
else
{
if (nexistcnt + record.CompleteFact.GetValueOrDefault() >= habits[0].CompleteCondition)
{
// Workout the new rule (maybe) then
var ncontcnt = firstMonthContCount + 1;
var ridx = rules.FindIndex(ruleitem => ncontcnt >= ruleitem.ContinuousRecordFrom && ruleitem.ContinuousRecordTo > ncontcnt);
if (ridx != -1)
{
record.ContinuousCount = ncontcnt;
record.RuleID = rules[ridx].RuleID;
}
else
{
record.ContinuousCount = firstMonthContCount;
}
}
else
{
record.ContinuousCount = firstMonthContCount;
}
}
}
break;
case HabitCompleteCategory.NumberOfTimes:
default:
{
int nexistcnt = secondMonth.getNumberOfTimes();
if (secondMonthRule.HasValue)
{
// Already has rule assigned, move the rule ID to new created one
var existRecord = secondMonth.getRecordWithRule();
var existDBRecord = _context.UserHabitRecords
.SingleOrDefaultAsync(x => x.HabitID == existRecord.HabitID && x.RecordDate == existRecord.RecordDate && x.SubID == existRecord.SubID);
record.RuleID = existDBRecord.Result.RuleID;
record.ContinuousCount = existDBRecord.Result.ContinuousCount;
existDBRecord.Result.RuleID = null;
existDBRecord.Result.ContinuousCount = 0;
}
else
{
if (nexistcnt + 1 == habits[0].CompleteCondition)
{
// Workout the rule then
var ncontcnt = firstMonthContCount + 1;
var ridx = rules.FindIndex(ruleitem => ncontcnt >= ruleitem.ContinuousRecordFrom && ruleitem.ContinuousRecordTo > ncontcnt);
if (ridx != -1)
{
record.ContinuousCount = ncontcnt;
record.RuleID = rules[ridx].RuleID;
}
}
}
}
break;
}
}
else
{
// New start in this month
switch (habits[0].CompleteCategory)
{
case HabitCompleteCategory.NumberOfCount:
{
int nexistcnt = secondMonth.getNumberOfCount().GetValueOrDefault();
if (secondMonthRule.HasValue)
{
// Already has rule assigned, move the rule ID to new created one
var existRecord = secondMonth.getRecordWithRule();
var existDBRecord = _context.UserHabitRecords
.SingleOrDefaultAsync(x => x.HabitID == existRecord.HabitID && x.RecordDate == existRecord.RecordDate && x.SubID == existRecord.SubID);
record.RuleID = existDBRecord.Result.RuleID;
record.ContinuousCount = existDBRecord.Result.ContinuousCount;
existDBRecord.Result.RuleID = null;
existDBRecord.Result.ContinuousCount = 0;
}
else
{
if (nexistcnt + record.CompleteFact.GetValueOrDefault() >= habits[0].CompleteCondition)
{
// Workout the rule then
var ridx = rules.FindIndex(ruleitem => record.ContinuousCount >= ruleitem.ContinuousRecordFrom && record.ContinuousCount < ruleitem.ContinuousRecordTo);
if (ridx != -1)
{
record.RuleID = rules[ridx].RuleID;
}
}
}
}
break;
case HabitCompleteCategory.NumberOfTimes:
default:
{
int nexistcnt = secondMonth.getNumberOfTimes();
if (secondMonthRule.HasValue)
{
// Already has rule assigned, move the rule ID to new created one
var existRecord = secondMonth.getRecordWithRule();
var existDBRecord = _context.UserHabitRecords
.SingleOrDefaultAsync(x => x.HabitID == existRecord.HabitID && x.RecordDate == existRecord.RecordDate && x.SubID == existRecord.SubID);
record.RuleID = existDBRecord.Result.RuleID;
record.ContinuousCount = existDBRecord.Result.ContinuousCount;
existDBRecord.Result.RuleID = null;
existDBRecord.Result.ContinuousCount = 0;
}
else
{
if (nexistcnt + 1 == habits[0].CompleteCondition)
{
// Workout the rule then
var ridx = rules.FindIndex(ruleitem => record.ContinuousCount >= ruleitem.ContinuousRecordFrom && record.ContinuousCount < ruleitem.ContinuousRecordTo);
if (ridx != -1)
{
record.RuleID = rules[ridx].RuleID;
}
else
{
record.ContinuousCount = 0;
}
}
else
{
record.ContinuousCount = 0;
}
}
}
break;
}
}
}
break;
case HabitFrequency.Daily:
default:
{
HabitDailyTrace yesterday = new HabitDailyTrace();
HabitDailyTrace today = new HabitDailyTrace();
HabitDailyTrace.analyzeUserRecord(oldrecords, dtbgn, yesterday, today);
int?yesterdayrule = yesterday.getRuleID();
int yesterdaycontcnt = 0;
if (yesterdayrule.HasValue)
{
yesterdaycontcnt = yesterday.getRuleContinuousCount().GetValueOrDefault();
}
int?todayrule = today.getRuleID();
if (yesterdayrule.HasValue)
{
switch (habits[0].CompleteCategory)
{
case HabitCompleteCategory.NumberOfCount:
{
int nexistcnt = today.getNumberOfCount().GetValueOrDefault();
if (todayrule.HasValue)
{
// Already has rule assigned, move the rule ID to new created one
var existRecord = today.getRecordWithRule();
var existDBRecord = _context.UserHabitRecords
.SingleOrDefaultAsync(x => x.HabitID == existRecord.HabitID && x.RecordDate == existRecord.RecordDate && x.SubID == existRecord.SubID);
record.RuleID = existDBRecord.Result.RuleID;
record.ContinuousCount = existDBRecord.Result.ContinuousCount;
existDBRecord.Result.RuleID = null;
existDBRecord.Result.ContinuousCount = 0;
}
else
{
if (nexistcnt + record.CompleteFact.GetValueOrDefault() >= habits[0].CompleteCondition)
{
// Workout the new rule (maybe) then
var ncontcnt = yesterdaycontcnt + 1;
var ridx = rules.FindIndex(ruleitem => ncontcnt >= ruleitem.ContinuousRecordFrom && ruleitem.ContinuousRecordTo > ncontcnt);
if (ridx != -1)
{
record.ContinuousCount = ncontcnt;
record.RuleID = rules[ridx].RuleID;
}
}
else
{
record.ContinuousCount = 0;
}
}
}
break;
case HabitCompleteCategory.NumberOfTimes:
default:
{
int nexistcnt = today.getNumberOfTimes();
if (todayrule.HasValue)
{
// Shall never happen
throw new Exception("Unexpected");
}
else
{
// Workout the rule then
var ncontcnt = yesterdaycontcnt + 1;
var ridx = rules.FindIndex(ruleitem => ncontcnt >= ruleitem.ContinuousRecordFrom && ruleitem.ContinuousRecordTo > ncontcnt);
if (ridx != -1)
{
record.ContinuousCount = ncontcnt;
record.RuleID = rules[ridx].RuleID;
}
else
{
record.ContinuousCount = 0;
}
}
}
break;
}
}
else
{
var ncontcnt = yesterdaycontcnt + 1;
// New start of the day
switch (habits[0].CompleteCategory)
{
case HabitCompleteCategory.NumberOfCount:
{
int completedFact = today.getNumberOfCount().GetValueOrDefault();
completedFact += record.CompleteFact.GetValueOrDefault();
if (completedFact >= habits[0].CompleteCondition)
{
var ridx = rules.FindIndex(ruleitem => ncontcnt >= ruleitem.ContinuousRecordFrom && ruleitem.ContinuousRecordTo > ncontcnt);
if (ridx != -1)
{
record.ContinuousCount = ncontcnt;
record.RuleID = rules[ridx].RuleID;
}
}
else
{
record.ContinuousCount = 0;
}
}
break;
case HabitCompleteCategory.NumberOfTimes:
default:
{
// Workout the rule then
var ridx = rules.FindIndex(ruleitem => ncontcnt >= ruleitem.ContinuousRecordFrom && ruleitem.ContinuousRecordTo > ncontcnt);
if (ridx != -1)
{
record.ContinuousCount = ncontcnt;
record.RuleID = rules[ridx].RuleID;
}
else
{
record.ContinuousCount = 0;
}
}
break;
}
}
}
break;
}
// Update db
_context.UserHabitRecords.Add(record);
try
{
await _context.SaveChangesAsync();
}
catch (Exception exp)
{
System.Console.WriteLine(exp.Message);
throw;
}
return(Created(record));
}
public void getDBSelectionDate(HabitWeeklyDateTestData testData)
{
DateTime actDate = HabitWeeklyTrace.getDBSelectionDate(testData.Dow, testData.RecordDate);
Assert.Equal(testData.ExpectedDate, actDate);
}