public virtual ApprovedStockNew CreateApprovedStockNewFromReader(IDataReader reader)
{
ApprovedStockNew item = new ApprovedStockNew();
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("Comment"))) item.Comment = (string)reader["Comment"];
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("ApprovedDate"))) item.ApprovedDate = (DateTime)reader["ApprovedDate"];
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreateApprovedStockNewFromReaderException, ex);
}
return item;
}
public virtual void CreateApprovedStockNew(ApprovedStockNew approvedStockNew)
{
try
{
Database database = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = database.GetStoredProcCommand("spApprovedStockNewsInsert");
database.AddInParameter(dbCommand, "@NewsTitle", DbType.String, approvedStockNew.NewsTitle);
database.AddInParameter(dbCommand, "@NewsDescription", DbType.String, approvedStockNew.NewsDescription);
database.AddInParameter(dbCommand, "@NewsContent", DbType.String, approvedStockNew.NewsContent);
database.AddInParameter(dbCommand, "@NewsDate", DbType.DateTime, approvedStockNew.NewsDate);
database.AddInParameter(dbCommand, "@NewsSource", DbType.String, approvedStockNew.NewsSource);
database.AddInParameter(dbCommand, "@ShareSymbol", DbType.String, approvedStockNew.ShareSymbol);
database.AddInParameter(dbCommand, "@UseUrl", DbType.Boolean, approvedStockNew.UseUrl);
database.AddInParameter(dbCommand, "@NewsUrl", DbType.String, approvedStockNew.NewsUrl);
database.AddInParameter(dbCommand, "@LanguageID", DbType.Int32, approvedStockNew.LanguageID);
database.AddInParameter(dbCommand, "@IsApproved", DbType.Int32, approvedStockNew.IsApproved);
database.AddInParameter(dbCommand, "@ImageUrl", DbType.String, approvedStockNew.ImageUrl);
database.AddInParameter(dbCommand, "@Comment", DbType.String, approvedStockNew.Comment);
database.AddInParameter(dbCommand, "@LinkId", DbType.Int32, approvedStockNew.LinkId);
database.AddInParameter(dbCommand, "@OriginalUrl", DbType.String, approvedStockNew.OriginalUrl);
database.AddInParameter(dbCommand, "@ApprovedDate", DbType.DateTime, approvedStockNew.ApprovedDate);
database.AddInParameter(dbCommand, "@NewsId", DbType.Int64, approvedStockNew.NewsId);
database.ExecuteNonQuery(dbCommand);
//approvedStockNew.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.DataAccessCreateApprovedStockNewException, ex);
}
}
public static void UpdateApprovedStockNew(ApprovedStockNew approvedStockNew)
{
try
{
ApprovedStockNewDAO approvedStockNewDAO = new ApprovedStockNewDAO();
approvedStockNewDAO.UpdateApprovedStockNew(approvedStockNew);
}
catch (ApplicationException)
{
throw;
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.BusinessUpdateApprovedStockNewException, ex);
}
}
private void StoredToApprovedNews(StockNew stockNew)
{
ApprovedStockNew approvedStockNew = new ApprovedStockNew();
approvedStockNew.NewsId = stockNew.NewsId;
approvedStockNew.NewsDate = stockNew.NewsDate;
approvedStockNew.NewsTitle = stockNew.NewsTitle;
approvedStockNew.NewsDescription = stockNew.NewsDescription;
approvedStockNew.NewsContent = stockNew.NewsContent;
approvedStockNew.NewsSource = stockNew.NewsSource;
approvedStockNew.ShareSymbol = stockNew.ShareSymbol;
approvedStockNew.UseUrl = stockNew.UseUrl;
approvedStockNew.NewsUrl = stockNew.NewsUrl;
approvedStockNew.LanguageID = stockNew.LanguageID;
approvedStockNew.ImageUrl = stockNew.ImageUrl;
approvedStockNew.LinkId = stockNew.LinkId;
approvedStockNew.OriginalUrl = stockNew.OriginalUrl;
approvedStockNew.ApprovedDate = DateTime.Now;
ApprovedStockNewService.CreateApprovedStockNew(approvedStockNew);
}
