private void SaveButton_Click(object sender, EventArgs e)
 {
     if (string.IsNullOrEmpty(DeptNameTextBox.Text))
     {
         MessageBox.Show("Opps! Something went wrong!", "There's an Empty Field." + Environment.NewLine + "Please Fill-up the form and Try again!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
         DeptNameTextBox.Focus();
     }
     else
     {
         /*
          * int adminid = 1;
          * string add = "Add";
          * int id = 1;
          * string comment = "Added Successfully";
          */
         cmd = new OleDbCommand("insert into department(deptname) values(@deptname)", con);
         //cmd1 = new OleDbCommand("insert into audittrail(action,tableid,comment) values(@add,@id,@comment)", con);
         con.Open();
         cmd.Parameters.AddWithValue("@deptname", DeptNameTextBox.Text);
         //cmd1.Parameters.AddWithValue("@add",add);
         //cmd1.Parameters.AddWithValue("@id", id);
         //cmd1.Parameters.AddWithValue("@comment", comment);
         cmd.ExecuteNonQuery();
         //cmd1.ExecuteNonQuery();
         con.Close();
         MessageBox.Show("Record Saved Successfully!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
         Form1 form = new Form1();
         this.Hide();
         form.Show();
     }
 }
        private void CancelButton_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrWhiteSpace(DeptNameTextBox.Text))
            {
                this.Hide();
            }
            else
            {
                var result = MessageBox.Show("There are still unsaved changes." + Environment.NewLine + "are you sure you want to continue?", "Textbox has been filled!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

                if (result == DialogResult.Yes)
                {
                    this.Close();
                }
                else if (result == DialogResult.No)
                {
                    DeptNameTextBox.Focus();
                }
            }
        }
        private void SaveButton_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(DeptNameTextBox.Text))
            {
                MessageBox.Show("There's an Empty Field." + Environment.NewLine + "Please Fill-up the form and Try again!", "Opps! Something went wrong!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                DeptNameTextBox.Focus();
            }
            else
            {
                string       adminid = "admin";
                string       action  = "Add Department Record";
                string       table   = "dept";
                string       eid     = "N/A";
                string       today   = DateTime.Now.ToString("dd/MM/yyyy h:mm tt");
                const string sql1    = "insert into audittrail (adminname,[action],[tablename],eid,[accesstime]) values (@adminname,@action,@tablename,@eid,@accesstime)";
                cmd1 = new OleDbCommand(sql1, con);
                cmd1.Parameters.AddWithValue("@adminname", adminid);
                cmd1.Parameters.AddWithValue("[@action]", action);
                cmd1.Parameters.AddWithValue("[@tablename]", table);
                cmd1.Parameters.AddWithValue("[@eid]", eid);
                cmd1.Parameters.AddWithValue("[@accesstime]", today);

                const string sql = "insert into dept(dept) values(@deptname)";

                cmd = new OleDbCommand(sql, Con);
                Con.Open();
                cmd.Parameters.AddWithValue("@deptname", DeptNameTextBox.Text);
                cmd1.ExecuteNonQuery();
                int result = cmd.ExecuteNonQuery();

                if (result > 0)
                {
                    MessageBox.Show("Record Saved Successfully!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    Con.Close();
                    DeptForm form = new DeptForm();
                    form.Show();
                    Hide();
                }
            }
        }