public List <ListViewItem> GetListView(Deal aDeal) { List <ListViewItem> ListViewItems = new List <ListViewItem>(); InvestmentGroupDetailDataHelper DH = new InvestmentGroupDetailDataHelper(); List <InvestmentGroupDetail> aList = DH.SelectByGroupID(aDeal.InvestmentGroupID); if (aList != null) { foreach (var item in aList) { // Define the list items ListViewItem aListViewItem = new ListViewItem(new InvestmentDataHelper().SelectByID(new InvestmentGroupDetailDataHelper().SelectByID(item.ID).InvestmentID).Name.ToString()); aListViewItem.SubItems.Add(item.InHand.ToString()); aListViewItem.SubItems.Add(item.BackUp.ToString()); aListViewItem.SubItems.Add(item.TotalAmount.ToString()); aListViewItem.SubItems.Add(item.ContributionPercentage.ToString()); // Add the list items to the ListView ListViewItems.Add(aListViewItem); } } return(ListViewItems); }
public void DeductFinancialTransaction(int anInvestmentGroupID) { SqlConnection con = new ConnectionString().GetConnection(); List <InvestmentGroupDetail> anInvestmentGroupDetailList = new List <InvestmentGroupDetail>(); InvestmentGroupDetailDataHelper aInvestmentGroupDetailDH = new InvestmentGroupDetailDataHelper(); Investment anInvestment = new Investment(); Investor anInvestor = new Investor(); FinancialTransactionDataHelper financialTransactionH = new FinancialTransactionDataHelper(); FinancialTransaction aTransaction = new FinancialTransaction(); aTransaction.CascadeChanges = false; con.Open(); using (con) { SqlTransaction tran = con.BeginTransaction(); try { anInvestmentGroupDetailList = aInvestmentGroupDetailDH.SelectByGroupID(anInvestmentGroupID); //Do financial Transaction foreach (var item in anInvestmentGroupDetailList) { if (!item.AmountDeducted) { anInvestment = new InvestmentDataHelper().SelectByID(item.InvestmentID); anInvestor = anInvestment.InvestorDetails; aTransaction.ContactID = anInvestor.ID; aTransaction.WalletType = WalletType.Investment; aTransaction.WalletReference = item.InvestmentID; aTransaction.Amount = item.InHand; aTransaction.FlowType = FlowType.Debit; aTransaction.TransactionType = TransactionType.ApplicationTransfer; aTransaction.TransactionReference = "Transfered to InvestmentGroup"; aTransaction.TransactionDate = DateTime.Now; // Deduct from Investment financialTransactionH.Insert(aTransaction, tran); //------------------------ // Add in InvestmentGroup aTransaction.WalletType = WalletType.InvestmentGroup; aTransaction.WalletReference = item.ID; aTransaction.FlowType = FlowType.Credit; aTransaction.TransactionReference = "Transfered from Investment"; financialTransactionH.Insert(aTransaction, tran); } } //do Update requied Tables aInvestmentGroupDetailDH.UpdateDeductFT(anInvestmentGroupID, tran); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } } }