/// <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 ItemID = ((Literal)gr.FindControl("litItemID")).Text;
                objLivelihoodRestoreItemsBLL = new LivelihoodRestoreItemsBLL();

                message = objLivelihoodRestoreItemsBLL.ObsoleteLiveRestItem(Convert.ToInt32(ItemID), Convert.ToString(chk.Checked));
                if (string.IsNullOrEmpty(message) || message == "" || message == "null")
                {
                    message = "Data updated successfully";
                }
                ClearDetails();
                BindGrid(false, true);
                if (message != "")
                {
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// Set Grid Data source
        /// </summary>
        /// <param name="addRow"></param>
        /// <param name="deleteRow"></param>e


        private void BindGrid(bool addRow, bool deleteRow)
        {
            objLivelihoodRestoreItemsBLL = new LivelihoodRestoreItemsBLL();
            objItem = new LivelihoodRestoreItemsBO();

            grdItem.DataSource = objLivelihoodRestoreItemsBLL.GetLiveRestItems_All();//(objItem);
            grdItem.DataBind();
        }
        /// <summary>
        /// To fetch details from database and assign to textbox
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>e


        private void GetItemDetails()
        {
            objLivelihoodRestoreItemsBLL = new LivelihoodRestoreItemsBLL();
            int ItemID = 0;

            if (ViewState["Liv_Rest_ItemID"] != null)
            {
                ItemID = Convert.ToInt32(ViewState["Liv_Rest_ItemID"].ToString());
            }

            objItem = new LivelihoodRestoreItemsBO();
            objItem = objLivelihoodRestoreItemsBLL.GetLiveRestItemsById(ItemID);

            txtItemName.Text = objItem.Liv_Rest_ItemName;
        }
        /// <summary>
        /// Delete details from  Database based on itemid
        /// </summary>
        private void DeleteItem(string ItemID)
        {
            objLivelihoodRestoreItemsBLL = new LivelihoodRestoreItemsBLL();
            string message = string.Empty;

            message = objLivelihoodRestoreItemsBLL.DeleteLiveRestItem(Convert.ToInt32(ItemID));
            if (string.IsNullOrEmpty(message) || message == "" || message == "null")
            {
                message = "Data Deleted successfully";
            }

            ClearDetails();
            BindGrid(false, true);
            if (message != "")
            {
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
            }
        }
        /// <summary>
        /// To save details to database
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>

        protected void btnSave_Click(object sender, EventArgs e)
        {
            string message      = string.Empty;
            string AlertMessage = string.Empty;

            objItem = new LivelihoodRestoreItemsBO();
            objLivelihoodRestoreItemsBLL = new LivelihoodRestoreItemsBLL();

            //Assignement
            objItem.Liv_Rest_ItemName = txtItemName.Text.Trim();

            if (ViewState["Liv_Rest_ItemID"] != null)
            {
                objItem.Liv_Rest_ItemID = Convert.ToInt32(ViewState["Liv_Rest_ItemID"].ToString());
            }

            objItem.IsDeleted = "False";

            if (Session["USER_ID"] != null)
            {
                objItem.CreatedBy = Convert.ToInt32(Session["USER_ID"].ToString());
            }


            if (objItem.Liv_Rest_ItemID < 1)
            {
                //If ItemID does Not exists then SaveItem
                objItem.Liv_Rest_ItemID = -1;//For New Item
                message      = objLivelihoodRestoreItemsBLL.AddLiveRestItem(objItem);
                AlertMessage = "alert('" + message + "');";

                if (string.IsNullOrEmpty(message) || message == "" || message == "null")
                {
                    message = "Data saved successfully";
                    ClearDetails();
                    BindGrid(true, false);
                }
            }
            else
            {
                if (Session["USER_ID"] != null)
                {
                    objItem.UpdatedBy = Convert.ToInt32(Session["USER_ID"].ToString());
                }
                //If ItemID exists then UpdateItem
                message = objLivelihoodRestoreItemsBLL.UpdateLiveRestItem(objItem); //For Updating Item

                if (string.IsNullOrEmpty(message) || message == "" || message == "null")
                {
                    message = "Data updated successfully";
                    ClearDetails();
                    BindGrid(true, false);
                }
            }

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

            SetUpdateMode(false);
        }