private void button1_Click(object sender, EventArgs e)
{
AddEdit addNew = new AddEdit();
addNew.Show();
constraintsList.Visible = false;
}
private void btnsave_Click(object sender, EventArgs e)
{
// --- confirmation with message box ---
string message = "Do you want to Save the changes?";
string title = "Please Confirm!";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result = MessageBox.Show(message, title, buttons, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
db.openConnection(); // open connection
MySqlCommand cmd = new MySqlCommand("UPDATE `student` SET indexno=@index,firstname=@firstname,lastname=@lastname,address=@address,gender=@gender,dob=@dob,email=@email,faculty=@faculty,mobile=@mobile,image=@image WHERE indexno ='" + selected + "'", db.getConnection());
// --- image ---
MemoryStream ms = new MemoryStream();
picImg.Image.Save(ms, picImg.Image.RawFormat);
byte[] img = ms.ToArray();
// ----
AddEdit addEdit = new AddEdit();
cmd.Parameters.Add("@index", MySqlDbType.VarChar).Value = txtindex.Text;
cmd.Parameters.Add("@firstname", MySqlDbType.VarChar).Value = txtfname.Text;
cmd.Parameters.Add("@lastname", MySqlDbType.VarChar).Value = txtlname.Text;
cmd.Parameters.Add("@address", MySqlDbType.VarChar).Value = txtaddress.Text;
cmd.Parameters.Add("@gender", MySqlDbType.VarChar).Value = addEdit.getGender();
cmd.Parameters.Add("@dob", MySqlDbType.Date).Value = dateDob.Value.Date;
cmd.Parameters.Add("@email", MySqlDbType.VarChar).Value = txtemail.Text;
cmd.Parameters.Add("@faculty", MySqlDbType.VarChar).Value = cmbfaculty.GetItemText(cmbfaculty.SelectedItem);
cmd.Parameters.Add("@mobile", MySqlDbType.VarChar).Value = txtmobile.Text;
cmd.Parameters.Add("@image", MySqlDbType.Blob).Value = img;
// query executed?
if (cmd.ExecuteNonQuery() == 1)
{
MessageBox.Show("Record added!", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
openRecs.searchData(""); // refreshing by reloading data from db
this.Close();
}
else
{
MessageBox.Show("Failed!, please retry", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
db.openConnection(); // close connection
}
}
