public void EditRow(NoOfLeave noOfLeave, int index)
        {
            //get selectedRow from the dataTable, tableCourse
            DataRow selectedRow = dataSet.Tables["JoinEmployeeNoOfLeave"].Rows[index];

            //replace values from course object
            selectedRow["SickLeave"] = noOfLeave.SickLeave;
            selectedRow["VacationLeave"] = noOfLeave.VacationLeave;
            selectedRow["Maternity"] = noOfLeave.MaternityLeave;
            selectedRow["Paternity"] = noOfLeave.PaternityLeave;

            EditRecord(noOfLeave, index);
        }
        public void DeleteRow(NoOfLeave noOfLeave, int index)
        {
            //get selectedRow from the dataTable, tableCourse
            DataRow selectedRow = dataSet.Tables["JoinEmployeeNoOfLeave"].Rows[index];

            //delete selected row from the dataSet
            selectedRow.Delete();

            DeleteRecord(noOfLeave, index);
        }
 public void AddRecord(NoOfLeave noOfLeave)
 {
     connection.Open();
     //set up command
     SqlCommand command = new SqlCommand("jprocedureInsertNoOfLeave", connection);
     //set up commandType
     command.CommandType = CommandType.StoredProcedure;
     //set up parameters
     //command.Parameters.AddWithValue("@LeaveNo", noOfLeave.LeaveNo);
     command.Parameters.AddWithValue("@SickLeave", noOfLeave.SickLeave);
     command.Parameters.AddWithValue("@Maternity", noOfLeave.MaternityLeave);
     command.Parameters.AddWithValue("@Paternity", noOfLeave.PaternityLeave);
     command.Parameters.AddWithValue("@VacationLeave", noOfLeave.VacationLeave);
     command.Parameters.AddWithValue("@EmployeeID", noOfLeave.Employee.EmoloyeeID);
     command.ExecuteNonQuery();
     connection.Close();
 }
        private void EditRecord(NoOfLeave noOfLeave, int index)
        {
            //set up command
            SqlCommand command = new SqlCommand();
            command.Connection = connection;

            //set up commandType
            command.CommandType = CommandType.StoredProcedure;

            //set up procedure name
            command.CommandText = "jprocedureUpdateNoOfLeave";
            dataAdapter.UpdateCommand = command;

            //set up parameters
            command.Parameters.AddWithValue("@LeaveNo", noOfLeave.LeaveNo);
            command.Parameters.AddWithValue("@SickLeave", noOfLeave.SickLeave);
            command.Parameters.AddWithValue("@Maternity", noOfLeave.MaternityLeave);
            command.Parameters.AddWithValue("@Paternity", noOfLeave.PaternityLeave);
            command.Parameters.AddWithValue("@VacationLeave", noOfLeave.VacationLeave);
            command.Parameters.AddWithValue("@EmployeeID", noOfLeave.Employee.EmoloyeeID);

            //update tableCourse from the dataSet
            dataAdapter.Update(dataSet, "JoinEmployeeNoOfLeave");
        }
        private void DeleteRecord(NoOfLeave noOfLeave, int index)
        {
            //set up command
            SqlCommand command = new SqlCommand();
            command.Connection = connection;

            //set up commandType
            command.CommandType = CommandType.StoredProcedure;

            //set up procedure name
            command.CommandText = "jprocedureDeleteNoOfLeave";
            dataAdapter.DeleteCommand = command;

            //set up parameters
            command.Parameters.AddWithValue("@LeaveNo", noOfLeave.LeaveNo);

            //update tableCourse from the dataSet
            dataAdapter.Update(dataSet, "JoinEmployeeNoOfLeave");
        }
 public FormNoOfLeave()
 {
     InitializeComponent();
     admin = new Admin();
     noOfleave = new NoOfLeave();
 }