public IEnumerable<MSI_Port_DistributionTrans> GetPortfolioDistributionSummary(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_DistributionTrans distributionTransaction = null; DBFactory db; List<MSI_Port_DistributionTrans> distributionTransactions = null; System.Data.DataSet ds; try { db = new DBFactory(); ds = db.ExecuteDataset("MSI_sp_GetPortfolioDistributionSummary", "DistributionSummary", new SqlParameter("@productCode", productCode), new SqlParameter("@userId", userId), new SqlParameter("@isOriginal", isOriginal)); if (ds.Tables["DistributionSummary"].Rows.Count > 0) { distributionTransactions = new List<MSI_Port_DistributionTrans>(); foreach (System.Data.DataRow dr in ds.Tables["DistributionSummary"].Rows) { distributionTransaction = new MSI_Port_DistributionTrans(); distributionTransaction.ID = int.Parse(dr["ID"].ToString()); distributionTransaction.Portfolio_ = dr["Portfolio#"].ToString(); if (dr["SalesPrice"] != DBNull.Value) distributionTransaction.SalesPrice = Convert.ToDecimal(dr["SalesPrice"].ToString()); if (dr["Notes"] != DBNull.Value) distributionTransaction.Notes = dr["Notes"].ToString(); if (dr["CheckNo"] != DBNull.Value) distributionTransaction.CheckNo = dr["CheckNo"].ToString(); distributionTransaction.Inv_AgencyName = dr["Inv_AgencyName"].ToString(); DateTime notNullDt; if (DateTime.TryParse(dr["ClosingDate"].ToString(), out notNullDt)) distributionTransaction.ClosingDate = notNullDt; if (DateTime.TryParse(dr["CreatedDate"].ToString(), out notNullDt)) distributionTransaction.CreatedDate = notNullDt; if (DateTime.TryParse(dr["UpdatedDate"].ToString(), out notNullDt)) distributionTransaction.UpdatedDate = notNullDt; distributionTransaction.CreatedBy = dr["CreatedBy"].ToString(); distributionTransaction.UpdatedBy = dr["UpdatedBy"].ToString(); distributionTransactions.Add(distributionTransaction); } } } catch (Exception ex) { ErrorLogHelper.Error(logMessage, ex); } return distributionTransactions.AsEnumerable<MSI_Port_DistributionTrans>(); }
public MSI_Port_DistributionTrans Post(MSI_Port_DistributionTrans inTransaction) { MSI_Port_DistributionTrans transactionToSave = null; MSI_PortDistributionTransRepository repository = null; bool editingRequired = true; try { repository = new MSI_PortDistributionTransRepository(); if (inTransaction.ID == 0) { transactionToSave = new MSI_Port_DistributionTrans(); 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; }