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();
}
}
}
}
public void clr()
{
txtId.Clear();
txtLastName.Clear();
txtSalary.Clear();
txtSpecialization.Clear();
txtFirstName.Clear();
txtConatctNo.Clear();
TxtAddress.Clear();
cmbSchedule.SelectedIndex = -1;
}
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();
}
}
}
}
private void BtnClear_Click(object sender, EventArgs e)
{
TxtTcnumber.Clear();
TxtName.Clear();
TxtSurname.Clear();
TxtAddress.Clear();
TxtDays.Clear();
MskTxtPhoneNumber.Clear();
TxtEmail.Clear();
TxtPayment.Clear();
TxtRoomNumber.Clear();
dateTimePicker1.ResetText();
DtpCheckin.ResetText();
DtpCheckout.ResetText();
}
/// <summary>
/// actually clears each textbox in the form
/// </summary>
private void ClearNewEmpForm()
{
EpForm.Clear();
TxtID.Clear();
TxtFirstName.Clear();
TxtLastName.Clear();
TxtAddress.Clear();
TxtCity.Clear();
CBxState.SelectedIndex = -1;
CBxEmpType.SelectedIndex = -1;
TxtZip.Clear();
TxtHireDate.Clear();
CBxMarriageStatus.SelectedIndex = -1;
TxtDept.Clear();
TxtJobTitle.Clear();
LblAfterSubmitMsg.Text = "";
TxtPayAmount.Visible = false;
LblPayAmount.Visible = false;
LblSecondInput.Visible = false;
TxtSecondInput.Visible = false;
}
