//Aggregated Account Display Methods
private void loadlstTransactions()
{
// Create an instance of a ListView column sorter and assign it
// to the ListView control.
lvwColumnSorter = new ListViewColumnSorter();
this.lstTransactions.ListViewItemSorter = lvwColumnSorter;
lstTransactions.BeginUpdate();
lstTransactions.Clear();
buildlstTransactionsColumns();
if (!dbcTransactions.isEmpty())
{
int recordCount = 0;
foreach (DataRow row in dbcTransactions.getDT().Rows)
{
ListViewItem listItem = new ListViewItem(row["refTransTypeDesc"].ToString());
listItem.Name = recordCount + "!" + row["TransID"].ToString(); //
listItem.SubItems.Add(row["refTransTypeSubDesc"].ToString()); //
if (row["EmpID"].ToString() != "") //Harry 01062016
{
var names = row["VendName"].ToString().TrimEnd().Split(' ');
string lastName;
if (names[names.Length - 1].IndexOf('(') != -1)
{
lastName = names[names.Length - 2];
}
else
{
lastName = names[names.Length - 1];
}
//string temp = lastName + " " + row["VendName"].ToString().Replace(lastName, "");
listItem.SubItems.Add(lastName + ", " + row["VendName"].ToString().Replace(lastName, ""));
}
else
{
listItem.SubItems.Add(row["VendName"].ToString());
}
listItem.SubItems.Add(row["EmpUIN"].ToString());
listItem.SubItems.Add(row["PostingDate"].ToString()); //
// listItem.SubItems.Add(row["TransactionDate"].ToString()); //
listItem.SubItems.Add(row["theUnitID"].ToString()); //
listItem.SubItems.Add(row["FundType"].ToString() + " " + row["DeptID"].ToString() + " " + row["FundProject"].ToString() + " " + row["FundClass"].ToString()); //
listItem.SubItems.Add(row["GL"].ToString());
listItem.SubItems.Add(String.Format(nfi, "{0:c}", double.Parse(UtilityParser.passEmptyNumber(row["TransAmount"].ToString())))); //
listItem.SubItems.Add(String.Format(nfi, "{0:c}", double.Parse(UtilityParser.passEmptyNumber(row["TransAmountRemainder"].ToString())))); //
listItem.SubItems.Add(row["TransDesc"].ToString()); //
listItem.SubItems.Add(row["StatusDesc"].ToString()); //
listItem.SubItems.Add(row["TransBiReference"].ToString());
listItem.SubItems.Add(UtilityDates.convertFormatedDateToSortableString(row["PostingDate"].ToString()));
// listItem.SubItems.Add(UtilityDates.convertFormatedDateToSortableString(row["TransactionDate"].ToString()));
listItem.SubItems.Add(row["TransAmount"].ToString().PadLeft(12, '0'));
listItem.SubItems.Add(row["TransAmountRemainder"].ToString().PadLeft(12, '0'));
lstTransactions.Items.Add(listItem);
recordCount++;
}
}
lstTransactions.EndUpdate();
this.Cursor = Cursors.Default;
}
//method to take row information and put it into a string sequence
private String dataRowToString(DataRow row)
{
String strReturn = row["refTransTypeSubDesc"].ToString() + "\t" +
row["StatusDesc"].ToString() + "\t" +
row["UnitID"].ToString() + " " + row["DeptID"].ToString() + " " + row["FundType"].ToString() + "\t" +
row["FundProject"].ToString() + "\t" +
row["FundClass"].ToString() + "\t" +
row["VendName"].ToString() + "\t" +
row["EmpUIN"].ToString() + "\t" +
UtilityParser.parseNullDate(DateTime.Parse(row["TransDatePosting"].ToString()).ToShortDateString()) + "\t" +
UtilityDates.translateDateToPeriod(DateTime.Parse(row["TransDatePosting"].ToString())) + "\t" +
UtilityParser.parseNullDate(DateTime.Parse(row["TransDateTransaction"].ToString()).ToShortDateString()) + "\t" +
String.Format(nfi, "{0:c}", double.Parse(row["TransAmount"].ToString())) + "\t" +
String.Format(nfi, "{0:c}", double.Parse(row["TransAmountRemainder"].ToString())) + "\t" +
row["TransDesc"].ToString() + "\t" +
row["GLNumber"].ToString() + "\n";
return(strReturn);
}
private void loadlstTransactions()
{
if (dbcTransactions.isEmpty())
{
return;
}
// Create an instance of a ListView column sorter and assign it
// to the ListView control.
lvwColumnSorter = new ListViewColumnSorter();
this.lstTransactions.ListViewItemSorter = lvwColumnSorter;
lstTransactions.BeginUpdate();
lstTransactions.Clear();
buildlstTransactionsColumns();
int i = 0;
foreach (DataRow row in dbcTransactions.getDT().Rows)
{
ListViewItem listItem = new ListViewItem(row["refTransTypeSubDesc"].ToString());
listItem.Name = i.ToString(); // index for record in dbConnector
listItem.SubItems.Add(row["StatusDesc"].ToString()); // Status
listItem.SubItems.Add(row["UnitID"].ToString() + " " +
row["DeptID"].ToString() + " " +
row["FundType"].ToString());
listItem.SubItems.Add(row["FundProject"].ToString()); // Status
listItem.SubItems.Add(row["FundClass"].ToString()); // Status
listItem.SubItems.Add(row["VendName"].ToString()); // Status
listItem.SubItems.Add(row["EmpUIN"].ToString()); // Status
listItem.SubItems.Add(UtilityParser.parseNullDate(DateTime.Parse(row["TransDatePosting"].ToString()).ToShortDateString())); // Unit
listItem.SubItems.Add(UtilityParser.parseNullDate(DateTime.Parse(row["TransDateTransaction"].ToString()).ToShortDateString())); // Status
listItem.SubItems.Add(String.Format(nfi, "{0:c}", double.Parse(row["TransAmount"].ToString()))); // Unit
listItem.SubItems.Add(String.Format(nfi, "{0:c}", double.Parse(row["TransAmountRemainder"].ToString()))); // Unit
listItem.SubItems.Add(row["TransDesc"].ToString()); // Description
listItem.SubItems.Add(row["GLNumber"].ToString()); // GL
lstTransactions.Items.Add(listItem);
i++; //increment i to track new index for next record
}
lstTransactions.EndUpdate();
}
