private void addNotice_Click(object sender, EventArgs e)
{
addNotice Addnotice = new addNotice();
this.Hide();
Addnotice.Show();
}
private void AddNotice_Click(object sender, EventArgs e)
{
ArrayList error2 = new ArrayList();
Boolean NoticeCat = true;
Boolean Details = true;
if (Category.Equals(""))
{
NoticeCat = false;
error2.Add("please Add Notice Category");
}
if (richTextBox1.Text.Equals(""))
{
Details = false;
error2.Add("please add Details");
}
string errorArr2 = "";
foreach (Object ob in error2)
{
errorArr2 = errorArr2 + "\n" + ob;
}
if (NoticeCat && Details)
{
OpenConnection();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = ("set IDENTITY_INSERT ON");
cmd.CommandText = ("insert into Notices( [Published Date] ,[Expiration Date], [Category],[Details]) values('" + dateTimePicker1.Value.ToString() + "','" + dateTimePicker2.Value.ToString() + "','" + Category + "','" + richTextBox1.Text + "')");
cmd.ExecuteNonQuery();
CloseConnection();
ResetRecords();
DialogResult dResult = MessageBox.Show("Add more Notices", "Record Inserted Successfully", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dResult == DialogResult.Yes)
{
addNotice Addnotice = new addNotice();
this.Hide();
Addnotice.Show();
}
}
else
{
MessageBox.Show(errorArr2);
}
}