protected void gvViewEmployee_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            TableCell cell = gvViewEmployee.Rows[e.RowIndex].Cells[1];
            int employeeID = Convert.ToInt32(cell.Text);

            emDAL = new EMDataAccessLayer();
            try
            {

                int retVal = emDAL.DeleteEmployee(employeeID);
                if (retVal == 1)
                {
                    lblStatus.Text = "Deleted Successfully!!!";
                    lblStatus.Visible = true;
                    try
                    {
                        gvViewEmployee.DataSource = emDAL.ViewJoinedEmployee();
                        gvViewEmployee.DataBind();
                    }
                    catch
                    {
                        lblStatus.Text = "Error in fetching the employee details!";
                        lblStatus.Visible = true;
                    }
                }
                else
                {
                    lblStatus.Text = "Error occured in deleting";
                    lblStatus.Visible = true;
                }
            }
            catch
            {
                lblStatus.Text = "Delete Operation Failed!!";
                lblStatus.Visible = true;
            }
        }
 private void ViewEmployee()
 {
     emDAL = new EMDataAccessLayer();
     if (!IsPostBack)
     {
         try
         {
             gvViewEmployee.DataSource = emDAL.ViewJoinedEmployee();
             gvViewEmployee.DataBind();
         }
         catch
         {
             lblStatus.Text = "Error in fetching the employee details!";
             lblStatus.Visible = true;
         }
     }
 }