Ejemplo n.º 1
0
        /// <summary>
        /// Set edit mode for edit comand
        /// Delete data from the database for delete comand
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void grdCounty_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            string message = string.Empty;

            if (e.CommandName == "EditRow")
            {
                ViewState["COUNTYID"] = e.CommandArgument;
                GetCountyById();
                SetUpdateMode(true);
                pnlCountyDetails.Visible = true;
                pnlSearch.Visible        = false;
            }
            else if (e.CommandName == "DeleteRow")
            {
                // ViewState["CDAPBUDGETID"] = e.CommandArgument;
                CountyBLL CountyBLLobj = new CountyBLL();
                message = CountyBLLobj.DeleteCounty(Convert.ToInt32(e.CommandArgument));
                if (string.IsNullOrEmpty(message) || message == "" || message == "null")
                {
                    message = "Data deleted successfully";
                }
                SetUpdateMode(false);
                ClearData();
                BindGrid();
            }
            if (message != "")
            {
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
            }
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Update Database Make data as Obsoluted
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void IsObsolete_CheckedChanged(Object sender, EventArgs e)
        {
            string message = string.Empty;

            try
            {
                CheckBox    chk = (CheckBox)sender;
                GridViewRow gr  = (GridViewRow)chk.Parent.Parent;

                string COUNTYID = ((Literal)gr.FindControl("litCOUNTYID")).Text;

                CountyBLL CountyBLLobj = new CountyBLL();
                message = CountyBLLobj.ObsoleteCounty(Convert.ToInt32(COUNTYID), Convert.ToString(chk.Checked), Convert.ToInt32(Session["USER_ID"]));
                if (string.IsNullOrEmpty(message) || message == "" || message == "null")
                {
                    message = "Data updated successfully";
                }
                ClearData();
                BindGrid();
                if (message != "")
                {
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Obsoleted", "alert('" + message + "');", true);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 3
0
        /// <summary>
        /// Set Grid Data source
        /// </summary>
        /// <param name="addRow"></param>
        /// <param name="deleteRow"></param>e
        public void searchBind(string County)
        {
            CountyBLL CountyBLLobj = new CountyBLL();

            grdCounty.DataSource = CountyBLLobj.GetCounties(County);
            grdCounty.DataBind();
            // DDLSearchDistrictName.ClearSelection();
            //txtSearchCounty.Text = string.Empty;
        }
Ejemplo n.º 4
0
        /// <summary>
        /// Set Grid Data source
        /// </summary>
        /// <param name="addRow"></param>
        /// <param name="deleteRow"></param>e
        private void BindGrid()
        {
            int districtID = Convert.ToInt32(ddlDistrictName.SelectedValue);
            //int districtID = Convert.ToInt32(ViewState["DISTRICTID"]);
            CountyBLL CountyBLLobj = new CountyBLL();

            grdCounty.DataSource = CountyBLLobj.GetAllCounties(districtID);
            grdCounty.DataBind();
        }
Ejemplo n.º 5
0
        /// <summary>
        /// to update data to database
        /// </summary>
        /// <returns></returns>
        private void UpdateCounty()
        {
            CountyBLL CountyBLLobj = new CountyBLL();
            CountyBO  CountyBOobj  = new CountyBO();
            string    message      = "";

            try
            {
                if (ViewState["COUNTYID"] != null)
                {
                    CountyBOobj.CountyID = Convert.ToInt32(ViewState["COUNTYID"].ToString());
                }

                string uID = string.Empty;
                uID = Session["USER_ID"].ToString();

                CountyBOobj.DistrictID = Convert.ToInt32(ddlDistrictName.SelectedItem.Value);
                CountyBOobj.CountyName = txtCounty.Text.Trim();
                CountyBOobj.UpdatedBy  = Convert.ToInt32(uID);

                message = CountyBLLobj.UpdateCounty(CountyBOobj);

                if (string.IsNullOrEmpty(message) || message == "" || message == "null")
                {
                    message = "Data updated successfully";
                }

                ClearData();
                SetUpdateMode(false);
                BindGrid();

                if (message != "")
                {
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "alert('" + message + "');", true);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                CountyBLLobj = null;
            }
        }
Ejemplo n.º 6
0
        /// <summary>
        /// to get county names based on ID
        /// </summary>
        /// <returns></returns>
        private void GetCountyById()
        {
            CountyBLL CountyBLLobj = new CountyBLL();

            CountyBO CountyBOobj = CountyBLLobj.GetCountyById(Convert.ToInt32(ViewState["COUNTYID"]));

            if (CountyBOobj != null)
            {
                txtCounty.Text = CountyBOobj.CountyName;
            }
            ddlDistrictName.ClearSelection();
            if (ddlDistrictName.Items.FindByText(CountyBOobj.DistrictName.ToString()) != null)
            {
                ddlDistrictName.Items.FindByText(CountyBOobj.DistrictName.ToString()).Selected = true;
            }
            CountyBOobj  = null;
            CountyBLLobj = null;
        }
Ejemplo n.º 7
0
        /// <summary>
        /// to save data to database
        /// </summary>
        /// <returns></returns>
        private void SaveCounty()
        {
            CountyBLL CountyBLLobj = new CountyBLL();
            CountyBO  CountyBOobj  = new CountyBO();

            string message = "";


            string uID = string.Empty;

            uID = Session["USER_ID"].ToString();

            CountyBOobj.DistrictID = Convert.ToInt32(ddlDistrictName.SelectedItem.Value);
            CountyBOobj.CountyName = txtCounty.Text.Trim();
            CountyBOobj.CreatedBy  = Convert.ToInt32(uID);

            try
            {
                message = CountyBLLobj.AddCounty(CountyBOobj);

                if (string.IsNullOrEmpty(message) || message == "" || message == "null")
                {
                    message = "Data saved successfully";
                }

                if (message != "")
                {
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
                }

                ClearData();
                BindGrid();
            }
            catch (Exception ee)
            {
                throw ee;
            }
            finally
            {
                CountyBLLobj = null;
            }
        }