Exemple #1
0
        private void saveBtn_Click(object sender, EventArgs e)
        {
            int er = 0;

            ep.Clear();

            if (txtName.Text == "")
            {
                er++;
                ep.SetError(txtName, "Name Required");
            }

            if (txtDescription.Text == "")
            {
                er++;
                ep.SetError(txtDescription, "Description Required");
            }

            if (txtDuration.Text == "")
            {
                er++;
                ep.SetError(txtDuration, "Duration Required");
            }

            if (txtMinimumCredit.Text == "")
            {
                er++;
                ep.SetError(txtMinimumCredit, "Minimum Credit Required");
            }

            if (cmbDepartment.Text == "")
            {
                er++;
                ep.SetError(cmbDepartment, "Department Required");
            }
            if (er == 0)
            {
                DAL.Program program = new DAL.Program();

                program.Name          = txtName.Text;
                program.Description   = txtDescription.Text;
                program.Duration      = Convert.ToInt32(txtDuration.Text);
                program.MinimumCredit = Convert.ToInt32(txtMinimumCredit.Text);
                program.DepartmentId  = Convert.ToInt32(cmbDepartment.SelectedValue);

                if (program.Insert())
                {
                    MessageBox.Show("Data Saved");
                    txtName.Text          = "";
                    txtDescription.Text   = "";
                    txtDuration.Text      = "";
                    txtMinimumCredit.Text = "";
                    cmbDepartment.Text    = "";
                }
                else
                {
                    MessageBox.Show(program.Error);
                }
            }
        }
        private void cmbDepartment_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cmbDepartment.SelectedValue == null || cmbDepartment.SelectedValue.ToString() == "")
            {
                return;
            }

            try
            {
                DAL.Program program = new DAL.Program();
                program.DepartmentId  = Convert.ToInt32(cmbDepartment.SelectedValue);
                cmbProgram.DataSource = program.Select().Tables[0];

                cmbProgram.DisplayMember = "name";
                cmbProgram.ValueMember   = "Id";
                cmbProgram.SelectedValue = -1;
            }
            catch (Exception)
            {
            }
        }
 private void searchBtn_Click(object sender, EventArgs e)
 {
     DAL.Program program = new DAL.Program();
     dgvData.DataSource = program.Select().Tables[0];
 }