//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();
}
