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 BindingSource GetList(Investor anInvestor) { InvestmentGroupDetailDataHelper DH = new InvestmentGroupDetailDataHelper(); BindingSource BS = new BindingSource(); Hashtable HT = new Hashtable(); List <InvestmentGroupDetail> myList = DH.SelectByInvestorID(anInvestor.ID); try { if (myList != null) { foreach (var item in myList) { if (item.State == EntityState.Enabled) { HT.Add(item.ID, item.ID); } } } HT.Add(-1, "Select Grouped Investment"); } catch (NullReferenceException ex) { throw ex; } BS.DataSource = HT; return(BS); }
public BindingList <InvestmentGroupDetail> Show(InvestmentGroup aType) { try { var myList = new InvestmentGroupDetailDataHelper().SelectByGroupID(aType.ID); var bindingList = new BindingList <InvestmentGroupDetail>(myList); return(bindingList); } catch (ArgumentNullException) { throw new DataExistence("No Data Found! No Members are avialable in selected Investment group."); } }
public BindingList <InvestmentGroupDetail> Show(InvestmentGroupDetail aType) { try { var myList = new InvestmentGroupDetailDataHelper().SelectAll(); var bindingList = new BindingList <InvestmentGroupDetail>(myList); return(bindingList); } catch (ArgumentNullException) { throw new DataExistence("No Data Found! No Members are yet added in Investment group."); } }
public int Add(InvestmentGroupDetail aType) { int returnValue = -1; try { returnValue = new InvestmentGroupDetailDataHelper().Insert(aType); DataInserted(this, new EventArgs()); } catch (SqlException ex) { throw ex; } return(returnValue); }
public int Add(FinancialTransaction aTransaction) { int returnValue = -1; SqlConnection con = new ConnectionString().GetConnection(); con.Open(); using (con) { SqlTransaction tran = con.BeginTransaction(); try { returnValue = new FinancialTransactionDataHelper().Insert(aTransaction, tran); if (aTransaction.CascadeChanges) { if (aTransaction.WalletType == WalletType.Investment) { #region Insert in Investment Investment anInvestment = new Investment(); Investor anInvestor = new Investor(); anInvestment.ID = aTransaction.WalletReference; anInvestor.ID = aTransaction.ContactID; anInvestment.InvestorDetails = anInvestor; anInvestment.InHand = (aTransaction.FlowType == FlowType.Debit) ? aTransaction.Amount * -1 : aTransaction.Amount; new InvestmentDataHelper().Update(anInvestment.ID, anInvestment, tran); #endregion Insert in Investment } else if (aTransaction.WalletType == WalletType.InvestmentGroup) { InvestmentGroupDetailDataHelper anInvestmentGroupDetailDH = new InvestmentGroupDetailDataHelper(); InvestmentGroupDetail aInvestmentGroupDetail = new InvestmentGroupDetail(); int ainvestmentID = anInvestmentGroupDetailDH.SelectByID(aTransaction.WalletReference, tran).InvestmentID; aInvestmentGroupDetail.AmountDeducted = true; aInvestmentGroupDetail.ID = aTransaction.WalletReference; aInvestmentGroupDetail.InHand = (aTransaction.FlowType == FlowType.Debit) ? aTransaction.Amount * -1 : aTransaction.Amount; //Update Investment/Group Tables anInvestmentGroupDetailDH.Update(aInvestmentGroupDetail.ID, aInvestmentGroupDetail, tran); aTransaction.WalletType = WalletType.Investment; //aInvestmentGroupDetail = anInvestmentGroupDetailDH.SelectByID(aTransaction.WalletReference,tran).InvestmentID; aTransaction.WalletReference = ainvestmentID; //aInvestmentGroupDetail.InvestmentID; aTransaction.FlowType = (aTransaction.FlowType == FlowType.Debit) ? FlowType.Credit : FlowType.Debit; //double entry rule, 2nd entry in Investment Account new FinancialTransactionDataHelper().Insert(aTransaction, tran); } } tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } } return(returnValue); }
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; } } }