public IEnumerable<MSI_Port_InterestTrans> GetPortfolioInterestSummary(string productCode, string userId, bool isOriginal) { string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name); string logMessage = string.Format("{0}|Method incoming parameters productCode={1}, userId={2}", thisMethod, productCode, userId); LogHelper.Info(logMessage); MSI_Port_InterestTrans interestTransaction = null; DBFactory db; List<MSI_Port_InterestTrans> interestTransactions = null; System.Data.DataSet ds; try { db = new DBFactory(); ds = db.ExecuteDataset("MSI_sp_GetPortfolioInterestSummary", "InterestSummary", new SqlParameter("@productCode", productCode), new SqlParameter("@userId", userId), new SqlParameter("@isOriginal", isOriginal)); if (ds.Tables["InterestSummary"].Rows.Count > 0) { interestTransactions = new List<MSI_Port_InterestTrans>(); foreach (System.Data.DataRow dr in ds.Tables["InterestSummary"].Rows) { interestTransaction = new MSI_Port_InterestTrans(); interestTransaction.ID = int.Parse(dr["ID"].ToString()); interestTransaction.Portfolio_ = dr["Portfolio#"].ToString(); if (dr["SalesPrice"] != DBNull.Value) interestTransaction.SalesPrice = Convert.ToDecimal(dr["SalesPrice"].ToString()); if (dr["Notes"] != DBNull.Value) interestTransaction.Notes = dr["Notes"].ToString(); if (dr["CheckNo"] != DBNull.Value) interestTransaction.CheckNo = dr["CheckNo"].ToString(); interestTransaction.Inv_AgencyName = dr["Inv_AgencyName"].ToString(); DateTime notNullDt; if (DateTime.TryParse(dr["ClosingDate"].ToString(), out notNullDt)) interestTransaction.ClosingDate = notNullDt; if (DateTime.TryParse(dr["CreatedDate"].ToString(), out notNullDt)) interestTransaction.CreatedDate = notNullDt; if (DateTime.TryParse(dr["UpdatedDate"].ToString(), out notNullDt)) interestTransaction.UpdatedDate = notNullDt; interestTransaction.CreatedBy = dr["CreatedBy"].ToString(); interestTransaction.UpdatedBy = dr["UpdatedBy"].ToString(); interestTransactions.Add(interestTransaction); } } } catch (Exception ex) { ErrorLogHelper.Error(logMessage, ex); } return interestTransactions.AsEnumerable<MSI_Port_InterestTrans>(); }
public MSI_Port_InterestTrans Post(MSI_Port_InterestTrans inTransaction) { MSI_Port_InterestTrans transactionToSave = null; MSI_PortInterestTransRepository repository = null; bool editingRequired = true; try { repository = new MSI_PortInterestTransRepository(); if (inTransaction.ID == 0) { transactionToSave = new MSI_Port_InterestTrans(); transactionToSave.Portfolio_ = inTransaction.Portfolio_; editingRequired = false; } else { transactionToSave = repository.GetById(inTransaction.ID); if (inTransaction.IsOriginal.Value) editingRequired = true; if (!inTransaction.IsOriginal.Value) { if (transactionToSave.IsOriginal.Value) editingRequired = false; else editingRequired = true; } } transactionToSave.SalesPrice = inTransaction.SalesPrice; transactionToSave.CheckNo = inTransaction.CheckNo; transactionToSave.Notes = inTransaction.Notes; transactionToSave.Inv_AgencyName = inTransaction.Inv_AgencyName; transactionToSave.IsOriginal = inTransaction.IsOriginal; transactionToSave.ClosingDate = inTransaction.ClosingDate; if (editingRequired) repository.Update(transactionToSave); else repository.Add(transactionToSave); } catch (Exception ex) { } return transactionToSave; }