public void LoadEmptyTable()
{
FMainDS.LoadAll();
FMainDS.DeleteAllRows();
FMainDS.SaveChanges();
TFrmSetupCorporateExchangeRate mainScreen = new TFrmSetupCorporateExchangeRate(null);
mainScreen.Show();
// Toolstrip
ToolStripButton btnSave = (new ToolStripButtonTester("tbbSave", mainScreen)).Properties;
// Grid
TSgrdDataGrid grdDetails = (TSgrdDataGrid)(new TSgrdDataGridPagedTester("grdDetails", mainScreen)).Properties;
// Panel and controls
Panel pnlDetails = (new PanelTester("pnlDetails", mainScreen)).Properties;
TCmbAutoPopulated cmbFromCurrency = (new TCmbAutoPopulatedTester("cmbDetailFromCurrencyCode", mainScreen)).Properties;
TCmbAutoPopulated cmbToCurrency = (new TCmbAutoPopulatedTester("cmbDetailToCurrencyCode", mainScreen)).Properties;
TtxtPetraDate dtpEffectiveDate = (new TTxtPetraDateTester("dtpDetailDateEffectiveFrom", mainScreen)).Properties;
CheckBox chkHideOthers = (new CheckBoxTester("chkHideOthers", mainScreen)).Properties;
Assert.IsFalse(btnSave.Enabled, "The Save button should be disabled when the screen is loaded");
Assert.IsFalse(pnlDetails.Enabled, "The Details Panel should be disabled on initial load");
Assert.IsFalse(dtpEffectiveDate.Date.HasValue, "The date control should be empty on initial load");
Assert.AreEqual(1, grdDetails.Rows.Count, "The grid should be empty");
mainScreen.Close();
}
public void ModalValidation()
{
FMainDS.LoadAll();
FMainDS.DeleteAllRows();
FMainDS.SaveChanges();
FLedgerDS.CreateTestLedger();
decimal selectedRate;
DateTime selectedDate;
int selectedTime;
// Open the screen modally on our test ledger and a from currency of GBP
// This test sets up a date range
TFrmSetupDailyExchangeRate mainScreen = new TFrmSetupDailyExchangeRate(null);
DialogBoxHandler = delegate(string name, IntPtr hWnd)
{
ModalValidationHandler();
};
DialogResult dlgResult = mainScreen.ShowDialog(STANDARD_TEST_LEDGER_NUMBER, FStandardEffectiveDate.AddDays(
-10), FStandardEffectiveDate, "GBP", 1.0m, out selectedRate, out selectedDate, out selectedTime);
if (dlgResult == DialogResult.Abort)
{
Assert.Fail(FModalAssertResult);
}
// Make sure we did save
Assert.AreEqual(DialogResult.OK, dlgResult);
Assert.IsFalse((new ToolStripButtonTester("tbbSave", mainScreen)).Properties.Enabled);
FMainDS.LoadAll();
Assert.AreEqual(2, FMainDS.ADailyExchangeRate.Rows.Count, "The data table should have 2 rows after a successful save operation");
}
public void Import()
{
FMainDS.LoadAll();
FMainDS.DeleteAllRows();
FMainDS.SaveChanges();
TVerificationResultCollection results = new TVerificationResultCollection();
string resultText;
string firstResultCode;
RunTestImport("corporate-csv/GoodImport.csv", ",", results, out resultText, out firstResultCode);
Assert.AreEqual(String.Empty, resultText, "Errors during import...");
Assert.AreEqual(8, FMainDS.ACorporateExchangeRate.Rows.Count, "Wrong number of rows after successful import");
FMainDS.DeleteAllRows();
RunTestImport("corporate-csv/BadCurrencyImport.csv", ",", results, out resultText, out firstResultCode);
Assert.AreEqual(1, results.Count);
Assert.AreEqual(CommonErrorCodes.ERR_INCONGRUOUSSTRINGS, firstResultCode);
FMainDS.DeleteAllRows();
RunTestImport("corporate-csv/BadDateImport.csv", ",", results, out resultText, out firstResultCode);
Assert.AreEqual(1, results.Count);
Assert.AreEqual(CommonErrorCodes.ERR_INVALIDDATE, firstResultCode);
FMainDS.DeleteAllRows();
RunTestImport("corporate-csv/BadRateImport.csv", ",", results, out resultText, out firstResultCode);
Assert.AreEqual(1, results.Count);
Assert.AreEqual(CommonErrorCodes.ERR_INVALIDNUMBER, firstResultCode);
// Test for a missing column
FMainDS.DeleteAllRows();
RunTestImport("corporate-csv/MissingColumn.csv", ",", results, out resultText, out firstResultCode);
Assert.AreEqual(1, results.Count);
Assert.AreEqual(CommonErrorCodes.ERR_INFORMATIONMISSING, firstResultCode);
// Run the test(s) that have duplicates
FMainDS.DeleteAllRows();
FMainDS.InsertStandardRows();
RunTestImport("corporate-csv/GoodImport-WithDuplicates.csv", ",", results, out resultText, out firstResultCode);
Assert.AreEqual(String.Empty, resultText, "Errors during import...");
Assert.AreEqual(12, FMainDS.ACorporateExchangeRate.Rows.Count, "Wrong number of rows after successful import");
// And Headers
FMainDS.DeleteAllRows();
RunTestImport("corporate-csv/GoodImport-WithHeader.csv", ",", results, out resultText, out firstResultCode);
Assert.AreEqual(String.Empty, resultText, "Errors during import...");
Assert.AreEqual(8, FMainDS.ACorporateExchangeRate.Rows.Count, "Wrong number of rows after successful import");
// Test a date/rate only file - this is tab separated
FMainDS.DeleteAllRows();
RunTestImport("corporate-csv/USD_EUR.csv", "\t", results, out resultText, out firstResultCode);
Assert.AreEqual(String.Empty, resultText, "Errors during import...");
Assert.AreEqual(8, FMainDS.ACorporateExchangeRate.Rows.Count, "Wrong number of rows after successful import");
// Test a file with its own inverses
FMainDS.DeleteAllRows();
RunTestImport("corporate-csv/GoodImport-WithInverses.csv", ",", results, out resultText, out firstResultCode);
Assert.AreEqual(String.Empty, resultText, "Errors during import...");
Assert.AreEqual(4, FMainDS.ACorporateExchangeRate.Rows.Count, "Wrong number of rows after successful import");
}
/// <summary>
/// clean up, disconnect from OpenPetra server
/// </summary>
public override void TearDown()
{
if (!FConnectedToServer)
{
return;
}
FMainDS.DeleteAllRows();
FMainDS.SaveChanges();
TPetraConnector.Disconnect();
}
public void Validation()
{
FMainDS.LoadAll();
FMainDS.DeleteAllRows();
FMainDS.SaveChanges();
TFrmSetupCorporateExchangeRate mainScreen = new TFrmSetupCorporateExchangeRate(null);
mainScreen.Show();
ButtonTester btnNew = new ButtonTester("btnNew", mainScreen);
TCmbAutoPopulated cmbFromCurrency = (new TCmbAutoPopulatedTester("cmbDetailFromCurrencyCode", mainScreen)).Properties;
TCmbAutoPopulated cmbToCurrency = (new TCmbAutoPopulatedTester("cmbDetailToCurrencyCode", mainScreen)).Properties;
TtxtPetraDate dtpEffectiveDate = (new TTxtPetraDateTester("dtpDetailDateEffectiveFrom", mainScreen)).Properties;
TTxtNumericTextBox txtExchangeRate = (new TTxtNumericTextBoxTester("txtDetailRateOfExchange", mainScreen)).Properties;
btnNew.Click();
// Set up some bad entries
dtpEffectiveDate.Text = "";
txtExchangeRate.NumberValueDecimal = 0.0m;
string dlgText = String.Empty;
bool dlgDisplayed = false;
// Click the New button and discover what validation errors we have
// Note - we do not put assert's inside the delegate because we want the dialog to close.
// If the dialog is left hanging this might do bad stuff to automated testing
ModalFormHandler = delegate(string name, IntPtr hWnd, Form form)
{
MessageBoxTester tester = new MessageBoxTester(hWnd);
dlgText = tester.Text;
dlgDisplayed = true;
tester.SendCommand(MessageBoxTester.Command.OK);
};
btnNew.Click();
// Check that we did display the dialog and that we picked up the validation errors we predicted
Assert.IsTrue(dlgDisplayed);
Assert.IsTrue(dlgText.Contains(CommonErrorCodes.ERR_NOUNDEFINEDDATE));
Assert.IsTrue(dlgText.Contains(CommonErrorCodes.ERR_INVALIDNUMBER));
// Close without saving
ModalFormHandler = delegate(string name, IntPtr hWnd, Form form)
{
MessageBoxTester tester = new MessageBoxTester(hWnd);
tester.SendCommand(MessageBoxTester.Command.No);
};
mainScreen.Close();
}
public void LoadModalEmptyTable()
{
// Initialise data - create an empty table and our test ledger
FMainDS.LoadAll();
FMainDS.DeleteAllRows();
FMainDS.SaveChanges();
FLedgerDS.CreateTestLedger();
// variables to hold the dialog result output
decimal selectedRate;
DateTime selectedDate;
int selectedTime;
// Open the screen modally on our test ledger using a 'from' currency of GBP
TFrmSetupDailyExchangeRate mainScreen = new TFrmSetupDailyExchangeRate(null);
DialogBoxHandler = delegate(string name, IntPtr hWnd)
{
LoadModalEmptyTableHandler();
};
DialogResult dlgResult = mainScreen.ShowDialog(STANDARD_TEST_LEDGER_NUMBER,
FStandardEffectiveDate,
"GBP",
1.0m,
out selectedRate,
out selectedDate,
out selectedTime);
// Check the result for any assertions
if (dlgResult == DialogResult.Abort)
{
Assert.Fail(FModalAssertResult);
}
// Check we returned the correct data to the caller
Assert.AreEqual(DialogResult.OK, dlgResult);
Assert.AreEqual(STANDARD_RATE_OF_EXCHANGE, selectedRate);
Assert.AreEqual(FStandardEffectiveDate, selectedDate);
Assert.AreEqual(7200, selectedTime);
// Check we did also save the result
FMainDS.LoadAll();
ADailyExchangeRateRow row =
(ADailyExchangeRateRow)FMainDS.ADailyExchangeRate.Rows.Find(new object[] { "GBP", STANDARD_TEST_CURRENCY, FStandardEffectiveDate,
7200 });
Assert.IsNotNull(row, "The selected exchange rate was not saved");
Assert.AreEqual(STANDARD_RATE_OF_EXCHANGE, row.RateOfExchange);
}
public void InvertRate()
{
FMainDS.LoadAll();
FMainDS.DeleteAllRows();
FMainDS.InsertStandardRows();
FMainDS.SaveChanges();
TFrmSetupCorporateExchangeRate mainScreen = new TFrmSetupCorporateExchangeRate(null);
mainScreen.Show();
// Toolstrip
ToolStripButton btnSave = (new ToolStripButtonTester("tbbSave", mainScreen)).Properties;
// Grid
TSgrdDataGrid grdDetails = (TSgrdDataGrid)(new TSgrdDataGridPagedTester("grdDetails", mainScreen)).Properties;
// Panel and controls
Panel pnlDetails = (new PanelTester("pnlDetails", mainScreen)).Properties;
ButtonTester btnNew = new ButtonTester("btnNew", mainScreen);
TCmbAutoPopulated cmbFromCurrency = (new TCmbAutoPopulatedTester("cmbDetailFromCurrencyCode", mainScreen)).Properties;
TCmbAutoPopulated cmbToCurrency = (new TCmbAutoPopulatedTester("cmbDetailToCurrencyCode", mainScreen)).Properties;
TtxtPetraDate dtpEffectiveDate = (new TTxtPetraDateTester("dtpDetailDateEffectiveFrom", mainScreen)).Properties;
TTxtNumericTextBox txtExchangeRate = (new TTxtNumericTextBoxTester("txtDetailRateOfExchange", mainScreen)).Properties;
ButtonTester btnInvert = new ButtonTester("btnInvertExchangeRate", mainScreen);
// Select the first row in the grid. New rows should be based on data row 5
SelectRowInGrid(1, 5);
// Check that Invert enabled and test that it works
btnNew.Click();
Assert.IsTrue(btnInvert.Properties.Enabled);
txtExchangeRate.NumberValueDecimal = 5.0m;
btnInvert.Click();
Assert.AreEqual(0.2m, txtExchangeRate.NumberValueDecimal);
btnInvert.Click();
Assert.AreEqual(5.0m, txtExchangeRate.NumberValueDecimal);
ModalFormHandler = delegate(string name, IntPtr hWnd, Form form)
{
MessageBoxTester tester = new MessageBoxTester(hWnd);
tester.SendCommand(MessageBoxTester.Command.OK);
};
mainScreen.SaveChanges();
mainScreen.Close();
}
public void ExchangeRateUsage()
{
FMainDS.LoadAll();
FMainDS.DeleteAllRows();
FMainDS.InsertStandardModalRows();
FMainDS.SaveChanges();
FGiftAndJournal.InitialiseData("load-data.sql");
decimal selectedRate;
DateTime selectedDate;
int selectedTime;
// Open the screen modally on our test ledger and a from currency of GBP
TFrmSetupDailyExchangeRate mainScreen = new TFrmSetupDailyExchangeRate(null);
mainScreen.ShowUsedRates();
DialogBoxHandler = delegate(string name, IntPtr hWnd)
{
ExchangeRateUsageHandler();
};
DialogResult dlgResult = mainScreen.ShowDialog(STANDARD_TEST_LEDGER_NUMBER,
FStandardEffectiveDate,
"GBP",
1.0m,
out selectedRate,
out selectedDate,
out selectedTime);
if (dlgResult == DialogResult.Abort)
{
Assert.Fail(FModalAssertResult);
}
Assert.AreEqual(DialogResult.OK, dlgResult);
}
public void LoadModalTableWithData()
{
// Initialse data
FMainDS.LoadAll();
FMainDS.DeleteAllRows();
FMainDS.InsertStandardModalRows();
FMainDS.SaveChanges();
FLedgerDS.CreateTestLedger();
decimal selectedRate;
DateTime selectedDate;
int selectedTime;
// Open the screen modally on our test ledger and a from currency of GBP
TFrmSetupDailyExchangeRate mainScreen = new TFrmSetupDailyExchangeRate(null);
DialogBoxHandler = delegate(string name, IntPtr hWnd)
{
LoadModalTableHandler();
};
DialogResult dlgResult = mainScreen.ShowDialog(STANDARD_TEST_LEDGER_NUMBER,
FStandardEffectiveDate,
"GBP",
1.0m,
out selectedRate,
out selectedDate,
out selectedTime);
if (dlgResult == DialogResult.Abort)
{
Assert.Fail(FModalAssertResult);
}
Assert.AreEqual(DialogResult.OK, dlgResult);
Assert.AreEqual(new DateTime(1900, 7, 1), selectedDate);
Assert.AreEqual(0.51m, selectedRate);
}
public void GetRateForDate()
{
// First test is with empty data
FMainDS.LoadAll();
FMainDS.DeleteAllRows();
FMainDS.SaveChanges();
FLedgerDS.CreateTestLedger();
// define our working date range
DateTime dtStart = new DateTime(2000, 01, 01);
DateTime dtEnd = new DateTime(2000, 12, 31);
// First test is with empty data - should return 1.0m
TFrmSetupDailyExchangeRate mainScreen = new TFrmSetupDailyExchangeRate(null);
decimal result = mainScreen.GetLastExchangeValueOfInterval(STANDARD_TEST_LEDGER_NUMBER, dtStart, dtEnd, "GBP");
Assert.AreEqual(1.0m, result, "The result should be 1.0m when the table contains no data");
// Repeat test with data but outside the date range - again should return 1.0m
FMainDS.InsertStandardModalRows();
FMainDS.SaveChanges();
mainScreen = new TFrmSetupDailyExchangeRate(null);
result = mainScreen.GetLastExchangeValueOfInterval(STANDARD_TEST_LEDGER_NUMBER, dtStart, dtEnd, "GBP");
Assert.AreEqual(1.0m, result, "The result should be 1.0m because there is no data in the date range");
// Repeat again with data inside the range
FMainDS.AddARow("GBP", STANDARD_TEST_CURRENCY, new DateTime(2000, 6, 1), 2.0m);
FMainDS.AddARow("GBP", STANDARD_TEST_CURRENCY, new DateTime(2000, 6, 10), 2.05m);
FMainDS.AddARow("GBP", STANDARD_TEST_CURRENCY, new DateTime(2000, 6, 30), 2.15m); // This is the latest
FMainDS.AddARow("GBP", STANDARD_TEST_CURRENCY, new DateTime(2000, 6, 20), 2.10m);
FMainDS.SaveChanges();
mainScreen = new TFrmSetupDailyExchangeRate(null);
result = mainScreen.GetLastExchangeValueOfInterval(STANDARD_TEST_LEDGER_NUMBER, dtStart, dtEnd, "GBP");
Assert.AreEqual(2.15m, result);
}
public void SaveAndCancel()
{
FMainDS.LoadAll();
FMainDS.DeleteAllRows();
FMainDS.SaveChanges();
TFrmSetupCorporateExchangeRate mainScreen = new TFrmSetupCorporateExchangeRate(null);
mainScreen.Show();
// Save and New buttons
ToolStripButtonTester btnSave = new ToolStripButtonTester("tbbSave", mainScreen);
ButtonTester btnNew = new ButtonTester("btnNew", mainScreen);
TTxtNumericTextBox txtExchangeRate = (new TTxtNumericTextBoxTester("txtDetailRateOfExchange", mainScreen)).Properties;
// Add new row, save and close
btnNew.Click();
txtExchangeRate.NumberValueDecimal = 10m;
btnSave.Click();
mainScreen.Close();
// Create the screen a second time
TFrmSetupCorporateExchangeRate mainScreen2 = new TFrmSetupCorporateExchangeRate(null);
mainScreen2.Show();
// make sure the data really got saved
TSgrdDataGrid grdDetails = (TSgrdDataGrid)(new TSgrdDataGridPagedTester("grdDetails", mainScreen2).Properties);
Assert.AreEqual(3, grdDetails.Rows.Count);
btnNew = new ButtonTester("btnNew", mainScreen2);
txtExchangeRate = (new TTxtNumericTextBoxTester("txtDetailRateOfExchange", mainScreen2)).Properties;
// Add another row, but this time close without saving
btnNew.Click();
ModalFormHandler = delegate(string name, IntPtr hWnd, Form form)
{
MessageBoxTester tester = new MessageBoxTester(hWnd);
tester.SendCommand(MessageBoxTester.Command.No);
};
mainScreen2.Close();
// Create the screen a third time
TFrmSetupCorporateExchangeRate mainScreen3 = new TFrmSetupCorporateExchangeRate(null);
mainScreen3.Show();
// make sure the data did not get saved
grdDetails = (TSgrdDataGrid)(new TSgrdDataGridPagedTester("grdDetails", mainScreen3).Properties);
Assert.AreEqual(3, grdDetails.Rows.Count);
btnNew = new ButtonTester("btnNew", mainScreen3);
txtExchangeRate = (new TTxtNumericTextBoxTester("txtDetailRateOfExchange", mainScreen3)).Properties;
// Add another row, but this time close AND save
btnNew.Click();
ModalFormHandler = delegate(string name, IntPtr hWnd, Form form)
{
MessageBoxTester tester = new MessageBoxTester(hWnd);
tester.SendCommand(MessageBoxTester.Command.Yes);
};
mainScreen3.Close();
// Create the screen a fourth time!
TFrmSetupCorporateExchangeRate mainScreen4 = new TFrmSetupCorporateExchangeRate(null);
mainScreen4.Show();
// make sure the data was saved last time
grdDetails = (TSgrdDataGrid)(new TSgrdDataGridPagedTester("grdDetails", mainScreen4).Properties);
Assert.AreEqual(5, grdDetails.Rows.Count);
mainScreen4.Close();
}
public void EditRow()
{
FMainDS.LoadAll();
FMainDS.DeleteAllRows();
FMainDS.InsertStandardRows();
FMainDS.SaveChanges();
TFrmSetupCorporateExchangeRate mainScreen = new TFrmSetupCorporateExchangeRate(null);
mainScreen.Show();
// Toolstrip
ToolStripButton btnSave = (new ToolStripButtonTester("tbbSave", mainScreen)).Properties;
// Grid
TSgrdDataGrid grdDetails = (TSgrdDataGrid)(new TSgrdDataGridPagedTester("grdDetails", mainScreen)).Properties;
// Panel and controls
Panel pnlDetails = (new PanelTester("pnlDetails", mainScreen)).Properties;
ButtonTester btnNew = new ButtonTester("btnNew", mainScreen);
TCmbAutoPopulated cmbFromCurrency = (new TCmbAutoPopulatedTester("cmbDetailFromCurrencyCode", mainScreen)).Properties;
TCmbAutoPopulated cmbToCurrency = (new TCmbAutoPopulatedTester("cmbDetailToCurrencyCode", mainScreen)).Properties;
TtxtPetraDate dtpEffectiveDate = (new TTxtPetraDateTester("dtpDetailDateEffectiveFrom", mainScreen)).Properties;
TTxtNumericTextBox txtExchangeRate = (new TTxtNumericTextBoxTester("txtDetailRateOfExchange", mainScreen)).Properties;
// Select the first row in the grid. New rows should be based on data row 5
SelectRowInGrid(1, 5);
// Add three rows
btnNew.Click();
btnNew.Click();
btnNew.Click();
DateTime dt1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
//DateTime dt2 = dt1.AddMonths(1);
DateTime dt3 = dt1.AddMonths(2);
// Check the data first
Assert.AreEqual(EffectiveCurrency(FFromCurrencyId), cmbFromCurrency.GetSelectedString());
Assert.AreEqual(EffectiveCurrency(FToCurrencyId), cmbToCurrency.GetSelectedString());
Assert.AreEqual(dt3, dtpEffectiveDate.Date);
Assert.AreEqual(EffectiveRate(), txtExchangeRate.NumberValueDecimal.Value);
Assert.AreEqual(3, mainScreen.GetSelectedRowIndex());
// Focus on the from currency, then change it to 'BEF'
cmbFromCurrency.Focus();
cmbFromCurrency.SetSelectedString("BEF");
cmbToCurrency.Focus();
// Now check the date and rate. Date should be back to this month and rate should be 0.00 because this currency has never been used
Assert.AreEqual(dt1, dtpEffectiveDate.Date.Value);
Assert.AreEqual(0.0m, txtExchangeRate.NumberValueDecimal);
Assert.AreEqual(1, mainScreen.GetSelectedRowIndex());
// Reset the currency and confirm we go back to where we were
cmbFromCurrency.Focus();
cmbFromCurrency.SetSelectedString(EffectiveCurrency(FFromCurrencyId));
cmbToCurrency.Focus();
Assert.AreEqual(dt3, dtpEffectiveDate.Date.Value);
Assert.AreEqual(EffectiveRate(), txtExchangeRate.NumberValueDecimal);
Assert.AreEqual(3, mainScreen.GetSelectedRowIndex());
// Repeat for the To currency
cmbToCurrency.Focus();
cmbToCurrency.SetSelectedString("BEF");
dtpEffectiveDate.Focus();
// Now check the date and rate. Date should be back to this month and rate should be 0.00 because this currency has never been used
Assert.AreEqual(dt1, dtpEffectiveDate.Date.Value);
Assert.AreEqual(0.0m, txtExchangeRate.NumberValueDecimal);
Assert.AreEqual(1, mainScreen.GetSelectedRowIndex());
// Reset the currency and confirm we go back to where we were
cmbToCurrency.Focus();
cmbToCurrency.SetSelectedString(EffectiveCurrency(FToCurrencyId));
dtpEffectiveDate.Focus();
Assert.AreEqual(dt3, dtpEffectiveDate.Date.Value);
Assert.AreEqual(EffectiveRate(), txtExchangeRate.NumberValueDecimal);
Assert.AreEqual(3, mainScreen.GetSelectedRowIndex());
// Finally check what happens when editing the date
SelectRowInGrid(5);
txtExchangeRate.NumberValueDecimal = 8.0m; // Today
FixUnvalidatedChanges();
SelectRowInGrid(4);
txtExchangeRate.NumberValueDecimal = 9.0m; // Today + 1m
FixUnvalidatedChanges();
SelectRowInGrid(3);
txtExchangeRate.NumberValueDecimal = 10.0m; // Today +2m
FixUnvalidatedChanges();
SelectRowInGrid(5);
Assert.AreEqual(8.0m, txtExchangeRate.NumberValueDecimal);
dtpEffectiveDate.Focus();
dtpEffectiveDate.Date = (new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1)).AddMonths(6);
grdDetails.Focus();
Assert.AreEqual(10.0m, txtExchangeRate.NumberValueDecimal);
mainScreen.SaveChanges();
mainScreen.Close();
}
public void AddRowToTable()
{
FMainDS.LoadAll();
FMainDS.DeleteAllRows();
FMainDS.InsertStandardRows();
FMainDS.SaveChanges();
TFrmSetupCorporateExchangeRate mainScreen = new TFrmSetupCorporateExchangeRate(null);
mainScreen.Show();
// Toolstrip
ToolStripButton btnSave = (new ToolStripButtonTester("tbbSave", mainScreen)).Properties;
// Grid
TSgrdDataGrid grdDetails = (TSgrdDataGrid)(new TSgrdDataGridPagedTester("grdDetails", mainScreen)).Properties;
// Panel and controls
Panel pnlDetails = (new PanelTester("pnlDetails", mainScreen)).Properties;
ButtonTester btnNew = new ButtonTester("btnNew", mainScreen);
TCmbAutoPopulated cmbFromCurrency = (new TCmbAutoPopulatedTester("cmbDetailFromCurrencyCode", mainScreen)).Properties;
TCmbAutoPopulated cmbToCurrency = (new TCmbAutoPopulatedTester("cmbDetailToCurrencyCode", mainScreen)).Properties;
TtxtPetraDate dtpEffectiveDate = (new TTxtPetraDateTester("dtpDetailDateEffectiveFrom", mainScreen)).Properties;
TTxtNumericTextBox txtExchangeRate = (new TTxtNumericTextBoxTester("txtDetailRateOfExchange", mainScreen)).Properties;
// Select the bottom row - when we get a new row it should be based on StandardData[1]
SelectRowInGrid(FAllRowCount, 1);
// Check that the controls are disabled
Assert.IsFalse(cmbFromCurrency.Enabled);
Assert.IsFalse(cmbToCurrency.Enabled);
Assert.IsTrue(dtpEffectiveDate.ReadOnly);
// Check that the controls are enabled
Assert.IsTrue(txtExchangeRate.Enabled);
// Click the 'New' button
Assert.IsFalse(btnSave.Enabled, "The Save button should be disabled when the screen is loaded");
btnNew.Click();
Assert.IsTrue(btnSave.Enabled, "The Save button should be enabled after adding a new row");
Assert.IsTrue(cmbFromCurrency.Enabled);
Assert.IsTrue(cmbToCurrency.Enabled);
Assert.IsTrue(dtpEffectiveDate.Enabled);
Assert.IsTrue(txtExchangeRate.Enabled);
// The effective date should be 1st of current month
DateTime expectedDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
Assert.AreEqual(EffectiveCurrency(FFromCurrencyId), cmbFromCurrency.GetSelectedString());
Assert.AreEqual(EffectiveCurrency(FToCurrencyId), cmbToCurrency.GetSelectedString());
Assert.AreEqual(expectedDate, dtpEffectiveDate.Date);
Assert.AreEqual(EffectiveRate(), txtExchangeRate.NumberValueDecimal.Value);
// The row number of the new row should be at row 7
Assert.AreEqual(FAllRowCount - 1, mainScreen.GetSelectedRowIndex());
// Change the rate to a new value
decimal newRate = 0.667m;
txtExchangeRate.NumberValueDecimal = newRate;
// click the 'New' button again - this time the date should be first of next month
btnNew.Click();
expectedDate = (new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1)).AddMonths(1);
// The details should be the same as before except for the new date and the rate being what we just set
Assert.AreEqual(EffectiveCurrency(FFromCurrencyId), cmbFromCurrency.GetSelectedString());
Assert.AreEqual(EffectiveCurrency(FToCurrencyId), cmbToCurrency.GetSelectedString());
Assert.AreEqual(expectedDate, dtpEffectiveDate.Date);
Assert.AreEqual(newRate, txtExchangeRate.NumberValueDecimal.Value);
Assert.AreEqual(FAllRowCount - 1, mainScreen.GetSelectedRowIndex());
// Save the changes and check the number of rows now
mainScreen.SaveChanges();
Assert.IsFalse(btnSave.Enabled, "The Save button should be disabled after the new row has been saved");
Assert.AreEqual(13, grdDetails.Rows.Count, "There should be 12 rows in the grid after saving 2 new rows");
mainScreen.Close();
}
public void AddRowToEmptyTable()
{
FMainDS.LoadAll();
FMainDS.DeleteAllRows();
FMainDS.SaveChanges();
TFrmSetupCorporateExchangeRate mainScreen = new TFrmSetupCorporateExchangeRate(null);
mainScreen.RunOnceOnActivation();
mainScreen.Show();
// Toolstrip
ToolStripButton btnSave = (new ToolStripButtonTester("tbbSave", mainScreen)).Properties;
// Grid
TSgrdDataGrid grdDetails = (TSgrdDataGrid)(new TSgrdDataGridPagedTester("grdDetails", mainScreen)).Properties;
// Panel and controls
Panel pnlDetails = (new PanelTester("pnlDetails", mainScreen)).Properties;
ButtonTester btnNew = new ButtonTester("btnNew", mainScreen);
TCmbAutoPopulated cmbFromCurrency = (new TCmbAutoPopulatedTester("cmbDetailFromCurrencyCode", mainScreen)).Properties;
TCmbAutoPopulated cmbToCurrency = (new TCmbAutoPopulatedTester("cmbDetailToCurrencyCode", mainScreen)).Properties;
TtxtPetraDate dtpEffectiveDate = (new TTxtPetraDateTester("dtpDetailDateEffectiveFrom", mainScreen)).Properties;
TTxtNumericTextBox txtExchangeRate = (new TTxtNumericTextBoxTester("txtDetailRateOfExchange", mainScreen)).Properties;
Assert.IsFalse(btnSave.Enabled, "The Save button should be disabled when the screen is loaded");
btnNew.Click();
Assert.IsTrue(btnSave.Enabled, "The Save button should be enabled after adding a new row");
// Work out our expectations
string expectedToCurrency = "USD";
string baseCurrency = GetDefaultBaseCurrency();
if (baseCurrency == "USD")
{
baseCurrency = "GBP";
}
DateTime expectedDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
// Check the details panel after adding the new row
Assert.AreEqual(baseCurrency, cmbFromCurrency.GetSelectedString());
Assert.AreEqual(expectedToCurrency, cmbToCurrency.GetSelectedString());
Assert.AreEqual(expectedDate, dtpEffectiveDate.Date);
Assert.AreEqual(0.0m, txtExchangeRate.NumberValueDecimal);
// Set a valid exchange rate and save
txtExchangeRate.NumberValueDecimal = 2.0m;
mainScreen.SaveChanges();
Assert.IsFalse(btnSave.Enabled, "The Save button should be disabled after the new row has been saved");
// Check the row count in the grid
Assert.AreEqual(3, grdDetails.Rows.Count, "There should be 2 rows in the grid after saving a new row");
// Even though an inverse row has been added we should still be highlighting the newly added row
Assert.AreEqual(baseCurrency, cmbFromCurrency.GetSelectedString());
Assert.AreEqual(expectedToCurrency, cmbToCurrency.GetSelectedString());
Assert.AreEqual(expectedDate, dtpEffectiveDate.Date);
Assert.AreEqual(2.0m, txtExchangeRate.NumberValueDecimal);
// Now select the inverese row
SelectRowInGrid(1);
// Check the details are, in fact, the inverse
Assert.AreEqual(expectedToCurrency, cmbFromCurrency.GetSelectedString());
Assert.AreEqual(baseCurrency, cmbToCurrency.GetSelectedString());
Assert.AreEqual(expectedDate, dtpEffectiveDate.Date);
Assert.AreEqual(0.5m, txtExchangeRate.NumberValueDecimal);
mainScreen.Close();
}
public void LoadTableContainingData()
{
FMainDS.LoadAll();
FMainDS.DeleteAllRows();
FMainDS.InsertStandardRows();
FMainDS.SaveChanges();
TFrmSetupCorporateExchangeRate mainScreen = new TFrmSetupCorporateExchangeRate(null);
mainScreen.Show();
// Toolstrip
ToolStripButton btnSave = (new ToolStripButtonTester("tbbSave", mainScreen)).Properties;
// Grid
TSgrdDataGrid grdDetails = (TSgrdDataGrid)(new TSgrdDataGridPagedTester("grdDetails", mainScreen)).Properties;
// Panel and controls
Panel pnlDetails = (new PanelTester("pnlDetails", mainScreen)).Properties;
TCmbAutoPopulated cmbFromCurrency = (new TCmbAutoPopulatedTester("cmbDetailFromCurrencyCode", mainScreen)).Properties;
TCmbAutoPopulated cmbToCurrency = (new TCmbAutoPopulatedTester("cmbDetailToCurrencyCode", mainScreen)).Properties;
TtxtPetraDate dtpEffectiveDate = (new TTxtPetraDateTester("dtpDetailDateEffectiveFrom", mainScreen)).Properties;
CheckBox chkHideOthers = (new CheckBoxTester("chkHideOthers", mainScreen)).Properties;
// Start of testing...
Assert.IsFalse(btnSave.Enabled, "The Save button should be disabled when the screen is loaded");
Assert.IsTrue(pnlDetails.Enabled, "The Details Panel should be enabled on initial load");
// Check the number of rows in the grid
Assert.AreEqual(FAllRowCount + 1, grdDetails.Rows.Count);
FCurrentDataId = Row2DataId(1);
// Check the content of the details panel matches the last item in standard data (because sorting will have put it first)
Assert.AreEqual(EffectiveCurrency(FFromCurrencyId),
cmbFromCurrency.GetSelectedString(), "The From currency on row 1 should be {0}", EffectiveCurrency(FFromCurrencyId));
Assert.AreEqual(EffectiveCurrency(FToCurrencyId),
cmbToCurrency.GetSelectedString(), "The To currency on row 1 should be {0}", EffectiveCurrency(FToCurrencyId));
Assert.AreEqual(EffectiveDate(), dtpEffectiveDate.Date, "The effective date on row 1 should be {0}", EffectiveDate().ToString());
// Select the second row - which will be the last but one item of standard data
SelectRowInGrid(2);
// Check the details again for this row
Assert.AreEqual(EffectiveCurrency(FFromCurrencyId),
cmbFromCurrency.GetSelectedString(), "The From currency on row 2 should be {0}", EffectiveCurrency(FFromCurrencyId));
Assert.AreEqual(EffectiveCurrency(FToCurrencyId),
cmbToCurrency.GetSelectedString(), "The To currency on row 2 should be {0}", EffectiveCurrency(FToCurrencyId));
Assert.AreEqual(EffectiveDate(), dtpEffectiveDate.Date, "The effective date on row 2 should be {0}", EffectiveDate().ToString());
// Now hide the other currencies
chkHideOthers.Checked = true;
// The number of rows in the grid should have changed
Assert.AreEqual(FHiddenRowCount + 1,
grdDetails.Rows.Count,
"The grid should have {0} rows when the checkbox is checked",
FHiddenRowCount + 1);
// But the details should still be the same
Assert.AreEqual(EffectiveCurrency(FFromCurrencyId),
cmbFromCurrency.GetSelectedString(), "The From currency on row 2 should be {0}", EffectiveCurrency(FFromCurrencyId));
Assert.AreEqual(EffectiveCurrency(FToCurrencyId),
cmbToCurrency.GetSelectedString(), "The To currency on row 2 should be {0}", EffectiveCurrency(FToCurrencyId));
Assert.AreEqual(EffectiveDate(), dtpEffectiveDate.Date, "The effective date on row 2 should be {0}", EffectiveDate().ToString());
Assert.IsFalse(cmbToCurrency.Enabled, "The To Currency should be disabled when the checkbox is checked");
// Uncheck the box and select the last row
chkHideOthers.Checked = false;
SelectRowInGrid(FAllRowCount);
// Check the details - should be the first item of standard data
Assert.AreEqual(EffectiveCurrency(FFromCurrencyId),
cmbFromCurrency.GetSelectedString(), "The From currency on row {0} should be {1}", FAllRowCount, EffectiveCurrency(FFromCurrencyId));
Assert.AreEqual(EffectiveCurrency(FToCurrencyId),
cmbToCurrency.GetSelectedString(), "The To currency on row {0} should be {1}", FAllRowCount, EffectiveCurrency(FToCurrencyId));
Assert.AreEqual(EffectiveDate(), dtpEffectiveDate.Date, "The effective date on row {0} should be {1}", FAllRowCount,
EffectiveDate().ToString());
// Hide other To currencies again - now the selected row will have jumped higher
chkHideOthers.Checked = true;
Assert.AreEqual(FHiddenRowCount,
mainScreen.GetSelectedRowIndex(), "When the checkbox is checked the selected row should be {0}", FHiddenRowCount);
// But the details should again be the same as before the checkbox check
Assert.AreEqual(EffectiveCurrency(FFromCurrencyId),
cmbFromCurrency.GetSelectedString(), "The From currency on row {0} should be {1}", FHiddenRowCount, EffectiveCurrency(FFromCurrencyId));
Assert.AreEqual(EffectiveCurrency(FToCurrencyId),
cmbToCurrency.GetSelectedString(), "The To currency on row {0} should be {1}", FHiddenRowCount, EffectiveCurrency(FToCurrencyId));
Assert.AreEqual(EffectiveDate(), dtpEffectiveDate.Date, "The effective date on row {0} should be {1}", FHiddenRowCount,
EffectiveDate().ToString());
mainScreen.Close();
}
