Esempio n. 1
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            SqlConnection conn;

            conn = DB.getinstance();
            conn.Open();
            ClsDonor D = new ClsDonor();

            D.Delete = Convert.ToInt32(txtDelete.Text);

            try
            {
                D.delete();
                MessageBox.Show("Donor deleted succesffully.");
                dataGridView1.DataSource = null;

                dataGridView2.DataSource = new ClsDonor.DonorDAL().GetAllDonor();
                dataGridView2.Enabled    = true;
            }
            catch (Exception)
            {
                MessageBox.Show("Donor Can't be deleted.");
            }
            txtDelete.Text = "";
        }
Esempio n. 2
0
        private void btnInsert_Click(object sender, EventArgs e)
        {
            SqlConnection conn;

            conn = DB.getinstance();
            conn.Open();
            ClsDonor D = new ClsDonor();

            D.Donor_Name       = txtDonorName.Text;
            D.Donor_Age        = Convert.ToInt32(txtDonorAge.Text);
            D.Donor_BloodGroup = txtBloodGroup.Text;
            if (rdbMale.Checked == true)
            {
                D.Donor_Gender = rdbMale.Text;
            }
            else if (rdbFemale.Checked == true)
            {
                D.Donor_Gender = rdbFemale.Text;
            }
            D.Donor_Phone   = Convert.ToInt32(txtDonorContact.Text);
            D.Donor_Address = txtAddress.Text;
            D.Donor_Id      = Convert.ToInt32(txtDonorId.Text);
            D.Branch_Id     = Convert.ToInt32(txtBranch.Text);

            try
            {
                D.insert();
                MessageBox.Show("Info inserted");

                txtDonorId.Text      = new ClsDonor.DonorDAL().GetDonorId();
                txtDonorName.Text    = "";
                txtDonorAge.Text     = "";
                txtBloodGroup.Text   = "";
                txtBloodGroup.Text   = "";
                rdbMale.Checked      = false;
                rdbFemale.Checked    = false;
                txtDonorContact.Text = "";
                txtAddress.Text      = "";
                txtBranch.Text       = "";

                dataGridView2.DataSource = new ClsDonor.DonorDAL().GetAllDonor();
                dataGridView2.Enabled    = true;
            }
            catch (Exception)
            {
                MessageBox.Show("Kindly check your data..");
            }
        }
Esempio n. 3
0
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            SqlConnection conn;

            conn = DB.getinstance();
            conn.Open();
            ClsDonor Donor = new ClsDonor();

            Donor.Id         = Convert.ToInt32(txtId.Text);
            Donor.Name       = txtName.Text;
            Donor.Age        = Convert.ToInt32(txtAge.Text);
            Donor.BloodGroup = bg.Text;
            if (btnMale.Checked == true)
            {
                Donor.Gender = btnMale.Text;
            }
            else if (btnFemale.Checked == true)
            {
                Donor.Gender = btnFemale.Text;
            }
            Donor.Phone   = Convert.ToInt32(txtContact.Text);
            Donor.Address = txtDAddress.Text;
            try
            {
                Donor.update();
                MessageBox.Show("Donor Updated.");

                dataGridView2.DataSource = new ClsDonor.DonorDAL().GetAllDonor();
                dataGridView2.Enabled    = true;
            }
            catch (Exception)
            {
                MessageBox.Show("Error");
            }
            txtId.Text        = "";
            txtName.Text      = "";
            txtAge.Text       = "";
            bg.Text           = "";
            btnMale.Checked   = false;
            btnFemale.Checked = false;
            txtContact.Text   = "";
            txtDAddress.Text  = "";
        }