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);
}
}
