private void ApplySorting(EntryData data)
{
try
{
data.Sorting = Convert.ToInt64(data.SearchDate.Subtract(new DateTime(1901, 1, 1)).TotalDays);
data.Sorting += ((decimal)data.EntryID / (decimal)Math.Pow(10, data.EntryID.ToString().Length));
}
catch (Exception) { throw; }
}
internal static EntryVM Convert(EntryData value)
{
var result = new EntryVM
{
EntryID = value.EntryID,
Type = (Categories.enCategoryType)value.Type,
Text = value.Text,
CategoryID = value.CategoryID,
DueDate = value.DueDate,
EntryValue = value.EntryValue,
Paid = value.Paid,
PayDate = value.PayDate,
AccountID = value.AccountID,
PatternID = value.PatternID,
RecurrencyID = value.RecurrencyID,
RecurrencyItem = value.RecurrencyItem,
RecurrencyTotal = value.RecurrencyTotal,
TransferID = value.TransferID
};
return(result);
}
internal async Task <ActionResult <EntryVM> > CreateAsync(EntryVM value)
{
try
{
DateTime startTime;
// VALIDATE
var validateMessage = await this.ValidateAsync(value);
var validateResult = this.GetValue(validateMessage);
if (!validateResult)
{
return(validateMessage.Result);
}
// NEW MODEL
var data = new EntryData()
{
ResourceID = this.GetService <Helpers.User>().ResourceID,
Type = (short)value.Type,
Text = value.Text,
CategoryID = value.CategoryID,
DueDate = value.DueDate,
EntryValue = Math.Abs(value.EntryValue),
Paid = value.Paid,
RowStatus = 1
};
if (value.Paid && value.PayDate.HasValue)
{
data.PayDate = value.PayDate;
}
if (value.AccountID.HasValue)
{
data.AccountID = value.AccountID;
}
if (!string.IsNullOrEmpty(value.TransferID))
{
data.TransferID = value.TransferID;
}
// SEARCH DATE
data.SearchDate = data.DueDate;
if (data.Paid && data.PayDate.HasValue)
{
data.SearchDate = data.PayDate.Value;
}
// PATTERN
data.PatternID = await this.GetService <Patterns.PatternsService>().AddAsync(value);
// RECURRENCY
data.RecurrencyID = value.RecurrencyID;
if (value.Recurrency != null && data.PatternID.HasValue)
{
var recurrency = new Recurrencies.RecurrencyVM
{
PatternID = data.PatternID.Value,
AccountID = data.AccountID.Value,
EntryDate = data.DueDate,
EntryValue = data.EntryValue,
Type = value.Recurrency.Type,
Count = value.Recurrency.Count
};
data.RecurrencyID = await this.GetService <Recurrencies.RecurrenciesService>().CreateAsync(recurrency);
}
// APPLY
startTime = DateTime.Now;
await this.dbContext.Entries.AddAsync(data);
await this.dbContext.SaveChangesAsync();
this.TrackMetric("Add new Entry", Math.Round(DateTime.Now.Subtract(startTime).TotalMilliseconds, 0));
// SORTING
startTime = DateTime.Now;
this.ApplySorting(data);
await this.dbContext.SaveChangesAsync();
this.TrackMetric("Apply Sorting to new Entry", Math.Round(DateTime.Now.Subtract(startTime).TotalMilliseconds, 0));
// ADD BALANCE
await this.GetService <Balances.BalancesService>().AddAsync(data);
// FIX BALANCE
await this.GetService <Balances.BalancesService>().FixAsync(data);
// RECURRENCY
if (data.RecurrencyID.HasValue && data.RecurrencyID > 0)
{
if (value.Recurrency != null)
{
await this.GetService <Recurrencies.RecurrenciesService>().AddEntriesAsync(data.RecurrencyID.Value);
}
await this.GetService <Recurrencies.RecurrenciesService>().UpdatePortionsAsync(data.RecurrencyID.Value);
}
// RESULT
var result = EntryVM.Convert(data);
return(this.CreatedResponse("entries", result.EntryID, result));
}
catch (Exception ex) { return(this.ExceptionResponse(ex)); }
}
