private bool get_indices() { int[] pointarray = new int[100]; int arrayindex = 0; con_db getindex = new con_db(); string sql = "SELECT chart_index FROM charts ORDER BY chart_index DESC"; getindex.OpenConnection(); MySqlDataReader readindex = getindex.Readinfo(sql); while (readindex.Read()) { pointarray[arrayindex] = int.Parse("" + readindex["chart_index"]); arrayindex++; } if (validate_dates(pointarray)) { return(true); } else { return(false); } }
private void poptoeditchrt(string thequery) { con_db getforedit = new con_db(); getforedit.OpenConnection(); MySqlDataReader readcharts = getforedit.Readinfo(thequery); while (readcharts.Read()) { textBox1.Text = "" + readcharts["chart_number"]; textBox2.Text = "" + readcharts["st_code"]; textBox4.Text = "" + readcharts["season"]; string date_digitized = "" + readcharts["date_digitized"]; string dateon = "" + readcharts["date_on"]; string dateoff = "" + readcharts["date_off"]; DateTime ddgtzd = Convert.ToDateTime(date_digitized).Date; DateTime don = Convert.ToDateTime(dateon).Date; DateTime doff = Convert.ToDateTime(dateoff).Date; dateTimePicker1.Value = ddgtzd; dateTimePicker2.Value = don; dateTimePicker3.Value = doff; string diff = doff.Subtract(don).ToString(); textBox5.Text = "" + diff; } }
public void Getallusers() { try { string sql = "SELECT * FROM gnrlusers"; con_db getusers = new con_db(); getusers.OpenConnection(); MySqlDataReader read = getusers.Readinfo(sql); while (read.Read()) { ListViewItem row = new ListViewItem(); row.SubItems.Add("" + read["usrname"]); row.SubItems.Add("" + read["usrpswrd"]); row.SubItems.Add("" + read["dob"]); row.SubItems.Add("" + read["gender"]); row.SubItems.Add("" + read["email"]); row.SubItems.Add("" + read["phone"]); row.SubItems.Add("G/User"); listView1.Items.Add(row); } getusers.CloseConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button3_Click(object sender, EventArgs e) { var chartno = int.Parse(textBox1.Text); var station = textBox2.Text; var datedigitzed = dateTimePicker1.Value.ToString("yyyy/MM/dd"); int season = int.Parse(textBox4.Text); var dateon = dateTimePicker2.Value.ToString("yyyy/MM/dd"); var dateoff = dateTimePicker3.Value.ToString("yyyy/MM/dd"); con_db save_chart = new con_db(); string sql = "UPDATE `charts` SET `st_code` = '" + station + "',`date_digitized` = '" + datedigitzed + "',`season` = '" + season + "',`date_on` = '" + dateon + "',`date_off` = '" + dateoff + "' WHERE `chart_number` = '" + chartno + "' LIMIT 1"; if (save_chart.Update(sql)) { MessageBox.Show("Data Updated Successfully"); Dispose(); chartmngmnt newform = new chartmngmnt(); newform.ShowDialog(); } else { MessageBox.Show("Failed to Update data"); } }
private void button3_Click(object sender, EventArgs e) { try { con_db deleteone = new con_db(); string sql = ""; ListViewItem record = listView1.SelectedItems[0]; sql = "DELETE FROM stations WHERE st_code='" + record.SubItems[2].Text + "'"; if (DialogResult.Yes == MessageBox.Show("Are you sure you want to delete this station?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { if (deleteone.Delete(sql)) { MessageBox.Show("user deleted success!!"); } } else { MessageBox.Show("User not found"); } } catch (Exception) { MessageBox.Show("Cant perform operation. Make sure you have selected a specific user!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button2_Click(object sender, EventArgs e) { try { string station_name = textBox2.Text; string station_code = textBox3.Text; string thequery = "INSERT INTO stations (st_name, st_code) VALUES ('" + station_name + "','" + station_code + "')"; con_db adduser = new con_db(); if (adduser.Insert(thequery)) { MessageBox.Show("Station added successfully"); globals.Clearallboxes(this); listView1.Items.Clear(); Getallstations(); } else { MessageBox.Show("Station add failed!!"); } } catch { MessageBox.Show("An Error occured please contact the system administrator"); } }
private void Getallcharts(string sql, bool decide = true) //Queries for all charts in the system { con_db getcharts = new con_db(); getcharts.OpenConnection(); MySqlDataReader readcharts = getcharts.Readinfo(sql); while (readcharts.Read()) { if (decide) { listCharts.Items.Add(readcharts["chart_number"]); } else { label11.Text = "" + readcharts["chart_number"]; label12.Text = "" + readcharts["st_code"]; //label13.Text= ""+ readcharts["date_digitized"]; label14.Text = "" + readcharts["season"]; string on = "" + readcharts["date_on"]; string off = "" + readcharts["date_off"]; label16.Text = "" + on; label18.Text = "" + off; DateTime don = Convert.ToDateTime(on).Date; DateTime doff = Convert.ToDateTime(off).Date; string diff = doff.Subtract(don).ToString(); label15.Text = "" + diff; } } getcharts.CloseConnection(); }
public void Getadmins() { string sql = "SELECT * FROM admns"; con_db getadmns = new con_db(); getadmns.OpenConnection(); MySqlDataReader read = getadmns.Readinfo(sql); while (read.Read()) { ListViewItem row = new ListViewItem(); row.SubItems.Add("" + read["usrname"]); row.SubItems.Add("" + read["usrpswrd"]); row.SubItems.Add("" + read["dob"]); row.SubItems.Add("" + read["gender"]); row.SubItems.Add("" + read["email"]); row.SubItems.Add("" + read["phone"]); row.SubItems.Add("Admin"); listView1.Items.Add(row); //listBox2.Items.Add("" + read["usrname"]);// + " |" + read["email"]); //dataGridView1.Rows.Add(read["usrname"]); //listBox1.Items.Add(read["usrname"].ToString()); } getadmns.CloseConnection(); }
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 button3_Click(object sender, EventArgs e) { con_db del_chart = new con_db(); del_chart.OpenConnection(); string sql = "DELETE FROM charts WHERE chart_number='" + listCharts.SelectedItem.ToString() + "'"; MessageBox.Show("Are you sure you want to delete the chart"); }
private void button5_Click(object sender, EventArgs e) { con_db updatestation = new con_db(); string thequery = "UPDATE `stations` SET `st_name` = '" + textBox2.Text + "',`st_code` = '" + textBox3.Text + "'"; if (updatestation.Update(thequery)) { MessageBox.Show("Station Update Successfull"); } }
private void button2_Click(object sender, EventArgs e) { con_db newconection = new con_db(); if (newconection.OpenConnection() == true) { MessageBox.Show("Connection Successfull"); } else { MessageBox.Show("Connection Unsuccessfull"); } }
private void button2_Click(object sender, EventArgs e) { try { string username = textusrername.Text; string password = textpassword.Text; string phone = textphone.Text; string dob = dateTimedob.Text; string gender = combogender.Text; string email = textemail.Text; string thequery = ""; //= "INSERT INTO admns (admName, admPass,phone,dob,gender,email) VALUES ('"+username+"','"+password +"','"+phone+"','"+dob+"','"+gender+"','"+email+"')"; if ((textpassword.Text == textverify.Text) && (textpassword.Text != "")) { if (comboaccess.Text == "Administrator") { thequery = "INSERT INTO admns (usrname, usrpswrd,phone,dob,gender,email) VALUES ('" + username + "','" + password + "','" + phone + "','" + dob + "','" + gender + "','" + email + "')"; } else if (comboaccess.Text == "General User") { thequery = "INSERT INTO gnrlusers (usrname, usrpswrd,email,phone,gender,dob) VALUES ('" + username + "','" + password + "','" + email + "','" + phone + "','" + gender + "','" + dob + "')"; } else { labelcantuser.Visible = true; } con_db adduser = new con_db(); if (adduser.Insert(thequery)) { MessageBox.Show("User added successfully"); globals.Clearallboxes(this); } else { MessageBox.Show("User add failed!!"); } } else { labelcantuser.Text = "Passwords Do Not Match Please Verify Your Password"; labelcantuser.Visible = true; } } catch { MessageBox.Show("An Error occured please contact the system administrator"); } }
private void button3_Click(object sender, EventArgs e) { try { con_db deleteone = new con_db(); string sql = ""; ListViewItem record = listView1.SelectedItems[0]; if (record.SubItems[7].Text == "Root user") { MessageBox.Show("You cannot remove this user from the system"); } else if (record.SubItems[7].Text == "Admin") { if (DialogResult.Yes == MessageBox.Show("Are you sure u want to delete this user?", "Confirm deletion", MessageBoxButtons.YesNo)) { sql = "DELETE FROM admns WHERE usrname='" + record.SubItems[1].Text + "'"; if (deleteone.Delete(sql)) { MessageBox.Show("user deleted success!!"); Refreshall(); } } } else if (record.SubItems[7].Text == "G/User") { if (DialogResult.Yes == MessageBox.Show("Are you sure u want to delete this user?", "Confirm deletion", MessageBoxButtons.YesNo)) { sql = "DELETE FROM gnrlusers WHERE usrname='" + record.SubItems[1].Text + "'"; if (deleteone.Delete(sql)) { MessageBox.Show("user deleted success!!"); Refreshall(); } } } else { MessageBox.Show("User not found"); } } catch (Exception) { MessageBox.Show("Cant perform operation. Make sure you have selected a specific user!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Getforchatrt(string sql) // Queries for a specific chart to display in chart area { con_db getcharts = new con_db(); getcharts.OpenConnection(); MySqlDataReader readcharts = getcharts.Readinfo(sql); chart1.Series["Series1"].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line; while (readcharts.Read()) { //MessageBox.Show("Got point " + readcharts["X(actualcoord)"].ToString()+", "+ readcharts["Y(actualcoord)"].ToString()); //for testing MessageBox.Show("" + readcharts["st_code"] + ", " + readcharts["st_name"]); chart1.Series["Series1"].Points.AddXY(readcharts["X(actualcoord)"].ToString(), readcharts["Y(actualcoord)"].ToString()); } getcharts.CloseConnection(); }
private bool validate_dates(int[] indexarray) { try { con_db getlargestindex = new con_db(); string newsql = "SELECT date_off FROM charts WHERE chart_index ='" + indexarray[0] + "'"; getlargestindex.OpenConnection(); MySqlDataReader newreadindex = getlargestindex.Readinfo(newsql); newreadindex.Read(); if (!newreadindex.HasRows) { return(true); } string off = "" + newreadindex["date_off"]; DateTime doff = Convert.ToDateTime(off).Date; var don = dateTimePicker1.Value; if (don.Subtract(doff).TotalDays >= 1) { if (DialogResult.Yes == MessageBox.Show("River data for the past " + don.Subtract(doff).TotalDays + " days is will not be captured. Do you want to continue? ", "Loose data", MessageBoxButtons.YesNo)) { return(true); } else { return(false); } } else { //MessageBox.Show("dates good"); return(true); } } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
private void queryforupdate() { try { string username = textusrername.Text; string thequery = ""; //= "INSERT INTO admns (admName, admPass,phone,dob,gender,email) VALUES ('"+username+"','"+password +"','"+phone+"','"+dob+"','"+gender+"','"+email+"')"; if ((textpassword.Text == textverify.Text) && (textpassword.Text != "")) { if (textacceslevel.Text == "Administrator") { thequery = "UPDATE `admns` SET `usrname` = '" + textusrername.Text + "',`usrpswrd` = '" + textpassword.Text + "',`phone` = '" + textphone.Text + "',`dob` = '" + dateTimedob.Text + "',`gender` = '" + combogender.Text + "' WHERE `admns`.`usrID` = '" + globals.rowid + "' LIMIT 1"; // thequery = "UPDATE admns SET usrname= '" + textusrername.Text + "', usrpswrd= '" + textpassword.Text + "',phone= '" + textphone.Text + "',dob= '" + dateTimedob.Text + "', gender= '" + combogender.Text + "', email= '" + textemail.Text + "' "; } else if (textacceslevel.Text == "General User") { thequery = "UPDATE `gnrlusers` SET `usrname` = '" + textusrername.Text + "',`usrpswrd` = '" + textpassword.Text + "',`phone` = '" + textphone.Text + "',`dob` = '" + dateTimedob.Text + "',`gender` = '" + combogender.Text + "' WHERE `gnrlusers`.`usrID` = '" + globals.rowid + "' LIMIT 1"; } else { labelcantuser.Visible = true; } con_db updateuser = new con_db(); if (updateuser.Update(thequery)) { MessageBox.Show("User Updated successfully"); Populate(); } else { MessageBox.Show("User Update failed!!"); } } else { labelcantuser.Text = "Passwords Do Not Match Please Verify Your Password"; labelcantuser.Visible = true; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void textBox1_TextChanged(object sender, EventArgs e) { string sql = "SELECT * FROM stations WHERE st_code='" + textBox1.Text + "' "; // MessageBox .Show(""+ sql ); //testing sql con_db populateforsearch = new con_db(); populateforsearch.OpenConnection(); MySqlDataReader read = populateforsearch.Readinfo(sql); while (read.Read()) { ListViewItem row = new ListViewItem(); row.SubItems.Add("" + read["st_name"]); row.SubItems.Add("" + read["st_code"]); listView1.Items.Add(row); } //populateforsearch.CloseConnection(); read.Close(); }
private void textBox1_TextChanged(object sender, EventArgs e) { string sql = "SELECT * FROM gnrlusers WHERE usrname='" + textBox1.Text + "' "; // MessageBox .Show(""+ sql ); //testing sql con_db populateforsearch = new con_db(); populateforsearch.OpenConnection(); MySqlDataReader read = populateforsearch.Readinfo(sql); while (read.Read()) { ListViewItem row = new ListViewItem(); row.SubItems.Add("" + read["usrname"]); row.SubItems.Add("" + read["usrpswrd"]); row.SubItems.Add("" + read["dob"]); row.SubItems.Add("" + read["gender"]); row.SubItems.Add("" + read["email"]); row.SubItems.Add("" + read["phone"]); row.SubItems.Add("G/User"); listView1.Items.Add(row); } //populateforsearch.CloseConnection(); read.Close(); /* con_db populateforsearch2 = new con_db();*/ string sql2 = "SELECT * FROM admns WHERE usrname='" + textBox1.Text + "' "; MySqlDataReader read2 = populateforsearch.Readinfo(sql2); //populateforsearch.OpenConnection(); while (read2.Read()) { ListViewItem row = new ListViewItem(); row.SubItems.Add("" + read2["usrname"]); row.SubItems.Add("" + read2["usrpswrd"]); row.SubItems.Add("" + read2["dob"]); row.SubItems.Add("" + read2["gender"]); row.SubItems.Add("" + read2["email"]); row.SubItems.Add("" + read2["phone"]); row.SubItems.Add("Admin"); listView1.Items.Add(row); } //populateforsearch2.CloseConnection(); }
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(); } }
private void login_Load(object sender, EventArgs e) { textBox1.Focus(); con_db atload = new con_db(); if (atload.OpenConnection()) { label3.ForeColor = Color.Blue; string codetail = atload.Getserverdetail(); label3.Text = "Connected to server at " + codetail; atload.CloseConnection(); } else { label3.ForeColor = Color.Red; label3.Text = "Connection to server Failed"; } }
private void getmyprofile() { string sql = "SELECT * FROM gnrlusers WHERE usrname='" + globals.usernamme + "' "; // MessageBox .Show(""+ sql ); //testing sql con_db populateprof = new con_db(); populateprof.OpenConnection(); MySqlDataReader read = populateprof.Readinfo(sql); while (read.Read()) { label1.Text = "" + read["usrname"].ToString(); label6.Text = "" + read["phone"].ToString(); label3.Text = "" + read["dob"].ToString(); label4.Text = "" + read["gender"].ToString(); label5.Text = "" + read["email"].ToString(); } populateprof.CloseConnection(); }
private void button2_Click(object sender, EventArgs e) { try { con_db qrychart = new con_db(); int size = upload.mystackx.Count; MessageBox.Show("size is " + size); //testing for (int i = 0; i < size; i++) { string sql = "INSERT INTO coordinates (chart_number, actualcoord) VALUES ('" + globals.chartnumber + "',GeomFromText('POINT(" + upload.mystackx.Pop() + " " + upload.mystacky.Pop() + ")'))"; qrychart.Insert(sql); MessageBox.Show("Popped point " + upload.mystackx.Pop() + "," + upload.mystacky.Pop()); //Testing point entry } MessageBox.Show("Success!!!"); Dispose(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void changepwd() { if ((textBox1.Text == textBox2.Text) && (textBox1.Text != "")) { string sql = "UPDATE gnrlusers SET usrpswrd='" + textBox1.Text + " ' WHERE usrname='" + globals.usernamme + "'"; con_db changepwd = new con_db(); if (changepwd.Update(sql)) { MessageBox.Show("Password Change Successfull"); Dispose(); } } else { label3.Visible = true; textBox2.Clear(); textBox1.Focus(); textBox1.SelectAll(); } }
private void Populate() { try { string sql = "SELECT * FROM " + globals.tablescope + " WHERE usrname='" + globals.targetuser + "' "; // MessageBox .Show(""+ sql ); //testing sql con_db populateforedit = new con_db(); populateforedit.OpenConnection(); MySqlDataReader read = populateforedit.Readinfo(sql); while (read.Read()) { textusrername.Text = read["usrname"].ToString(); textpassword.Text = read["usrpswrd"].ToString(); textverify.Text = read["usrpswrd"].ToString(); textphone.Text = read["phone"].ToString(); //dateTimedob.Text = read["dob"].ToString(); combogender.Text = read["gender"].ToString(); textemail.Text = read["email"].ToString(); if (globals.tablescope == "admns") { textacceslevel.Text = "Administrator"; } else if (globals.tablescope == "gnrlusers") { textacceslevel.Text = "General User"; } globals.rowid = int.Parse(read["usrID"].ToString()); } populateforedit.CloseConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button4_Click(object sender, EventArgs e) { button2.Visible = false; try { ListViewItem record = listView1.SelectedItems[0]; string sql = "SELECT * FROM stations WHERE st_code =" + record.SubItems[2].Text; con_db getstations = new con_db(); getstations.OpenConnection(); MySqlDataReader read = getstations.Readinfo(sql); while (read.Read()) { textBox2.Text = read["st_name"].ToString(); textBox3.Text = read["st_code"].ToString(); } button5.Visible = true; getstations.CloseConnection(); } catch (Exception) { MessageBox.Show("Please make a selecton first"); } }
public void Getallstations() { try { string sql = "SELECT * FROM stations"; con_db getstations = new con_db(); getstations.OpenConnection(); MySqlDataReader read = getstations.Readinfo(sql); while (read.Read()) { ListViewItem row = new ListViewItem(); row.SubItems.Add("" + read["st_name"]); row.SubItems.Add("" + read["st_code"]); listView1.Items.Add(row); } getstations.CloseConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/* 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); } }