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]; }