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