private void Attendeeschedule_Load(object sender, EventArgs e)
{
Attendeebll attendee = new Attendeebll();
DataTable dt = attendee.datagridload();
dgAttendee.DataSource = dt;
}
private void dgAttendee_CellClick(object sender, DataGridViewCellEventArgs e)
{
Attendeebll attendee = new Attendeebll();
int columnIndex = dgAttendee.CurrentCell.ColumnIndex;
int attendeid = int.Parse(dgAttendee.CurrentRow.Cells["aid"].Value.ToString());
attendee.Id = attendeid;
if (dgAttendee.CurrentRow.Cells[columnIndex].Value.ToString() == "Edit")
{
DataTable dts = attendee.loaddata();
txtFirst.Text = dts.Rows[0][0].ToString();
txtLast.Text = dts.Rows[0][1].ToString();
txtEmail.Text = dts.Rows[0][2].ToString();
cmbTicket.Text = dts.Rows[0][3].ToString();
txtNumber.Text = dts.Rows[0][4].ToString();
btnAdd.Text = "Update";
}
else if (dgAttendee.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)
{
attendee.Delete();
DataTable dt = attendee.datagridload();
dgAttendee.DataSource = dt;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txtFirst.Text == "")
{
MessageBox.Show("Please enter a firstname");
}
else if (txtLast.Text == "")
{
MessageBox.Show("Please enter a lastname");
}
else if (txtEmail.Text == "")
{
MessageBox.Show("Please enter a Email");
}
else if (txtNumber.Text == "")
{
MessageBox.Show("Please enter a Number of days");
}
else if (cmbTicket.Text == "")
{
MessageBox.Show("Please select a type of ticket");
}
else
{
if (btnAdd.Text == "Add")
{
Attendeebll attendee = new Attendeebll();
attendee.Firstname = txtFirst.Text;
attendee.Lastname1 = txtLast.Text;
attendee.Numberofdays = txtNumber.Text;
attendee.Email1 = txtEmail.Text;
attendee.Typeofticket1 = cmbTicket.Text;
attendee.add();
MessageBox.Show("Successful");
txtFirst.Text = txtLast.Text = txtEmail.Text = txtNumber.Text = "";
Attendeebll attende = new Attendeebll();
DataTable dt = attende.datagridload();
dgAttendee.DataSource = dt;
}
else if (btnAdd.Text == "Update")
{
Attendeebll attendee = new Attendeebll();
attendee.update();
MessageBox.Show("Updated");
btnAdd.Text = "Add";
txtFirst.Text = txtLast.Text = txtEmail.Text = txtNumber.Text = "";
Attendeebll attende = new Attendeebll();
DataTable dt = attende.datagridload();
dgAttendee.DataSource = dt;
}
}
}