Aspose.Sitefinity.FormBuilder.AsposeFormBuilder.GridView1_RowCommand C# (CSharp) Method

        protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            try
            {
                string SetupSeletectedItemID = "";

                if (string.Equals(e.CommandName, "EditSetupValue"))     // Update Record Case
                {
                    SetupSeletectedItemID = e.CommandArgument.ToString();
                    Session["SetupSeletectedItemID"] = SetupSeletectedItemID;
                    lbl_Msg.Visible = false;
                    if (Session["AsposeDynamicFormsdataTable"] != null)
                    {
                        DataTable dt = (DataTable)Session["AsposeDynamicFormsdataTable"];
                        if (dt != null)
                        {
                            if (dt.Rows.Count > 0)
                            {
                                DataRow[] drs = dt.Select("[Field ID] = '" + SetupSeletectedItemID + "'");
                                if (drs != null)
                                {
                                    if (drs.Length > 0)
                                    {
                                        btnUpdate.Visible = true;
                                        ProcessButton.Visible = false;
                                        ddlFieldType.SelectedValue = drs[0]["Field Type"].ToString().Trim();
                                        txtFieldId.Text = drs[0]["Field ID"].ToString().Trim();
                                        txtFieldLableText.Text = drs[0]["Field Label Text"].ToString().Trim();
                                        txtFieldValues.Text = drs[0]["Field Values"].ToString().Trim();
                                        if (drs[0]["Is Display"].ToString().Trim().Equals("TRUE"))
                                        {
                                            chkIsDisplay.Checked = true;
                                        }
                                        else
                                        {
                                            chkIsDisplay.Checked = false;
                                        }
                                        txtSortId.Text = drs[0]["Sort ID"].ToString().Trim();
                                    }
                                }
                            }
                        }
                    }
                }
                else if (string.Equals(e.CommandName, "Delete"))
                {                                                   // Delete Record Case
                    SetupSeletectedItemID = e.CommandArgument.ToString();
                    if (!SetupSeletectedItemID.Equals(""))
                    {
                        if (Session["AsposeDynamicFormsdataTable"] != null)
                        {
                            DataTable dt = (DataTable)Session["AsposeDynamicFormsdataTable"];
                            if (dt != null)
                            {
                                DataTable dataTable = null;
                                if (dt.Rows.Count > 0)
                                {
                                    int selectedRow = -1;

                                    if (SetupSeletectedItemID != null || !SetupSeletectedItemID.Equals(""))
                                        selectedRow = Convert.ToInt16(SetupSeletectedItemID);

                                    //Creating a file stream containing the Excel file to be opened

                                    FileStream fstream = new FileStream(Server.MapPath("~/Addons/Aspose.SiteFinity.FormBuilder.ToExcel/uploads/AsposeDynamicFormsDataFile.xlsx"), FileMode.Open, FileAccess.Read);

                                    //Instantiating a Workbook object
                                    //Opening the Excel file through the file stream
                                    Workbook workbook = new Workbook(fstream);

                                    //Accessing a worksheet using its sheet name
                                    Worksheet worksheet = workbook.Worksheets["Settings"];

                                    //Closing the file stream to free all resources
                                    fstream.Close();
                                    selectedRow = selectedRow + 1;
                                    worksheet.Cells.DeleteRow(selectedRow);
                                    workbook.Save(Server.MapPath("~/Addons/Aspose.SiteFinity.FormBuilder.ToExcel/uploads/AsposeDynamicFormsDataFile.xlsx"), SaveFormat.Xlsx);
                                    dataTable = worksheet.Cells.ExportDataTableAsString(0, 0, worksheet.Cells.Rows.Count, 10, true);
                                    Session["AsposeDynamicFormsdataTable"] = dataTable;
                                    lbl_Msg.Visible = true;
                                    lbl_Msg.CssClass = "alertdanger";
                                    lbl_Msg.Text = "Field deleted successfully";
                                    PopulateGrid();
                                    ClearFields();
                                }
                            }
                        }
                    }
                }


            }
            catch (Exception exc)
            {
                ShowException(exc);
            }
        }