protected override void CreateControl(Guid categoryID, string categoryName) { INewsCategoryService srvNewsCateg = ServiceFactory.GetNewsCategoryService(); INewsService srvNews = ServiceFactory.GetNewsService(); NewsByCategoryControl control = (NewsByCategoryControl)LoadControl("Controls/NewsByCategoryControl.ascx"); DataSet ds = new DataSet(); if (categoryID == Guid.Empty) { newsCont = srvNews.NewsSelectNullCategory(); } else { //lekérdezzük a kategóriához tartozó max megjelenítési számot NewsCategory categ = srvNewsCateg.NewsCategorySelect(categoryID); newsCont = srvNews.NewsSelectByCategoryAllForVisitors(categoryID, categ.ShowMaxCount); control.ShowMaxCount = categ.ShowMaxCount; } if (newsCont.All.Count > 0) { ds.Tables.Add(newsCont.AllAsDatatable); SelectedGridOrder = "Descending"; SelectedGridSort = "ModifiedDate"; control.DataSource = ds; control.Caption = categoryName; //control.CategoryID = categoryID; pnlNewsList.Controls.Add(control); } }
/// <summary> /// Creates the control. /// </summary> /// <param name="categoryID">The category ID.</param> /// <param name="categoryName">Name of the category.</param> private void CreateControl(Guid categoryID, string categoryName) { INewsCategoryService srvNewsCateg = ServiceFactory.GetNewsCategoryService(); INewsService srvNews = ServiceFactory.GetNewsService(); NewsByCategoryControl control = (NewsByCategoryControl) LoadControl("Controls/NewsByCategoryControl.ascx"); DataSet ds = new DataSet(); NewsContainer newsCont = new NewsContainer(); if (categoryID == Guid.Empty) { newsCont = srvNews.NewsSelectNullCategory(); } else { //lekérdezzük a kategóriához tartozó max megjelenítési számot NewsCategory categ = srvNewsCateg.NewsCategorySelect(categoryID); newsCont = srvNews.NewsSelectByCategoryAllForRegistered(categoryID, categ.ShowMaxCount); control.ShowMaxCount = categ.ShowMaxCount; } if (newsCont.All.Count > 0) { ds.Tables.Add(newsCont.AllAsDatatable); control.DataSource = ds; control.Caption = categoryName; //control.CategoryID = categoryID; pnlNewsList.Controls.Add(control); } }
protected override void CreateControl(Guid categoryID, string categoryName, bool all) { INewsCategoryService srvNewsCateg = ServiceFactory.GetNewsCategoryService(); INewsService srvNews = ServiceFactory.GetNewsService(); NewsByCategoryControl control = (NewsByCategoryControl)LoadControl("Controls/NewsByCategoryControl.ascx"); DataSet ds = new DataSet(); if (categoryID == Guid.Empty) { newsCont = srvNews.NewsSelectNullCategory(); } else { //lekérdezzük a kategóriához tartozó max megjelenítési számot NewsCategory categ = srvNewsCateg.NewsCategorySelect(categoryID); if (Context.User.Identity.IsAuthenticated) { newsCont = srvNews.NewsSelectByCategoryAllForRegistered(categoryID, DBInt16.MaxValue); } else { newsCont = srvNews.NewsSelectByCategoryAllForVisitors(categoryID, DBInt16.MaxValue); } if (!all) { control.ShowMaxCount = categ.ShowMaxCount; } } if (newsCont.All.Count > 0) { DataTable table = newsCont.AllAsDatatable; table.Columns.Add("CategoryName"); ds.Tables.Add(table); SelectedGridOrder = "Descending"; SelectedGridSort = "CreatedDate"; control.Caption = categoryName; control.DataSource = ds; //control.CategoryID = categoryID; pnlNewsList.Controls.Add(control); } ////DataSet selected = srvNews.NewsSelectFiltered(filter); HtmlGenericControl h1 = new HtmlGenericControl(); h1.TagName = "h1"; h1.InnerText = categoryName; h1.Attributes.Add("class", "PageTitle"); //Label label = new Label(); //label.CssClass = "PageTitle"; //label.Text = categoryName; pnlNewsList.Controls.Add(h1); pnlNewsList.Controls.Add(control); }
public virtual NewsContainer SelectChildrenByCategoryOfNews(DBGuid IDVal) { TraceCallEnterEvent.Raise(); try { NewsContainer result; DataSet entitySet = m_DataContext.ndihdCategoryOfNewsSelectBy(IDVal); result = new NewsContainer(entitySet.Tables[0]); TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }
public NewsContainer NewsSelectNullCategory() { // permission: everyone TraceCallEnterEvent.Raise(); try { NewsContainer result; DataSet entitySet = m_DataContext.ndihdNewsSelectNullCategory(); result = new NewsContainer(entitySet.Tables[0]); TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }
public NewsContainer NewsSelectFreeText(string SearchKey, DBInt IsActive, DBInt IsActual, DBInt VisibleForVisitor, DBInt VisibleForRegistered) { // permission: everyone TraceCallEnterEvent.Raise(); try { NewsContainer result; DataSet entitySet = m_DataContext.ndihdNewsSelectFreeText( SearchKey, IsActive, IsActual, VisibleForVisitor, VisibleForRegistered); result = new NewsContainer(entitySet.Tables[0]); TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }
public NewsContainer NewsSelectByCategoryAllForVisitors(Guid CategoryID, int ShowMaxCount) { // permission: everyone TraceCallEnterEvent.Raise(); try { NewsContainer result; DataSet entitySet = m_DataContext.ndihdNewsSelectByCategory(CategoryID, ShowMaxCount, 1, DBInt.Null); result = new NewsContainer(entitySet.Tables[0]); TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }
public virtual NewsContainer NewsSelectAll() { TraceCallEnterEvent.Raise(); try { NewsContainer result; DataSet entitySet = m_DataContext.ndihdNewsSelectAll(); result = new NewsContainer(entitySet.Tables[0]); TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }
protected void Page_Load(object sender, EventArgs e) { // Check permission: anybody can use this page try { if (!Page.IsPostBack) { INewsCategoryService srvNewsCateg = ServiceFactory.GetNewsCategoryService(); NewsCategoryContainer categCont = srvNewsCateg.NewsCategorySelectAll(); DataTable dt = (new NewsContainer()).AllAsDatatable; DataSet ds = new DataSet(); ds.Tables.Add(dt); dt.Columns.Add("CategoryName"); INewsService srvNews = ServiceFactory.GetNewsService(); //INewsCategoryService srvNewsCateg = ServiceFactory.GetNewsCategoryService(); //INewsService srvNews = ServiceFactory.GetNewsService(); foreach (NewsCategory categ in categCont.All) { if (categ.ShowMaxCount > 0) { for (int i = 0; i < categ.ShowMaxCount; i++) { if (newsCont.AllCount >= i) { if (Context.User.Identity.IsAuthenticated) { newsCont = srvNews.NewsSelectByCategoryAllForRegistered(categ.ID, categ.ShowMaxCount); } else { newsCont = srvNews.NewsSelectByCategoryAllForVisitors(categ.ID, categ.ShowMaxCount); } if (newsCont.AllCount > 0) { DataRow row = dt.NewRow(); if (newsCont.AllAsDatatable.Rows.Count > i) { for (int j = 0; j < newsCont.AllAsDatatable.Rows[i].Table.Columns.Count; j++) { row[newsCont.AllAsDatatable.Rows[i].Table.Columns[j].ColumnName] = newsCont.AllAsDatatable.Rows[i][j]; } row["CategoryName"] = categ.Name; dt.Rows.Add(row); } } } } } } //CreateNewsCategoryBottomDated(categCont, rowCat); CreateControlDated(ds, categCont); //lehetnek olyan cikkek is amelyekmég nem lettek hozzárendelve egyik kategóriához sem //CreateControl(Guid.Empty, "Egyéb"); } } catch (Exception ex) { errorPanel.Exception = ex; } }