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