private void cmdOk_Click(object sender, EventArgs e)
        {
            try
            {
                if (System.IO.File.Exists(MyModules.ConfigFile))
                {
                    System.IO.File.Delete(MyModules.ConfigFile);
                }

                System.IO.StreamWriter objWriter = new System.IO.StreamWriter(MyModules.ConfigFile, true, System.Text.Encoding.UTF8);

                objWriter.Write(cboServerName.Text);
                objWriter.Write(Environment.NewLine);
                objWriter.Write(txtAttachName.Text);
                objWriter.Write(Environment.NewLine);
                objWriter.Write(chkWinAuthen.Checked);
                objWriter.Write(Environment.NewLine);
                objWriter.Write(txtUserID.Text);
                objWriter.Write(Environment.NewLine);
                objWriter.Write(txtPassword.Text);
                objWriter.Write(Environment.NewLine);
                objWriter.Write(txtOwner.Text);
                objWriter.Close();

                MyModules.InitialiseEntireSystem();
                MessageBox.Show("Update Successfull" + char.ConvertFromUtf32(13) + "Pls. Restart", MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
                //InitialiseEntireSystem()
                System.Environment.Exit(0);
                //Me.Close()
            }
            catch (Exception er)
            {
                MessageBox.Show(er.Message, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
        private void cmdOk_Click(object sender, EventArgs e)
        {
            try
            {
                SqlConnection cnSQL = new SqlConnection(MyModules.strConnect);
                SqlCommand    cmSQL = new SqlCommand("FetchUserAccessByPwd", cnSQL);
                // SqlDataReader drSQL;

                cnSQL.Open();


                // byte[] arrayLogo = { 0 };
                byte[] arrayLogo = null;

                if ((OwnerLogo.Image == null) == false)
                {
                    using (MemoryStream m = new MemoryStream())
                    {
                        OwnerLogo.Image.Save(m, System.Drawing.Imaging.ImageFormat.Jpeg);
                        //image.Save(m, image.RawFormat);

                        arrayLogo = m.ToArray();
                    }
                }

                cmSQL.CommandText = "UpdateSysParam4CoySetup";
                cmSQL.CommandType = CommandType.StoredProcedure;
                cmSQL.Parameters.AddWithValue("@NName", tName.Text);
                cmSQL.Parameters.AddWithValue("@Address", tAddress.Text);
                cmSQL.Parameters.AddWithValue("@Phone", tPhone.Text);
                cmSQL.Parameters.AddWithValue("@Email", temail.Text);
                cmSQL.Parameters.AddWithValue("@wwweb", tWebsite.Text);
                cmSQL.Parameters.AddWithValue("@logo", arrayLogo);
                cmSQL.Parameters.AddWithValue("@eDocPath", tDocFile.Text);
                cmSQL.Parameters.AddWithValue("@BackupPath", tBackupPath.Text);


                cmSQL.ExecuteNonQuery();
                //cmSQL.Connection.Close()
                cmSQL.Dispose();
                // cnSQL.Close()
                //cnSQL.Dispose()

                MyModules.InitialiseEntireSystem();

                MessageBox.Show("Pls. restart...", MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);

                System.Environment.Exit(1);

                return;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }