public virtual stock_NewsGroup Createstock_NewsGroupFromReader(IDataReader reader) { stock_NewsGroup item = new stock_NewsGroup(); try { if (!reader.IsDBNull(reader.GetOrdinal("ID"))) item.ID = (int)reader["ID"]; if (!reader.IsDBNull(reader.GetOrdinal("NewsID"))) item.NewsID = (int)reader["NewsID"]; if (!reader.IsDBNull(reader.GetOrdinal("NewsGroup"))) item.NewsGroup = (int)reader["NewsGroup"]; } catch (Exception ex) { // log this exception log4net.Util.LogLog.Error(ex.Message, ex); // wrap it and rethrow throw new ApplicationException(SR.DataAccessCreatestock_NewsGroupFromReaderException, ex); } return item; }
public static void Updatestock_NewsGroup(stock_NewsGroup stock_NewsGroup) { try { stock_NewsGroupDAO stock_NewsGroupDAO = new stock_NewsGroupDAO(); stock_NewsGroupDAO.Updatestock_NewsGroup(stock_NewsGroup); } catch (ApplicationException) { throw; } catch (Exception ex) { // log this exception log4net.Util.LogLog.Error(ex.Message, ex); // wrap it and rethrow throw new ApplicationException(SR.BusinessUpdatestock_NewsGroupException, ex); } }
public virtual void Updatestock_NewsGroup(stock_NewsGroup stock_NewsGroup) { try { //Database database = DatabaseFactory.CreateDatabase(); Database database = DatabaseFactory.CreateDatabase("DestinationConnection"); DbCommand dbCommand = database.GetStoredProcCommand("spstock_NewsGroupsUpdate"); database.AddInParameter(dbCommand, "@ID", DbType.Int32, stock_NewsGroup.ID); database.AddInParameter(dbCommand, "@NewsID", DbType.Int32, stock_NewsGroup.NewsID); database.AddInParameter(dbCommand, "@NewsGroup", DbType.Int32, stock_NewsGroup.NewsGroup); database.ExecuteNonQuery(dbCommand); } catch (Exception ex) { // log this exception log4net.Util.LogLog.Error(ex.Message, ex); // wrap it and rethrow throw new ApplicationException(SR.DataAccessUpdatestock_NewsGroupException, ex); } }
public bool FeedItemIntoWebSite(Int16 sourceId) { bool returnVal = true; StockNewCollection stockNewCollection; DestinationEntities.stock_New stockNewDestination = new DestinationEntities.stock_New(); DestinationEntities.stock_NewsGroup stock_NewsGroupDestination = new DestinationEntities.stock_NewsGroup(); DestinationEntities.stock_NewsGroup stock_NewsGroupHome = new DestinationEntities.stock_NewsGroup(); Int32 totalRows = 0; int pos, symbolId; Int32 newGroupId; newGroupId = 2; //nhom tin cong bo thong tin try { stockNewCollection = StockNewService.GetStockNewListBySource(sourceId, StockNewColumns.NewsId, "ASC", 1, 10, out totalRows); foreach (StockNew stockNew in stockNewCollection) { stockNewDestination.NewsTitle = stockNew.NewsTitle; stockNewDestination.NewsDescription = stockNew.NewsDescription; stockNewDestination.NewsContent = stockNew.NewsContent; stockNewDestination.NewsDate = DateTime.Now.AddHours(-7); stockNewDestination.IsApproved = true; stockNewDestination.LanguageID = 2;// should be dymamic stockNewDestination.NewsSource = stockNew.NewsSource; pos = stockNewDestination.NewsTitle.Trim().IndexOf(':'); symbolId = 0; if (pos > 0) symbolId = GetStockSymbolId(stockNewDestination.NewsTitle.Substring(0, pos)); if (symbolId > 0) { stockNew.ShareSymbol = stockNewDestination.NewsTitle.Substring(0, pos); } stockNewDestination.SymbolID = (symbolId > 0 ? symbolId : new int()); DestinationBusiness.stock_NewService.Createstock_New(stockNewDestination); stock_NewsGroupDestination.NewsID = stockNewDestination.NewsID; stock_NewsGroupDestination.NewsGroup = newGroupId; DestinationBusiness.stock_NewsGroupService.Createstock_NewsGroup(stock_NewsGroupDestination); stock_NewsGroupHome.NewsID = stockNewDestination.NewsID; stock_NewsGroupHome.NewsGroup = 5; DestinationBusiness.stock_NewsGroupService.Createstock_NewsGroup(stock_NewsGroupHome); Ultility.Error("stock id: " + stockNew.NewsId.ToString()); StoredToApprovedNews(stockNew); StockNewService.DeleteStockNew((int)stockNew.NewsId); } } catch (Exception ex) { Ultility.Error(ex.InnerException); returnVal = false; } return returnVal; }
private void ApprovedNewStockList() { Int32 totalRows; string stockNewItemStringId; stockNewCollection = StockNewService.GetStockNewList(linkId, StockNewColumns.NewsId, "DESC", this.topPaging.CurrentIndex, ApplicationHelper.PageSize, out totalRows); foreach (StockNew stockNewItem in stockNewCollection) { stockNewItemStringId = Request.Form["selectedItem_" + Convert.ToString(stockNewItem.NewsId)]; if (stockNewItemStringId != null) { selectedItems = selectedItems + "," + stockNewItemStringId; } } selectedItems = selectedItems.Substring(1,(selectedItems.Length)-1); string selectedItemsGroupNews = Request.Form["selectedGroupNewsItem"]; int pos, symbolId; Int32 stockId; Int32 newGroupId; if (selectedItems == string.Empty || selectedItems == null) return; foreach (string selectedItemId in selectedItems.Split(',')) { stockId = Convert.ToInt32(selectedItemId); newGroupId = Convert.ToInt32(Request.Form["newsCategorySelect_" + stockId.ToString()]); StockNew stockNew = StockNewService.GetStockNew(stockId); stock_New stockNewDestination = new stock_New(); stock_NewsGroup stock_NewsGroupDestination = new stock_NewsGroup(); stock_NewsGroup stock_NewsGroupHome = new stock_NewsGroup(); stockNewDestination.NewsTitle = stockNew.NewsTitle; stockNewDestination.NewsDescription = stockNew.NewsDescription; stockNewDestination.NewsContent = stockNew.NewsContent; stockNewDestination.NewsDate = DateTime.Now.AddHours(-7); stockNewDestination.IsApproved = true; stockNewDestination.LanguageID = 2;// should be dymamic stockNewDestination.NewsSource = stockNew.NewsSource; pos = stockNewDestination.NewsTitle.Trim().IndexOf(':'); symbolId = 0; if (pos > 0) symbolId = GetStockSymbolId(stockNewDestination.NewsTitle.Substring(0, pos)); if (symbolId > 0) { stockNew.ShareSymbol = stockNewDestination.NewsTitle.Substring(0, pos); } stockNewDestination.SymbolID = (symbolId > 0 ? symbolId : new int()); stock_NewService.Createstock_New(stockNewDestination); stock_NewsGroupDestination.NewsID = stockNewDestination.NewsID; stock_NewsGroupDestination.NewsGroup = newGroupId; stock_NewsGroupService.Createstock_NewsGroup(stock_NewsGroupDestination); if (selectedItemsGroupNews != null) { if (selectedItemsGroupNews.IndexOf(selectedItemId) >= 0) { stock_NewsGroupHome.NewsID = stockNewDestination.NewsID; stock_NewsGroupHome.NewsGroup = 5; stock_NewsGroupService.Createstock_NewsGroup(stock_NewsGroupHome); } } StoredToApprovedNews(stockNew); StockNewService.DeleteStockNew(stockId); } }
private void ApprovedNewStockList() { string selectedItems = Request.Form["selectedItem"]; int pos, symbolId; Int32 stockId; Int32 newGroupId; if (selectedItems == string.Empty || selectedItems == null) return; foreach (string selectedItemId in selectedItems.Split(',')) { stockId = Convert.ToInt32(selectedItemId); newGroupId = Convert.ToInt32(Request.Form["newsCategorySelect_" + stockId.ToString()]); StockNew stockNew = StockNewService.GetStockNew(stockId); stock_New stockNewDestination = new stock_New(); stock_NewsGroup stock_NewsGroupDestination = new stock_NewsGroup(); stockNewDestination.NewsTitle = stockNew.NewsTitle; stockNewDestination.NewsDescription = stockNew.NewsDescription; stockNewDestination.NewsContent = stockNew.NewsContent; stockNewDestination.NewsDate = stockNew.NewsDate; stockNewDestination.IsApproved = false; stockNewDestination.LanguageID = 2;// should be dymamic stockNewDestination.NewsSource = stockNew.NewsSource; pos = stockNewDestination.NewsTitle.IndexOf(':'); symbolId = 0; if (linkId == 2) { if (pos > 0) symbolId = GetStockSymbolId(stockNewDestination.NewsTitle.Substring(0, pos)); if (symbolId > 0) { stockNew.ShareSymbol = stockNewDestination.NewsTitle.Substring(0, pos); } } stockNewDestination.SymbolID = (symbolId > 0 ? symbolId : new int()); stock_NewService.Createstock_New(stockNewDestination); stock_NewsGroupDestination.NewsID = stockNewDestination.NewsID; stock_NewsGroupDestination.NewsGroup = newGroupId; stock_NewsGroupService.Createstock_NewsGroup(stock_NewsGroupDestination); StoredToApprovedNews(stockNew); StockNewService.DeleteStockNew(stockId); } }