/// <summary> /// /// </summary> /// <returns></returns> public static List<premiumserviceslisting> GetAllPremiumServices(int tradingType) { //DB Connection goes here List<premiumserviceslisting> _article = new List<premiumserviceslisting>(); // Create the Database object, using the default database service. The // default database service is determined through configuration. Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "GetPremiumServices"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "TypeOfTradeId", DbType.String, tradingType); // DataSet that will hold the returned results DataSet commentaryDataSet = null; commentaryDataSet = db.ExecuteDataSet(dbCommand); // Note: connection was closed by ExecuteDataSet method call foreach (DataRow dr in commentaryDataSet.Tables[0].Rows) { premiumserviceslisting _premiumserviceslisting = new premiumserviceslisting(); _premiumserviceslisting.ArticleId = Int32.Parse(dr["PremiumServiceId"].ToString()); _premiumserviceslisting.ArticleTitle = dr["PremiumServiceTitle"].ToString(); _premiumserviceslisting.ArticleDesc = dr["PremiumServiceDescription"].ToString(); _premiumserviceslisting.ArticleDate = DateTime.Parse(dr["PremiumServiceDate"].ToString()); _premiumserviceslisting.Ticker = dr["Ticker"].ToString(); _article.Add(_premiumserviceslisting); } return _article; }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { premiumservicesedit _premiumEdit = new premiumservicesedit(); premiumserviceslisting _listing = new premiumserviceslisting(); _listing = _premiumEdit.GetNewsViewsByArticle(Int32.Parse(Request.QueryString["id"].ToString())); txtheader.Text = _listing.ArticleTitle; isPaid.Checked = _listing.IsPaid; isActive.Checked = _listing.IsActive; fckcontent.Value = _listing.ArticleDesc; txtTicker.Text = _listing.Ticker; } }
/// <summary> /// /// </summary> public static premiumserviceslisting GetPremiumServicesByArticle(int _premiumServicesId) { //DB Connection goes here premiumserviceslisting _PremiumServicesListing = new premiumserviceslisting(); // Create the Database object, using the default database service. The // default database service is determined through configuration. Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "GetPremiumServiceByArticle"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); // Retrieve products from the specified category. db.AddInParameter(dbCommand, "PremiumServiceId", DbType.Int32, _premiumServicesId); // DataSet that will hold the returned results DataSet commentaryDataSet = null; commentaryDataSet = db.ExecuteDataSet(dbCommand); // Note: connection was closed by ExecuteDataSet method call foreach (DataRow dr in commentaryDataSet.Tables[0].Rows) { _PremiumServicesListing.ArticleTitle = dr["PremiumServiceTitle"].ToString(); _PremiumServicesListing.ArticleDesc = dr["PremiumServiceDescription"].ToString(); _PremiumServicesListing.IsActive = Boolean.Parse(dr["IsActive"].ToString()); _PremiumServicesListing.IsPaid = Boolean.Parse(dr["IsPaid"].ToString()); _PremiumServicesListing.Ticker = dr["Ticker"].ToString(); } return _PremiumServicesListing; }
/// <summary> /// /// </summary> /// <param name="filterData"></param> /// <returns></returns> public static List<premiumserviceslisting> GetPremiumServicesFilterData(string filterData, int tradingType) { //DB Connection goes here List<premiumserviceslisting> _article = new List<premiumserviceslisting>(); // Create the Database object, using the default database service. The // default database service is determined through configuration. Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "GetPremiumServices"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "TypeOfTradeId", DbType.Int32, tradingType); // Retrieve products from the specified category. //db.AddInParameter(dbCommand, "CategoryID", DbType.Int32, Category); // DataSet that will hold the returned results DataSet commentaryDataSet = null; commentaryDataSet = db.ExecuteDataSet(dbCommand); DataRow[] dataRow; dataRow = commentaryDataSet.Tables[0].Select("PremiumServiceTitle LIKE '%" + filterData + "%'"); // Note: connection was closed by ExecuteDataSet method call foreach (DataRow dr in dataRow) { premiumserviceslisting _commListing = new premiumserviceslisting(); _commListing.ArticleId = Int32.Parse(dr["PremiumServiceId"].ToString()); _commListing.ArticleTitle = dr["PremiumServiceTitle"].ToString(); _commListing.ArticleDesc = dr["PremiumServiceDescription"].ToString(); _commListing.ArticleDate = DateTime.Parse(dr["PremiumServiceDate"].ToString()); _commListing.Ticker = dr["Ticker"].ToString(); _article.Add(_commListing); } return _article; }