Example #1
0
        protected void EventListBox_SelectedIndexChanged(object sender, EventArgs e)
        {
            String sqlQuery  = "select * from Event where EventID = " + EventListBox.SelectedItem.Value;
            String sqlQuery1 = "select S.StaffID, S.FirstName + ' ' + S.LastName as Name from Staff S inner join EventAttendees E on E.StaffID = S.StaffID where EventID = " + EventListBox.SelectedItem.Value;

            //Get connection string from web.config file
            string strcon = ConfigurationManager.ConnectionStrings["CARESconnection"].ConnectionString;
            //create new sqlconnection and connection to database by using connection string from web.config file
            SqlConnection con = new SqlConnection(strcon);

            con.Open();
            SqlDataAdapter sqlAdapter  = new SqlDataAdapter(sqlQuery, con);
            SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sqlQuery1, con);

            DataSet ds = new DataSet();

            sqlAdapter.Fill(ds);

            FormView4.DataSource = ds;
            FormView4.DataBind();
            DataTable dt = new DataTable();

            sqlAdapter1.Fill(dt);

            if (dt.Rows.Count > 0)
            {
                WorkerListLabel.Text        = "Employees Attending Event: ";
                WorkerListBox.DataSource    = dt;
                EventListBox.DataValueField = "StaffID";
                WorkerListBox.DataTextField = "Name";
                WorkerListBox.DataBind();
            }
            con.Close();
            ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal1();", true);
        }
    eticaretDataContext et = new eticaretDataContext(); // data context nesnemizi olusturdur.

    protected void Page_Load(object sender, EventArgs e)
    {
        stokvaryok();// Ürün stok var yok fonksiyonun çağırdık.
        // Veritabanımıza baglandık tabloları birleştirerek çünkü markaAD adlı kolonumuz Urunler tablosunda yoktu.
        //Ona ulasmak içinde Ürünler tablosu ile markalar Tablosunu birleştirdik.
        var urun = (from u in et.Urunlers.Where(v => v.UrunID == Convert.ToInt32(Request.QueryString["id"].ToString()))
                    join u2 in et.Markalars on u.MarkaID equals u2.MarkaID
                    select new { u.UrunID, u.UrunAD, u.UrunDetay, u.UrunFiyat, u.KDV, u.Resim1, u.Resim2, u.Resim3, u.Resim4, u.Resim5, u.Video, u.Taksit, u2.MarkaAD });

        //Ürün Adımızı almak için veritabanımıza bağlandık.
        var urunad = et.Urunlers.Where(v => v.UrunID == int.Parse(Request.QueryString["id"])).FirstOrDefault();

        lblAD.Text = urunad.UrunAD; // Ürün adımızı veritabanından alarak Label'ımıza atadık.



        FormView1.DataSource = urun; // sonucumuzu FormView'umuza attık.
        FormView1.DataBind();

        FormView2.DataSource = urun; // Ürün Resimlerinin gösterimi için FormView2 ile bağlantımızı kurduk.
        FormView2.DataBind();
        FormView3.DataSource = urun;
        FormView3.DataBind();
        FormView4.DataSource = urun;
        FormView4.DataBind();
        FormView5.DataSource = urun;
        FormView5.DataBind();
        FormView6.DataSource = urun;
        FormView6.DataBind();
        yorumgetir();
    }
Example #3
0
        protected void GridView4_SelectedIndexChanged(object sender, EventArgs e)
        {
            DataKey dk = GridView4.SelectedDataKey;
            int     a  = 0;

            FormView4.PageIndex = 0;
            FormView4.DataBind();
            while (FormView4.DataKey.Value.ToString() != dk.Value.ToString() &&
                   a < FormView4.PageCount)
            {
                if (a + 1 < FormView4.PageCount)
                {
                    FormView4.PageIndex++;
                    FormView4.DataBind();
                }
            }
        }
Example #4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        BookBL bl = new BookBL();

        GridView1.DataSource = bl.new_Message();
        GridView1.DataBind();

        DataList1.DataSource = bl.chinese_Book("1");
        DataList1.DataBind();

        DataList2.DataSource = bl.chinese_Book("2");
        DataList2.DataBind();


        FormView2.DataSource = bl.chinese_Book("1");
        FormView2.DataBind();

        FormView5.DataSource = bl.chinese_Book("2");
        FormView5.DataBind();

        FormView7.DataSource = bl.chinese_Book("3");
        FormView7.DataBind();


        FormView1.DataSource = bl.everyday_Book();
        FormView1.DataBind();


        FormView4.DataSource = bl.book_top1("1");
        FormView4.DataBind();

        FormView3.DataSource = bl.book_top1("2");
        FormView3.DataBind();

        FormView6.DataSource = bl.book_top1("3");
        FormView6.DataBind();

        bl.book_Hit("1", HyperLink19, HyperLink20, HyperLink21, HyperLink22, HyperLink23, HyperLink24, HyperLink25, HyperLink26, HyperLink27);
        bl.book_Hit("2", HyperLink28, HyperLink29, HyperLink30, HyperLink31, HyperLink32, HyperLink33, HyperLink34, HyperLink35, HyperLink36);
        bl.book_Hit("3", HyperLink38, HyperLink39, HyperLink40, HyperLink41, HyperLink42, HyperLink43, HyperLink44, HyperLink45, HyperLink46);
    }
Example #5
0
    public void ViewVesselDetails(int Key)
    {
        DataTable dtVessel = objBLL.GetVesselDetails_ByID(Key);

        FormView1.DataSource = dtVessel;
        FormView1.DataBind();
        FormView3.DataSource = dtVessel;
        FormView3.DataBind();
        FormView4.DataSource = dtVessel;
        FormView4.DataBind();
        FormView5.DataSource = dtVessel;
        FormView5.DataBind();
        FormView6.DataSource = dtVessel;
        FormView6.DataBind();
        FormView7.DataSource = dtVessel;
        FormView7.DataBind();
        ShipImg.ImageUrl = "~/Vessel/ShipImage/" + dtVessel.Rows[0]["Vessel_Image"].ToString();
        TankImg.ImageUrl = "~/Vessel/shipLayout/" + dtVessel.Rows[0]["Vessel_Tank_Image"].ToString();
        lblShipName.Text = dtVessel.Rows[0]["Vessel_Short_Name"].ToString();

        DataSet ds = objBLL.GetInmarsatValues_ForVesselID(Key);

        DataTable dt1 = ds.Tables[0];
        DataTable dt2 = ds.Tables[0];

        dt1 = RemoveDuplicateRows(dt1, "terminal");
        dt2 = RemoveDuplicateRows(dt2, "channel");
        // GridView1.DataSource = ds.Tables["Dtl_IID_INMARSAT"].DefaultView;
        // GridView1.DataBind();
        //DataTable SourceDt = new DataTable();



        for (int i = 0; i < dt1.Rows.Count + 1; i++)
        {
            TableRow tr = new TableRow();
            for (int j = 0; j < 5; j++)
            {
                TableCell tc  = new TableCell();
                Label     lbl = new Label();
                tc.Text        = "";
                tc.BorderWidth = 1;

                tr.Cells.Add(tc);
                if (j == 0 && i > 0)
                {
                    tc.Text = "<b>Inmarsat-</b>" + dt1.Rows[i - 1]["terminal"].ToString();
                }
            }
            tr.BorderStyle = BorderStyle.Solid;
            Table1.Rows.Add(tr);
            if (i >= 1)
            {
                switch (ds.Tables[0].Rows[i - 1]["Channel"].ToString())
                {
                case "Telex":
                {
                    Table1.Rows[i].Cells[1].Text = ds.Tables[0].Rows[i - 1]["Phone"].ToString();
                    break;
                }

                case "Telephone":
                {
                    Table1.Rows[i].Cells[2].Text = ds.Tables[0].Rows[i - 1]["Phone"].ToString();
                    break;
                }

                case "Fax":
                {
                    Table1.Rows[i].Cells[3].Text = ds.Tables[0].Rows[i - 1]["Phone"].ToString();
                    break;
                }

                case "Data":
                {
                    Table1.Rows[i].Cells[4].Text = ds.Tables[0].Rows[i - 1]["Phone"].ToString();
                    break;
                }
                }
            }
        }
        Table1.Rows[0].Cells[0].Text = "";
        Table1.Rows[0].Cells[1].Text = "<b>Telex</b>";
        Table1.Rows[0].Cells[2].Text = "<b>Telephone</b>";
        Table1.Rows[0].Cells[3].Text = "<b>Fax</b>";
        Table1.Rows[0].Cells[4].Text = "<b>Data</b>";
        //GridView1.DataSource = dt2;
        //GridView1.DataBind();
    }