public long GetMaxComputeRuleId()
{
using (var context = new SmartKPIDbContext(this._connectionString))
{
DateTime maxDate = context.ComputeRules.Max(x => x.CreateDate);
ComputeRule lastRule = context.ComputeRules.FirstOrDefault(x => x.CreateDate == maxDate);
return(lastRule.ComputeRuleId);
}
}
public async Task InsertComputeRule(IEnumerable <string> httpSuccessCodes)
{
httpSuccessCodes = httpSuccessCodes.OrderBy(x => x);
string httpCodes = string.Join(',', httpSuccessCodes);
ComputeRule computeRule = new ComputeRule {
HttpSuccessCodes = httpCodes
};
using (var context = new SmartKPIDbContext(this._connectionString))
{
DateTime maxDate = await context.ComputeRules.MaxAsync(x => x.CreateDate);
ComputeRule lastRule = await context.ComputeRules.FirstOrDefaultAsync(x => x.CreateDate == maxDate);
if (lastRule.HttpSuccessCodes != httpCodes)
{
context.ComputeRules.Add(computeRule);
await context.SaveChangesAsync();
}
}
ServiceManager.LastRuleId = GetMaxComputeRuleId();
}
