private void SetupGrid()
{
// create a new table
FCriteriaData.Columns.Add(PBankTable.GetPartnerKeyDBName(), Type.GetType("System.Int64"));
FCriteriaData.Columns.Add(BankTDSPBankTable.GetSiteKeyDBName(), Type.GetType("System.Int64"));
FCriteriaData.Columns.Add(BankTDSPBankTable.GetLocationKeyDBName(), Type.GetType("System.Int32"));
FCriteriaData.Columns.Add(PBankTable.GetBranchNameDBName(), Type.GetType("System.String"));
FCriteriaData.Columns.Add(PBankTable.GetBranchCodeDBName(), Type.GetType("System.String"));
FCriteriaData.Columns.Add(PBankTable.GetBicDBName(), Type.GetType("System.String"));
FCriteriaData.Columns.Add(BankTDSPBankTable.GetCityDBName(), Type.GetType("System.String"));
FCriteriaData.Columns.Add(BankTDSPBankTable.GetCountryCodeDBName(), Type.GetType("System.String"));
FCriteriaData.Columns.Add(BankTDSPBankTable.GetStatusCodeDBName(), Type.GetType("System.String"));
FCriteriaData.PrimaryKey = new DataColumn[] {
FCriteriaData.Columns[PBankTable.GetPartnerKeyDBName()],
FCriteriaData.Columns[BankTDSPBankTable.GetSiteKeyDBName()], FCriteriaData.Columns[BankTDSPBankTable.GetLocationKeyDBName()]
};
FCriteriaData.DefaultView.AllowNew = false;
// add columns to the grid
grdDetails.Columns.Clear();
grdDetails.AddTextColumn("Partner Key", FCriteriaData.Columns[PBankTable.GetPartnerKeyDBName()], 80);
grdDetails.AddTextColumn("Bank Name", FCriteriaData.Columns[PBankTable.GetBranchNameDBName()]);
grdDetails.AddTextColumn("Bank/Branch Code", FCriteriaData.Columns[PBankTable.GetBranchCodeDBName()], 120);
grdDetails.AddTextColumn("BIC/SWIFT Code", FCriteriaData.Columns[PBankTable.GetBicDBName()], 110);
grdDetails.AddTextColumn("Status", FCriteriaData.Columns[BankTDSPBankTable.GetStatusCodeDBName()], 70);
grdDetails.AddTextColumn("City", FCriteriaData.Columns[PLocationTable.GetCityDBName()], 80);
grdDetails.AddTextColumn("Country", FCriteriaData.Columns[PLocationTable.GetCountryCodeDBName()], 60);
grdDetails.DoubleClickCell += new TDoubleClickCellEventHandler(grdDetails_DoubleClickCell);
grdDetails.EnterKeyPressed += new TKeyPressedEventHandler(grdDetails_EnterKey);
grdDetails.Selection.FocusRowEntered += new SourceGrid.RowEventHandler(this.FocusedRowChanged);
}
// A new row is selected in the grid
private void FocusedRowChanged(System.Object sender, EventArgs e)
{
if (grdDetails.SelectedDataRows.Length == 1)
{
DataRowView RowDataRowView = (DataRowView)grdDetails.SelectedDataRows[0];
if (RowDataRowView.Row[BankTDSPBankTable.GetStatusCodeDBName()].ToString() !=
SharedTypes.StdPartnerStatusCodeEnumToString(TStdPartnerStatusCode.spscACTIVE))
{
chkShowInactive.Enabled = false;
}
else
{
chkShowInactive.Enabled = true;
}
// Update property with a new selected bank's partner key
FBankPartnerKey = Convert.ToInt64(RowDataRowView.Row[BankTDSPBankTable.GetPartnerKeyDBName()]);
btnAccept.Enabled = true;
btnEdit.Enabled = true;
}
}
private void Filter(System.Object sender, EventArgs e)
{
// Apply filter to the grid
DataView MyDataView = FCriteriaData.DefaultView;
String Filter = "";
if (!string.IsNullOrEmpty(txtBranchName.Text))
{
Filter += FCriteriaData.Columns[PBankTable.GetBranchNameDBName()] + " LIKE '" + txtBranchName.Text + "%'";
}
if (!string.IsNullOrEmpty(txtBranchCode.Text))
{
if (Filter != "")
{
Filter += " AND ";
}
Filter += FCriteriaData.Columns[PBankTable.GetBranchCodeDBName()] + " LIKE '" + txtBranchCode.Text + "%'";
}
if (!string.IsNullOrEmpty(txtBicCode.Text))
{
if (Filter != "")
{
Filter += " AND ";
}
Filter += FCriteriaData.Columns[PBankTable.GetBicDBName()] + " LIKE '" + txtBicCode.Text + "%'";
}
if (!string.IsNullOrEmpty(txtCity.Text))
{
if (Filter != "")
{
Filter += " AND ";
}
Filter += FCriteriaData.Columns[PLocationTable.GetCityDBName()] + " LIKE '" + txtCity.Text + "%'";
}
if (!string.IsNullOrEmpty(txtCountry.Text))
{
if (Filter != "")
{
Filter += " AND ";
}
Filter += FCriteriaData.Columns[PLocationTable.GetCountryCodeDBName()] + " LIKE '" + txtCountry.Text + "%'";
}
if (!chkShowInactive.Checked)
{
if (Filter != "")
{
Filter += " AND ";
}
Filter += FCriteriaData.Columns[BankTDSPBankTable.GetStatusCodeDBName()] + " = '" +
SharedTypes.StdPartnerStatusCodeEnumToString(TStdPartnerStatusCode.spscACTIVE) + "'";
}
MyDataView.RowFilter = Filter;
grdDetails.DataSource = new DevAge.ComponentModel.BoundDataView(MyDataView);
UpdateRecordNumberDisplay();
SelectRowInGrid();
FocusedRowChanged(this, null);
}
// automatically select the currently selected Bank (if it exists)
private void SelectRowInGrid()
{
int RowPos = 1;
// if no bank is selected then no row should be selected
if ((grdDetails.Rows.Count <= 1) || (FBankPartnerKey == 0))
{
// select the first row in the grid
if (grdDetails.Rows.Count > 1)
{
grdDetails.SelectRowWithoutFocus(1);
}
else
{
btnAccept.Enabled = false;
btnEdit.Enabled = false;
}
return;
}
BankTDSPBankRow BankRow = null;
// Multiple rows could have the same partner keys but different locations.
// We just want the first row.
foreach (BankTDSPBankRow Row in FMainDS.PBank.Rows)
{
if (Row.PartnerKey == FBankPartnerKey)
{
BankRow = Row;
break;
}
}
// if current bank is 'inactive' then make sure chkShowInactive is checked (unchecked by default)
if ((BankRow != null) &&
(BankRow.StatusCode != SharedTypes.StdPartnerStatusCodeEnumToString(TStdPartnerStatusCode.spscACTIVE)) &&
(chkShowInactive.Checked == false))
{
chkShowInactive.Checked = true;
}
if (BankRow == null)
{
grdDetails.SelectRowWithoutFocus(1);
}
else
{
// look through each row in the grid
foreach (DataRowView RowView in FCriteriaData.DefaultView)
{
// if current grid row is the row we are looking for the select it
if (Convert.ToInt64(RowView[PBankTable.GetPartnerKeyDBName()]) == FBankPartnerKey)
{
grdDetails.SelectRowWithoutFocus(RowPos);
btnAccept.Enabled = true;
btnEdit.Enabled = true;
return;
}
// account for grid rows being filtered by being inactive
if (chkShowInactive.Checked ||
(!chkShowInactive.Checked &&
(RowView[BankTDSPBankTable.GetStatusCodeDBName()].ToString() ==
SharedTypes.StdPartnerStatusCodeEnumToString(TStdPartnerStatusCode.spscACTIVE))))
{
RowPos++;
}
}
}
}
/// <summary>
/// Load data into grid
/// </summary>
/// <param name="AFirstTime">True if being run for the first time</param>
public void LoadDataGrid(bool AFirstTime)
{
// Only call data from server if the dataset is actually empty.
// (A filled dataset is passed to this screen from the 'Finance Details' tab and 'Find By Bank Details'.)
if ((FMainDS == null) || (FMainDS.PBank.Rows.Count == 0))
{
FMainDS = new BankTDS();
FMainDS.Merge(TRemote.MPartner.Partner.WebConnectors.GetPBankRecords());
}
FCriteriaData.Clear();
if (AFirstTime)
{
// setup the grid on first run
SetupGrid();
}
// create a new row for each bank record
foreach (BankTDSPBankRow BankRow in FMainDS.PBank.Rows)
{
if (BankRow.PartnerKey >= 0)
{
DataRow NewBankRow = FCriteriaData.NewRow();
NewBankRow[PBankTable.GetPartnerKeyDBName()] = BankRow.PartnerKey;
NewBankRow[BankTDSPBankTable.GetCityDBName()] = BankRow.City;
NewBankRow[BankTDSPBankTable.GetCountryCodeDBName()] = BankRow.CountryCode;
NewBankRow[PBankTable.GetBranchNameDBName()] = BankRow.BranchName;
if (BankRow.BranchCode.StartsWith(SharedConstants.INACTIVE_VALUE_WITH_QUALIFIERS + " "))
{
NewBankRow[PBankTable.GetBranchCodeDBName()] = BankRow.BranchCode.Substring(11);
}
else if (BankRow.BranchCode.StartsWith(SharedConstants.INACTIVE_VALUE_WITH_QUALIFIERS))
{
NewBankRow[PBankTable.GetBranchCodeDBName()] = BankRow.BranchCode.Substring(10);
}
else
{
NewBankRow[PBankTable.GetBranchCodeDBName()] = BankRow.BranchCode;
}
NewBankRow[BankTDSPBankTable.GetSiteKeyDBName()] = BankRow.SiteKey;
NewBankRow[BankTDSPBankTable.GetLocationKeyDBName()] = BankRow.LocationKey;
NewBankRow[PBankTable.GetBicDBName()] = BankRow.Bic;
NewBankRow[BankTDSPBankTable.GetStatusCodeDBName()] = BankRow.StatusCode;
FCriteriaData.Rows.Add(NewBankRow);
}
}
// sort order for grid
DataView MyDataView = FCriteriaData.DefaultView;
MyDataView.Sort = "p_branch_name_c ASC";
grdDetails.DataSource = new DevAge.ComponentModel.BoundDataView(MyDataView);
SelectRowInGrid();
FinishButtonPanelSetup();
Filter(this, null);
}
