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