private void ButtonExpenses_Click(object sender, EventArgs e) { AddExpense_form Form_ax = new AddExpense_form(); this.Hide(); Form_ax.Show(); }
private void AddEx_click(object sender, EventArgs e) { ArrayList errors = new ArrayList(); Boolean eventID = true; Boolean details = true; Boolean amount = true; if (comboBoxEv1.SelectedIndex == -1) { eventID = false; errors.Add("please Add EventID"); } if (textBoxdet.Text.Equals("")) { details = false; errors.Add("please add details"); } if (textBoxAmt.Text.Equals("")) { amount = false; errors.Add("please add amount"); } string errorArr = ""; foreach (Object ob in errors) { errorArr = errorArr + "\n" + ob; } if (eventID && details && amount) { OpenConnection(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = ("set IDENTITY_INSERT ON"); cmd.CommandText = ("insert into Expenses([Event Id],[Details],[Amount]) values ('" + comboBoxEv1.SelectedItem + "','" + textBoxdet.Text + "','" + textBoxAmt.Text + "')"); cmd.ExecuteNonQuery(); CloseConnection(); ResetRecords(); DialogResult dResult = MessageBox.Show("Add more Expenses", "Record Inserted Successfully", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dResult == DialogResult.Yes) { AddExpense_form AddExpense = new AddExpense_form(); this.Hide(); AddExpense.Show(); } } else { MessageBox.Show(errorArr); } }