protected void BtnSave_Click(object sender, EventArgs e)
    {
        int InsertRow = 0, InsertRowDtls = 0;

        try
        {
            DS = Obj_SL.ChkDuplicate(TxtStockLocation.Text.Trim(), out StrError);
            if (DS.Tables[0].Rows.Count > 0)
            {
                obj_Comm.ShowPopUpMsg("Location Name Already Exist..!", this.Page);
                TxtStockLocation.Focus();
            }
            else
            {
                Entity_SL.Location     = TxtStockLocation.Text.Trim();
                Entity_SL.abbreviation = Txtabbreviations.Text.Trim();
                Entity_SL.SiteId       = 0;
                Entity_SL.TowerId      = 0;
                Entity_SL.CompanyId    = Convert.ToInt32(ddlcompany.SelectedValue);
                Entity_SL.SiteAddr     = TxtSiteAddr.Text;
                Entity_SL.UserId       = Convert.ToInt32(Session["UserId"]);
                Entity_SL.LoginDate    = DateTime.Now;
                Entity_SL.IsDeleted    = false;
                Entity_SL.IsCental     = chkCenLoc.Checked ? true : false;
                InsertRow = Obj_SL.InsertRecord(ref Entity_SL, out StrError);

                if (InsertRow > 0)
                {
                    if (ViewState["CurrentTable"] != null)
                    {
                        DataTable dtInsert = new DataTable();
                        dtInsert = (DataTable)ViewState["CurrentTable"];
                        for (int i = 0; i < dtInsert.Rows.Count; i++)
                        {
                            Entity_SL.StockLocationID = InsertRow;
                            Entity_SL.EmployeeId      = Convert.ToInt32(dtInsert.Rows[i]["EmployeeId"].ToString());
                            Entity_SL.CpersonName     = dtInsert.Rows[i]["PersonName"].ToString();
                            Entity_SL.ContactNo       = dtInsert.Rows[i]["ContactNo"].ToString();
                            Entity_SL.MailId          = dtInsert.Rows[i]["EmailId"].ToString();
                            Entity_SL.PersonAddress   = dtInsert.Rows[i]["Address"].ToString();
                            InsertRowDtls             = Obj_SL.InsertDetailsRecord(ref Entity_SL, out StrError);
                        }
                    }
                    if (InsertRow != 0)
                    {
                        obj_Comm.ShowPopUpMsg("Record Saved Successfully", this.Page);
                        MakeControlEmpty();
                        MakeEmptyForm();
                        Entity_SL = null;
                        obj_Comm  = null;
                    }
                }
            }
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
    }
    //User Right Function===========

    private void MakeEmptyForm()
    {
        TxtStockLocation.Focus();
        if (!FlagAdd)
        {
            BtnSave.Visible = true;
        }
        BtnUpdate.Visible           = false;
        BtnDelete.Visible           = false;
        TxtStockLocation.Text       = string.Empty;
        ddlPersonName.SelectedValue = "0";
        TxtSiteAddr.Text            = string.Empty;
        Txtabbreviations.Text       = string.Empty;
        TxtSearch.Text    = string.Empty;
        chkCenLoc.Checked = false;
        SetInitialRow();
        ReportGrid(StrCondition);
    }
    protected void GrdReport_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        try
        {
            switch (e.CommandName)
            {
            case ("Select"):
            {
                if (Convert.ToInt32(e.CommandArgument) != 0)
                {
                    ViewState["EditID"] = Convert.ToInt32(e.CommandArgument);
                    DS = Obj_SL.GetStockLOcationForEdit(Convert.ToInt32(e.CommandArgument), out StrError);
                    if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
                    {
                        ddlcompany.SelectedValue = DS.Tables[0].Rows[0]["CompanyID"].ToString();
                        TxtStockLocation.Text    = DS.Tables[0].Rows[0]["Location"].ToString();
                        Txtabbreviations.Text    = DS.Tables[0].Rows[0]["abbreviation"].ToString();
                        TxtSiteAddr.Text         = DS.Tables[0].Rows[0]["SiteAddr"].ToString();
                        if (Convert.ToBoolean(DS.Tables[0].Rows[0]["IsCentral"].ToString()) == true)
                        {
                            chkCenLoc.Checked = true;
                        }
                        else
                        {
                            chkCenLoc.Checked = false;
                        }
                    }
                    else
                    {
                        MakeEmptyForm();
                    }
                    if (DS.Tables[1].Rows.Count > 0)
                    {
                        GridDetails.DataSource = DS.Tables[1];
                        GridDetails.DataBind();
                        ViewState["CurrentTable"] = DS.Tables[1];
                    }
                    else
                    {
                        SetInitialRow();
                    }
                    DS     = null;
                    Obj_SL = null;
                    if (!FlagEdit)
                    {
                        BtnUpdate.Visible = true;
                    }
                    BtnSave.Visible = false;
                    if (!FladDel)
                    {
                        BtnDelete.Visible = true;
                    }
                    TxtStockLocation.Focus();
                    MakeControlEmpty();
                }

                break;
            }
            }
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
    }