Listing the source code file InfoCDTitul.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 InfoCDTitul : 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))
        {
            //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();

            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.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))
        {
            //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();

            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.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";

        }
        else
        {

        }

        lblIDCDTitul.PxDataSource = wquCdTitul;
        lblIDCDTitul.FieldName = wquCdTitul.Columns["IDCDTitul"].ToString();

        lblTitul.PxDataSource = wquCdTitul;
        lblTitul.FieldName = wquCdTitul.Columns["Titul"].ToString();

        lblIdVydavatel.PxDataSource = wquCdTitul;
        lblIdVydavatel.FieldName = wquCdTitul.Columns["IdVydavatel"].ToString();

        lblIdCDNosic.PxDataSource = wquCdTitul;
        lblIdCDNosic.FieldName = wquCdTitul.Columns["IdCDNosic"].ToString();

        lblIDCDFormat.PxDataSource = wquCdTitul;
        lblIDCDFormat.FieldName = wquCdTitul.Columns["IDCDFormat"].ToString();

        lblCreate_Date.PxDataSource = wquCdTitul;
        lblCreate_Date.FieldName = wquCdTitul.Columns["Create_Date"].ToString();

        gtrAuthor.PxDataSource = wquCdTitul;
        gtrAuthor.FieldName = "Author";

        fcmbZanerfull.PxDataSource = wquCdTitul;
        fcmbZanerfull.FieldName = "Zanerfull";
     }

     protected void ButtonClose_Click(object sender, EventArgs e)
     {
            this.Response.Redirect("~/CDTitul.aspx");
     }
}

Return to original page