public void AddPortfolio(MSI_Port_Acq_Original portfolioToSave) { string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name); string logMessage = string.Format("{0}|Method incoming parameters Portfolio Number={1}", thisMethod, portfolioToSave.Portfolio_); LogHelper.Info(logMessage); MSI_Port_Acq_OriginalRepository repository = null; try { repository = new MSI_Port_Acq_OriginalRepository(); repository.Add(portfolioToSave); } catch (Exception ex) { ErrorLogHelper.Error(logMessage, ex); } }
public MSI_Port_Acq_Original Save(MSI_Port_Acq_Original inPortfolio) { string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name); string logMessage = string.Format("{0}|Method incoming parameters portfolioNumber={1}", thisMethod, inPortfolio.Portfolio_); LogHelper.Info(logMessage); MSI_Port_Acq_Original portfolioToSave = null; bool editingRequired = true; try { portfolioToSave = Query.GetPortfolioOriginal(inPortfolio.Portfolio_); if (portfolioToSave == null) { editingRequired = false; portfolioToSave = new MSI_Port_Acq_Original(); } portfolioToSave.Portfolio_ = inPortfolio.Portfolio_; portfolioToSave.Company = inPortfolio.Company; portfolioToSave.Cut_OffDate = inPortfolio.Cut_OffDate; portfolioToSave.ClosingDate = inPortfolio.ClosingDate; portfolioToSave.Lender_FileDescription = inPortfolio.Lender_FileDescription; portfolioToSave.Seller = inPortfolio.Seller; portfolioToSave.CostBasis = inPortfolio.CostBasis; portfolioToSave.Face = inPortfolio.Face; portfolioToSave.C_ofAccts = inPortfolio.C_ofAccts; portfolioToSave.PutbackDeadline = inPortfolio.PutbackDeadline; portfolioToSave.PutbackTerm__days_ = inPortfolio.PutbackTerm__days_; portfolioToSave.PurchasePrice = inPortfolio.PurchasePrice; portfolioToSave.ResaleRestrictionId = inPortfolio.ResaleRestrictionId; portfolioToSave.Notes = inPortfolio.Notes; portfolioToSave.CreatedBy = inPortfolio.CreatedBy; portfolioToSave.UpdatedBy = inPortfolio.UpdatedBy; portfolioToSave.CreatedDate = DateTime.Now; portfolioToSave.UpdatedDate = DateTime.Now; if (editingRequired) Query.UpdatePortfolio(portfolioToSave); else Query.AddPortfolio(portfolioToSave); } catch (Exception ex) { ErrorLogHelper.Error(logMessage, ex); } return portfolioToSave; }
public MSI_Port_Acq_Original GetPortfolioPurchaseSummary(string productCode) { MSI_Port_Acq_Original portfolio = null; DBFactory db; System.Data.DataSet ds; System.Data.DataRow dr; try { portfolio = new MSI_Port_Acq_Original(); db = new DBFactory(); ds = db.ExecuteDataset("MSI_sp_GetPortfolioPurchaseSummary", "PurchaseSummary", new SqlParameter("@productCode", productCode)); dr = ds.Tables["PurchaseSummary"].Rows[0]; portfolio.Portfolio_ = dr["Portfolio#"].ToString(); portfolio.Company = dr["Company"].ToString(); portfolio.Seller = dr["Seller"].ToString(); portfolio.CostBasis = Convert.ToDouble(dr["CostBasis"].ToString()); portfolio.Face = Convert.ToDecimal(dr["Face"].ToString()); portfolio.Cut_OffDate = DateTime.Parse(dr["Cut-OffDate"].ToString()); portfolio.C_ofAccts = Convert.ToDouble(dr["#ofAccts"].ToString()); portfolio.PurchasePrice = Convert.ToDecimal(dr["PurchasePrice"].ToString()); DateTime closingDate; if (DateTime.TryParse(dr["ClosingDate"].ToString(), out closingDate)) portfolio.ClosingDate = closingDate; portfolio.Lender_FileDescription = dr["Lender/FileDescription"].ToString(); int putbackTermDays; if (int.TryParse(dr["PutBackTerm"].ToString(), out putbackTermDays)) portfolio.PutbackTerm__days_ = putbackTermDays; DateTime putbackDeadLine; if (DateTime.TryParse(dr["PutbackDeadLine"].ToString(), out putbackDeadLine)) portfolio.PutbackDeadline = putbackDeadLine; portfolio.Notes = dr["Notes"].ToString(); int resaleId; if (int.TryParse(dr["ResaleRestrictionId"].ToString(), out resaleId)) portfolio.ResaleRestrictionId = resaleId; } catch (Exception ex) { } return portfolio; }
public MSI_Port_Acq_Original GetPortfolioPurchaseSummary(string productCode) { string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name); string logMessage = string.Format("{0}|Method incoming parameters productCode={1}", thisMethod, productCode); LogHelper.Info(logMessage); MSI_Port_Acq_Original portfolio = null; DBFactory db; System.Data.DataSet ds; System.Data.DataRow dr; try { portfolio = new MSI_Port_Acq_Original(); db = new DBFactory(); ds = db.ExecuteDataset("MSI_sp_GetPortfolioPurchaseSummary", "PurchaseSummary", new SqlParameter("@productCode", productCode)); dr = ds.Tables["PurchaseSummary"].Rows[0]; portfolio.Portfolio_ = dr["Portfolio#"].ToString(); portfolio.Company = dr["Company"].ToString(); portfolio.Seller = dr["Seller"].ToString(); portfolio.CostBasis = Convert.ToDouble(dr["CostBasis"].ToString()); portfolio.Face = Convert.ToDecimal(dr["Face"].ToString()); portfolio.Cut_OffDate = DateTime.Parse(dr["Cut-OffDate"].ToString()); portfolio.C_ofAccts = Convert.ToDouble(dr["#ofAccts"].ToString()); portfolio.PurchasePrice = Convert.ToDecimal(dr["PurchasePrice"].ToString()); DateTime closingDate; if (DateTime.TryParse(dr["ClosingDate"].ToString(), out closingDate)) portfolio.ClosingDate = closingDate; portfolio.Lender_FileDescription = dr["Lender/FileDescription"].ToString(); int putbackTermDays; if (int.TryParse(dr["PutBackTerm"].ToString(), out putbackTermDays)) portfolio.PutbackTerm__days_ = putbackTermDays; DateTime putbackDeadLine; if (DateTime.TryParse(dr["PutbackDeadLine"].ToString(), out putbackDeadLine)) portfolio.PutbackDeadline = putbackDeadLine; portfolio.Notes = dr["Notes"].ToString(); int resaleId; if (int.TryParse(dr["ResaleRestrictionId"].ToString(), out resaleId)) portfolio.ResaleRestrictionId = resaleId; portfolio.CreatedBy = dr["CreatedBy"].ToString(); portfolio.CreatedDate = DateTime.Parse(dr["CreatedDate"].ToString()); portfolio.UpdatedBy = dr["UpdatedBy"].ToString(); portfolio.UpdatedDate = DateTime.Parse(dr["UpdatedDate"].ToString()); } catch (Exception ex) { ErrorLogHelper.Error(logMessage, ex); } return portfolio; }
public MSI_Port_Acq_Original Post(MSI_Port_Acq_Original inPortfolio) { string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name); string logMessage = string.Format("{0}|Method incoming parameters portfolioNumber={1}", thisMethod, inPortfolio.Portfolio_); LogHelper.Info(logMessage); MSI_Port_Acq_Original portfolioToSave = null; try { portfolioToSave = business.Save(inPortfolio); } catch (Exception ex) { ErrorLogHelper.Error(logMessage, ex); throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(string.Format("Error occur in POST MediaRequest : {0}", ex.Message)) }); } return portfolioToSave; }