private void cmbEmpID_SelectedIndexChanged(object sender, EventArgs e)
        {
            AdvanceLoan         Advance = new AdvanceLoan();
            Tuple <int, double> result  = Advance.IndexChange(cmbEmpID.Text);

            txtInstallment.Text = result.Item1.ToString();
            txtLoanAmount.Text  = result.Item2.ToString();
        }
        void FillComboID()
        {
            AdvanceLoan   Advance = new AdvanceLoan();
            List <string> range   = Advance.FillComboID();

            foreach (string item in range)
            {
                cmbEmpID.Items.Add(item);
            }
        }
        private void btnInsert_Click(object sender, EventArgs e)
        {
            AdvanceLoan advance = new AdvanceLoan();

            if (txtLoanRemain.Text == "" || txtRemain.Text == "")
            {
                MessageBox.Show("Press Check button before continue");
            }
            else
            {
                advance.Update_Loan(Convert.ToInt32(cmbEmpID.Text), Convert.ToInt32(txtRemain.Text), Payments);
            }

            cmbEmpID.ResetText();
            txtInstallment.Clear();
            txtLoanAmount.Clear();
            txtLoanPayNow.Clear();
            txtLoanRemain.Clear();
            txtRemain.Clear();
        }