private void button1_Click(object sender, EventArgs e) { try { con_db sttncheck = new con_db(); int stcode = int.Parse(textStationCode.Text); string sql = "SELECT * FROM stations WHERE st_code=" + stcode; if (sttncheck.SelectVerifyStation(sql)) { //MessageBox.Show("The station exists in the database"+stcode); globals.stationcode = stcode; Hide(); StationParameters newform = new StationParameters(); newform.ShowDialog(); Show(); textStationCode.Clear(); textStationCode.Focus(); } else { labelnotexist.Text = "Station does not exist !!!"; labelnotexist.Visible = true; textStationCode.Focus(); textStationCode.SelectAll(); } } catch (Exception) { MessageBox.Show("Enter Code in the correct format"); } }
private void button1_Click(object sender, EventArgs e) { string username = textBox1.Text; string password = textBox2.Text; string sqlgnrluser = "******" + username + "' AND usrpswrd='" + password + "'"; string sqladmin = "SELECT * FROM admns WHERE usrname='" + username + "'AND usrpswrd='" + password + "'"; con_db loginuora = new con_db(); if (loginuora.SelectVerifyStation(sqlgnrluser)) { // MessageBox.Show("user success"); //testing access globals.usernamme = username; Hide(); userwelcome newform = new userwelcome(); newform.ShowDialog(); Show(); textBox1.Clear(); textBox2.Clear(); } else if (loginuora.SelectVerifyStation(sqladmin)) { // MessageBox.Show("admin access"); //testing access globals.usernamme = username; Hide(); administrator newform = new administrator(); newform.ShowDialog(); Show(); textBox1.Clear(); textBox2.Clear(); } else { labelerror.Text = "Invalid login parameters!!!"; labelerror.Visible = true; textBox1.Focus(); textBox1.SelectAll(); textBox2.Clear(); } }
/* public void Control_KeyUp(object sender, KeyEventArgs e) * { * if ((e.KeyCode == Keys.Enter) || (e.KeyCode == Keys.Return)) * { * this.SelectNextControl((Control)sender, true, true, true, true); * } * * }*/ private void button1_Click(object sender, EventArgs e) { try { if (get_indices()) { if (radioApendNo.Checked == true) { string season = comboBox1.SelectedText.ToString(); int chartno = int.Parse(textBox1.Text); // int chartduration = int.Parse(textBox4.Text); var dateon = dateTimePicker1.Value.ToString("yyyy/MM/dd"); var dateoff = dateTimePicker2.Value.ToString("yyyy/MM/dd"); var datedigitzed = System.DateTime.Now; // var range = comboBox2.SelectedText; con_db newentry = new con_db(); string sql = "INSERT INTO charts (chart_number,date_digitized,date_on,date_off,season,st_code) VALUES ('" + chartno + "','" + datedigitzed + "','" + dateon + "','" + dateoff + "','" + season + "','" + globals.stationcode + "')"; if (newentry.Insert(sql)) { globals.chartnumber = chartno; globals.x_date = dateon; Hide(); upload newform = new upload(); newform.ShowDialog(); Show(); globals.Clearallboxes(this); } else { MessageBox.Show("data not updated"); } } else if (radioApendYes.Checked == true) { int chartno = int.Parse(textBox3.Text); string sql = "SELECT * FROM charts WHERE chart_number ='" + chartno + "'AND st_code ='" + globals.stationcode + "'"; con_db newentry = new con_db(); if (newentry.SelectVerifyStation(sql)) { globals.chartnumber = chartno; Hide(); upload newform = new upload(); newform.ShowDialog(); Show(); } else { labelcantappend.Text = "Can not find chart to append"; labelcantappend.Visible = true; textBox3.Focus(); textBox3.SelectAll(); } } } } catch (Exception ex) { MessageBox.Show("" + ex.Message); } }