private void ButtonEvent_Click(object sender, EventArgs e)
{
AddEventform Form_ae = new AddEventform();
this.Hide();
Form_ae.Show();
}
private void AddEvent_click(object sender, EventArgs e)
{
ArrayList error1 = new ArrayList();
Boolean eventName = true;
Boolean eventVenue = true;
Boolean time = true;
Boolean status = true;
if (textBoxName.Text.Equals(""))
{
eventName = false;
error1.Add("please Add Event Name");
}
if (textBoxvenue.Text.Equals(""))
{
eventVenue = false;
error1.Add("please add Venue");
}
if (textBoxTime.Text.Equals(""))
{
time = false;
error1.Add("please add time");
}
if (comboBoxStat.SelectedIndex == -1)
{
status = false;
error1.Add("please add status");
}
string errorArr1 = "";
foreach (Object ob in error1)
{
errorArr1 = errorArr1 + "\n" + ob;
}
if (eventName && eventVenue && time && status)
{
OpenConnection();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = ("set IDENTITY_INSERT ON");
cmd.CommandText = ("insert into Events([Event Name], [Event Date], [Event Venue],[Time],[Status]) values ('" + textBoxName.Text + "','" + dateTimePicker1.Value.ToString() + "','" + textBoxvenue.Text + "','" + textBoxTime.Text + "','" + comboBoxStat.SelectedItem + "')");
cmd.ExecuteNonQuery();
CloseConnection();
DialogResult dResult = MessageBox.Show("Add more Events", "Record Inserted Successfully", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dResult == DialogResult.Yes)
{
AddEventform Addevent = new AddEventform();
this.Hide();
Addevent.Show();
}
}
else
{
MessageBox.Show(errorArr1);
}
}