public void btDelete_Click(object sender, EventArgs e)
        {
            string       sqlDelete = "DELETE FROM tb_RateExchange WHERE RateID = '" + txtRateID.Text + "'";
            classDelete  del       = new classDelete();
            DialogResult i         = MessageBox.Show("ທ່ານຕ້ອງການລົບຫົວໜ່ວຍລະຫັນ " + txtRateID.Text + " ແທ້ບໍ່?", "ກະລຸນາຢືນຢັນ", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (i == DialogResult.Yes)
            {
                del.Delete(sqlDelete, connect.DatabaseConnection(constr));
                txtRateID.Text = idauto.SetID(constr, "RateID", "tb_RateExchange", "R000", 1, 4);
                show.ShowData("SELECT * FROM v_RateExchange", connect.DatabaseConnection(constr), dgvRate);
            }
        }
Exemple #2
0
        public void btDelete_Click(object sender, EventArgs e)
        {
            string       sqldeletescript = "Delete from tb_Employee where employeeID = '" + txtEmployeeID.Text + "'";
            classDelete  del             = new classDelete();
            DialogResult i = MessageBox.Show("ທ່ານຕ້ອງການທີ່ຈະລົບ " + txtEmployeeID.Text + " ແທ້ບໍ່?", "ກະລຸນາຢືນຢັນ", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (i == DialogResult.Yes)
            {
                del.Delete(sqldeletescript, connect.DatabaseConnection(constr));
                show.ShowData("SELECT * FROM v_Employee", connect.DatabaseConnection(constr), dgvEmployee);
            }
            txtEmployeeID.Text = idauto.SetID(constr, "EmployeeID", "tb_Employee", "EP00", 2, 3);
        }
        public void btDelete1_Click(object sender, EventArgs e)
        {
            classDelete  del = new classDelete();
            DialogResult i   = MessageBox.Show("ທ່ານຕ້ອງການທີ່ຈະລົບ " + txtID1.Text + " ແທ້ບໍ່?", "ກະລຸນາຢືນຢັນ", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (i == DialogResult.Yes)
            {
                del.Delete("DELETE FROM  tb_FoodAndDrink WHERE FoodID='" + txtID1.Text + "'", connect.DatabaseConnection(constr));
                show.ShowData(sqlshow, connect.DatabaseConnection(constr), dgvEmployee);
                txtID1.Text = autoID.SetID(constr, "FoodID", "tb_FoodAndDrink", "FD00", 2, 3);
                cleartxt();
            }
        }
Exemple #4
0
        public void btDelete_Click(object sender, EventArgs e)
        {
            string       sqldeletescript = "Delete from tb_boat where boatID = '" + txtBoatID.Text + "'";
            classDelete  del             = new classDelete();
            DialogResult i = MessageBox.Show("ທ່ານຕ້ອງການທີ່ຈະລົບ " + txtBoatID.Text + " ແທ້ບໍ່?", "ກະລຸນາຢືນຢັນ", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (i == DialogResult.Yes)
            {
                del.Delete(sqldeletescript, connect.DatabaseConnection(constr));
                selectData.ShowData(sqlshow, connect.DatabaseConnection(constr), dgvboat);
            }
            txtBoatID.Text = autoID.SetID(constr, "BoatID", "tb_Boat", "B0", 1, 2);
            Clear();
        }
Exemple #5
0
        public void btDelete_Click(object sender, EventArgs e)
        {
            string      sqlDelete = "DELETE FROM tb_Unit WHERE UnitID='" + txtUnitID.Text + "'";
            classDelete de        = new classDelete();

            DialogResult i = MessageBox.Show("ທ່ານຕ້ອງການລົບຫົວໜ່ວຍລະຫັນ " + txtUnitID.Text + " ແທ້ບໍ່?", "ກະລຸນາຢືນຢັນ", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (i == DialogResult.Yes)
            {
                de.Delete(sqlDelete, connect.DatabaseConnection(constr));
                show.ShowData("SELECT * FROM v_Unit", connect.DatabaseConnection(constr), dgvUnit);
            }
            txtUnitID.Text = idauto.SetID(constr, "UnitID", "tb_Unit", "UN00", 2, 3);
        }