private void BtnClear_Click(object sender, EventArgs e)
{
TxtFirstName.Clear();
TxtLastName.Clear();
TxtGrade.Clear();
TxtAddress.Clear();
TxtContactNo.Clear();
}
private void BtnUpdate_Click(object sender, EventArgs e)
{
if (TxtFirstName.Text == "")
{
MessageBox.Show("Please fill empty fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (TxtLastName.Text == "")
{
MessageBox.Show("Please fill empty fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (TxtGrade.Text == "")
{
MessageBox.Show("Please fill empty fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (TxtAddress.Text == "")
{
MessageBox.Show("Please fill empty fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (TxtContactNo.Text == "")
{
MessageBox.Show("Please fill empty fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
var result = MessageBox.Show("Confirm editing new record?", "Edit New Record", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
using (var con = new MySqlConnection(GetConnection()))
{
string command = $"UPDATE `lms.sad`.`tblusers`" +
$" SET " +
$"`First_Name`='{TxtFirstName.Text}',`Last_Name`='{TxtLastName.Text}',`Year_Level`='{TxtGrade.Text}',`Address`='{TxtAddress.Text}',`Contact_Number`='{TxtContactNo.Text}'" +
$" WHERE `User_ID`='{TxtUserID.Text}'";
con.Open();
using (var cmd = new MySqlCommand(command, con))
{
cmd.CommandType = CommandType.Text;
var i = cmd.ExecuteNonQuery();
if (i > 0)
{
MessageBox.Show("Successfully Updated! Please refresh Book List to view entry!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
TxtFirstName.Clear();
TxtLastName.Clear();
TxtGrade.Clear();
TxtAddress.Clear();
TxtContactNo.Clear();
TxtUserID.Clear();
}
}
con.Close();
}
}
}
}
private void BtnRegister_Click(object sender, EventArgs e)
{
if (TxtFirstName.Text == "")
{
MessageBox.Show("Please enter missing fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (TxtLastName.Text == "")
{
MessageBox.Show("Please enter missing fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (TxtGrade.Text == "")
{
MessageBox.Show("Please enter missing fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (TxtAddress.Text == "")
{
MessageBox.Show("Please enter missing fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (TxtContactNo.Text == "")
{
MessageBox.Show("Please enter missing fields!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
var result = MessageBox.Show("Confirm adding new record?", "Add New Record", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
using (var con = new MySqlConnection(GetConnection()))
{
string command = $"INSERT INTO `lms.sad`.`tblusers` (`First_Name`,`Last_Name`, `Year_Level`, `Address`,`Contact_Number`) " +
"VALUES " +
$"('{TxtFirstName.Text}','{TxtLastName.Text}','{TxtGrade.Text}','{TxtAddress.Text}','{TxtContactNo.Text}')";
con.Open();
using (var cmd = new MySqlCommand(command, con))
{
cmd.CommandType = CommandType.Text;
var i = cmd.ExecuteNonQuery();
if (i > 0)
{
MessageBox.Show("Successfully Added! Please refresh Borrower List to view entry!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
TxtFirstName.Clear();
TxtLastName.Clear();
TxtGrade.Clear();
TxtAddress.Clear();
TxtContactNo.Clear();
}
}
con.Close();
}
}
}
}
