private void GetTransactionData()
{
this.dataGridViewTransaction.Rows.Clear();
Eventt transactionModel = new Eventt();
var transactionTable = transactionModel.GetTransaction();
ContactModel contactModel = new ContactModel();
var contactTable = contactModel.GetContact();
foreach (var transaction in transactionTable)
{
if (this.dateTimePickerStartDate.Value.Date <= transaction.Date.Date && transaction.Date.Date <= this.dateTimePickerEndDate.Value.Date)
{
this.transactionDetailsBindingSource.Add(new TransactionDetails()
{
Id = transaction.Id,
Date = transaction.Date,
Type = transaction.Type,
ContactId = transaction.ContactId,
ContactName = contactTable.Find(transaction.ContactId).Name,
Amount = transaction.Amount
});
}
}
}
private void GetTransactionData()
{
textBoxFinancialStatus.Text = string.Empty;
Eventt transactionModel = new Eventt();
var transactionTable = transactionModel.GetTransaction();
List <TransactionDetails> filteredTransactionList = new List <TransactionDetails>();
DateTime currentDate = DateTime.UtcNow.Date;
DateTime futureDate = dateTimePickerDate.Value.Date;
double totalFutureDays = (futureDate - currentDate).TotalDays;
DateTime pastDate = currentDate.AddDays(-totalFutureDays);
Console.WriteLine("totalFutureDays " + totalFutureDays);
Console.WriteLine("futureDate " + futureDate);
Console.WriteLine("pastDate " + pastDate);
//Create a List of transactions from the pastDate to currentDate
foreach (var transaction in transactionTable)
{
//Console.WriteLine("transactionTable" + transaction.Id);
if (transaction.Date.Date >= pastDate)
{
filteredTransactionList.Add(new TransactionDetails()
{
Id = transaction.Id,
Date = transaction.Date,
Type = transaction.Type,
Amount = transaction.Amount
});
}
}
if (filteredTransactionList.Count != 0)
{
//Sort the filteredTransactionList by Date in ascending order
List <TransactionDetails> sortedTransactionList = filteredTransactionList.OrderBy(record => record.Date).ToList();
foreach (var i in sortedTransactionList)
{
Console.WriteLine(i.Date + " " + "transactionTable" + i.Id + " " + i.Type + i.Amount);
}
//Get list of Dates repeating in sortedTransactionList
List <DateTime> sortedTransactionDateTimeList = new List <DateTime>();
foreach (var record in sortedTransactionList)
{
if (!sortedTransactionDateTimeList.Contains(record.Date.Date))
{
sortedTransactionDateTimeList.Add(record.Date.Date);
}
}
//Get a list with NetAmount per a given date in the sortedTransactionDateTimeList to combinedTransactionList
DateTime minDateFromSortedTransactionList = sortedTransactionDateTimeList[0];
DateTime currentLoopDate = minDateFromSortedTransactionList;
double netAmountPerDate = 0;
int sortedTransactionDateTimeListIndex = 0;
List <TransactionDetails> combinedTransactionList = new List <TransactionDetails>();
foreach (var record in sortedTransactionList)
{
if (record.Date.Date != currentLoopDate)
{
combinedTransactionList.Add(new TransactionDetails()
{
Date = currentLoopDate,
Amount = netAmountPerDate,
});
sortedTransactionDateTimeListIndex++;
currentLoopDate = sortedTransactionDateTimeList[sortedTransactionDateTimeListIndex];
netAmountPerDate = 0;
}
double transactionAmount = 0;
if (record.Type == "Income")
{
transactionAmount = record.Amount;
}
else
{
transactionAmount = -1 * record.Amount;
}
netAmountPerDate += transactionAmount;
if (record == sortedTransactionList.Last())
{
combinedTransactionList.Add(new TransactionDetails()
{
Date = currentLoopDate,
Amount = netAmountPerDate,
});
}
}
foreach (var i in combinedTransactionList)
{
Console.WriteLine(i.Date + " combinedTransactionList " + i.Amount);
}
//Get a list with day and netAmount per a given date in the combinedTransactionList to updateCombinedTransactionList
List <dynamic> updateCombinedTransactionList = new List <dynamic>();
double currentDay = 1;
for (int i = 0; i < combinedTransactionList.Count; i++)
{
List <dynamic> currentItemList = new List <dynamic>();
currentItemList.Add(currentDay);
currentItemList.Add(combinedTransactionList[i].Amount);
updateCombinedTransactionList.Add(currentItemList);
if (i != combinedTransactionList.Count - 1)
{
currentDay = (combinedTransactionList[i + 1].Date - combinedTransactionList[i].Date).TotalDays + currentDay;
}
}
//Calculate the slope and y-intercept of the Line of Best Fit (Least Square Method) of the datavalues in updateCombinedTransactionList
//Calculate the mean of days and netAmount
double meanDays = 0;
double meanNetAmount = 0;
double totalDays = 0;
double totalNetAmount = 0;
double numberofItemsInUpdateCombinedTransactionList = updateCombinedTransactionList.Count;
Console.WriteLine("numberofItemsInUpdateCombinedTransactionList " + numberofItemsInUpdateCombinedTransactionList);
foreach (var item in updateCombinedTransactionList)
{
Console.WriteLine(item[0] + " " + item[1]);
totalDays += item[0];
totalNetAmount += item[1];
}
Console.WriteLine("totalDays " + totalDays);
Console.WriteLine("totalNetAmount " + totalNetAmount);
meanDays = totalDays / numberofItemsInUpdateCombinedTransactionList;
meanNetAmount = totalNetAmount / numberofItemsInUpdateCombinedTransactionList;
Console.WriteLine("meanDays " + meanDays);
Console.WriteLine("meanNetAmount " + meanNetAmount);
//Calculate the slope
double slopeNumerator = 0;
double slopeDenominator = 0;
for (int i = 0; i < numberofItemsInUpdateCombinedTransactionList; i++)
{
double x = updateCombinedTransactionList[i][0];
double y = updateCombinedTransactionList[i][1];
double numeratorItemValue = (y - meanNetAmount) * (x - meanDays);
double denominateItemValue = (x - meanNetAmount) * (x - meanNetAmount);
slopeNumerator += numeratorItemValue;
slopeDenominator += denominateItemValue;
}
//Calculate slope of best fit line
double slope = slopeNumerator / slopeDenominator;
//Calculate y-intercept of best fit line
double yIntercept = meanNetAmount - slope * meanDays;
//Get the futureDate from dateTimePickerDate in days;
double futureDateinDays = (futureDate - combinedTransactionList[0].Date).TotalDays + 1;
//Calculate the netAmount at the futureDate from dateTimePickerDate
double futureNetAmount = Math.Round(slope * futureDateinDays + yIntercept, 2);
this.textBoxFinancialStatus.Text = futureNetAmount.ToString();
}
else
{
this.textBoxFinancialStatus.Text = "Cannot Predict Status. Try Different Date";
}
}