public virtual void CreateRejectedStockNew(RejectedStockNew rejectedStockNew)
{
try
{
Database database = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = database.GetStoredProcCommand("spRejectedStockNewsInsert");
database.AddInParameter(dbCommand, "@NewsTitle", DbType.String, rejectedStockNew.NewsTitle);
database.AddInParameter(dbCommand, "@NewsDescription", DbType.String, rejectedStockNew.NewsDescription);
database.AddInParameter(dbCommand, "@NewsContent", DbType.String, rejectedStockNew.NewsContent);
database.AddInParameter(dbCommand, "@NewsDate", DbType.DateTime, rejectedStockNew.NewsDate);
database.AddInParameter(dbCommand, "@NewsSource", DbType.String, rejectedStockNew.NewsSource);
database.AddInParameter(dbCommand, "@ShareSymbol", DbType.String, rejectedStockNew.ShareSymbol);
database.AddInParameter(dbCommand, "@UseUrl", DbType.Boolean, rejectedStockNew.UseUrl);
database.AddInParameter(dbCommand, "@NewsUrl", DbType.String, rejectedStockNew.NewsUrl);
database.AddInParameter(dbCommand, "@LanguageID", DbType.Int32, rejectedStockNew.LanguageID);
database.AddInParameter(dbCommand, "@IsApproved", DbType.Int32, rejectedStockNew.IsApproved);
database.AddInParameter(dbCommand, "@ImageUrl", DbType.String, rejectedStockNew.ImageUrl);
database.AddInParameter(dbCommand, "@RejectedReason", DbType.String, rejectedStockNew.RejectedReason);
database.AddInParameter(dbCommand, "@LinkId", DbType.Int32, rejectedStockNew.LinkId);
database.AddInParameter(dbCommand, "@OriginalUrl", DbType.String, rejectedStockNew.OriginalUrl);
database.AddInParameter(dbCommand, "@RejectedDate", DbType.DateTime, rejectedStockNew.RejectedDate);
database.AddInParameter(dbCommand, "@NewsId", DbType.Int64, rejectedStockNew.NewsId);
database.ExecuteNonQuery(dbCommand);
//rejectedStockNew.NewsId = (long)database.GetParameterValue(dbCommand, "@NewsId");
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreateRejectedStockNewException, ex);
}
}
public virtual RejectedStockNew CreateRejectedStockNewFromReader(IDataReader reader)
{
RejectedStockNew item = new RejectedStockNew();
try
{
if (!reader.IsDBNull(reader.GetOrdinal("NewsId"))) item.NewsId = (long)reader["NewsId"];
if (!reader.IsDBNull(reader.GetOrdinal("NewsTitle"))) item.NewsTitle = (string)reader["NewsTitle"];
if (!reader.IsDBNull(reader.GetOrdinal("NewsDescription"))) item.NewsDescription = (string)reader["NewsDescription"];
if (!reader.IsDBNull(reader.GetOrdinal("NewsContent"))) item.NewsContent = (string)reader["NewsContent"];
if (!reader.IsDBNull(reader.GetOrdinal("NewsDate"))) item.NewsDate = (DateTime)reader["NewsDate"];
if (!reader.IsDBNull(reader.GetOrdinal("NewsSource"))) item.NewsSource = (string)reader["NewsSource"];
if (!reader.IsDBNull(reader.GetOrdinal("ShareSymbol"))) item.ShareSymbol = (string)reader["ShareSymbol"];
if (!reader.IsDBNull(reader.GetOrdinal("UseUrl"))) item.UseUrl = (bool)reader["UseUrl"];
if (!reader.IsDBNull(reader.GetOrdinal("NewsUrl"))) item.NewsUrl = (string)reader["NewsUrl"];
if (!reader.IsDBNull(reader.GetOrdinal("LanguageID"))) item.LanguageID = (int)reader["LanguageID"];
if (!reader.IsDBNull(reader.GetOrdinal("IsApproved"))) item.IsApproved = (int)reader["IsApproved"];
if (!reader.IsDBNull(reader.GetOrdinal("ImageUrl"))) item.ImageUrl = (string)reader["ImageUrl"];
if (!reader.IsDBNull(reader.GetOrdinal("RejectedReason"))) item.RejectedReason = (string)reader["RejectedReason"];
if (!reader.IsDBNull(reader.GetOrdinal("LinkId"))) item.LinkId = (int)reader["LinkId"];
if (!reader.IsDBNull(reader.GetOrdinal("OriginalUrl"))) item.OriginalUrl = (string)reader["OriginalUrl"];
if (!reader.IsDBNull(reader.GetOrdinal("RejectedDate"))) item.RejectedDate = (DateTime)reader["RejectedDate"];
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreateRejectedStockNewFromReaderException, ex);
}
return item;
}
public static void UpdateRejectedStockNew(RejectedStockNew rejectedStockNew)
{
try
{
RejectedStockNewDAO rejectedStockNewDAO = new RejectedStockNewDAO();
rejectedStockNewDAO.UpdateRejectedStockNew(rejectedStockNew);
}
catch (ApplicationException)
{
throw;
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.BusinessUpdateRejectedStockNewException, ex);
}
}
private void StoreToRejectedNews(StockNew stockNew)
{
RejectedStockNew rejectedStockNew = new RejectedStockNew();
rejectedStockNew.NewsId = stockNew.NewsId;
rejectedStockNew.NewsDate = stockNew.NewsDate;
rejectedStockNew.NewsTitle = stockNew.NewsTitle;
rejectedStockNew.NewsDescription = stockNew.NewsDescription;
rejectedStockNew.NewsContent = stockNew.NewsContent;
rejectedStockNew.NewsSource = stockNew.NewsSource;
rejectedStockNew.ShareSymbol = stockNew.ShareSymbol;
rejectedStockNew.UseUrl = stockNew.UseUrl;
rejectedStockNew.NewsUrl = stockNew.NewsUrl;
rejectedStockNew.LanguageID = stockNew.LanguageID;
rejectedStockNew.ImageUrl = stockNew.ImageUrl;
rejectedStockNew.LinkId = stockNew.LinkId;
rejectedStockNew.OriginalUrl = stockNew.OriginalUrl;
rejectedStockNew.RejectedDate = DateTime.Now;
RejectedStockNewService.CreateRejectedStockNew(rejectedStockNew);
}