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;
}