Ejemplo n.º 1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Controls_Language();

        string Lang      = "ru";
        string currentid = "";

        if (Session["lng"] == null)
        {
            Session["lng"] = "ru";
        }
        if (Session["lng"] != null)
        {
            string Str = Session["lng"].ToString();
            if (Str == "az")
            {
                Lang = "az";
            }
            else if (Str == "ru")
            {
                Lang = "ru";
            }
        }
        if (Request.QueryString["lng"] != null)
        {
            string Str = Request.QueryString["lng"];
            if (Str == "az")
            {
                Lang = "az";
            }
            else if (Str == "ru")
            {
                Lang = "ru";
            }
            Session["lng"] = Str;
        }

        using (SqlConnection Conn = new SqlConnection())
        {
            Conn.ConnectionString = ConfigurationManager.ConnectionStrings["CS"].ConnectionString;
            SqlCommand Comm = new SqlCommand();
            Comm.Connection = Conn;
            Conn.Open();

            /* if (Lang == "ru")
             * {
             *   Comm.CommandText = @"SELECT ID, NAMERU FROM HEADERS WHERE ACTIVE='TRUE'";
             * }
             * else if (Lang == "az")
             * {
             *   Comm.CommandText = @"SELECT ID, NAMEAZ FROM HEADERS WHERE ACTIVE='TRUE'";
             * }
             * else
             * {
             *   Comm.CommandText = @"SELECT ID, NAMERU FROM HEADERS WHERE ACTIVE='TRUE'";
             * }*/

            Comm.CommandText = string.Format("SELECT ID, NAME{0} FROM HEADERS WHERE ACTIVE='TRUE'", Lang);

            SqlDataReader reader = Comm.ExecuteReader();
            //Header_lb.Text = "<table  border='1px solid black'  cellpadding='0' cellspacing='0' width='1020px' height='40px'><tr class='style7'>";
            bool hasmenus = false;

            /*      while (reader.Read())
             *    {
             *        hasmenus = true;
             *        Header_lb.Text += string.Format("<td><a  href='Default.aspx?id={0}'><label style='margin-bottom:15px; width:120px;height:40px; position:relative; color:white;text-decoration:none;cursor:pointer;'>{1}</label></a></td>", reader[0].ToString(), reader[1].ToString());
             *    }
             *    reader.Close();
             *    if (hasmenus)
             *    {
             *        Header_lb.Text += "<td>&nbsp;</td>";
             *    }
             *    Header_lb.Text += "</tr></table>";
             *
             */
            Literal1.Text = "<table  border='0'  cellpadding='0' cellspacing='0' width='1020px' height='40px'><tr>";
            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    Literal1.Text += string.Format("<td><a href=\"Default.aspx?id={0}\" class=\"style7\">{1}</a></td>", reader[0].ToString(), reader[1].ToString());
                }
            }
            Literal1.Text += "</tr></table>";
            reader.Close();
            if (Request.QueryString["id"] != null)
            {
                currentid = Request.QueryString["id"];
            }

            else
            {
                Comm.CommandText = @"SELECT MIN(ID) FROM HEADERS WHERE ACTIVE='TRUE'";
                reader           = Comm.ExecuteReader();
                if (reader.Read())
                {
                    if (reader[0].ToString() != "")
                    {
                        currentid = reader[0].ToString();
                    }
                }
                reader.Close();
            }


            if (Headerid.get_headerid(currentid) != "")
            {
                if (Lang == "ru")
                {
                    Comm.CommandText = @"SELECT ID, NAMERU FROM MENU WHERE ACTIVE='TRUE' AND HEADERID=@HEADERID";
                }
                else if (Lang == "az")
                {
                    Comm.CommandText = @"SELECT ID, NAMEAZ FROM MENU WHERE ACTIVE='TRUE' AND HEADERID=@HEADERID";
                }
                else
                {
                    Comm.CommandText = @"SELECT ID, NAMERU FROM MENU WHERE ACTIVE='TRUE' AND HEADERID=@HEADERID";
                }
                Comm.Parameters.Add("@HEADERID", SqlDbType.Int);
                Comm.Parameters["@HEADERID"].Value = currentid;

                reader          = Comm.ExecuteReader();
                Sidebar_lb.Text = "<table border='0' cellpadding='0' cellspacing='0' width='120px'>";
                hasmenus        = false;
                while (reader.Read())
                {
                    hasmenus         = true;
                    Sidebar_lb.Text += string.Format("<tr><td><a href='Default.aspx?id={2}&cat={0}'>{1}</a></td></tr>", reader[0].ToString(), reader[1].ToString(), currentid);
                }
                reader.Close();

                Sidebar_lb.Text += "</table>";


                if (Contentid.get_contentid() != "")
                {
                    if (Lang == "ru")
                    {
                        Comm.CommandText = @"SELECT NAMERU FROM CONTENT WHERE MENUID=@MENUID";
                    }
                    else if (Lang == "az")
                    {
                        Comm.CommandText = @"SELECT NAMEAZ FROM CONTENT WHERE MENUID=@MENUID";
                    }
                    else
                    {
                        Comm.CommandText = @"SELECT NAMERU FROM CONTENT WHERE MENUID=@MENUID";
                    }
                    Comm.Parameters.Add("@MENUID", SqlDbType.Int);
                    Comm.Parameters["@MENUID"].Value = Request.QueryString["cat"];
                    reader = Comm.ExecuteReader();
                    if (reader.Read())
                    {
                        if (reader[0].ToString() != "")
                        {
                            Content_lb.Text = reader[0].ToString();
                        }
                    }
                    reader.Close();
                }
                else
                {
                    if (Lang == "ru")
                    {
                        Comm.CommandText = @"SELECT CONTENTRU FROM HEADERS WHERE ACTIVE='TRUE' AND ID=@ID";
                    }
                    else if (Lang == "az")
                    {
                        Comm.CommandText = @"SELECT CONTENTAZ FROM HEADERS WHERE ACTIVE='TRUE' AND ID=@ID";
                    }
                    else
                    {
                        Comm.CommandText = @"SELECT CONTENTRU FROM HEADERS WHERE ACTIVE='TRUE' AND ID=@ID";
                    }
                    Comm.Parameters.Add("@ID", SqlDbType.Int);
                    Comm.Parameters["@ID"].Value = currentid;
                    reader = Comm.ExecuteReader();
                    if (reader.Read())
                    {
                        if (reader[0].ToString() != "")
                        {
                            Content_lb.Text = reader[0].ToString();
                        }
                    }
                    reader.Close();
                }
            }
        }
    }
Ejemplo n.º 2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        RU_lb.Text         = "";
        AZ_lb.Text         = "";
        RU_edt.Visible     = true;
        AZ_edt.Visible     = true;
        Update_btn.Visible = false;
        Add_btn.Visible    = false;
        Error_lb.Text      = "";
        Error_lb.ForeColor = Color.Red;
        Update_btn.Visible = true;
        int ID = 0;

        if (Contentid.get_contentid() == "")
        {
            RU_edt.Visible = false;
            AZ_edt.Visible = false;
            Error_lb.Text  = "Неверный ID";
            return;
        }
        else
        {
            ID = Convert.ToInt32(Request.QueryString["cat"]);
        }

        //if (Request.QueryString["id"] != null)
        //{
        //    try
        //    {
        //        ID = Convert.ToInt32(Request.QueryString["id"]);
        //    }
        //    catch
        //    {
        //        RU_edt.Visible = false;
        //        AZ_edt.Visible = false;
        //        Error_lb.Text = "Неверный ID";
        //        return;
        //    }
        //}
        //else
        //{
        //    AZ_edt.Visible = false;
        //    Update_btn.Visible = false;
        //    Error_lb.Text = "Неверный ID";
        //    return;
        //}

        using (SqlConnection Conn = new SqlConnection())
        {
            Conn.ConnectionString = ConfigurationManager.ConnectionStrings["CS"].ConnectionString;
            SqlCommand Comm = new SqlCommand();
            Comm.Connection = Conn;
            Conn.Open();

            Comm.CommandText = @"SELECT C.NAMERU, C.NAMEAZ, M.NAMERU, M.NAMEAZ FROM CONTENT C, MENU M WHERE M.ID=C.MENUID AND C.MENUID = @ID";
            Comm.Parameters.Add("@ID", SqlDbType.Int);
            Comm.Parameters["@ID"].Value = ID;

            SqlDataReader reader = Comm.ExecuteReader();

            if (reader.Read())
            {
                if (reader[2].ToString() == "")
                {
                    RU_lb.Text = "Нет названия заголовка";
                }
                else
                {
                    RU_lb.Text = reader[2].ToString();
                    if (!Page.IsPostBack)
                    {
                        if (reader[0].ToString() != "")
                        {
                            RU_edt.Html = reader[0].ToString();
                        }
                    }
                }

                if (reader[3].ToString() == "")
                {
                    AZ_lb.Text = "Нет названия заголовка";
                }
                else
                {
                    AZ_lb.Text = reader[3].ToString();
                    if (!Page.IsPostBack)
                    {
                        if (reader[1].ToString() != "")
                        {
                            AZ_edt.Html = reader[1].ToString();
                        }
                    }
                }
                reader.Close();
                Add_btn.Visible    = false;
                Update_btn.Visible = true;
            }
            else
            {
                reader.Close();
                Comm.CommandText = @"SELECT NAMERU, NAMEAZ FROM MENU WHERE ID=@ID";
                reader           = Comm.ExecuteReader();
                if (reader.Read())
                {
                    RU_lb.Text = reader[0].ToString();
                    AZ_lb.Text = reader[1].ToString();
                }
                Add_btn.Visible    = true;
                Update_btn.Visible = false;
                reader.Close();
            }
        }
    }