public MSI_Port_SalesTrans_Original SaveSalesTransaction(MSI_Port_SalesTrans_Original inTransaction)
{
string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name);
string logMessage = string.Format("{0}|Method incoming parameters id={1}", thisMethod, inTransaction.ID);
LogHelper.Info(logMessage);
MSI_Port_SalesTrans_Original transactionToSave = null;
bool editingRequired = true;
try
{
if (inTransaction.ID == 0)
{
editingRequired = false;
transactionToSave = new MSI_Port_SalesTrans_Original();
}
else{
transactionToSave = Query.GetPortfolioSalesTransactionOriginal(inTransaction.ID);
}
transactionToSave.PutbackDeadline = inTransaction.PutbackDeadline;
transactionToSave.PutbackTerm_days_ = inTransaction.PutbackTerm_days_;
transactionToSave.C_ofAccts = inTransaction.C_ofAccts;
transactionToSave.FaceValue = inTransaction.FaceValue;
transactionToSave.SalesBasis = inTransaction.SalesBasis;
transactionToSave.SalesPrice = inTransaction.SalesPrice;
transactionToSave.Buyer = inTransaction.Buyer;
transactionToSave.Lender = inTransaction.Lender;
transactionToSave.ClosingDate = inTransaction.ClosingDate;
transactionToSave.Cut_OffDate = inTransaction.Cut_OffDate;
transactionToSave.Notes = inTransaction.Notes;
transactionToSave.Portfolio_ = inTransaction.Portfolio_;
transactionToSave.C_ofAccts = inTransaction.C_ofAccts;
transactionToSave.CreatedBy = inTransaction.CreatedBy;
transactionToSave.CreatedDate = DateTime.Now;
transactionToSave.UpdatedBy = inTransaction.UpdatedBy;
transactionToSave.UpdatedDate = DateTime.Now;
if (!editingRequired)
Query.AddSalesTransaction(transactionToSave);
else
Query.UpdateSalesTransaction(transactionToSave);
}
catch (Exception ex)
{
ErrorLogHelper.Error(logMessage, ex);
}
return transactionToSave;
}
public IEnumerable<MSI_Port_SalesTrans_Original> GetPortfolioSalesSummary(string productCode)
{
MSI_Port_SalesTrans_Original salesTransaction = null;
DBFactory db;
List<MSI_Port_SalesTrans_Original> salesTransactions = null;
System.Data.DataSet ds;
try
{
db = new DBFactory();
ds = db.ExecuteDataset("MSI_sp_GetPortfolioSalesSummary", "PurchaseSalesSummary", new SqlParameter("@productCode", productCode));
if (ds.Tables["PurchaseSalesSummary"].Rows.Count > 0)
{
salesTransactions = new List<MSI_Port_SalesTrans_Original>();
foreach (System.Data.DataRow dr in ds.Tables["PurchaseSalesSummary"].Rows)
{
salesTransaction = new MSI_Port_SalesTrans_Original();
salesTransaction.ID = int.Parse(dr["ID"].ToString());
salesTransaction.Portfolio_ = dr["Portfolio#"].ToString();
salesTransaction.Buyer = dr["Buyer"].ToString();
if (dr["SalesBasis"] != DBNull.Value)
salesTransaction.SalesBasis = Convert.ToDouble(dr["SalesBasis"].ToString());
if (dr["FaceValue"] != DBNull.Value)
salesTransaction.FaceValue = Convert.ToDecimal(dr["FaceValue"].ToString());
if (dr["Cut-OffDate"] != DBNull.Value)
salesTransaction.Cut_OffDate = DateTime.Parse(dr["Cut-OffDate"].ToString());
if (dr["#ofAccts"] != DBNull.Value)
salesTransaction.C_ofAccts = Convert.ToDouble(dr["#ofAccts"].ToString());
if (dr["SalesPrice"] != DBNull.Value)
salesTransaction.SalesPrice = Convert.ToDecimal(dr["SalesPrice"].ToString());
DateTime closingDate;
if (DateTime.TryParse(dr["ClosingDate"].ToString(), out closingDate))
salesTransaction.ClosingDate = closingDate;
salesTransaction.Lender = dr["Lender"].ToString();
int putbackTermDays;
if (int.TryParse(dr["PutbackTerm"].ToString(), out putbackTermDays))
salesTransaction.PutbackTerm_days_ = putbackTermDays;
DateTime putbackDeadLine;
if (DateTime.TryParse(dr["PutbackDeadLine"].ToString(), out putbackDeadLine))
salesTransaction.PutbackDeadline = putbackDeadLine;
salesTransaction.Notes = dr["Notes"].ToString();
salesTransactions.Add(salesTransaction);
}
}
}
catch (Exception ex)
{
}
return salesTransactions.AsEnumerable<MSI_Port_SalesTrans_Original>();
}
public IEnumerable<MSI_Port_SalesTrans_Original> GetPortfolioSalesSummary(string productCode, string userId)
{
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_SalesTrans_Original salesTransaction = null;
DBFactory db;
List<MSI_Port_SalesTrans_Original> salesTransactions = null;
System.Data.DataSet ds;
try
{
db = new DBFactory();
ds = db.ExecuteDataset("MSI_sp_GetPortfolioSalesSummary", "PurchaseSalesSummary", new SqlParameter("@productCode", productCode), new SqlParameter("@userId", userId));
if (ds.Tables["PurchaseSalesSummary"].Rows.Count > 0)
{
salesTransactions = new List<MSI_Port_SalesTrans_Original>();
foreach (System.Data.DataRow dr in ds.Tables["PurchaseSalesSummary"].Rows)
{
salesTransaction = new MSI_Port_SalesTrans_Original();
salesTransaction.ID = int.Parse(dr["ID"].ToString());
salesTransaction.Portfolio_ = dr["Portfolio#"].ToString();
salesTransaction.Buyer = dr["Buyer"].ToString();
if (dr["SalesBasis"] != DBNull.Value)
salesTransaction.SalesBasis = Convert.ToDouble(dr["SalesBasis"].ToString());
if (dr["FaceValue"] != DBNull.Value)
salesTransaction.FaceValue = Convert.ToDecimal(dr["FaceValue"].ToString());
if (dr["Cut-OffDate"] != DBNull.Value)
salesTransaction.Cut_OffDate = DateTime.Parse(dr["Cut-OffDate"].ToString());
if (dr["#ofAccts"] != DBNull.Value)
salesTransaction.C_ofAccts = Convert.ToDouble(dr["#ofAccts"].ToString());
if (dr["SalesPrice"] != DBNull.Value)
salesTransaction.SalesPrice = Convert.ToDecimal(dr["SalesPrice"].ToString());
DateTime closingDate;
if (DateTime.TryParse(dr["ClosingDate"].ToString(), out closingDate))
salesTransaction.ClosingDate = closingDate;
salesTransaction.Lender = dr["Lender"].ToString();
int putbackTermDays;
if (int.TryParse(dr["PutbackTerm"].ToString(), out putbackTermDays))
salesTransaction.PutbackTerm_days_ = putbackTermDays;
DateTime putbackDeadLine;
if (DateTime.TryParse(dr["PutbackDeadLine"].ToString(), out putbackDeadLine))
salesTransaction.PutbackDeadline = putbackDeadLine;
salesTransaction.Notes = dr["Notes"].ToString();
DateTime notNullDt;
if (DateTime.TryParse(dr["CreatedDate"].ToString(), out notNullDt))
salesTransaction.CreatedDate = notNullDt;
if (DateTime.TryParse(dr["UpdatedDate"].ToString(), out notNullDt))
salesTransaction.UpdatedDate = notNullDt;
salesTransaction.CreatedBy = dr["CreatedBy"].ToString();
salesTransaction.UpdatedBy = dr["UpdatedBy"].ToString();
salesTransactions.Add(salesTransaction);
}
}
}
catch (Exception ex)
{
ErrorLogHelper.Error(logMessage, ex);
}
return salesTransactions.AsEnumerable<MSI_Port_SalesTrans_Original>();
}
public MSI_Port_SalesTrans_Original UpdateSalesTransaction(MSI_Port_SalesTrans_Original inTransaction)
{
string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name);
string logMessage = string.Format("{0}|Method incoming parameters id={1}", thisMethod, inTransaction.ID);
LogHelper.Info(logMessage);
MSI_Port_SalesTrans_OriginalRepository repository = null;
try
{
repository = new MSI_Port_SalesTrans_OriginalRepository();
repository.Update(inTransaction);
}
catch (Exception ex)
{
ErrorLogHelper.Error(logMessage, ex);
}
return inTransaction;
}
public MSI_Port_SalesTrans_Original Post(MSI_Port_SalesTrans_Original inTransaction)
{
string thisMethod = string.Format("{0}.{1}", thisClass, System.Reflection.MethodBase.GetCurrentMethod().Name);
string logMessage = string.Format("{0}|Method incoming parameters id={1}", thisMethod, inTransaction.ID);
LogHelper.Info(logMessage);
MSI_Port_SalesTrans_Original transactionToSave = null;
try
{
transactionToSave = business.SaveSalesTransaction(inTransaction);
}
catch (Exception ex)
{
ErrorLogHelper.Error(logMessage, ex);
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError)
{
Content = new StringContent(string.Format("Error occur in saving Sales transaction : {0}", ex.Message))
});
}
return transactionToSave;
}
