예제 #1
0
    protected void ddl_reduce_SelectedIndexChanged1(object sender, EventArgs e)
    {
        string            u   = ddl_reduce.SelectedItem.Value;
        class_list_tutors obj = new class_list_tutors();

        ds = obj.showdata1(u);
        if (ds.Tables[0].Rows.Count > 0)
        {
            grd_list_tutors.DataSource = ds;
            grd_list_tutors.DataBind();
            lbl_error.Visible = false;
        }
        else
        {
            grd_list_tutors.DataSource = null;
            grd_list_tutors.DataBind();
            lbl_error.Visible = true;
        }
        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            string a = ds.Tables[0].Rows[i]["tut_id"].ToString();
            int    o = obj.findleads(ds.Tables[0].Rows[i]["tut_id"].ToString());
            if (o > 0)
            {
                grd_list_tutors.Rows[i].Cells[6].Text = "<a href='list_students.aspx?tut_id=" + ds.Tables[0].Rows[i]["tut_id"].ToString() + "'>" + o.ToString() + "</a>";
            }
            else
            {
                grd_list_tutors.Rows[i].Cells[6].Text = "0";
            }
        }
    }
예제 #2
0
    protected void row_updating(object sender, GridViewUpdateEventArgs e)
    {
        int         id  = Convert.ToInt32((grd_list_tutors.DataKeys[e.RowIndex].Value));
        GridViewRow row = (GridViewRow)grd_list_tutors.Rows[e.RowIndex];

        TextBox t1 = (TextBox)row.FindControl("txt_name");

        TextBox t2 = (TextBox)row.FindControl("txt_email");
        TextBox t3 = (TextBox)row.FindControl("txt_phone");
        TextBox t4 = (TextBox)row.FindControl("txt_posted_on");



        RadioButtonList   t5  = (RadioButtonList)row.FindControl("rbl_status");
        class_list_tutors cls = new class_list_tutors();

        int i = cls.update(t1.Text, t2.Text, t3.Text, t4.Text, t5.SelectedItem.Text.ToString(), id);

        if (i > 0)
        {
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record updated successfully')", true);
        }
        else
        {
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record not updated successfully')", true);
        }
        grd_list_tutors.EditIndex = -1;

        databind1();
    }
예제 #3
0
    protected void btn_see_earning_Click(object sender, EventArgs e)
    {
        decimal d = 0.0M;

        start = Convert.ToDateTime(txt_start_date.Text);
        end   = Convert.ToDateTime(txt_end_date.Text);
        class_list_tutors cls = new class_list_tutors();

        ds = cls.see_earning(start, end, "see_earnings");

        if (ds.Tables[0].Rows.Count > 0)
        {
            grd_list_tutors.DataSource = ds;
            grd_list_tutors.DataBind();
            lbl_error.Visible = false;
        }
        else
        {
            grd_list_tutors.DataSource = null;
            grd_list_tutors.DataBind();
            lbl_error.Visible = true;
        }

        for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
        {
            d = d + Convert.ToDecimal(ds.Tables[0].Rows[j].ItemArray[5]);
        }
        txt_total_earning.Text = d.ToString();
    }
예제 #4
0
    protected void btn_search_Click1(object sender, EventArgs e)
    {
        string            search = txt_search.Text;
        class_list_tutors obj    = new class_list_tutors();

        ds1 = obj.filter(search);
        if (ds1.Tables[0].Rows.Count > 0)
        {
            grd_list_tutors.DataSource = ds1;
            grd_list_tutors.DataBind();
            lbl_error.Visible = false;
        }
        else
        {
            grd_list_tutors.DataSource = null;
            grd_list_tutors.DataBind();
            lbl_error.Visible = true;
        }
        for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
        {
            string a = ds1.Tables[0].Rows[i]["tut_id"].ToString();
            int    o = obj.findleads(ds1.Tables[0].Rows[i]["tut_id"].ToString());
            if (o > 0)
            {
                grd_list_tutors.Rows[i].Cells[6].Text = "<a href='list_students.aspx?tut_id=" + ds1.Tables[0].Rows[i]["tut_id"].ToString() + "'>" + o.ToString() + "</a>";
            }
            else
            {
                grd_list_tutors.Rows[i].Cells[6].Text = "0";
            }
        }
    }
예제 #5
0
    protected void ddl_sort_SelectedIndexChanged(object sender, EventArgs e)
    {
        class_list_tutors obj = new class_list_tutors();

        if (ddl_sort.SelectedValue == "taken_on")
        {
            ds = obj.select_from_id(0, "sort_taken_on");
            if (ds.Tables[0].Rows.Count > 0)
            {
                grd_list_tutors.DataSource = ds;
                grd_list_tutors.DataBind();
                lbl_error.Visible = false;
            }
            else
            {
                grd_list_tutors.DataSource = null;
                grd_list_tutors.DataBind();
                lbl_error.Visible = true;
            }
        }
        else if (ddl_sort.SelectedValue == "days_remaining_to_expiry")
        {
            ds = obj.select_from_id(0, "sort_expiry_date");
            if (ds.Tables[0].Rows.Count > 0)
            {
                grd_list_tutors.DataSource = ds;
                grd_list_tutors.DataBind();
                lbl_error.Visible = false;
            }
            else
            {
                grd_list_tutors.DataSource = null;
                grd_list_tutors.DataBind();
                lbl_error.Visible = true;
            }
        }
        else
        {
            ds = obj.select_from_id(0, "sort_leads_remaining");
            if (ds.Tables[0].Rows.Count > 0)
            {
                grd_list_tutors.DataSource = ds;
                grd_list_tutors.DataBind();
                lbl_error.Visible = false;
            }
            else
            {
                grd_list_tutors.DataSource = null;
                grd_list_tutors.DataBind();
                lbl_error.Visible = true;
            }
        }
    }
예제 #6
0
    private void bind()
    {
        class_list_tutors cls = new class_list_tutors();
        int i = cls.count_totals("count_total_tutors");

        txt_tot_tutors.Text = i.ToString();
        int j = cls.count_totals("count_total_students");

        txt_tot_students.Text = j.ToString();
        txt_tot_users.Text    = (i + j).ToString();
        int k = cls.count_totals("count_total_earning");

        txt_tot_earn.Text = k.ToString();
    }
예제 #7
0
    protected void row_deleting(object sender, GridViewDeleteEventArgs e)
    {
        int id = Convert.ToInt32((grd_list_tutors.DataKeys[e.RowIndex].Value));
        class_list_tutors cls2 = new class_list_tutors();

        int i = cls2.delete(id);

        if (i > 0)
        {
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record deleted successfully')", true);
        }
        else
        {
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record not deleted successfully')", true);
        }
        databind1();
    }
예제 #8
0
    private void databind()
    {
        class_list_tutors cls = new class_list_tutors();

        ds = cls.see_earning(DateTime.Now, DateTime.Now, "see_monthwise_earnings");

        if (ds.Tables[0].Rows.Count > 0)
        {
            grd_list_tutors.DataSource = ds;
            grd_list_tutors.DataBind();
            lbl_error.Visible = false;
        }
        else
        {
            grd_list_tutors.DataSource = null;
            grd_list_tutors.DataBind();
            lbl_error.Visible = true;
        }
    }
예제 #9
0
    private void databind1()
    {
        //try
        //{
        class_list_tutors obj = new class_list_tutors();

        string str1 = "";

        if (Request.QueryString["Loc_id"] != null)
        {
            str1 = Request.QueryString["Loc_id"].ToString();

            ds = obj.select_from_id(Convert.ToInt32(str1), "select_location_from_id");
            if (ds.Tables[0].Rows.Count > 0)
            {
                grd_list_tutors.DataSource = ds;
                grd_list_tutors.DataBind();
                lbl_error.Visible = false;
            }
            else
            {
                grd_list_tutors.DataSource = null;
                grd_list_tutors.DataBind();
                lbl_error.Visible = true;
            }

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                string a = ds.Tables[0].Rows[i]["tut_id"].ToString();
                int    o = obj.findleads(ds.Tables[0].Rows[i]["tut_id"].ToString());
                if (o > 0)
                {
                    grd_list_tutors.Rows[i].Cells[6].Text = "<a href='list_students.aspx?tut_id=" + ds.Tables[0].Rows[i]["tut_id"].ToString() + "'>" + o.ToString() + "</a>";
                }
                else
                {
                    grd_list_tutors.Rows[i].Cells[6].Text = "0";
                }
            }
        }

        else if (Request.QueryString["sub_id"] != null)
        {
            str1 = Request.QueryString["sub_id"].ToString();

            ds = obj.select_from_id(Convert.ToInt32(str1), "select_subject_from_id");
            if (ds.Tables[0].Rows.Count > 0)
            {
                grd_list_tutors.DataSource = ds;
                grd_list_tutors.DataBind();
                lbl_error.Visible = false;
            }
            else
            {
                grd_list_tutors.DataSource = null;
                grd_list_tutors.DataBind();
                lbl_error.Visible = true;
            }

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                string a = ds.Tables[0].Rows[i]["tut_id"].ToString();
                int    o = obj.findleads(ds.Tables[0].Rows[i]["tut_id"].ToString());
                if (o > 0)
                {
                    grd_list_tutors.Rows[i].Cells[6].Text = "<a href='list_students.aspx?tut_id=" + ds.Tables[0].Rows[i]["tut_id"].ToString() + "'>" + o.ToString() + "</a>";
                }
                else
                {
                    grd_list_tutors.Rows[i].Cells[6].Text = "0";
                }
            }
        }
        else if (Request.QueryString["pac_id"] != null)
        {
            str1 = Request.QueryString["pac_id"].ToString();

            ds = obj.select_from_id(Convert.ToInt32(str1), "select_package_from_id");
            if (ds.Tables[0].Rows.Count > 0)
            {
                grd_list_tutors.DataSource = ds;
                grd_list_tutors.DataBind();
                lbl_error.Visible = false;
            }
            else
            {
                grd_list_tutors.DataSource = null;
                grd_list_tutors.DataBind();
                lbl_error.Visible = true;
            }
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                string a = ds.Tables[0].Rows[i]["tut_id"].ToString();
                int    o = obj.findleads(ds.Tables[0].Rows[i]["tut_id"].ToString());
                if (o > 0)
                {
                    grd_list_tutors.Rows[i].Cells[6].Text = "<a href='list_students.aspx?tut_id=" + ds.Tables[0].Rows[i]["tut_id"].ToString() + "'>" + o.ToString() + "</a>";
                }
                else
                {
                    grd_list_tutors.Rows[i].Cells[6].Text = "0";
                }
            }
        }
        else if (ddl_reduce.SelectedItem.Text == "Show Active" || ddl_reduce.SelectedItem.Text == "Show Inactive")
        {
            string u = ddl_reduce.SelectedItem.Value;
            ds = obj.showdata1(u);
            if (ds.Tables[0].Rows.Count > 0)
            {
                grd_list_tutors.DataSource = ds;
                grd_list_tutors.DataBind();
                lbl_error.Visible = false;
            }
            else
            {
                grd_list_tutors.DataSource = null;
                grd_list_tutors.DataBind();
                lbl_error.Visible = true;
            }
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                string a = ds.Tables[0].Rows[i]["tut_id"].ToString();
                int    o = obj.findleads(a);
                if (o > 0)
                {
                    grd_list_tutors.Rows[i].Cells[6].Text = "<a href='list_students.aspx?tut_id=" + ds.Tables[0].Rows[i]["tut_id"].ToString() + "'>" + o.ToString() + "</a>";
                }
                else
                {
                    grd_list_tutors.Rows[i].Cells[6].Text = "0";
                }
            }
        }

        else
        {
            ds = obj.showdata();
            if (ds.Tables[0].Rows.Count > 0)
            {
                grd_list_tutors.DataSource = ds;
                grd_list_tutors.DataBind();
                lbl_error.Visible = false;
            }
            else
            {
                grd_list_tutors.DataSource = null;
                grd_list_tutors.DataBind();
                lbl_error.Visible = true;
            }
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                string a = ds.Tables[0].Rows[i]["tut_id"].ToString();
                int    o = obj.findleads(ds.Tables[0].Rows[i]["tut_id"].ToString());
                if (o > 0)
                {
                    grd_list_tutors.Rows[i].Cells[6].Text = "<a href='list_students.aspx?tut_id=" + ds.Tables[0].Rows[i]["tut_id"].ToString() + "'>" + o.ToString() + "</a>";
                }
                else
                {
                    grd_list_tutors.Rows[i].Cells[6].Text = "0";
                }
            }
        }
        //}
        //catch (Exception ex)
        //{ }
    }
예제 #10
0
    private void databind()
    {
        string str  = "";
        string str1 = "";

        if (Request.QueryString["Name"] != null && Request.QueryString["ID"] != null)
        {
            str1 = Request.QueryString["Name"].ToString();
            str  = Request.QueryString["ID"].ToString();

            class_list_tutors cls = new class_list_tutors();
            ds = cls.select_from_id(Convert.ToInt32(str), "select_from_id");
            if (ds.Tables[0].Rows.Count > 0)
            {
                txt_name.Text  = ds.Tables[0].Rows[0].ItemArray[1].ToString();
                txt_email.Text = ds.Tables[0].Rows[0].ItemArray[2].ToString();

                txt_phone.Text         = ds.Tables[0].Rows[0].ItemArray[3].ToString();
                txt_status.Text        = ds.Tables[0].Rows[0].ItemArray[4].ToString();
                txt_posted_on.Text     = ds.Tables[0].Rows[0].ItemArray[5].ToString();
                txt_pic.ImageUrl       = ds.Tables[0].Rows[0].ItemArray[6].ToString();
                txt_qualification.Text = ds.Tables[0].Rows[0].ItemArray[7].ToString();
            }
            else
            {
            }
            ds1 = cls.select_from_id(Convert.ToInt32(str), "select_subjects");
            if (ds1.Tables[0].Rows.Count > 0)
            {
                txt_sub.DataSource    = ds1.Tables[0];
                txt_sub.DataTextField = "sub_name";
                txt_sub.DataBind();
            }
            ds1 = cls.select_from_id(Convert.ToInt32(str), "select_locations");
            if (ds1.Tables[0].Rows.Count > 0)
            {
                txt_loc.DataSource    = ds1.Tables[0];
                txt_loc.DataTextField = "loc_name";
                txt_loc.DataBind();
            }
            ds1 = cls.select_from_id(Convert.ToInt32(str), "select_packages");
            if (ds1.Tables[0].Rows.Count > 0)
            {
                txt_pac.DataSource    = ds1.Tables[0];
                txt_pac.DataTextField = "pac_name";
                txt_pac.DataBind();
            }
            ds1 = cls.select_from_id(Convert.ToInt32(str), "select_class");
            if (ds1.Tables[0].Rows.Count > 0)
            {
                txt_class.DataSource    = ds1.Tables[0];
                txt_class.DataTextField = "tut_class";
                txt_class.DataBind();
            }
            ds1 = cls.select_from_id(Convert.ToInt32(str), "select_board");
            if (ds1.Tables[0].Rows.Count > 0)
            {
                txt_board.DataSource    = ds1.Tables[0];
                txt_board.DataTextField = "board_name";
                txt_board.DataBind();
            }
        }
    }
예제 #11
0
    private void databind1()
    {
        try
        {
            class_list_tutors obj = new class_list_tutors();

            string str1 = "";
            if (Request.QueryString["Loc_id"] != null)
            {
                str1 = Request.QueryString["Loc_id"].ToString();

                ds = obj.select_from_id(Convert.ToInt32(str1), "select_location_from_id");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    grd_list_tutors.DataSource = ds;
                    grd_list_tutors.DataBind();
                    lbl_error.Visible = false;
                }
                else
                {
                    grd_list_tutors.DataSource = null;
                    grd_list_tutors.DataBind();
                    lbl_error.Visible = true;
                }
            }

            else if (Request.QueryString["sub_id"] != null)
            {
                str1 = Request.QueryString["sub_id"].ToString();

                ds = obj.select_from_id(Convert.ToInt32(str1), "select_subject_from_id");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    grd_list_tutors.DataSource = ds;
                    grd_list_tutors.DataBind();
                    lbl_error.Visible = false;
                }
                else
                {
                    grd_list_tutors.DataSource = null;
                    grd_list_tutors.DataBind();
                    lbl_error.Visible = true;
                }
            }
            else if (Request.QueryString["pac_id"] != null)
            {
                str1 = Request.QueryString["pac_id"].ToString();

                ds = obj.select_from_id(Convert.ToInt32(str1), "select_package_from_id");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    grd_list_tutors.DataSource = ds;
                    grd_list_tutors.DataBind();
                    lbl_error.Visible = false;
                }
                else
                {
                    grd_list_tutors.DataSource = null;
                    grd_list_tutors.DataBind();
                    lbl_error.Visible = true;
                }
            }
            else
            {
                string stat = ddl_reduce.SelectedValue.ToString();
                ds = obj.select_from_id(0, stat);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    grd_list_tutors.DataSource = ds;
                    grd_list_tutors.DataBind();
                    lbl_error.Visible = false;
                }
                else
                {
                    grd_list_tutors.DataSource = null;
                    grd_list_tutors.DataBind();
                    lbl_error.Visible = true;
                }
            }
            //DateTime dt = new DateTime();
            //for(int i=0;i<ds.Tables[0].Rows.Count();i++)
            //dt=ds.Tables[0].Rows[i].ItemArray[5].ToString();
        }
        catch (Exception ex)
        { }
    }