Listing the source code file CDTitul.aspx.cs

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using PxControls;
using PxFiles;
using System.Globalization;

public partial class CDTitul : BasePage
{

 protected void Page_Load(object sender, EventArgs e)
 {
 //rutina na vypnutie BackButonu v Browsery
 this.Context.Response.Cache.SetCacheability(HttpCacheability.NoCache);
 this.Context.Response.Cache.SetAllowResponseInBrowserHistory(false);

 if (Request.Browser.MSDomVersion.Major == 0) // Non IE Browser?)
 this.Context.Response.Cache.SetNoStore();

 PxCulture.CurrentCulture = new CultureInfo("en-US");

 if (/*(!IsPostBack)&&*/(wquQAuthor.Active==false))
 {
 wquQAuthor.ConnectString = AppConst.ConnectString;
 wquQAuthor.SQLSelect = "select IDAuthor, CONCAT_WS(' ', Last_Name, First_Name) as Name from Author";

 wquQAuthor.Open();

 wquQAuthor.AutomaticRefresh = true;
 wquQAuthor.IntervalQueryRefresh = 30;

 }
 else
 {

 }

 if (/*(!IsPostBack)&&*/(wquQZaner.Active==false))
 {
 wquQZaner.ConnectString = AppConst.ConnectString;
 wquQZaner.SQLSelect = "select Zaner.IDZaner as IDZaner, Zaner.Name as Zaner, Zaner.IDKateg_Zaner as IDKateg_Zaner, Kateg_Zaner.Name as Kateg_Zaner from Zaner, Kateg_Zaner where Kateg_Zaner.IDKateg_Zaner=Zaner.IDKateg_Zaner";

 wquQZaner.Open();

 wquQZaner.AutomaticRefresh = true;
 wquQZaner.IntervalQueryRefresh = 30;

 wquQZaner.Columns["IDKateg_Zaner"].Caption = "ID category";

 wquQZaner.Columns["Kateg_Zaner"].Caption = "Category";

 wquQZaner.Columns["IDZaner"].Caption = "ID Genre";

 wquQZaner.Columns["Zaner"].Caption = "Genre";

 }
 else
 {

 }

 if (/*(!IsPostBack)&&*/(wquCdTitul.Active == false))
 {
 filterCdTitul.AddParamFilter("Titul", "CD Title", "");
 filterCdTitul.AddParamFilter("Author", "Author", "IdAuthor1");
 filterCdTitul.AddParamFilter("ZanerFull", "Category the Genre", "IDKateg_Zaner");
 filterCdTitul.AddParamFilter("ZanerFull", "Genre", "IDZaner");
 filterCdTitul.OrigSQLSelect = "select IDCDTitul, Titul, IDKATEG_ZANER, IDZaner, IdVydavatel, IdCDNosic, IDCDFormat, Create_Date, IdAuthor1, IdAuthor2, IdAuthor3, IdAuthor4 from CdTitul";

 string sSQLText1 = "select IdCDNosic as aKey, Name as aValue from CDNosic Order By aValue";
 string sSQLText2 = "select IDCDFormat as aKey, Name as aValue from CDFormat Order By aValue";
 string sSQLText3 = "select IdVydavatel as aKey, Vydavatel as aValue from Vydavatel Order By aValue";

 wquCdTitul.ConnectString = AppConst.ConnectString;
 wquCdTitul.SQLSelect = "select IDCDTitul, Titul, IDKATEG_ZANER, IDZaner, IdVydavatel, IdCDNosic, IDCDFormat, Create_Date, IdAuthor1, IdAuthor2, IdAuthor3, IdAuthor4 from CdTitul";

 wquCdTitul.AddParamKey("IdCDNosic", "aKey", "aValue", "aValue", "aKey", sSQLText1);
 wquCdTitul.AddParamKey("IDCDFormat", "aKey", "aValue", "aValue", "aKey", sSQLText2);
 wquCdTitul.AddParamKey("IdVydavatel", "aKey", "aValue", "aValue", "aKey", sSQLText3);

 wquCdTitul.AddParamWebQuery("IdAuthor1", "IDAuthor", "Name", "Name", "IDAuthor", "wquQAuthor");
 wquCdTitul.AddParamWebQuery("IdAuthor2", "IDAuthor", "Name", "Name", "IDAuthor", "wquQAuthor");
 wquCdTitul.AddParamWebQuery("IdAuthor3", "IDAuthor", "Name", "Name", "IDAuthor", "wquQAuthor");
 wquCdTitul.AddParamWebQuery("IdAuthor4", "IDAuthor", "Name", "Name", "IDAuthor", "wquQAuthor");

 wquCdTitul.AddParamGreatWebQuery("Author", "IdAuthor1", "IdAuthor1", 4, "mvBreakHR");
 wquCdTitul.AddParamFlyComboBox("ZanerFull", "IDKATEG_ZANER;IDZaner", "IDKateg_Zaner;IDZaner", "Kateg_Zaner;Zaner", "Kateg_Zaner;Zaner","wquQZaner", "mvNameAndBR");
 wquCdTitul.AddParamValidation("Titul", "vtIsNotNull");

 wquCdTitul.Open();

 wquCdTitul.AutomaticRefresh = true;
 wquCdTitul.IntervalQueryRefresh = 30;

 wquCdTitul.Columns["IDCDTitul"].Caption = "Id Title";

 wquCdTitul.Columns["Titul"].Caption = "CD Title";

 wquCdTitul.Columns["IDKATEG_ZANER"].Caption = "Category the Genre";

 wquCdTitul.Columns["IDZaner"].Caption = "Genre";

 wquCdTitul.Columns["IdVydavatel"].Caption = "Publisher";

 wquCdTitul.Columns["IdCDNosic"].Caption = "CD Media";

 wquCdTitul.Columns["IDCDFormat"].Caption = "CD Format";

 wquCdTitul.Columns["Create_Date"].Caption = "Creation date";

 wquCdTitul.Columns["IdAuthor1"].Caption = "Author";

 wquCdTitul.Columns["IdAuthor2"].Caption = "Author";

 wquCdTitul.Columns["IdAuthor3"].Caption = "Author";

 wquCdTitul.Columns["IdAuthor4"].Caption = "Author";

 wquCdTitul.Columns["Author"].Caption = "Author";

 wquCdTitul.Columns["ZanerFull"].Caption = "Category / Genre";

 }
 else
 {

 }

 filterCdTitul.PxDataSource = wquCdTitul;

 grdCdTitul.VisibleFields = "IDCDTitul:40;Titul:120;Author:120;IdCDNosic:40;IDCDFormat:40;IdVydavatel;ZanerFull";
 grdCdTitul.PxDataSource = wquCdTitul;
 //grdCdTitul.AllowSorting = true;
 grdCdTitul.DataBind();
 navCdTitul.PxDataSource = wquCdTitul;
 navCdTitul.PxVisibleButtons = "FRNL";

 Uploader.IdUploadFile = 17771;
 Uploader.UploadDir = @"uploads/data";
 Uploader.ButtonImageUrl = "./images/AddFiles.png";
 Uploader.ButtonWidth = 122;
 Uploader.ButtonHeight = 37;
 Uploader.ProgressBarColor = "#FF9933";
 }

}

Return to original page