private void btnAdd_Click(object sender, EventArgs e) { Stallbll stall = new Stallbll(); if (txtDay.Text == "") { MessageBox.Show("Please Enter day"); txtDay.Focus(); } else if (txtStall.Text == "") { MessageBox.Show("Please Stall Type"); txtStall.Focus(); } else { stall.Location1 = cmbLocation.SelectedValue.ToString(); stall.Size1 = cmbSize.SelectedValue.ToString(); stall.Attendee1 = cmbAttendee.SelectedValue.ToString(); stall.Day1 = txtDay.Text; stall.Type = txtStall.Text; stall.add(); stall.updatestatus(); stall.updatesize(); MessageBox.Show("Successful"); txtDay.Text = ""; txtStall.Text = ""; datadisplay(); } }
private void StallSchedule_Load(object sender, EventArgs e) { Stallbll stall = new Stallbll(); DataTable dt = stall.datagridload(); dgStall.DataSource = dt; }
private void AddStall_Load(object sender, EventArgs e) { Stallbll stalls = new Stallbll(); DataTable dtts = stalls.datagridload(); dgStall.DataSource = dtts; datadisplay(); }
private void dgStall_CellClick(object sender, DataGridViewCellEventArgs e) { Stallbll stall = new Stallbll(); int columnIndex = dgStall.CurrentCell.ColumnIndex; int seminarid = int.Parse(dgStall.CurrentRow.Cells["sid"].Value.ToString()); stall.Id = seminarid; if (dgStall.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) { stall.Delete(); DataTable dt = stall.datagridload(); dgStall.DataSource = dt; } } }
private void datadisplay() { Stallbll stall = new Stallbll(); DataTable dt = stall.load(); cmbAttendee.DataSource = dt; cmbAttendee.DisplayMember = "Firstname"; cmbAttendee.ValueMember = "Attendeeid"; DataTable dtt = stall.Sizeload(); cmbSize.DataSource = dtt; cmbSize.DisplayMember = "Capacity"; cmbSize.ValueMember = "Locationid"; DataTable dttss = stall.Locationload(); cmbLocation.DataSource = dttss; cmbLocation.DisplayMember = "Locations"; cmbLocation.ValueMember = "Locationid"; }