public void SetTransactions(db DBConnection, string commandValue)
{
DBConnection.ExecuteQuery(commandValue);
while (DBConnection.QueryStep())
{
addedTrans = new Transaction();
addedTrans.date = DBConnection.QueryReturnInt(0);
addedTrans.type = DBConnection.QueryReturnInt(2);
addedTrans.amount = DBConnection.QueryReturnFloat(3);
addedTrans.verified = DBConnection.QueryReturnBool(4);
addedTrans.description = DBConnection.QueryReturnString(1);
//dbListNum = System.Convert.ToInt32(reader[5]);
dbTransList.Add(DBConnection.QueryReturnInt(5),addedTrans);
dbListNum++;
}
}
void ReadInitFiles(int monthVal, bool onStart)
{
#region AccountTransactionDB
//Get Account Transaction Info from database
//SQLiteConnection connector = new SQLiteConnection(dbPath);
//connector.Open();
//SQLiteCommand mycommand = new SQLiteCommand(connector);
string commandValue = "SELECT date,description,category,amount,cleared,id FROM Transactions WHERE Month=";
commandValue += monthVal;
DBConnection.ExecuteQuery(commandValue);
while (DBConnection.QueryStep())
{
addedTrans = new Transaction();
addedTrans.date = DBConnection.QueryReturnInt(0);
addedTrans.type = DBConnection.QueryReturnInt(2);
addedTrans.amount = DBConnection.QueryReturnFloat(3);
addedTrans.verified = DBConnection.QueryReturnBool(4);
addedTrans.description = DBConnection.QueryReturnString(1);
//dbListNum = System.Convert.ToInt32(reader[5]);
dbTransList.Add(DBConnection.QueryReturnInt(5),addedTrans);
dbListNum++;
}
//reader.Close();
if (dbListNum == 0)
{
numTransactions = 1;
}
else
{
numTransactions = dbListNum+1;
}
#endregion
#region AmazonTransactionDB
//Get Amazon Account Transaction Info from database
commandValue = "";
commandValue = "SELECT * FROM AmazonTransactions WHERE Month=";
commandValue += monthVal;
commandValue += " ORDER BY ID";
AmazonTransaction amazonTrans;
DBConnection.ExecuteQuery(commandValue);
while (DBConnection.QueryStep())
{
amazonTrans = new AmazonTransaction();
amazonTrans.type = DBConnection.QueryReturnInt(0);
amazonTrans.description = DBConnection.QueryReturnString(1);
amazonTrans.amount = DBConnection.QueryReturnFloat(2);
amazonTransList.Add(DBConnection.QueryReturnInt(4),amazonTrans);
amazonListNum++;
}
aMnumTransactions = amazonListNum+1;
//Get the monthly start amount
commandValue = "SELECT * FROM StartAmount WHERE Month=";
commandValue += monthVal;
commandValue += " AND TransactionType=0";
DBConnection.ExecuteQuery(commandValue);
while (DBConnection.QueryStep())
{
previousAmount = DBConnection.QueryReturnFloat(1);
}
previousTotalTextBox.Text = previousAmount.ToString("0.00");
#endregion
#region CarOil
commandValue = "SELECT Mileage FROM CarOil WHERE Car='Alan'";
try
{
DBConnection.ExecuteQuery(commandValue);
while (DBConnection.QueryStep())
{
alanCarOilText.Text = DBConnection.QueryReturnString(0);
}
}
catch (System.Data.SQLite.SQLiteException)
{
Console.WriteLine("Table Not Found\n");
}
commandValue = "SELECT Mileage FROM CarOil WHERE Car='Katie'";
try
{
DBConnection.ExecuteQuery(commandValue);
while (DBConnection.QueryStep())
{
katieCarOilText.Text = DBConnection.QueryReturnString(0);
}
}
catch (System.Data.SQLite.SQLiteException)
{
Console.WriteLine("Table Not Found\n");
}
#endregion
}
void AddTransactionValues(bool firstEntry)
{
int dateVal = 0;
float amountVal = 0.0f;
string tempTransaction = transactionTextBox[numTransactions-1].Text;
string tempBudgetText = budgetCombo[numTransactions-1].Text;
float tempVal = 0.0f;
tempVal = System.Convert.ToSingle(amountTextBox[numTransactions-1].Text);
//int selectedIndex = budgetCombo[numTransactions-1].SelectedIndex;
dateVal = System.Convert.ToInt32(dateTextBox[numTransactions-1].Text);
amountVal = System.Convert.ToSingle(amountTextBox[numTransactions-1].Text);
if (dateVal != 0 && amountVal != 0.0 && tempTransaction != "")
{
string command;
if (firstEntry)
{
command = DBConnection.BuildInsertQuery("First",
dateTextBox[numTransactions-1].Text,
tempTransaction,
BudgetInfo.GetBudgetIndexString(budgetCombo[numTransactions-1].Text),
amountTextBox[numTransactions-1].Text,
System.Convert.ToInt32(clearedCB[numTransactions-1].Checked).ToString(),
currentMonth.ToString());
}
else
{
command = DBConnection.BuildInsertQuery("Transactions",
dateTextBox[numTransactions-1].Text,
tempTransaction,
BudgetInfo.GetBudgetIndexString(budgetCombo[numTransactions-1].Text),
amountTextBox[numTransactions-1].Text,
System.Convert.ToInt32(clearedCB[numTransactions-1].Checked).ToString(),
currentMonth.ToString());
}
DBConnection.DBUpdate(command);
command = "SELECT last_insert_rowid()";
int rowID = 0;
rowID = System.Convert.ToInt32(DBConnection.ReturnTotals(command));
//Add a new item to the Transaction List
Transaction newTrans = new Transaction();
newTrans.date = System.Convert.ToInt32(dateTextBox[numTransactions-1].Text);
newTrans.type = BudgetInfo.GetBudgetIndex(budgetCombo[numTransactions-1].Text);
newTrans.description = transactionTextBox[numTransactions-1].Text;
newTrans.amount = System.Convert.ToSingle(amountTextBox[numTransactions-1].Text);
newTrans.verified = clearedCB[numTransactions-1].Checked;
dbTransList.Add(rowID, newTrans);
//dbListNum++;
//Then increment the transactions
AddMainTransactions(numTransactions);
numTransactions++;
//Then reorder transactions by date
ReorderTransactions();
}
else
{
if (dateVal == 0)
{
MessageBox.Show("Date is not Valid: Please Enter a Valid Date");
}
else if (amountVal == 0.0)
{
MessageBox.Show("Amount is not Valid: Please Enter a Valid Amount");
}
else
{
MessageBox.Show("Description is not Valid: Please Enter a Valid Description");
}
}
}
void amountBoxChanged(object sender, System.EventArgs e)
{
System.Windows.Forms.TextBox changedBox = new System.Windows.Forms.TextBox();
changedBox = (System.Windows.Forms.TextBox)sender;
int tempInt = System.Convert.ToInt32(changedBox.Tag);
int keyListNum = System.Convert.ToInt32(listNumTextBox[tempInt].Text);
Transaction newTrans = new Transaction();
if (dbTransList.ContainsKey(keyListNum))
{
newTrans = dbTransList[keyListNum];
if (newTrans.amount != System.Convert.ToSingle(changedBox.Text))
{
dbTransList.Remove(keyListNum);
newTrans.date = System.Convert.ToInt32(dateTextBox[tempInt].Text);
newTrans.type = budgetCombo[tempInt].SelectedIndex;
newTrans.description = transactionTextBox[tempInt].Text;
newTrans.amount = System.Convert.ToSingle(amountTextBox[tempInt].Text);
newTrans.verified = clearedCB[tempInt].Checked;
dbTransList.Add(keyListNum,newTrans);
string command = "UPDATE Transactions SET Amount=";
command += amountTextBox[tempInt].Text;
command += " WHERE ID=";
command += keyListNum.ToString();
DBConnection.DBUpdate(command);
ReorderTransactions();
}
}
}
void ReorderTransactions()
{
int transCounter = 0;
int dateCounter = 1;
while (transCounter < numTransactions)
{
foreach (KeyValuePair<int,Transaction> pair in dbTransList)
{
Transaction tempTransaction = new Transaction();
tempTransaction = (Transaction)pair.Value;
int tempDate = tempTransaction.date;
if (tempTransaction.date == dateCounter)
{
//float tempValue = previousInfo[i,0];
listNumTextBox[transCounter].Text = pair.Key.ToString();
listNumTextBox[transCounter].Tag = transCounter;
dateTextBox[transCounter].Text = tempTransaction.date.ToString();//previousInfo[i,0].ToString();
dateTextBox[transCounter].Tag = transCounter;
int tempValue = 0;
foreach (string value in budgetItemList)//int i = 0; i < BudgetInfo.numBudget; i++)
{
if (BudgetInfo.budgetCategories[tempTransaction.type] == value)//budgetItem[i])
{
break;
}
tempValue++;
}
budgetCombo[transCounter].SelectedIndex = tempValue;//GetBudgetIndex(tempTransaction.type);//tempValue;//tempTransaction.type;//System.Convert.ToInt32(tempValue);
budgetCombo[transCounter].Tag = transCounter;
transactionTextBox[transCounter].Text = tempTransaction.description;//previousInfoText[i];
transactionTextBox[transCounter].Tag = transCounter;
amountTextBox[transCounter].Text = tempTransaction.amount.ToString("0.00");//previousInfo[i,2].ToString("0.00");
amountTextBox[transCounter].Tag = transCounter;
clearedCB[transCounter].Checked = tempTransaction.verified;//System.Convert.ToBoolean(previousInfo[i,3]);
clearedCB[transCounter].Tag = transCounter;
transCounter++;
}
}
dateCounter++;
if (dateCounter > 40)
{
transCounter = numTransactions+1;
}
}
transCounter = 0;
/*while (transCounter < aMnumTransactions-1)
{
foreach (KeyValuePair<int,AmazonTransaction> pair in amazonTransList)
{
AmazonTransaction tempTransaction = new AmazonTransaction();
tempTransaction = (AmazonTransaction)pair.Value;
aMkeyListNumText[transCounter].Text = pair.Key.ToString();
aMkeyListNumText[transCounter].Tag = transCounter;
int tempValue = 0;
foreach (string value in budgetItemList)// (int i = 0; i < BudgetInfo.numBudget; i++)
{
if (BudgetInfo.budgetCategories[tempTransaction.type] == value)//budgetItem[i])
{
//tempValue = i;
//i = BudgetInfo.numBudget;
break;
}
tempValue++;
}
aMbudgetCombo[transCounter].SelectedIndex = tempValue;//tempTransaction.type;//System.Convert.ToInt32(tempValue);
aMbudgetCombo[transCounter].Tag = transCounter;
aMtransactionTextBox[transCounter].Text = tempTransaction.description;//previousInfoText[i];
aMtransactionTextBox[transCounter].Tag = transCounter;
aMamountTextBox[transCounter].Text = tempTransaction.amount.ToString("0.00");//previousInfo[i,2].ToString("0.00");
aMamountTextBox[transCounter].Tag = transCounter;
transCounter++;
}
}*/
//calculationTimer.Enabled = true;
}
void ReadInitFiles(int monthVal, bool onStart)
{
#region AccountTransactionDB
//Get Account Transaction Info from database
SQLiteConnection connector = new SQLiteConnection(dbPath);
connector.Open();
SQLiteCommand mycommand = new SQLiteCommand(connector);
string commandValue = "SELECT * FROM Transactions WHERE Month=";
commandValue += monthVal;
mycommand.CommandText = commandValue;
SQLiteDataReader reader = mycommand.ExecuteReader();
while (reader.Read())
{
addedTrans = new Transaction();
addedTrans.date = System.Convert.ToInt32(reader[0]);
addedTrans.type = System.Convert.ToInt32(reader[2]);
addedTrans.amount = System.Convert.ToSingle(reader[3]);
addedTrans.verified = System.Convert.ToBoolean(reader[4]);
addedTrans.description = reader[1].ToString();
//dbListNum = System.Convert.ToInt32(reader[5]);
dbTransList.Add(System.Convert.ToInt32(reader[6]),addedTrans);
dbListNum++;
}
reader.Close();
if (dbListNum == 0)
{
numTransactions = 1;
}
else
{
numTransactions = dbListNum+1;
}
#endregion
#region AmazonTransactionDB
//Get Amazon Account Transaction Info from database
commandValue = "";
commandValue = "SELECT * FROM AmazonTransactions WHERE Month=";
commandValue += monthVal;
mycommand.CommandText = commandValue;
reader = mycommand.ExecuteReader();
AmazonTransaction amazonTrans;
while (reader.Read())
{
amazonTrans = new AmazonTransaction();
amazonTrans.type = System.Convert.ToInt32(reader[0]);
amazonTrans.description = reader[1].ToString();
amazonTrans.amount = System.Convert.ToSingle(reader[2]);
amazonTransList.Add(System.Convert.ToInt32(reader[4]),amazonTrans);
amazonListNum++;
}
reader.Close();
aMnumTransactions = amazonListNum+1;
//Get the monthly start amount
commandValue = "SELECT * FROM StartAmount WHERE Month=";
commandValue += monthVal;
commandValue += " AND TransactionType=0";
mycommand.CommandText = commandValue;
reader = mycommand.ExecuteReader();
while (reader.Read())
{
previousAmount = System.Convert.ToSingle(reader[1]);
}
previousTotalTextBox.Text = previousAmount.ToString("0.00");
reader.Close();
#endregion
//Only add the savings transactions on startup
#region SavingsInformation
if (onStart)
{
#region MainSavingsDB
//Get the Start amount for the savings accounts from database
//Get the monthly start amount
int savingsIndexerValue = 0;
for (int i = 0; i < 7; i++)
{
savingsIndexerValue = i + 1;
commandValue = "SELECT * FROM StartAmount WHERE Month=0";
commandValue += " AND TransactionType=";
commandValue += savingsIndexerValue.ToString();
mycommand.CommandText = commandValue;
reader = mycommand.ExecuteReader();
while (reader.Read())
{
MainSavingsInfo[i].StartAmount = System.Convert.ToSingle(reader[1]);
SavingsStartBox[i].Text = MainSavingsInfo[i].StartAmount.ToString("0.00");
}
reader.Close();
}
for (int i = 0; i < 7; i++)
{
commandValue = "SELECT * FROM SavingsTransactions WHERE Type=";
commandValue += i.ToString();
mycommand.CommandText = commandValue;
reader = mycommand.ExecuteReader();
float tempTotalAmount = MainSavingsInfo[i].StartAmount;
while (reader.Read())
{
int savingsType = i;// System.Convert.ToInt32(reader[1]);
float tempAmount = System.Convert.ToSingle(reader[0]);
tempTotalAmount += tempAmount;
MainSavingsInfo[savingsType].AmountValue[MainSavingsInfo[savingsType].Transactions] = tempAmount;
MainSavingsInfo[savingsType].TotalValue[MainSavingsInfo[savingsType].Transactions] = tempTotalAmount;
MainSavingsInfo[savingsType].CurrentTotalAmount = MainSavingsInfo[savingsType].TotalValue[MainSavingsInfo[savingsType].Transactions];
AddSavingsTransaction(savingsType,
MainSavingsInfo[savingsType].AmountValue[MainSavingsInfo[savingsType].Transactions],
MainSavingsInfo[savingsType].TotalValue[MainSavingsInfo[savingsType].Transactions]);
MainSavingsInfo[savingsType].Transactions++;
}
reader.Close();
}
#endregion
#region INGSavingsDB
//Get the Start amount for the savings accounts from database
//Get the monthly start amount
savingsIndexerValue = 0;
for (int i = 0; i < 3; i++)
{
savingsIndexerValue = i + 8;
commandValue = "SELECT * FROM StartAmount WHERE Month=0";
commandValue += " AND TransactionType=";
commandValue += savingsIndexerValue.ToString();
mycommand.CommandText = commandValue;
reader = mycommand.ExecuteReader();
while (reader.Read())
{
INGSavingsInfo[i].StartAmount = System.Convert.ToSingle(reader[1]);
INGSavingsStartBox[i].Text = INGSavingsInfo[i].StartAmount.ToString("0.00");
}
reader.Close();
}
for (int i = 0; i < 3; i++)
{
savingsIndexerValue = i+7;
commandValue = "SELECT * FROM SavingsTransactions WHERE Type=";
commandValue += savingsIndexerValue.ToString();
mycommand.CommandText = commandValue;
reader = mycommand.ExecuteReader();
float tempTotalAmount = INGSavingsInfo[i].StartAmount;
while (reader.Read())
{
int savingsType = i;// System.Convert.ToInt32(reader[1]);
float tempAmount = System.Convert.ToSingle(reader[0]);
tempTotalAmount += tempAmount;
INGSavingsInfo[savingsType].AmountValue[INGSavingsInfo[savingsType].Transactions] = tempAmount;
INGSavingsInfo[savingsType].TotalValue[INGSavingsInfo[savingsType].Transactions] = tempTotalAmount;
INGSavingsInfo[savingsType].CurrentTotalAmount = INGSavingsInfo[savingsType].TotalValue[INGSavingsInfo[savingsType].Transactions];
AddINGSavingsTransaction(savingsType,
INGSavingsInfo[savingsType].AmountValue[INGSavingsInfo[savingsType].Transactions],
INGSavingsInfo[savingsType].TotalValue[INGSavingsInfo[savingsType].Transactions]);
INGSavingsInfo[savingsType].Transactions++;
//AddINGSavingsTransaction(savingsType,INGSavingsInfo[savingsType].AmountValue[INGSavingsInfo[savingsType].Transactions],INGSavingsInfo[savingsType].TotalValue[INGSavingsInfo[savingsType].Transactions]);
}
reader.Close();
}
#endregion
}
#endregion
#region CarOil
commandValue = "SELECT Mileage FROM CarOil WHERE Car='Alan'";
mycommand.CommandText = commandValue;
reader = mycommand.ExecuteReader();
while (reader.Read())
{
alanCarOilText.Text = reader[0].ToString();
}
reader.Close();
commandValue = "SELECT Mileage FROM CarOil WHERE Car='Katie'";
mycommand.CommandText = commandValue;
reader = mycommand.ExecuteReader();
while (reader.Read())
{
katieCarOilText.Text = reader[0].ToString();
}
reader.Close();
#endregion
connector.Close();
}
// Handle the KeyDown event to determine the type of character entered into the control.
#region AddTransactions
private void addButtonClick(object sender, System.EventArgs e)
{
int dateVal = 0;
float amountVal = 0.0f;
try
{
string tempTransaction = transactionTextBox[numTransactions-1].Text;
float tempVal = 0.0f;
tempVal = System.Convert.ToSingle(amountTextBox[numTransactions-1].Text);
int selectedIndex = budgetCombo[numTransactions-1].SelectedIndex;
dateVal = System.Convert.ToInt32(dateTextBox[numTransactions-1].Text);
amountVal = System.Convert.ToSingle(amountTextBox[numTransactions-1].Text);
if (dateVal != 0 && amountVal != 0.0 && tempTransaction != "")
{
SQLiteConnection connector = new SQLiteConnection(dbPath);
connector.Open();
SQLiteCommand mycommand = new SQLiteCommand(connector);
string command = "INSERT INTO Transactions (Date,Description,Category,Amount,Cleared,Month) VALUES (";
command += dateTextBox[numTransactions-1].Text + ",'";
if (tempTransaction.Contains("'"))
{
tempTransaction = tempTransaction.Replace("'","''");// = Replace(lsLastName, "'", "''");
}
command += tempTransaction + "',";
command += budgetCombo[numTransactions-1].SelectedIndex.ToString() + ",";
command += amountTextBox[numTransactions-1].Text + ",";
command += System.Convert.ToInt32(clearedCB[numTransactions-1].Checked).ToString() + ",";
command += currentMonth.ToString() + ");";
mycommand.CommandText = command;
mycommand.ExecuteScalar();
command = "SELECT last_insert_rowid()";
mycommand.CommandText = command;
SQLiteDataReader reader = mycommand.ExecuteReader();
int rowID = 0;
while (reader.Read())
{
rowID = System.Convert.ToInt32(reader[0]);
}
connector.Close();
#region SavingsAccountStuff
if (tempVal > 0.0 && selectedIndex < monthlySavingsIndex &&
selectedIndex != mtSavingsIndex &&
selectedIndex != itSavingsIndex &&
String.Compare(budgetCombo[numTransactions-1].Text,"Deposit") != 0)
{
Deduction getDeductionLocation = new Deduction();
getDeductionLocation.ShowDialog();
selectedIndex = getDeductionLocation.selectedValue;
if (selectedIndex == 0)
{
selectedIndex = ingSavingsIndex;
}
else if (selectedIndex == 1)
{
selectedIndex = mtSavingsIndex;
}
else if (selectedIndex == 2)
{
selectedIndex = itSavingsIndex;
}
else
{
selectedIndex += deductionOffset;
}
}
//AddToLayout(numTransactions);
string savingsDBString = "";
if (selectedIndex == citizensSavingsIndex ||
selectedIndex == miscSavingsIndex)
{
int indexer = 0;
if (selectedIndex == citizensSavingsIndex)
{
indexer = 0;//selectedIndex - 29;
}
else
{
indexer = 1;//selectedIndex - 29;
}
int tempInt = MainSavingsInfo[indexer].Transactions;
float tempFloat = -1.0f * tempVal;//System.Convert.ToSingle(amountTextBox[numTransactions-1].Text);
MainSavingsInfo[indexer].AmountValue[tempInt] = tempFloat;
savingsDBString = "INSERT INTO SavingsTransactions (Amount,Type) VALUES (";
savingsDBString += tempFloat.ToString() + "," + indexer.ToString() + ")";
ExecuteQuery(savingsDBString);
if (tempInt == 0)
{
MainSavingsInfo[indexer].TotalValue[tempInt] = tempFloat + MainSavingsInfo[indexer].StartAmount;
}
else
{
MainSavingsInfo[indexer].TotalValue[tempInt] = tempFloat + MainSavingsInfo[indexer].TotalValue[(tempInt - 1)];
}
AddSavingsTransaction(indexer, MainSavingsInfo[indexer].AmountValue[tempInt], MainSavingsInfo[indexer].TotalValue[tempInt]);
MainSavingsInfo[indexer].Transactions++;
}
else if (selectedIndex == monthlySavingsIndex)
{
float tempFloat = -1.0f * tempVal;//tempVal.Convert.ToSingle(amountTextBox[numTransactions-1].Text);
float[] tempAmount = {55.0f,80.00f,17.0f,70.0f,0.0f};
tempFloat -= tempAmount[0];
tempFloat -= tempAmount[1];
tempFloat -= tempAmount[2];
tempFloat -= tempAmount[3];
tempAmount[4] = tempFloat;
//Add to the Citizens Tax Column
for (int i = 2; i < 7;i++)
{
savingsDBString = "INSERT INTO SavingsTransactions (Amount,Type) VALUES (";
savingsDBString += tempAmount[i-2].ToString() + "," + i.ToString() + ")";
ExecuteQuery(savingsDBString);
int tempInt = MainSavingsInfo[i].Transactions;
MainSavingsInfo[i].AmountValue[tempInt] = tempAmount[i-2];
if (tempInt == 0)
{
MainSavingsInfo[i].TotalValue[tempInt] = tempAmount[i-2] + MainSavingsInfo[i].StartAmount;
}
else
{
MainSavingsInfo[i].TotalValue[tempInt] = tempAmount[i-2] + MainSavingsInfo[i].TotalValue[(tempInt - 1)];
}
AddSavingsTransaction(i, MainSavingsInfo[i].AmountValue[tempInt], MainSavingsInfo[i].TotalValue[tempInt]);
MainSavingsInfo[i].Transactions++;
}
}
else if (selectedIndex >= fromTaxesSavingsIndex &&
selectedIndex <= fromHealthSavingsIndex)
{
int indexer = selectedIndex - otherCitizensOffsetIndex;
int tempInt = MainSavingsInfo[indexer].Transactions;
float tempFloat = -1.0f * tempVal;//System.Convert.ToSingle(amountTextBox[numTransactions-1].Text);
//int dbIndex = indexer;
savingsDBString = "INSERT INTO SavingsTransactions (Amount,Type) VALUES (";
savingsDBString += tempFloat.ToString() + "," + indexer.ToString() + ")";
ExecuteQuery(savingsDBString);
MainSavingsInfo[indexer].AmountValue[tempInt] = tempFloat;
if (tempInt == 0)
{
MainSavingsInfo[indexer].TotalValue[tempInt] = tempFloat + MainSavingsInfo[indexer].StartAmount;
}
else
{
MainSavingsInfo[indexer].TotalValue[tempInt] = tempFloat + MainSavingsInfo[indexer].TotalValue[(tempInt - 1)];
}
AddSavingsTransaction(indexer, MainSavingsInfo[indexer].AmountValue[tempInt], MainSavingsInfo[indexer].TotalValue[tempInt]);
MainSavingsInfo[indexer].Transactions++;
}
else if (selectedIndex == ingSavingsIndex)
{
int indexer = 0;//selectedIndex - otherCitizensOffsetIndex;
int tempInt = INGSavingsInfo[indexer].Transactions;
float tempFloat = -1.0f * tempVal;//System.Convert.ToSingle(amountTextBox[numTransactions-1].Text);
int dbIndexer = 7;
savingsDBString = "INSERT INTO SavingsTransactions (Amount,Type) VALUES (";
savingsDBString += tempFloat.ToString() + "," + dbIndexer.ToString() + ")";
ExecuteQuery(savingsDBString);
INGSavingsInfo[indexer].AmountValue[tempInt] = tempFloat;
if (tempInt == 0)
{
INGSavingsInfo[indexer].TotalValue[tempInt] = tempFloat + INGSavingsInfo[indexer].StartAmount;
}
else
{
INGSavingsInfo[indexer].TotalValue[tempInt] = tempFloat + INGSavingsInfo[indexer].TotalValue[(tempInt - 1)];
}
AddINGSavingsTransaction(indexer, INGSavingsInfo[indexer].AmountValue[tempInt], INGSavingsInfo[indexer].TotalValue[tempInt]);
INGSavingsInfo[indexer].Transactions++;
}
else if (selectedIndex == mtSavingsIndex)
{
int indexer = 1;//selectedIndex - otherCitizensOffsetIndex;
int tempInt = INGSavingsInfo[indexer].Transactions;
float tempFloat = -1.0f * tempVal;//System.Convert.ToSingle(amountTextBox[numTransactions-1].Text);
int dbIndexer = 8;
savingsDBString = "INSERT INTO SavingsTransactions (Amount,Type) VALUES (";
savingsDBString += tempFloat.ToString() + "," + dbIndexer.ToString() + ")";
ExecuteQuery(savingsDBString);
INGSavingsInfo[indexer].AmountValue[tempInt] = tempFloat;
if (tempInt == 0)
{
INGSavingsInfo[indexer].TotalValue[tempInt] = tempFloat + INGSavingsInfo[indexer].StartAmount;
}
else
{
INGSavingsInfo[indexer].TotalValue[tempInt] = tempFloat + INGSavingsInfo[indexer].TotalValue[(tempInt - 1)];
}
AddINGSavingsTransaction(indexer, INGSavingsInfo[indexer].AmountValue[tempInt], INGSavingsInfo[indexer].TotalValue[tempInt]);
INGSavingsInfo[indexer].Transactions++;
}
else if (selectedIndex == itSavingsIndex)
{
int indexer = 2;//selectedIndex - otherCitizensOffsetIndex;
int tempInt = INGSavingsInfo[indexer].Transactions;
float tempFloat = -1.0f * tempVal;//System.Convert.ToSingle(amountTextBox[numTransactions-1].Text);
int dbIndexer = 9;
savingsDBString = "INSERT INTO SavingsTransactions (Amount,Type) VALUES (";
savingsDBString += tempFloat.ToString() + "," + dbIndexer.ToString() + ")";
ExecuteQuery(savingsDBString);
INGSavingsInfo[indexer].AmountValue[tempInt] = tempFloat;
if (tempInt == 0)
{
INGSavingsInfo[indexer].TotalValue[tempInt] = tempFloat + INGSavingsInfo[indexer].StartAmount;
}
else
{
INGSavingsInfo[indexer].TotalValue[tempInt] = tempFloat + INGSavingsInfo[indexer].TotalValue[(tempInt - 1)];
}
AddINGSavingsTransaction(indexer, INGSavingsInfo[indexer].AmountValue[tempInt], INGSavingsInfo[indexer].TotalValue[tempInt]);
INGSavingsInfo[indexer].Transactions++;
}
#endregion
//Add a new item to the Dictionary
Transaction newTrans = new Transaction();
newTrans.date = System.Convert.ToInt32(dateTextBox[numTransactions-1].Text);
newTrans.type = budgetCombo[numTransactions-1].SelectedIndex;
newTrans.description = transactionTextBox[numTransactions-1].Text;
newTrans.amount = System.Convert.ToSingle(amountTextBox[numTransactions-1].Text);
newTrans.verified = clearedCB[numTransactions-1].Checked;
dbTransList.Add(rowID, newTrans);
//dbListNum++;
//Then increment the transactions
AddToLayout(numTransactions);
numTransactions++;
//Then reorder transactions by date
ReorderTransactions();
}
else
{
if (dateVal == 0)
{
MessageBox.Show("Date is not Valid: Please Enter a Valid Date");
}
else if (amountVal == 0.0)
{
MessageBox.Show("Amount is not Valid: Please Enter a Valid Amount");
}
else
{
MessageBox.Show("Description is not Valid: Please Enter a Valid Description");
}
}
}
catch (FormatException)
{
MessageBox.Show("Please Enter a Number");
}
}
private void descriptionBoxChanged(object sender, System.EventArgs e)
{
System.Windows.Forms.TextBox changedBox = new System.Windows.Forms.TextBox();
changedBox = (System.Windows.Forms.TextBox)sender;
int tempInt = System.Convert.ToInt32(changedBox.Tag);
int keyListNum = System.Convert.ToInt32(listNumTextBox[tempInt].Text);
Transaction newTrans = new Transaction();
if (dbTransList.ContainsKey(keyListNum))
{
newTrans = dbTransList[keyListNum];
if (String.Compare(newTrans.description,changedBox.Text) != 0)
{
dbTransList.Remove(keyListNum);
newTrans.date = System.Convert.ToInt32(dateTextBox[tempInt].Text);
newTrans.type = budgetCombo[tempInt].SelectedIndex;
newTrans.description = transactionTextBox[tempInt].Text;
newTrans.amount = System.Convert.ToSingle(amountTextBox[tempInt].Text);
newTrans.verified = clearedCB[tempInt].Checked;
dbTransList.Add(keyListNum,newTrans);
string command = "UPDATE Transactions SET Description='";
string tempTransaction = transactionTextBox[tempInt].Text;
if (tempTransaction.Contains("'"))
{
tempTransaction = tempTransaction.Replace("'","''");
}
command += tempTransaction;
command += "' WHERE ID=";
command += keyListNum.ToString();
ExecuteQuery(command);
ReorderTransactions();
}
}
}
private void verifiedCBChanged(object sender, System.Windows.Forms.MouseEventArgs e)
{
System.Windows.Forms.CheckBox sentBox = new System.Windows.Forms.CheckBox();
sentBox = (System.Windows.Forms.CheckBox)sender;
int tempInt = System.Convert.ToInt32(sentBox.Tag);
int keyListNum = System.Convert.ToInt32(listNumTextBox[tempInt].Text);
Transaction newTrans = new Transaction();
if (dbTransList.ContainsKey(keyListNum))
{
dbTransList.Remove(keyListNum);
newTrans.date = System.Convert.ToInt32(dateTextBox[tempInt].Text);
newTrans.type = budgetCombo[tempInt].SelectedIndex;
newTrans.description = transactionTextBox[tempInt].Text;
newTrans.amount = System.Convert.ToSingle(amountTextBox[tempInt].Text);
newTrans.verified = clearedCB[tempInt].Checked;
dbTransList.Add(keyListNum,newTrans);
string command = "UPDATE Transactions SET Cleared=";
command += System.Convert.ToInt32(clearedCB[tempInt].Checked).ToString();
command += " WHERE ID=";
command += keyListNum.ToString();
ExecuteQuery(command);
}
}
void ReorderTransactions()
{
calculationTimer.Enabled = false;
int transCounter = 0;
int dateCounter = 1;
while (transCounter < numTransactions)
{
foreach (KeyValuePair<int,Transaction> pair in dbTransList)
{
Transaction tempTransaction = new Transaction();
tempTransaction = (Transaction)pair.Value;
int tempDate = tempTransaction.date;
if (tempTransaction.date == dateCounter)
{
//float tempValue = previousInfo[i,0];
listNumTextBox[transCounter].Text = pair.Key.ToString();
listNumTextBox[transCounter].Tag = transCounter;
dateTextBox[transCounter].Text = tempTransaction.date.ToString();//previousInfo[i,0].ToString();
dateTextBox[transCounter].Tag = transCounter;
//tempValue = previousInfo[i,1];
budgetCombo[transCounter].SelectedIndex = tempTransaction.type;//System.Convert.ToInt32(tempValue);
budgetCombo[transCounter].Tag = transCounter;
transactionTextBox[transCounter].Text = tempTransaction.description;//previousInfoText[i];
transactionTextBox[transCounter].Tag = transCounter;
//tempValue = previousInfo[i,2];
amountTextBox[transCounter].Text = tempTransaction.amount.ToString("0.00");//previousInfo[i,2].ToString("0.00");
amountTextBox[transCounter].Tag = transCounter;
clearedCB[transCounter].Checked = tempTransaction.verified;//System.Convert.ToBoolean(previousInfo[i,3]);
clearedCB[transCounter].Tag = transCounter;
transCounter++;
}
}
dateCounter++;
if (dateCounter > 40)
{
transCounter = numTransactions+1;
}
}
transCounter = 0;
while (transCounter < aMnumTransactions-1)
{
foreach (KeyValuePair<int,AmazonTransaction> pair in amazonTransList)
{
AmazonTransaction tempTransaction = new AmazonTransaction();
tempTransaction = (AmazonTransaction)pair.Value;
aMkeyListNumText[transCounter].Text = pair.Key.ToString();
aMkeyListNumText[transCounter].Tag = transCounter;
aMbudgetCombo[transCounter].SelectedIndex = tempTransaction.type;//System.Convert.ToInt32(tempValue);
aMbudgetCombo[transCounter].Tag = transCounter;
aMtransactionTextBox[transCounter].Text = tempTransaction.description;//previousInfoText[i];
aMtransactionTextBox[transCounter].Tag = transCounter;
aMamountTextBox[transCounter].Text = tempTransaction.amount.ToString("0.00");//previousInfo[i,2].ToString("0.00");
aMamountTextBox[transCounter].Tag = transCounter;
transCounter++;
}
}
calculationTimer.Enabled = true;
}
