/// <summary> /// this will add a course to the List view to be saved when the employee is created /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnAddCourse_Click(object sender, EventArgs e) { foreach (ListViewItem item in LVxCourses.Items) { if (item.SubItems[0].Text == TxtCourseID.Text) { if (MessageBox.Show("Course already exists would you like to update the record.", "Update", MessageBoxButtons.YesNo) == DialogResult.Yes) { LVxCourses.Items.Remove(item); } else { return; } } } ListViewItem lvi = new ListViewItem(TxtCourseID.Text); if (TxtDescription.Text != "") { lvi.SubItems.Add(TxtDescription.Text); } else { LblStatus.Text = "Please enter a value for the Description"; TxtDescription.Focus(); } if (TxtGrade.Text != "") { lvi.SubItems.Add(TxtGrade.Text); } else { LblStatus.Text = "Please enter a value for the Grade"; TxtGrade.Focus(); } if (TxtDateApproved.Text != "") { lvi.SubItems.Add(TxtDateApproved.Text); } else { LblStatus.Text = "Please enter a value for the Date Approved"; TxtDateApproved.Focus(); } if (TxtCredits.Text != "") { lvi.SubItems.Add(TxtCredits.Text); } else { LblStatus.Text = "Please enter a value for the Credits."; TxtCredits.Focus(); } //checkbox value lvi.SubItems.Add(CkbApproved.Checked.ToString()); LVxCourses.Items.Add(lvi); ClearEducation(); }
private void BtnClear_Click(object sender, EventArgs e) { TxtFirstName.Clear(); TxtLastName.Clear(); TxtGrade.Clear(); TxtAddress.Clear(); TxtContactNo.Clear(); }
/// <summary> /// this will clear all the educational fields /// </summary> private void ClearEducation() { CkbApproved.Checked = true; TxtCourseID.Clear(); TxtGrade.Clear(); TxtDescription.Clear(); TxtDateApproved.Clear(); TxtCredits.Clear(); }
private void BtnScoreAdd_Click(object sender, EventArgs e) { if (CboSno.Text == "") { MessageBox.Show("请选择学号!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); CboSno.Focus(); } else if (CboCourse.Text == "") { MessageBox.Show("请选择课程号!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); CboCourse.Focus(); } else if (CboYear.Text == "") { MessageBox.Show("请选择学年!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); CboYear.Focus(); } else if (CboTeam.Text == "") { MessageBox.Show("请选择学期!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); CboTeam.Focus(); } else if (TxtGrade.Text == "") { MessageBox.Show("请输入成绩!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); TxtGrade.Focus(); } else { try { string str = string.Format(" insert into tbscore(studentNo,courseID,score,term,Year) values('{0}','{1}','{2}','{3}','{4}')", CboSno.Text, Status.sql, int.Parse(TxtGrade.Text), CboTeam.Text, CboYear.Text); DBHelper.conn.Open(); SqlCommand command = new SqlCommand(str, DBHelper.conn); int result = command.ExecuteNonQuery(); if (result < 1) { MessageBox.Show("成绩录入失败!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("成绩录入成功!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show("数据库操作错误:" + ex.Message, "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { DBHelper.conn.Close(); this.ViewInfo(); } } }
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(); } } } }
/*************************************** * * This is where the UTILITY METHODS are. * ***************************************/ /// <summary> /// This clears the form after an entry is added. /// </summary> private void ClearForm() { TxtEmpID.Clear(); TxtFirstName.Clear(); TxtLastName.Clear(); TxtMiddleName.Clear(); TxtXtraProp1.Clear(); TxtXtraProp2.Clear(); CkbActiveEmployee.Checked = true; CkbBenefits.Checked = true; CkbApproved.Checked = true; LVxCourses.Items.Clear(); TxtCourseID.Clear(); TxtGrade.Clear(); TxtDescription.Clear(); TxtDateApproved.Clear(); TxtCredits.Clear(); TxtMaritalStatus.Clear(); TxtDepartment.Clear(); TxtTitle.Clear(); TxtStartDate.Clear(); }