private void tableBookingToolStripMenuItem_Click(object sender, EventArgs e) { Tablebook tb = new Tablebook(); tb.Show(); this.Refresh(); }
private void savetxt_Click(object sender, EventArgs e) { try { char ch = ' '; if (fstnameTxt.Text != "") { ch = fstnameTxt.Text[0]; } if ((fstnameTxt.Text == "") || (phoneNotxt.Text == "") || (gmailtxt.Text == "") || (tablenotxt.Text == "") || (dateTimePicker1.Text == "")) { MessageBox.Show("Fields all "); } else if (!((gmailtxt.Text.Contains("@")) && (gmailtxt.Text.Contains(".")))) { MessageBox.Show("Invalid E-mail ID"); } else if ((gmailtxt.Text.IndexOf("@")) > (gmailtxt.Text.LastIndexOf("."))) { MessageBox.Show("Invalid E-mail ID"); } string query = ""; query = "INSERT INTO [dbo].[Reservation] ([Firstname] ,[Lastname] ,[Gmail] ,[Phone],[Date],[TableNo]) VALUES('" + fstnameTxt.Text + "','" + scndnameTxt.Text + "','" + gmailtxt.Text + "','" + phoneNotxt.Text + "','" + dateTimePicker1.Text + "','" + tablenotxt.Text + "')"; int row = DataAccess.ExecuteQuery(query); if (row > 0) { MessageBox.Show("Reservation successful"); Tablebook tb = new Tablebook(); tb.Show(); this.Close(); this.Dispose(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void selectDateTimeToolStripMenuItem_Click(object sender, EventArgs e) { Tablebook tb = new Tablebook(); tb.Show(); }