예제 #1
0
    private void GetRiDgData(int id)
    {
        DataTable dt  = new DataTable();
        RIDGBll   obj = new RIDGBll();

        obj.Id = id;

        dt = obj.GetRiDgData();

        if (dt.Rows.Count > 0)
        {
            DDLYears.SelectedItem.Text       = dt.Rows[0]["year"].ToString();
            txtRotarian.Text                 = dt.Rows[0]["name"].ToString();
            txtClubName.Text                 = dt.Rows[0]["club_name"].ToString();
            ddlDesignation.SelectedItem.Text = dt.Rows[0]["designation"].ToString();
            txtClassification.Text           = dt.Rows[0]["classification"].ToString();
            txtDescription.Content           = dt.Rows[0]["description"].ToString();

            string strImg = dt.Rows[0]["image"].ToString();
            if (strImg != "")
            {
                Session["RIDGImages"] = strImg;
                memImg.Visible        = true;
                memImg.ImageUrl       = "../RIDGImages/" + strImg;
            }
        }
    }
예제 #2
0
    private void AddRiDgData()
    {
        try
        {
            /************Code for find IP address of user's machine**********/
            string ipaddress;
            ipaddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
            if (ipaddress == "" || ipaddress == null)
            {
                ipaddress = Request.ServerVariables["REMOTE_ADDR"];
            }
            /***************************************************************/

            RIDGBll obj = new RIDGBll();

            obj.Year          = DDLYears.SelectedItem.Text.ToString();
            obj.Name          = txtRotarian.Text.ToString();
            obj.ClubName      = txtClubName.Text.ToString();
            obj.Designation   = ddlDesignation.SelectedItem.Text.ToString();
            obj.Classfication = txtClassification.Text.ToString();
            obj.Description   = txtDescription.Content.ToString();
            obj.Ipaddress     = ipaddress;

            if (Session["RIDGImages"] != null)
            {
                obj.Image = Session["RIDGImages"].ToString();
            }
            else
            {
                obj.Image = "";
            }

            int exe = obj.AddRiDgData();

            if (exe > 0)
            {
                clear();
                string jv = "<script>alert('Record Added Successfully');</script>";
                ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
            }
        }
        catch { }
    }
예제 #3
0
    private void UpdateRiDgData(int id)
    {
        try
        {
            RIDGBll obj = new RIDGBll();

            obj.Id            = id;
            obj.Year          = DDLYears.SelectedItem.Text.ToString();
            obj.Name          = txtRotarian.Text.ToString();
            obj.ClubName      = txtClubName.Text.ToString();
            obj.Designation   = ddlDesignation.SelectedItem.Text.ToString();
            obj.Classfication = txtClassification.Text.ToString();
            obj.Description   = txtDescription.Content.ToString();

            if (Session["RIDGImages"] != null)
            {
                obj.Image = Session["RIDGImages"].ToString();
            }
            else
            {
                obj.Image = "";
            }

            int exe = obj.UpdateRiDgData();


            if (exe > 0)
            {
                clear();
                showmsg("Record Updated Successfully", "view_ri_dg_data.aspx");
                //string jv = "<script>alert('Record Updated Successfully');</script>";
                //ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
            }
        }
        catch { }
    }