public BindingSource GetList() { InvestmentDataHelper DH = new InvestmentDataHelper(); BindingSource BS = new BindingSource(); Hashtable HT = new Hashtable(); List <Investment> myList = DH.SelectAll(); try { if (myList != null) { foreach (var item in myList) { if (item.State == EntityState.Enabled) { HT.Add(item.ID, item.Name); } } } HT.Add(-1, "Select Investment"); } catch (NullReferenceException ex) { throw ex; } BS.DataSource = HT; return(BS); }
public BindingList <Investment> Show(Investment aType) { try { var myList = new InvestmentDataHelper().SelectAll(); var bindingList = new BindingList <Investment>(myList); return(bindingList); } catch (ArgumentNullException) { throw new DataExistence("No Data Found! No Investment is yet Added."); } }
public int Add(Investment aType) { int returnValue = -1; int returnKey; SqlConnection con = new ConnectionString().GetConnection(); FinancialTransactionDataHelper financialTransactionH = new FinancialTransactionDataHelper(); FinancialTransaction aTransaction = new FinancialTransaction(); aTransaction.ContactID = aType.InvestorDetails.ID; aTransaction.WalletType = WalletType.Investment; aTransaction.Amount = aType.InHand; aTransaction.FlowType = FlowType.Credit; aTransaction.TransactionType = TransactionType.Cash; aTransaction.TransactionReference = aType.Name + " Has Paid inhand amount"; aTransaction.TransactionDate = DateTime.Now; con.Open(); using (con) { SqlTransaction tran = con.BeginTransaction(); try { returnKey = new InvestmentDataHelper().Insert(aType, tran); aTransaction.WalletReference = returnKey; new FinancialTransactionDataHelper().Insert(aTransaction, tran); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } } returnValue = returnKey; return(returnValue); }
public Investment Show(int SearchbyID) { var mySingleItem = new InvestmentDataHelper().SelectByID(SearchbyID); return(mySingleItem); }
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; } } }