public LoginForm() { InitializeComponent(); //need to subscribe to event here because Designer file is generated by compiler textBoxPassword.KeyPress += new System.Windows.Forms.KeyPressEventHandler(textBox_TextChanged); textBoxUsername.KeyPress += new System.Windows.Forms.KeyPressEventHandler(textBox_TextChanged); textBoxPassword.TextChanged += textBox_ResizeToContent; textBoxUsername.TextChanged += textBox_ResizeToContent; string serverName = "46.22.134.194"; string port = "5432"; string userName = "******"; string password = "******"; string databaseName = "WellsForZoe_fyp"; string connString = String.Format("Server={0};Port={1}; User Id={2};Password={3};Database={4};Ssl=True;SslMode=Prefer;Timeout=5;CommandTimeout=5;Pooling=False;", serverName, port, userName, password, databaseName); databaseLoader = new DatabaseLoader(connString, NetworkChecker.LastStatus); textBoxUsername.Select(); }
private void Edit_Click(object sender, EventArgs e) { editErrorLbl.Text = string.Empty; var button = sender as Button; if (button.Text == "Edit") { latEditBackup = editLngBox.Text; lngEditBackup = editLatBox.Text; //open edit window or better allow editing in same open space //let browse new image editLngBox.Enabled = true; editLatBox.Enabled = true; editImageBtn.Visible = true; button.Text = "Save"; closeBtn.Text = "Cancel"; } else if (button.Text == "Save") { if (string.IsNullOrWhiteSpace(editLngBox.Text)) editErrorLbl.Text = "Latitude cannot be empty"; else if (string.IsNullOrWhiteSpace(editLatBox.Text)) editErrorLbl.Text = "Longitude cannot be empty"; else { editLngBox.Enabled = false; editLatBox.Enabled = false; editImageBtn.Visible = false; try { var testPoint = StringToCoordinateConverter.ConvertToCoordinate(editLngBox.Text, editLatBox.Text); } catch (ArgumentException) { editErrorLbl.Text = "Lat/Long not in L DD MM.MMM"; editLngBox.Enabled = true; editLatBox.Enabled = true; editImageBtn.Visible = true; return; } //send all to database var db = new DatabaseLoader(connectionString, NetworkChecker.LastStatus); well.UpdateCoordinates(editLatBox.Text, editLngBox.Text); try { db.UpdateWellData(well); } catch (NpgsqlException ex) { editErrorLbl.Text = ex.Message; RestoreFromBackup(); } updateMarkerPositionAction(well); button.Text = "Edit"; closeBtn.Text = "Close"; } } else { throw new NotSupportedException("Button can only be Edit or Save"); } }
private void deleteBtn_Click(object sender, EventArgs e) { var warning = MessageBox.Show( this, "Are you sure you want to delete well?\n This action cannot be undone.", "Deleting Well", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button2); if (warning == DialogResult.Yes) { var db = new DatabaseLoader(connectionString, NetworkChecker.LastStatus); try { db.DeleteWell(well); deleteMarkerAction(well); this.Close(); } catch (NpgsqlException ex) { editErrorLbl.Text = ex.Message; } } }