// Refresh the fields so they represent the clicked entry in the list
private void RefreshFields()
{
fldDayPaid.Enabled = true;
fldDayOfWeekPaid.Enabled = true;
fldFrequency.Enabled = true;
// Find and Load the clsOutgoing record
string selectedItem = fldOutgoings.GetItemText(fldOutgoings.SelectedItem);
clsOutgoing theOutgoing = new clsOutgoing();
foreach (DataRow row in OutgoingsTable.Rows)
{
if ((string)row["Description"] == selectedItem)
{
theOutgoing = new clsOutgoing(
(string)row["Description"], (float)row["Amount"], (int)row["DayPaid"], (bool)row["ReOccuring"], (int)row["DayOfWeekPaid"], (int)row["Frequency"]);
break;
}
}
// Update the fields
fldDescription.Text = theOutgoing.Description;
fldDayPaid.SelectedItem = theOutgoing.DayLeaveAccount.ToString();
fldAmount.Text = theOutgoing.Amount.ToString();
fldReoccuring.Checked = theOutgoing.ReOccuring;
fldDayOfWeekPaid.SelectedItem = DaysOfWeek[theOutgoing.DayOfWeekPaid];
fldFrequency.Text = theOutgoing.Frequency.ToString();
}
public clsOutgoing FindOutgoingByDescription(string SearchString)
{
clsOutgoing theOutgoing = new clsOutgoing();
/*
* foreach (clsOutgoing T in Outgoings)
* {
* if (T.Description == SearchString)
* {
* theOutgoing = T;
* return (theOutgoing);
* }
* }
*/
return(theOutgoing);
}
// Set up some test data
public static DataSet SetUpOutgoingsData(DataTable theOutGoingsTable, DataTable theOutGoingsListTable)
{
// Set up some outgoings
DateTime defaultDate = DateTime.Now;
DataTable outgoingsTable = theOutGoingsTable;
outgoingsTable.Rows.Add("Santander Credit", 200, 1, 0, 0, 0);
outgoingsTable.Rows.Add("Loan - Car", 280.52, 1, 0, 0, 0);
outgoingsTable.Rows.Add("AIL QUOTE ME HAPPY", 55.04, 24, 0, 0, 0);
outgoingsTable.Rows.Add("AVIVA", 83.78, 11, 0, 0, 0);
outgoingsTable.Rows.Add("British Gas", 169.84, 5, 0, 0, 0);
outgoingsTable.Rows.Add("CAMELOT LOTTERY", 40.50, 23, 0, 0, 0);
outgoingsTable.Rows.Add("CREATION.CO.UK", 102.06, 1, 0, 0, 0);
outgoingsTable.Rows.Add("EE - Georgie", 33.73, 15, 0, 0, 0);
outgoingsTable.Rows.Add("EE - Mine", 32.98, 15, 0, 0, 0);
outgoingsTable.Rows.Add("FDA", 29, 1, 0, 0, 0);
outgoingsTable.Rows.Add("L&G I LTD XBM-MI", 22.16, 24, 0, 0, 0);
outgoingsTable.Rows.Add("LEGAL & GEN MI C/L", 9.62, 1, 0, 0, 0);
outgoingsTable.Rows.Add("PC/SOURCE INS", 25.23, 11, 0, 0, 0);
outgoingsTable.Rows.Add("ROYAL SUNALLIANCE", 17.29, 17, 0, 0, 0);
outgoingsTable.Rows.Add("Mortage", 684.45, 1, 0, 0, 0);
outgoingsTable.Rows.Add("SEVERN TRENT WATER", 33.89, 4, 0, 0, 0);
outgoingsTable.Rows.Add("SKY DIGITAL", 74, 1, 0, 0, 0);
outgoingsTable.Rows.Add("TALKTALK LIMITED", 40.01, 23, 0, 0, 0);
outgoingsTable.Rows.Add("TV LICENCE MBP", 12.12, 1, 0, 0, 0);
outgoingsTable.Rows.Add("WALSALL M.B.C", 145, 11, 0, 0, 0);
outgoingsTable.Rows.Add("WWF-UK DD", 6, 31, 0, 0, 0);
outgoingsTable.Rows.Add("Amazon Prime", 7.99, 7, 0, 0, 0);
outgoingsTable.Rows.Add("Google Drive", 1.59, 24, 0, 0, 0);
outgoingsTable.Rows.Add("Amazon Music", 7.99, 26, 0, 0, 0);
outgoingsTable.Rows.Add("PAYPAL *POSTCODELO ", 10.35, 14, 0, 0, 0);
outgoingsTable.Rows.Add("Petrol", 60, 1, 0, 0, 0);
// Reoccuring weekly
outgoingsTable.Rows.Add("Pocket Money", 70, 0, 1, 5, 7);
// Create a data table
DataTable outgoingsListTable = theOutGoingsListTable;
// Create the table of the full outgoings list
// This will cycle through the Outgoings and repeat any that are reoccuring
DateTime currentDate = DateTime.Now;
int payDay = clsParameters.DayOfMonthPaid;
// check if PayDay is greater than the number of days in month, if so make it the same so we do not get errors
if (DateTime.DaysInMonth(currentDate.Year, currentDate.Month) < payDay)
{
payDay = DateTime.DaysInMonth(currentDate.Year, currentDate.Month);
}
// check to see if pay day is actually next month, i.e paid pn 16th and it is the 20th when we are checking.
bool PayDayIsNextMonth = currentDate.Day > payDay ? true : false;
// cycle through the rows in the outgoings table
foreach (DataRow row in outgoingsTable.Rows)
{
// Create clsOutgoing
clsOutgoing outGoing = new clsOutgoing(
(string)row["Description"], (float)row["Amount"], (int)row["DayPaid"], (bool)row["ReOccuring"], (int)row["DayOfWeekPaid"], (int)row["Frequency"]);
currentDate = DateTime.Now;
if (Convert.ToBoolean(row["ReOccuring"]))
{
// If reoccuring calculate how many left until end of month and add these to the
int currentDayOfWeek = (int)DateTime.Now.DayOfWeek;
if (PayDayIsNextMonth)
// set the payday to end last day in month, will reset when we move to next month
{
payDay = DateTime.DaysInMonth(currentDate.Year, currentDate.Month);
}
// start loop from current day and increment up to pay day
for (int i = currentDate.Day; i <= payDay; i++)
{
// check if if the day = the DayOfWeek paid
DateTime newDate = new DateTime(currentDate.Year, currentDate.Month, i);
if (outGoing.DayOfWeekPaid == (int)newDate.DayOfWeek)
{
Console.WriteLine("Adding recocuring line to Outgoing lists Descr {0} - {1} - {2}.", outGoing.Description, outGoing.DayOfWeekPaid, outGoing.Amount);
outgoingsListTable.Rows.Add(outGoing.Description, outGoing.Amount, i, newDate);
}
// If pay date is next month and day is last day of this month then increase month and set day back to 1
if (PayDayIsNextMonth)
{
// check if last day of month
if (isLastDayInMonth(currentDate, i))
{
// Increase Month and also set day back to 1
Console.WriteLine("Last Day in month check has triggered");
currentDate = currentDate.AddMonths(1);
currentDate = new DateTime(currentDate.Year, currentDate.Month, 1);
payDay = clsParameters.DayOfMonthPaid;
i = 0;
}
}
// If so add to the table
}
// End loop
}
else
{
// If not reoccuring then add to the list
if (PayDayIsNextMonth)
{
if (outGoing.DayLeaveAccount <= payDay)
{
outgoingsListTable.Rows.Add(outGoing.Description, outGoing.Amount, outGoing.DayLeaveAccount, currentDate);
}
}
else
{
if (outGoing.DayLeaveAccount > currentDate.Day)
{
outgoingsListTable.Rows.Add(outGoing.Description, outGoing.Amount, outGoing.DayLeaveAccount, currentDate);
}
}
}
}
DataSet ds = new DataSet("Data");
ds.Tables.Add(outgoingsTable);
ds.Tables["OutGoings"].DefaultView.Sort = "Description";
ds.Tables.Add(outgoingsListTable);
ds.Tables["OutGoingsList"].DefaultView.Sort = "DayPaid";
return(ds);
}
