private void btnAddRecoveryDetl_Click(object sender, EventArgs e)
        {
            AddAuditDRPlanningDetl AuditDRPlan = new AddAuditDRPlanningDetl();

            AuditDRPlan.objAuditDRPlanning = this;
            AuditDRPlan.ShowDialog();
        }
        private void gvAuditEmpPlanningDetl_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            objSQLdb = new SQLDB();
            string          strCmd        = "";
            string          strComp       = "";
            string          strBranchCode = "";
            string          strBranType   = "";
            string          strBranName   = "";
            string          strRmarks     = "";
            DateTime        dtpPlanDate;
            DataGridViewRow rowIndex;

            if (e.RowIndex >= 0)
            {
                if (e.ColumnIndex == gvAuditEmpPlanningDetl.Columns["Edit"].Index)
                {
                    if (Convert.ToBoolean(gvAuditEmpPlanningDetl.Rows[e.RowIndex].Cells["Edit"].Selected) == true)
                    {
                        rowIndex = gvAuditEmpPlanningDetl.Rows[e.RowIndex];

                        strComp       = gvAuditEmpPlanningDetl.Rows[e.RowIndex].Cells["CompCode"].Value.ToString();
                        strBranchCode = gvAuditEmpPlanningDetl.Rows[e.RowIndex].Cells["LocationCode"].Value.ToString();
                        strBranType   = gvAuditEmpPlanningDetl.Rows[e.RowIndex].Cells["BranchType"].Value.ToString();
                        dtpPlanDate   = Convert.ToDateTime(gvAuditEmpPlanningDetl.Rows[e.RowIndex].Cells["Date"].Value.ToString());
                        strRmarks     = gvAuditEmpPlanningDetl.Rows[e.RowIndex].Cells["Remarks"].Value.ToString();

                        AddAuditDRPlanningDetl AuditDRPlan = new AddAuditDRPlanningDetl(dtpPlanDate, strComp, strBranchCode, strBranType, strRmarks, rowIndex);
                        AuditDRPlan.objAuditDRPlanning = this;
                        AuditDRPlan.ShowDialog();

                        OrderSlNo();
                    }
                }

                if (e.ColumnIndex == gvAuditEmpPlanningDetl.Columns["Del"].Index)
                {
                    DialogResult dlgResult = MessageBox.Show("Do you want delete this record?", "Confirm?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                    if (dlgResult == DialogResult.Yes)
                    {
                        strCmd = "DELETE FROM AUDIT_DR_PLANNING WHERE ADRP_EORA_CODE=" + Convert.ToInt32(cbAuditEmployees.Text.ToString().Split('-')[0]) +
                                 " AND ADRP_DATE='" + Convert.ToDateTime(gvAuditEmpPlanningDetl.Rows[e.RowIndex].Cells["Date"].Value).ToString("dd/MMM/yyyy") +
                                 "'AND ADRP_TRN_TYPE='" + gvAuditEmpPlanningDetl.Rows[e.RowIndex].Cells["BranchType"].Value.ToString() +
                                 "'AND ADRP_LOCATION='" + gvAuditEmpPlanningDetl.Rows[e.RowIndex].Cells["LocationCode"].Value.ToString() + "' ";

                        int iRes = objSQLdb.ExecuteSaveData(strCmd);

                        DataGridViewRow dgvr = gvAuditEmpPlanningDetl.Rows[e.RowIndex];
                        gvAuditEmpPlanningDetl.Rows.Remove(dgvr);


                        MessageBox.Show("Selected Data Deleted Sucessfully", "SSERP", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        OrderSlNo();
                        //FillEmpAuditPlanningDetl();
                    }
                }
            }
        }