public static DataTable setupDataTable(List <PFI_TransitionData> TransitionDatas, ref int iTagCount, ref decimal dCosts) { iTagCount = 0; dCosts = 0.00M; var myTable = new DataTable(); myTable.Columns.Add("colRefurb"); myTable.Columns.Add("colAssignmentType"); myTable.Columns.Add("colNumber"); myTable.Columns.Add("colDescription"); myTable.Columns.Add("colTags"); myTable.Columns.Add("colCost"); myTable.Columns.Add("colRetail"); myTable.Columns.Add("colReason"); foreach (PFI_TransitionData transitionData in TransitionDatas) { PFI_ProductData pawnLoan = transitionData.pfiLoan; foreach (Item pawnItem in pawnLoan.UpdatedObject.Items) { if (pawnItem.RefurbNumber > 0) { DataRow myRow = myTable.NewRow(); myRow["colRefurb"] = pawnItem.RefurbNumber; myRow["colAssignmentType"] = Commons.GetPfiAssignmentAbbreviation(pawnItem.PfiAssignmentType); myRow["colNumber"] = pawnLoan.UpdatedObject.TicketNumber; myRow["colDescription"] = pawnItem.TicketDescription; myRow["colTags"] = pawnItem.PfiTags; myRow["colCost"] = String.Format("{0:C}", pawnItem.ItemAmount); myRow["colRetail"] = String.Format("{0:C}", pawnItem.RetailPrice); ItemReasonCode reasonCode = ItemReasonFactory.Instance.FindByReason(pawnItem.ItemReason); if (reasonCode != null) { myRow["colReason"] = reasonCode.Description; } myTable.Rows.Add(myRow); iTagCount += Utilities.GetIntegerValue(pawnItem.PfiTags, 0); dCosts += Utilities.GetDecimalValue(pawnItem.ItemAmount, 0.00M); } } } return(myTable); }
public static DataTable setupDataTable(List <PFI_TransitionData> TransitionDatas, ref int iTagCount, ref decimal dCosts) { iTagCount = 0; dCosts = 0.00M; List <ItemReasonCode> reasonCodes = ItemReasonFactory.Instance.GetChargeOffCodes(GlobalDataAccessor.Instance.DesktopSession.PawnSecApplication); DataTable myTable = new DataTable(); myTable.Columns.Add("colNumber"); myTable.Columns.Add("colDescription"); myTable.Columns.Add("colTags"); myTable.Columns.Add("colCost"); myTable.Columns.Add("colRetail"); myTable.Columns.Add("colReason"); foreach (PFI_TransitionData transitionData in TransitionDatas) { PFI_ProductData pawnLoan = transitionData.pfiLoan; foreach (Item pawnItem in pawnLoan.UpdatedObject.Items) { if (reasonCodes.FindIndex(rc => rc.Reason == pawnItem.ItemReason) >= 0) { DataRow myRow = myTable.NewRow(); myRow["colNumber"] = pawnLoan.UpdatedObject.TicketNumber; myRow["colDescription"] = pawnItem.TicketDescription; myRow["colTags"] = pawnItem.PfiTags; myRow["colCost"] = String.Format("{0:C}", pawnItem.ItemAmount); myRow["colRetail"] = String.Format("{0:C}", pawnItem.RetailPrice); ItemReasonCode reasonCode = ItemReasonFactory.Instance.FindByReason(pawnItem.ItemReason); if (reasonCode != null) { myRow["colReason"] = reasonCode.Description; } myTable.Rows.Add(myRow); iTagCount += Utilities.GetIntegerValue(pawnItem.PfiTags, 0); dCosts += Utilities.GetDecimalValue(pawnItem.ItemAmount, 0.00M); } } } return(myTable); }