private void datadisplay() { Seminarbll seminar = new Seminarbll(); DataTable dtsss = seminar.Locationload(); cmbSize.DataSource = dtsss; cmbSize.DisplayMember = "Locations"; cmbSize.ValueMember = "id"; DataTable dt = seminar.load(); clbAttendee.DataSource = dt; clbAttendee.DisplayMember = "Firstname"; clbAttendee.ValueMember = "Attendeeid"; cmbPresenter.DataSource = dt; cmbPresenter.DisplayMember = "Firstname"; cmbPresenter.ValueMember = "Attendeeid"; DataTable dtt = seminar.Sizeload(); cmbSize.DataSource = dtt; cmbSize.DisplayMember = "Capacity"; cmbSize.ValueMember = "id"; }
private void btnAdd_Click(object sender, EventArgs e) { Seminarbll seminar = new Seminarbll(); if (txtTitle.Text == "") { MessageBox.Show("Please enter title"); txtTitle.Focus(); } else if (txtDuration.Text == "") { MessageBox.Show("Please enter Duration"); txtDuration.Focus(); } else if (cmbPresenter.Text == "") { MessageBox.Show("Please select a value"); cmbPresenter.Focus(); } else if (cmbSize.Text == "") { MessageBox.Show("Please select a value"); cmbSize.Focus(); } else { for (int i = 0; i < clbAttendee.Items.Count; i++) { if (clbAttendee.GetItemChecked(i)) { seminar.Title1 = txtTitle.Text; seminar.Date1 = dtpDate.Text; seminar.Time1 = dtpTime.Text; seminar.Presenter1 = cmbPresenter.SelectedValue.ToString(); seminar.Registered1 = clbAttendee.SelectedValue.ToString(); seminar.Size = cmbSize.Text; seminar.Duration1 = txtDuration.Text; seminar.add(); seminar.add2(int.Parse(cmbPresenter.SelectedValue.ToString())); seminar.updatestatus(); seminar.updatesize(); } } MessageBox.Show("Sucessful"); txtTitle.Text = ""; txtDuration.Text = ""; cmbPresenter.Text = ""; cmbSize.Text = ""; if (clbAttendee.CheckedIndices.Count > 0) { clbAttendee.SetItemChecked(clbAttendee.CheckedIndices[0], false); } } Seminarbll sem = new Seminarbll(); DataTable dts = sem.datagridload(); dgSeminar.DataSource = dts; datadisplay(); }
private void SeminarSchedule_Load(object sender, EventArgs e) { Seminarbll sem = new Seminarbll(); DataTable dt = sem.datagridload(); dgSeminar.DataSource = dt; }
private void AddSeminar_Load(object sender, EventArgs e) { Seminarbll sem = new Seminarbll(); DataTable dts = sem.datagridload(); dgSeminar.DataSource = dts; datadisplay(); }
private void dgSeminar_CellClick(object sender, DataGridViewCellEventArgs e) { Seminarbll seminar = new Seminarbll(); int columnIndex = dgSeminar.CurrentCell.ColumnIndex; int seminarid = int.Parse(dgSeminar.CurrentRow.Cells["eid"].Value.ToString()); seminar.Id = seminarid; if (dgSeminar.CurrentRow.Cells[columnIndex].Value.ToString() == "Delete") { DialogResult confirmResult = MessageBox.Show("Are you sure to delete this item??", "Confirm Delete?", MessageBoxButtons.YesNo); if (confirmResult == DialogResult.Yes) { seminar.Delete(); DataTable dt = seminar.datagridload(); dgSeminar.DataSource = dt; } } }