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 SaveTransaction(object sender, EventArgs e)
{
if (MessageBox.Show("Do you want to save the new transaction?", "PFMS | Save Transaction", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
string type = radioBtnExpense.Text;
if (this.radioBtnExpense.Checked == true)
{
type = radioBtnExpense.Text;
}
else if (this.radioBtnIncome.Checked == true)
{
type = radioBtnIncome.Text;
}
this.TransactionDetailsData = new TransactionDetails();
this.TransactionDetailsData.Date = this.dateTimePicker.Value;
this.TransactionDetailsData.Type = type;
this.TransactionDetailsData.ContactId = this.currentSelectedContactId;
this.TransactionDetailsData.Amount = double.Parse(textBoxAmount.Text);
if (File.Exists(@"transactioninputdata.xml"))
{
this.dbManager.ReadXml(@"transactioninputdata.xml");
}
DBManager.TransactionHeaderRow row = this.dbManager.TransactionHeader.NewTransactionHeaderRow();
row.Date = this.TransactionDetailsData.Date;
row.Type = this.TransactionDetailsData.Type;
row.FK_ContactNo = this.TransactionDetailsData.ContactId;
row.Amount = this.TransactionDetailsData.Amount;
this.dbManager.TransactionHeader.AddTransactionHeaderRow(row);
this.dbManager.AcceptChanges();
this.dbManager.WriteXml(@"transactioninputdata.xml");
Eventt transactionModel = new Eventt();
transactionModel.SaveTransaction(this.TransactionDetailsData);
this.dbManager.Reset();
File.Delete(@"transactioninputdata.xml");
MessageBox.Show("Successfully Saved");
// this.dateTimePicker.Value = DateTime.UtcNow();
this.radioBtnExpense.Checked = true;
this.textBoxAmount.Clear();
}
}
private void EditTransaction(object sender, EventArgs e)
{
if (MessageBox.Show("Do you want to edit the selected transaction?", "PFMS | Edit Transaction", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
this.TransactionDetailsData.Date = this.dateTimePicker.Value;
this.TransactionDetailsData.ContactId = this.currentSelectedContactId;
this.TransactionDetailsData.Amount = double.Parse(this.textBoxAmount.Text);
if (File.Exists(@"transactioneditdata.xml"))
{
this.dbManager.ReadXml(@"transactioneditdata.xml");
}
DBManager.TransactionHeaderRow row = this.dbManager.TransactionHeader.NewTransactionHeaderRow();;
row.Date = this.TransactionDetailsData.Date;
row.FK_ContactNo = this.TransactionDetailsData.ContactId;
row.Amount = this.TransactionDetailsData.Amount;
this.dbManager.TransactionHeader.AddTransactionHeaderRow(row);
this.dbManager.AcceptChanges();
this.dbManager.WriteXml(@"transactioneditdata.xml");
Eventt transactionModel = new Eventt();
transactionModel.EditTransaction(TransactionDetailsData);
this.dbManager.Reset();
File.Delete(@"transactioneditdata.xml");
MessageBox.Show("Successfully Edited");
this.Close();
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridViewTransaction.Columns[e.ColumnIndex].Name == "Edit")
{
int selectId = (int)dataGridViewTransaction.Rows[e.RowIndex].Cells[0].Value;
DateTime selectDate = (DateTime)dataGridViewTransaction.Rows[e.RowIndex].Cells[1].Value;
String selectType = (string)dataGridViewTransaction.Rows[e.RowIndex].Cells[2].Value;
String selectName = (string)dataGridViewTransaction.Rows[e.RowIndex].Cells[3].Value;
double selectAmount = (double)dataGridViewTransaction.Rows[e.RowIndex].Cells[4].Value;
this.TransactionDetailsData = new TransactionDetails();
this.TransactionDetailsData.Id = selectId;
this.TransactionDetailsData.Date = selectDate;
this.TransactionDetailsData.Type = selectType;
this.TransactionDetailsData.Amount = selectAmount;
EditTransactionForm editTransactionForm = new EditTransactionForm(TransactionDetailsData);
editTransactionForm.Activate();
editTransactionForm.ShowDialog();
GetTransactionData();
}
if (dataGridViewTransaction.Columns[e.ColumnIndex].Name == "Delete")
{
if (MessageBox.Show("Do you want to delete the selected transaction?", "PFMS | Delete Transaction", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int selectId = (int)dataGridViewTransaction.Rows[e.RowIndex].Cells[0].Value;
Eventt transactionModel = new Eventt();
transactionModel.DeleteTransaction(selectId);
MessageBox.Show("Successfully Deleted");
transactionDetailsBindingSource.RemoveCurrent();
}
}
}
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";
}
}