private bool FindRecord(string scode) { Conn connect = new Conn(); if (connect.OpenConnection() == true) { query = "SELECT * FROM student WHERE Reg_No='" + scode + "'"; MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list if (dataReader.Read()) { connect.CloseConnection(); return(true); } else { connect.CloseConnection(); return(false); } } else { return(true); } }
private bool FindRecord2(string scode) { Conn connect = new Conn(); if (connect.OpenConnection() == true) { query = "SELECT * FROM staff WHERE Staff_No='" + Sessions.userID + "' and Phone_No='" + Sessions.phoneNo + "' and Passsword='" + scode + "'"; MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list if (dataReader.Read()) { if (dataReader["Passsword"].ToString() == scode && dataReader["Phone_No"].ToString() == Sessions.phoneNo && dataReader["Staff_No"].ToString() == Sessions.userID) { connect.CloseConnection(); return(true); } else { connect.CloseConnection(); return(false); } } else { connect.CloseConnection(); return(false); } } else { return(true); } }
private void btnDelete_Click(object sender, EventArgs e) { if (cboCourseProgCode.Visible == false) { MessageBox.Show("Select Records to Delete", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboCourseProgCode.Visible = true; cboCourseProgCode.Focus(); } else if (cboCourseProgCode.Text.Replace(" ", "") == "" && cboCourseProgCode.Visible == true) { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboCourseProgCode.Focus(); } else if (cboCourseCode.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboCourseCode.Focus(); } else if (cboSemester.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSemester.Focus(); } else if (cboYoS.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboYoS.Focus(); } else { Conn connect = new Conn(); connect.CloseConnection(); if (connect.OpenConnection() == true) { if (MessageBox.Show("Are you sure you want to delete these details?", "MMUST CIMS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { query = "DELETE FROM program_course WHERE ProgCourse_Code='" + cboCourseProgCode.Text + "'"; //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connect.connection); //Execute command cmd.ExecuteNonQuery(); //close connection clean(); MessageBox.Show("Records Successfully Deleted!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { clean(); MessageBox.Show("Records Not Deleted!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } connect.CloseConnection(); GetProgCourses(); } } }
private void cboLoadingCode_SelectedIndexChanged(object sender, EventArgs e) { Conn connect = new Conn(); if (connect.OpenConnection() == true) { query = "SELECT * FROM loading WHERE Loading_Code='" + cboLoadingCode.Text.ToString() + "'"; MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list if (dataReader.Read()) { cboLoadingCode.Text = dataReader["Loading_Code"].ToString(); cboCourse.Text = dataReader["ProgCourse_Code"].ToString(); cboSemester.Text = dataReader["Semester"].ToString(); txtVenue.Text = dataReader["Venue"].ToString(); txtTime.Text = dataReader["Lecture_Time"].ToString(); cboAcYr.Text = dataReader["Academic_Year"].ToString(); cboStaffName.Text = GetStaff(dataReader["Staff_No"].ToString()); lblStaffNo.Text = dataReader["Staff_No"].ToString(); lodCode = cboLoadingCode.Text; } connect.CloseConnection(); } }
private void cboRegNo_SelectedIndexChanged(object sender, EventArgs e) { Conn connect = new Conn(); if (connect.OpenConnection() == true) { query = "SELECT * FROM student WHERE Reg_No='" + cboRegNo.Text.ToString() + "'"; MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list if (dataReader.Read()) { txtStudentName.Text = dataReader["Student_Name"].ToString(); cboProgCode.Text = dataReader["Program_Code"].ToString(); cboSemester.Text = dataReader["Semester"].ToString(); cboYoS.Text = dataReader["Year_of_Study"].ToString(); txtPostalAddress.Text = dataReader["Postal_Address"].ToString(); txtPostalCode.Text = dataReader["Postal_Code"].ToString(); txtTown.Text = dataReader["Town"].ToString(); txtResidence.Text = dataReader["Residence"].ToString(); txtEmail.Text = dataReader["Email_Address"].ToString(); txtPhoneNo.Text = dataReader["Phone_No"].ToString(); if (dataReader["Status"].ToString() == "1") { chkStatus.CheckState = CheckState.Checked; } else { chkStatus.CheckState = CheckState.Unchecked; } studentCode = cboRegNo.Text; } connect.CloseConnection(); } }
private void btnFind_Click(object sender, EventArgs e) { if (cboSearchCriteria.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSearchCriteria.Focus(); } else if (txtSearchValue.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtSearchValue.Focus(); } else { Conn connect = new Conn(); if (connect.OpenConnection() == true) { string searchval = "%" + txtSearchValue.Text + "%"; if (cboSearchCriteria.Text == "All") { query = "SELECT * FROM program ORDER BY Program_Code ASC"; } else if (cboSearchCriteria.Text == "Department Code") { query = "SELECT * FROM program WHERE Department_Code LIKE '" + searchval + "' ORDER BY Program_Code ASC"; } else if (cboSearchCriteria.Text == "Program Code") { query = "SELECT * FROM program WHERE Program_Code LIKE '" + searchval + "' ORDER BY Program_Code ASC"; } else if (cboSearchCriteria.Text == "Program Name") { query = "SELECT * FROM department WHERE Program_Name LIKE '" + searchval + "' ORDER BY Program_Code ASC"; } else { MessageBox.Show("Invalid Criteria", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSearchCriteria.Focus(); } MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list this.dataGridView1.Rows.Clear(); while (dataReader.Read()) { if (dataReader["Program_Code"].ToString().Replace(" ", "") != "") { string[] row = new string[] { dataReader["Program_Code"].ToString(), dataReader["Program_Name"].ToString(), dataReader["Department_Code"].ToString(), dataReader["Description"].ToString() }; dataGridView1.Rows.Add(row); } } connect.CloseConnection(); } } }
private void btnQuit_Click(object sender, EventArgs e) { //this.Dispose(); Conn connn = new Conn(); connn.CloseConnection(); Application.Exit(); }
private void frmLogin_Load(object sender, EventArgs e) { Conn connn = new Conn(); connn.CloseConnection(); lblConfirmPassword.Visible = false; lblStaffNo.Text = "Staff No:"; lblPhoneNo.Text = "Phone No:"; gboxReset.Visible = false; groupBox1.Left = (this.ClientSize.Width - groupBox1.Width) / 2; groupBox1.Top = (this.ClientSize.Height - groupBox1.Height) / 2; }
private void cboStaffNo_SelectedIndexChanged(object sender, EventArgs e) { Conn connect = new Conn(); if (connect.OpenConnection() == true) { query = "SELECT * FROM staff WHERE Staff_No='" + cboStaffNo.Text.ToString() + "'"; MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list if (dataReader.Read()) { cboStaffNo.Text = dataReader["Staff_No"].ToString(); txtPfNo.Text = dataReader["Pf_No"].ToString(); txtStaffName.Text = dataReader["Staff_Name"].ToString(); txtDesignation.Text = dataReader["Designation"].ToString(); cboDepCode.Text = dataReader["Department_Code"].ToString(); txtStaffID.Text = dataReader["Staff_ID"].ToString(); txtPostalAddress.Text = dataReader["Postal_Address"].ToString(); txtPostalCode.Text = dataReader["Postal_Code"].ToString(); txtTown.Text = dataReader["Town"].ToString(); txtResidence.Text = dataReader["Residence"].ToString(); txtEmail.Text = dataReader["Email_Address"].ToString(); txtPhoneNo.Text = dataReader["Phone_No"].ToString(); txtOffice.Text = dataReader["Office"].ToString(); txtTimeAvailable.Text = dataReader["Time_Available"].ToString(); txtLoginName.Text = dataReader["Login_Name"].ToString(); txtPassword.Text = dataReader["Passsword"].ToString(); txtConfirmPassword.Text = dataReader["Passsword"].ToString(); cboPriviledges.Text = dataReader["Priviledges"].ToString(); if (dataReader["Status"].ToString() == "1") { chkStatus.CheckState = CheckState.Checked; } else { chkStatus.CheckState = CheckState.Unchecked; } staffCode = cboStaffNo.Text; } connect.CloseConnection(); } }
private void cboFacultyCode_SelectedIndexChanged(object sender, EventArgs e) { Conn connect = new Conn(); if (connect.OpenConnection() == true) { query = "SELECT * FROM faculty WHERE Faculty_Code='" + cboFacultyCode.Text.ToString() + "'"; MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list if (dataReader.Read()) { txtFacultyName.Text = dataReader["Faculty_Name"].ToString(); txtDescription.Text = dataReader["Description"].ToString(); facCode = cboFacultyCode.Text; } connect.CloseConnection(); } }
private void GetStaffs() { Conn connect = new Conn(); if (connect.OpenConnection() == true) { query = "SELECT * FROM staff WHERE Priviledges='Staff' ORDER BY Staff_Name ASC"; MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list this.cboStaffName.Items.Clear(); while (dataReader.Read()) { if (dataReader["Staff_Name"].ToString().Replace(" ", "") != "") { this.cboStaffName.Items.Add(dataReader["Staff_Name"].ToString()); } } connect.CloseConnection(); } }
private void GetStudent() { Conn connect = new Conn(); if (connect.OpenConnection() == true) { query = "SELECT * FROM student ORDER BY Reg_No ASC"; MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list this.cboRegNo.Items.Clear(); while (dataReader.Read()) { if (dataReader["Reg_No"].ToString().Replace(" ", "") != "") { this.cboRegNo.Items.Add(dataReader["Reg_No"].ToString()); } } connect.CloseConnection(); } }
private void cboProgramCode_SelectedIndexChanged(object sender, EventArgs e) { Conn connect = new Conn(); if (connect.OpenConnection() == true) { query = "SELECT * FROM program WHERE Program_Code='" + cboProgramCode.Text.ToString() + "'"; MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list if (dataReader.Read()) { cboProgramCode.Text = dataReader["Program_Code"].ToString(); cboDepCode.Text = dataReader["Department_Code"].ToString(); txtProgName.Text = dataReader["Program_Name"].ToString(); txtDescription.Text = dataReader["Description"].ToString(); progCode = cboProgramCode.Text; } connect.CloseConnection(); } }
private void GetPrograms() { Conn connect = new Conn(); if (connect.OpenConnection() == true) { query = "SELECT * FROM program ORDER BY Program_Code ASC"; MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list this.cboProgCode.Items.Clear(); while (dataReader.Read()) { if (dataReader["Program_Code"].ToString().Replace(" ", "") != "") { this.cboProgCode.Items.Add(dataReader["Program_Code"].ToString()); } } connect.CloseConnection(); } }
private void AssignStaffNo() { Conn connect = new Conn(); if (connect.OpenConnection() == true) { query = "SELECT * FROM staff ORDER BY Staff_No DESC"; MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list //this.cboStaffNo.Items.Clear(); int stffNo; if (dataReader.Read()) { if (dataReader["Staff_No"].ToString().Replace(" ", "") != "") { stffNo = Convert.ToInt32((dataReader["Staff_No"].ToString().Substring(4))); if (stffNo < 9) { txtStaffNo.Text = "EMP/000" + (stffNo + 1); } else if (stffNo >= 9 && stffNo < 99) { txtStaffNo.Text = "EMP/00" + (stffNo + 1); } else if (stffNo >= 99 && stffNo < 999) { txtStaffNo.Text = "EMP/0" + (stffNo + 1); } else { txtStaffNo.Text = "EMP/" + (stffNo + 1); } //MessageBox.Show(txtStaffNo.Text); } } connect.CloseConnection(); } }
private void cboCourseProgCode_SelectedIndexChanged(object sender, EventArgs e) { Conn connect = new Conn(); if (connect.OpenConnection() == true) { query = "SELECT * FROM program_course WHERE ProgCourse_Code='" + cboCourseProgCode.Text.ToString() + "'"; MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list if (dataReader.Read()) { cboCourseCode.Text = dataReader["Course_Code"].ToString(); cboSemester.Text = dataReader["Semester"].ToString(); cboProgCode.Text = dataReader["Program_Code"].ToString(); cboCourseProgCode.Text = dataReader["ProgCourse_Code"].ToString(); cboYoS.Text = dataReader["Year_of_Study"].ToString(); cosProgCode = cboCourseProgCode.Text; } connect.CloseConnection(); } }
private void btnPostLoading_Click(object sender, EventArgs e) { string msg = ""; Conn connect = new Conn(); Conn connect1 = new Conn(); Conn connect2 = new Conn(); Conn connect3 = new Conn(); Conn connect4 = new Conn(); Conn connect5 = new Conn(); string query1, query2, query3, query4, query5; connect.CloseConnection(); if (connect.OpenConnection() == true) { query = "DELETE FROM lecturer_enquiry"; //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connect.connection); //Execute command cmd.ExecuteNonQuery(); //close connection } connect.CloseConnection(); if (connect1.OpenConnection() == true) { query1 = "SELECT DISTINCT Staff_No FROM loading ORDER BY Staff_No ASC"; MySqlCommand cmd1 = new MySqlCommand(query1, connect1.connection); MySqlDataReader dataReader1 = cmd1.ExecuteReader(); //Read the data and store them in the list while (dataReader1.Read()) { if (connect2.OpenConnection() == true) { query2 = "SELECT DISTINCT Academic_Year FROM loading WHERE Staff_No='" + dataReader1["Staff_No"].ToString() + "' ORDER BY Academic_Year ASC"; MySqlCommand cmd2 = new MySqlCommand(query2, connect2.connection); MySqlDataReader dataReader2 = cmd2.ExecuteReader(); while (dataReader2.Read()) { if (connect3.OpenConnection() == true) { query3 = "SELECT DISTINCT Semester FROM loading WHERE Academic_Year='" + dataReader2["Academic_Year"].ToString() + "' AND Staff_No='" + dataReader1["Staff_No"].ToString() + "' ORDER BY Semester ASC"; MySqlCommand cmd3 = new MySqlCommand(query3, connect3.connection); MySqlDataReader dataReader3 = cmd3.ExecuteReader(); while (dataReader3.Read()) { if (connect4.OpenConnection() == true) { query4 = "SELECT * FROM loading WHERE Semester='" + dataReader3["Semester"] + "' and Academic_Year='" + dataReader2["Academic_Year"] + "' and Staff_No='" + dataReader1["Staff_No"].ToString() + "' ORDER BY Semester ASC"; MySqlCommand cmd4 = new MySqlCommand(query4, connect4.connection); MySqlDataReader dataReader4 = cmd4.ExecuteReader(); msg = ""; while (dataReader4.Read()) { msg = msg + " " + dataReader4["ProgCourse_Code"]; } if (connect5.OpenConnection() == true) { query5 = "INSERT INTO lecturer_enquiry(Academic_Year,Semester,Staff_No,Message) VALUES('" + dataReader4["Academic_Year"] + "', '" + dataReader4["Semester"] + "', '" + dataReader4["Staff_No"] + "','" + msg + "')"; MySqlCommand cmd5 = new MySqlCommand(query5, connect5.connection); //Execute command cmd5.ExecuteNonQuery(); } connect5.CloseConnection(); } connect4.CloseConnection(); } //MessageBox.Show("Connection3"); } connect3.CloseConnection(); } //MessageBox.Show("Connection2"); } connect2.CloseConnection(); } //MessageBox.Show("Connection1"); } connect1.CloseConnection(); MessageBox.Show("Posting Complete!", "MMUST", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); }
private void btnPrint_Click(object sender, EventArgs e) { if (cboSearchCriteria.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSearchCriteria.Focus(); } else if (txtSearchValue.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtSearchValue.Focus(); } else { Conn connect = new Conn(); if (connect.OpenConnection() == true) { string searchval = "%" + txtSearchValue.Text + "%"; if (cboSearchCriteria.Text == "All") { query = "SELECT * FROM faculty ORDER BY Faculty_Code ASC"; } else if (cboSearchCriteria.Text == "Faculty Code") { query = "SELECT * FROM faculty WHERE Faculty_Code LIKE '" + searchval + "' ORDER BY Faculty_Code ASC"; } else if (cboSearchCriteria.Text == "Faculty Name") { query = "SELECT * FROM faculty WHERE Faculty_Name LIKE '" + searchval + "' ORDER BY Faculty_Code ASC"; } else { MessageBox.Show("Invalid Criteria", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSearchCriteria.Focus(); } MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list this.dataGridView1.Rows.Clear(); while (dataReader.Read()) { if (dataReader["Faculty_Code"].ToString().Replace(" ", "") != "") { string[] row = new string[] { dataReader["Faculty_Code"].ToString(), dataReader["Faculty_Name"].ToString(), dataReader["Description"].ToString() }; dataGridView1.Rows.Add(row); } } connect.CloseConnection(); PrintDialog printDial = new PrintDialog(); printDial.Document = printDocument1; printDial.UseEXDialog = true; if (DialogResult.OK == printDial.ShowDialog()) { printDocument1.DocumentName = "Faculty Details"; printDocument1.Print(); } } } }
private void btnSave_Click(object sender, EventArgs e) { txtFacultyCode.Text = txtFacultyCode.Text.ToUpper(); cboFacultyCode.Text = cboFacultyCode.Text.ToUpper(); if (txtFacultyCode.Text.Replace(" ", "") == "" && cboFacultyCode.Visible == false) { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtFacultyCode.Focus(); } else if (cboFacultyCode.Text.Replace(" ", "") == "" && cboFacultyCode.Visible == true) { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboFacultyCode.Focus(); } else if (txtFacultyName.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtFacultyName.Focus(); } else if (txtDescription.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtDescription.Focus(); } else { string msg = ""; int op; if (facCode == "") { if (FindRecord(txtFacultyCode.Text.ToString()) == false) { query = "INSERT INTO faculty VALUES('" + txtFacultyCode.Text.ToString() + "', '" + txtFacultyName.Text.ToString() + "', '" + txtDescription.Text.ToString() + "')"; msg = "Records have been successfully saved"; op = 0; } else { query = "UPDATE faculty SET Faculty_Code='" + txtFacultyCode.Text.ToString() + "', Faculty_Name= '" + txtFacultyName.Text.ToString() + "', Description='" + txtDescription.Text.ToString() + "' WHERE Faculty_Code='" + txtFacultyCode.Text.ToString() + "'"; msg = "Records have been Successfully updated!"; op = 1; } } else { query = "UPDATE faculty SET Faculty_Code='" + cboFacultyCode.Text.ToString() + "', Faculty_Name= '" + txtFacultyName.Text.ToString() + "', Description='" + txtDescription.Text.ToString() + "' WHERE Faculty_Code='" + facCode + "'"; msg = "Records have been Successfully updated!"; op = 1; } //open connection Conn connect = new Conn(); if (connect.OpenConnection() == true) { if (op == 0) { optn = "Are you sure you want to Insert these details?"; //optn = MessageBox.Show("Are you sure you want to Insert these details?", "MMUST CIMS", MessageBoxButtons.YesNo,MessageBoxIcon.Question); } else { optn = optn = "Are you sure you want to update these details?"; //optn = MessageBox.Show("Are you sure you want to update these details?", "MMUST CIMS", MessageBoxButtons.YesNoMessageBoxIcon.Question); } if (MessageBox.Show(optn, "MMUST CIMS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connect.connection); //Execute command cmd.ExecuteNonQuery(); //close connection clean(); MessageBox.Show(msg, "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { clean(); MessageBox.Show("Changes not Effected!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } connect.CloseConnection(); GetFaculties(); } } }
private void btnPrint_Click(object sender, EventArgs e) { if (cboSearchCriteria.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSearchCriteria.Focus(); } else if (txtSearchValue.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtSearchValue.Focus(); } else if (cboSemesterSearch.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSemesterSearch.Focus(); } else if (cboYoSSearch.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboYoSSearch.Focus(); } else { Conn connect = new Conn(); int sts; if (chkStatusSearch.CheckState == CheckState.Checked) { sts = 1; } else { sts = 0; } if (connect.OpenConnection() == true) { string searchval = "%" + txtSearchValue.Text + "%"; if (cboSearchCriteria.Text == "All") { query = "SELECT * FROM student WHERE Semester='" + cboSemesterSearch.Text + "' AND Year_of_Study='" + cboYoSSearch.Text + "' AND Status=" + sts + " ORDER BY Reg_No ASC"; } else if (cboSearchCriteria.Text == "Reg No") { query = "SELECT * FROM student WHERE Reg_No LIKE '" + searchval + "' AND Semester='" + cboSemesterSearch.Text + "' AND Year_of_Study='" + cboYoSSearch.Text + "' AND Status=" + sts + " ORDER BY Reg_No ASC"; } else if (cboSearchCriteria.Text == "Name") { query = "SELECT * FROM student WHERE Student_Name LIKE '" + searchval + "' AND Semester='" + cboSemesterSearch.Text + "' AND Year_of_Study='" + cboYoSSearch.Text + "' AND Status=" + sts + " ORDER BY Reg_No ASC"; } else if (cboSearchCriteria.Text == "Program") { query = "SELECT * FROM student WHERE Program_Code LIKE '" + searchval + "' AND Semester='" + cboSemesterSearch.Text + "' AND Year_of_Study='" + cboYoSSearch.Text + "' AND Status=" + sts + " ORDER BY Reg_No ASC"; } else if (cboSearchCriteria.Text == "Phone No") { query = "SELECT * FROM student WHERE Phone_No LIKE '" + searchval + "' AND Semester='" + cboSemesterSearch.Text + "' AND Year_of_Study='" + cboYoSSearch.Text + "' AND Status=" + sts + " ORDER BY Reg_No ASC"; } else { MessageBox.Show("Invalid Criteria", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSearchCriteria.Focus(); } MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list this.dataGridView1.Rows.Clear(); while (dataReader.Read()) { if (dataReader["Reg_No"].ToString().Replace(" ", "") != "") { string[] row = new string[] { dataReader["Reg_No"].ToString(), dataReader["Student_Name"].ToString(), dataReader["Program_Code"].ToString(), dataReader["Semester"].ToString(), dataReader["Year_of_Study"].ToString(), dataReader["Phone_No"].ToString() }; dataGridView1.Rows.Add(row); } } connect.CloseConnection(); PrintDialog printDial = new PrintDialog(); printDial.Document = printDocument1; printDial.UseEXDialog = true; if (DialogResult.OK == printDial.ShowDialog()) { printDocument1.DocumentName = "Student Details"; printDocument1.Print(); } } } }
private void btnPostCourses_Click(object sender, EventArgs e) { string msg = ""; Conn connect = new Conn(); Conn connect1 = new Conn(); Conn connect2 = new Conn(); Conn connect3 = new Conn(); Conn connect4 = new Conn(); Conn connect5 = new Conn(); string query1, query2, query3, query4, query5; connect.CloseConnection(); if (connect.OpenConnection() == true) { query = "DELETE FROM courses_done"; //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connect.connection); //Execute command cmd.ExecuteNonQuery(); //close connection } connect.CloseConnection(); if (connect1.OpenConnection() == true) { query1 = "SELECT DISTINCT Program_Code FROM program_course ORDER BY Program_Code ASC"; MySqlCommand cmd1 = new MySqlCommand(query1, connect1.connection); MySqlDataReader dataReader1 = cmd1.ExecuteReader(); //Read the data and store them in the list while (dataReader1.Read()) { if (connect2.OpenConnection() == true) { query2 = "SELECT DISTINCT Year_of_Study FROM program_course WHERE Program_Code='" + dataReader1["Program_Code"].ToString() + "' ORDER BY Year_of_Study ASC"; MySqlCommand cmd2 = new MySqlCommand(query2, connect2.connection); MySqlDataReader dataReader2 = cmd2.ExecuteReader(); while (dataReader2.Read()) { if (connect3.OpenConnection() == true) { query3 = "SELECT DISTINCT Semester FROM program_course WHERE Year_of_Study='" + dataReader2["Year_of_Study"].ToString() + "' AND Program_Code='" + dataReader1["Program_Code"].ToString() + "' ORDER BY Course_Code ASC"; MySqlCommand cmd3 = new MySqlCommand(query3, connect3.connection); MySqlDataReader dataReader3 = cmd3.ExecuteReader(); while (dataReader3.Read()) { if (connect4.OpenConnection() == true) { query4 = "SELECT * FROM program_course WHERE Semester='" + dataReader3["Semester"] + "' and Year_of_Study='" + dataReader2["Year_of_Study"] + "' and Program_Code='" + dataReader1["Program_Code"].ToString() + "' ORDER BY Course_Code ASC"; MySqlCommand cmd4 = new MySqlCommand(query4, connect4.connection); MySqlDataReader dataReader4 = cmd4.ExecuteReader(); msg = ""; while (dataReader4.Read()) { msg = msg + " " + dataReader4["Course_Code"]; } if (connect5.OpenConnection() == true) { query5 = "INSERT INTO courses_done(Program_Code,Academic_Year,Semester,Message) VALUES('" + dataReader4["Program_Code"].ToString() + "', '" + dataReader4["Year_of_Study"].ToString() + "', '" + dataReader4["Semester"].ToString() + "','" + msg + "')"; MySqlCommand cmd5 = new MySqlCommand(query5, connect5.connection); //Execute command cmd5.ExecuteNonQuery(); } connect5.CloseConnection(); } connect4.CloseConnection(); } //MessageBox.Show("Connection3"); } connect3.CloseConnection(); } //MessageBox.Show("Connection2"); } connect2.CloseConnection(); } //MessageBox.Show("Connection1"); } connect1.CloseConnection(); MessageBox.Show("Posting Complete!", "MMUST", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); }
private void btnSave_Click(object sender, EventArgs e) { int units; string unt = txtUnits.Text.Trim().ToString(); txtCourseCode.Text = txtCourseCode.Text.ToUpper(); cboCourseCode.Text = cboCourseCode.Text.ToUpper(); if (txtCourseCode.Text.Replace(" ", "") == "" && cboCourseCode.Visible == false) { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtCourseCode.Focus(); } else if (cboCourseCode.Text.Replace(" ", "") == "" && cboCourseCode.Visible == true) { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtCourseCode.Focus(); } else if (txtCourseName.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtCourseName.Focus(); } else if (txtDescription.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtDescription.Focus(); } else if (cboSemCode.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSemCode.Focus(); } else if (cboYoS.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboYoS.Focus(); } else if (txtUnits.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtUnits.Focus(); } else if (!int.TryParse(unt, out units)) { MessageBox.Show("Invalid data!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtUnits.Focus(); } else { string msg = ""; int op; if (cosCode == "") { if (FindRecord(txtCourseCode.Text.ToString()) == false) { query = "INSERT INTO course VALUES('" + txtCourseCode.Text.ToString() + "', '" + txtCourseName.Text.ToString() + "','" + txtDescription.Text + "', '" + cboSemCode.Text.ToString() + "','" + cboYoS.Text.ToString() + "'," + units + ")"; msg = "Records have been successfully saved"; op = 0; } else { query = "UPDATE course SET Course_Code='" + txtCourseCode.Text.ToString() + "', Course_Name= '" + txtCourseName.Text.ToString() + "', Description='" + txtDescription.Text.ToString() + "', Semester='" + cboSemCode.Text.ToString() + "', Year_of_Study='" + cboYoS.Text + "',Units=" + units + " WHERE Course_Code='" + txtCourseCode.Text.ToString() + "'"; msg = "Records have been Successfully updated!"; op = 1; } } else { query = "UPDATE course SET Course_Code='" + cboCourseCode.Text.ToString() + "', Course_Name= '" + txtCourseName.Text.ToString() + "', Description='" + txtDescription.Text.ToString() + "',Semester='" + cboSemCode.Text.ToString() + "',Year_of_Study='" + cboYoS.Text + "',Units=" + units + " WHERE Course_Code='" + cosCode + "'"; msg = "Records have been Successfully updated!"; op = 1; } //open connection Conn connect = new Conn(); connect.CloseConnection(); if (connect.OpenConnection() == true) { if (op == 0) { optn = "Are you sure you want to Insert these details?"; //optn = MessageBox.Show("Are you sure you want to Insert these details?", "MMUST CIMS", MessageBoxButtons.YesNo,MessageBoxIcon.Question); } else { optn = optn = "Are you sure you want to update these details?"; //optn = MessageBox.Show("Are you sure you want to update these details?", "MMUST CIMS", MessageBoxButtons.YesNoMessageBoxIcon.Question); } if (MessageBox.Show(optn, "MMUST CIMS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connect.connection); //Execute command cmd.ExecuteNonQuery(); //close connection clean(); MessageBox.Show(msg, "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { clean(); MessageBox.Show("Changes not Effected!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } connect.CloseConnection(); GetCourses(); } } }
private void btnDelete_Click(object sender, EventArgs e) { if (cboRegNo.Visible == false) { MessageBox.Show("Select Records to Delete", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboRegNo.Visible = true; cboRegNo.Focus(); } else if (cboRegNo.Text.Replace(" ", "") == "" && cboRegNo.Visible == true) { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtRegNo.Focus(); } else if (txtStudentName.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtStudentName.Focus(); } else if (cboProgCode.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboProgCode.Focus(); } else if (cboSemester.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSemester.Focus(); } else if (cboYoS.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboYoS.Focus(); } else if (txtPostalAddress.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPostalAddress.Focus(); } else if (txtPostalCode.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPostalCode.Focus(); } else if (txtTown.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtTown.Focus(); } else if (txtResidence.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtResidence.Focus(); } else if (txtEmail.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtEmail.Focus(); } else if (txtPhoneNo.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPhoneNo.Focus(); } else if (txtPhoneNo.Text.Length.ToString() != "13" || (txtPhoneNo.Text.Replace("+", "")).ToString() == "") { MessageBox.Show("Invalid Phone Number!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPhoneNo.Focus(); } else { Conn connect = new Conn(); connect.CloseConnection(); if (connect.OpenConnection() == true) { if (MessageBox.Show("Are you sure you want to delete these details?", "MMUST CIMS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { query = "DELETE FROM student WHERE Reg_No='" + cboRegNo.Text + "'"; //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connect.connection); //Execute command cmd.ExecuteNonQuery(); //close connection clean(); MessageBox.Show("Records Successfully Deleted!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { clean(); MessageBox.Show("Records Not Deleted!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } connect.CloseConnection(); GetStudent(); } } }
private void btnSave_Click(object sender, EventArgs e) { long phone; string phn = txtPhoneNo.Text.Replace("+", "").Trim().ToString(); string postalcode = txtPostalCode.Text.Trim().ToString(); string stName = txtStudentName.Text.Trim().ToString(); if (txtRegNo.Text.Replace(" ", "") == "" && cboRegNo.Visible == false) { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtRegNo.Focus(); } else if (cboRegNo.Text.Replace(" ", "") == "" && cboRegNo.Visible == true) { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtRegNo.Focus(); } else if (txtStudentName.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtStudentName.Focus(); } else if (IsCharacter(txtStudentName.Text.ToString())) { MessageBox.Show("Invalid Name!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtStudentName.Focus(); } else if (cboProgCode.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboProgCode.Focus(); } else if (cboSemester.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSemester.Focus(); } else if (cboYoS.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboYoS.Focus(); } else if (txtPostalAddress.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPostalAddress.Focus(); } else if (txtPostalCode.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPostalCode.Focus(); } else if (!long.TryParse(postalcode, out phone)) { MessageBox.Show("Invalid Postal Code!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPostalCode.Focus(); } else if (txtTown.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtTown.Focus(); } else if (txtResidence.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtResidence.Focus(); } else if (txtEmail.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtEmail.Focus(); } else if (!IsValidEmail(txtEmail.Text.Replace(" ", "").ToString())) { MessageBox.Show("Invalid Email", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtEmail.Focus(); } else if (txtPhoneNo.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPhoneNo.Focus(); } else if (txtPhoneNo.Text.Length != 13) { MessageBox.Show("Invalid Phone Number!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPhoneNo.Focus(); } else if (!long.TryParse(phn, out phone)) { MessageBox.Show("Invalid Phone Number!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPhoneNo.Focus(); } else if (!txtPhoneNo.Text.Contains("+")) { MessageBox.Show("Invalid Phone Number!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPhoneNo.Focus(); } else { string msg = ""; int op; int status; if (chkStatus.CheckState == CheckState.Checked) { status = 1; } else { status = 0; } if (studentCode == "") { if (FindRecord(txtRegNo.Text.ToString()) == false) { query = "INSERT INTO student VALUES('" + txtRegNo.Text.ToString() + "', '" + txtStudentName.Text.ToString() + "','" + cboProgCode.Text + "', '" + cboSemester.Text.ToString() + "','" + cboYoS.Text.ToString() + "','" + txtPostalAddress.Text + "','" + txtPostalCode.Text + "','" + txtTown.Text + "','" + txtResidence.Text + "','" + txtEmail.Text + "','" + txtPhoneNo.Text + "'," + status + ")"; msg = "Records have been successfully saved"; op = 0; } else { query = "UPDATE student SET Reg_No='" + txtRegNo.Text + "',Student_Name='" + txtStudentName.Text.ToString() + "', Program_Code= '" + cboProgCode.Text.ToString() + "', Semester='" + cboSemester.Text.ToString() + "', Year_of_Study='" + cboYoS.Text.ToString() + "', Postal_Address='" + txtPostalAddress.Text + "',Postal_Code='" + txtPostalCode.Text + "',Town='" + txtTown.Text + "',Residence='" + txtResidence.Text + "',Email_Address='" + txtEmail.Text + "',Phone_No='" + txtPhoneNo.Text + "',Status=" + status + " WHERE Reg_No='" + txtRegNo.Text.ToString() + "'"; msg = "Records have been Successfully updated!"; op = 1; } } else { query = "UPDATE student SET Reg_No='" + cboRegNo.Text + "',Student_Name='" + txtStudentName.Text.ToString() + "', Program_Code= '" + cboProgCode.Text.ToString() + "', Semester='" + cboSemester.Text.ToString() + "', Year_of_Study='" + cboYoS.Text.ToString() + "', Postal_Address='" + txtPostalAddress.Text + "',Postal_Code='" + txtPostalCode.Text + "',Town='" + txtTown.Text + "',Residence='" + txtResidence.Text + "',Email_Address='" + txtEmail.Text + "',Phone_No='" + txtPhoneNo.Text + "',Status=" + status + " WHERE Reg_No='" + studentCode + "'"; msg = "Records have been Successfully updated!"; op = 1; } //open connection Conn connect = new Conn(); connect.CloseConnection(); if (connect.OpenConnection() == true) { if (op == 0) { optn = "Are you sure you want to Insert these details?"; //optn = MessageBox.Show("Are you sure you want to Insert these details?", "MMUST CIMS", MessageBoxButtons.YesNo,MessageBoxIcon.Question); } else { optn = optn = "Are you sure you want to update these details?"; //optn = MessageBox.Show("Are you sure you want to update these details?", "MMUST CIMS", MessageBoxButtons.YesNoMessageBoxIcon.Question); } if (MessageBox.Show(optn, "MMUST CIMS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { //create command and assign the query and connection from the constructor MySqlCommand cmdd = new MySqlCommand(query, connect.connection); //Execute command cmdd.ExecuteNonQuery(); //close connection clean(); MessageBox.Show(msg, "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { clean(); MessageBox.Show("Changes not Effected!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } connect.CloseConnection(); GetStudent(); } } }
private void btnSave_Click(object sender, EventArgs e) { if (txtLoadingCode.Text.Replace(" ", "") == "" && cboLoadingCode.Visible == false) { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtLoadingCode.Focus(); } else if (cboLoadingCode.Text.Replace(" ", "") == "" && cboLoadingCode.Visible == true) { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtLoadingCode.Focus(); } else if (cboCourse.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboCourse.Focus(); } else if (txtVenue.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtVenue.Focus(); } else if (txtTime.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtTime.Focus(); } else if (cboSemester.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSemester.Focus(); } else if (cboAcYr.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboAcYr.Focus(); } else if (cboStaffName.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboStaffName.Focus(); } else { string msg = ""; int op; if (lodCode == "") { if (FindRecord(txtLoadingCode.Text.ToString()) == false) { query = "INSERT INTO loading VALUES('" + txtLoadingCode.Text.ToString() + "', '" + cboCourse.Text.ToString() + "','" + txtVenue.Text + "', '" + txtTime.Text.ToString() + "','" + cboSemester.Text.ToString() + "','" + cboAcYr.Text.ToString() + "','" + lblStaffNo.Text + "')"; msg = "Records have been successfully saved"; op = 0; } else { query = "UPDATE loading SET Loading_Code='" + txtLoadingCode.Text + "',ProgCourse_Code='" + cboCourse.Text.ToString() + "', Venue= '" + txtVenue.Text.ToString() + "', Lecture_Time='" + txtTime.Text.ToString() + "', Semester='" + cboSemester.Text.ToString() + "', Academic_Year='" + cboAcYr.Text + "',Staff_No='" + lblStaffNo.Text + "' WHERE Loading_Code='" + txtLoadingCode.Text.ToString() + "'"; msg = "Records have been Successfully updated!"; op = 1; } } else { query = "UPDATE loading SET Loading_Code='" + cboLoadingCode.Text + "',ProgCourse_Code='" + cboCourse.Text.ToString() + "', Venue= '" + txtVenue.Text.ToString() + "', Lecture_Time='" + txtTime.Text.ToString() + "',Semester='" + cboSemester.Text.ToString() + "',Academic_Year='" + cboAcYr.Text + "',Staff_No='" + lblStaffNo.Text + "' WHERE Loading_Code='" + lodCode + "'"; msg = "Records have been Successfully updated!"; op = 1; } //open connection Conn connect = new Conn(); connect.CloseConnection(); if (connect.OpenConnection() == true) { if (op == 0) { optn = "Are you sure you want to Insert these details?"; //optn = MessageBox.Show("Are you sure you want to Insert these details?", "MMUST CIMS", MessageBoxButtons.YesNo,MessageBoxIcon.Question); } else { optn = optn = "Are you sure you want to update these details?"; //optn = MessageBox.Show("Are you sure you want to update these details?", "MMUST CIMS", MessageBoxButtons.YesNoMessageBoxIcon.Question); } if (MessageBox.Show(optn, "MMUST CIMS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connect.connection); //Execute command cmd.ExecuteNonQuery(); //close connection clean(); MessageBox.Show(msg, "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { clean(); MessageBox.Show("Changes not Effected!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } connect.CloseConnection(); GetLoadings(); } } }
private void frmLogin_UnLoad(object sender, EventArgs e) { Conn connn = new Conn(); connn.CloseConnection(); }
private void btnRequest_Click(object sender, EventArgs e) { if (txtConfirmPassword.Visible == false) { var chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"; var stringChars = new char[8]; var random = new Random(); long phone; string phn = txtPhoneNo.Text.Replace("+", "").Trim().ToString(); for (int i = 0; i < stringChars.Length; i++) { stringChars[i] = chars[random.Next(chars.Length)]; } var finalString = new String(stringChars); if (txtStaffNo.Text == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtStaffNo.Focus(); } else if (txtPhoneNo.Text == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPhoneNo.Focus(); } else if (txtPhoneNo.Text.Length != 13) { MessageBox.Show("Invalid Phone Number!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPhoneNo.Focus(); } else if (!long.TryParse(phn, out phone)) { MessageBox.Show("Invalid Phone Number!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPhoneNo.Focus(); } else if (!txtPhoneNo.Text.Contains("+")) { MessageBox.Show("Invalid Phone Number!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPhoneNo.Focus(); } else { if (FindRecord(txtStaffNo.Text, txtPhoneNo.Text) == true) { //MessageBox.Show(finalString); Sessions.phoneNo = txtPhoneNo.Text.Trim(); Sessions.userID = txtStaffNo.Text; string senders = "MCIMS"; string subject = "MCIMS Passwword Reset"; string body = "Your new Password is " + finalString + ". If you did not request for password reset, Please contact system administrator urgently"; query = "UPDATE staff SET Passsword='" + finalString + "' WHERE Staff_No='" + txtStaffNo.Text.ToString() + "' AND Phone_No='" + txtPhoneNo.Text.ToString() + "'"; string query1 = "INSERT INTO messages(Direction,Type,Status,Sender,Recipient,Subject,Body) VALUES(2,2,1,'" + senders + "','" + Sessions.phoneNo + "','" + subject + "','" + body + "')"; Conn connect = new Conn(); connect.CloseConnection(); if (connect.OpenConnection() == true) { //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connect.connection); //Execute command cmd.ExecuteNonQuery(); //create command and assign the query and connection from the constructor } connect.CloseConnection(); Conn connect2 = new Conn(); if (connect2.OpenConnection() == true) { //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query1, connect2.connection); //Execute command cmd.ExecuteNonQuery(); } connect2.CloseConnection(); MessageBox.Show("New password has been sent to your phone number", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); lblStaffNo.Text = "Reset Code:"; lblPhoneNo.Text = "Password:"******""; txtPhoneNo.Text = ""; txtConfirmPassword.Text = ""; txtPassword2.Visible = true; txtConfirmPassword.Visible = true; lblConfirmPassword.Visible = true; txtStaffNo.Focus(); } else { MessageBox.Show("Staff Details do not exist!\nPlease try again or contact system administrator", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtStaffNo.Text = ""; txtPhoneNo.Text = ""; txtPassword2.Text = ""; txtStaffNo.Focus(); } } } else { if (txtStaffNo.Text.Trim() == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtStaffNo.Focus(); } else if (txtPassword2.Text == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPassword2.Focus(); } else if (txtPassword2.Text.Length < 5) { MessageBox.Show("Weak Password, Put 5 or more characters", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPassword2.Focus(); } else if (txtConfirmPassword.Text == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtConfirmPassword.Focus(); } else if (txtPassword2.Text != txtConfirmPassword.Text) { MessageBox.Show("Password Mismatch!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPassword2.Text = ""; txtConfirmPassword.Text = ""; txtPassword2.Focus(); } else if (FindRecord2(txtStaffNo.Text) == false) { MessageBox.Show("Invalid Code!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtStaffNo.Text = ""; txtStaffNo.Focus(); } else { //MessageBox.Show(finalString); query = "UPDATE staff SET Passsword='" + txtPassword2.Text.ToString() + "' WHERE Staff_No='" + Sessions.userID + "' AND Phone_No='" + Sessions.phoneNo + "'"; Conn connect = new Conn(); connect.CloseConnection(); if (connect.OpenConnection() == true) { //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connect.connection); //Execute command cmd.ExecuteNonQuery(); } connect.CloseConnection(); MessageBox.Show("Password has been successfully reset!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); lblStaffNo.Text = "Staff No:"; lblPhoneNo.Text = "Phone No:"; txtStaffNo.Text = ""; txtPhoneNo.Text = ""; txtConfirmPassword.Text = ""; txtPassword2.Text = ""; txtPassword2.Visible = false; txtConfirmPassword.Visible = false; lblConfirmPassword.Visible = false; gboxReset.Visible = false; txtUsername.Text = ""; txtPassword.Text = ""; Sessions.phoneNo = ""; Sessions.userID = ""; txtUsername.Focus(); } } }
private void btnPrint_Click(object sender, EventArgs e) { if (cboSearchCriteria.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSearchCriteria.Focus(); } else if (txtSearchValue.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtSearchValue.Focus(); } else if (cboSemesterSearch.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSemesterSearch.Focus(); } else if (cboAcYrSearch.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboAcYrSearch.Focus(); } else { Conn connect = new Conn(); if (connect.OpenConnection() == true) { string searchval = "%" + txtSearchValue.Text + "%"; if (cboSearchCriteria.Text == "All") { query = "SELECT * FROM loading WHERE Semester='" + cboSemesterSearch.Text + "' and Academic_Year='" + cboAcYrSearch.Text + "' ORDER BY Loading_Code ASC"; } else if (cboSearchCriteria.Text == "Course Code") { query = "SELECT * FROM loading WHERE ProgCourse_Code LIKE '" + searchval + "' and Semester='" + cboSemesterSearch.Text + "' and Academic_Year='" + cboAcYrSearch.Text + "' ORDER BY Loading_Code ASC"; } else if (cboSearchCriteria.Text == "Program Code") { query = "SELECT * FROM loading WHERE ProgCourse_Code LIKE '" + searchval + "' and Semester='" + cboSemesterSearch.Text + "' and Academic_Year='" + cboAcYrSearch.Text + "' ORDER BY Loading_Code ASC"; } else { MessageBox.Show("Invalid Criteria", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboSearchCriteria.Focus(); } MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list this.dataGridView1.Rows.Clear(); while (dataReader.Read()) { if (dataReader["Loading_Code"].ToString().Replace(" ", "") != "") { string[] row = new string[] { dataReader["Loading_Code"].ToString(), dataReader["ProgCourse_Code"].ToString(), dataReader["Venue"].ToString(), dataReader["Lecture_Time"].ToString(), dataReader["Semester"].ToString(), dataReader["Academic_Year"].ToString(), dataReader["Staff_No"].ToString(), GetStaff(dataReader["Staff_No"].ToString()) }; dataGridView1.Rows.Add(row); } } connect.CloseConnection(); PrintDialog printDial = new PrintDialog(); printDial.Document = printDocument1; printDial.UseEXDialog = true; if (DialogResult.OK == printDial.ShowDialog()) { printDocument1.DocumentName = "Loading Details"; printDocument1.Print(); } } } }
private void btnLogin_Click(object sender, EventArgs e) { if (txtUsername.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtUsername.Focus(); } else if (txtPassword.Text == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPassword.Focus(); } else { Conn connect = new Conn(); query = "SELECT * FROM staff WHERE Login_Name='" + txtUsername.Text.ToString() + "' AND Passsword='" + txtPassword.Text.ToString() + "' AND Status=1"; //open connection if (connect.OpenConnection() == true) { //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connect.connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list if (dataReader.Read()) { //list[0].Add(dataReader["id"] + ""); //list[1].Add(dataReader["name"] + ""); if (dataReader["Login_Name"].ToString() == txtUsername.Text && dataReader["Passsword"].ToString() == txtPassword.Text) { Sessions.username = dataReader["Staff_Name"].ToString(); Sessions.prev = dataReader["Priviledges"].ToString(); Sessions.userID = dataReader["Staff_No"].ToString(); Sessions.loginTime = DateTime.Now.ToString(); MDIParent1 mdi = new MDIParent1(); mdi.Visible = true; this.Hide(); } else { MessageBox.Show("Username/Password Mismatch!\nPlease Try again!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtUsername.Text = ""; txtPassword.Text = ""; txtUsername.Focus(); } } else { MessageBox.Show("Username/Password Mismatch!\nPlease Try again!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtUsername.Text = ""; txtPassword.Text = ""; txtUsername.Focus(); } //close Data Reader dataReader.Close(); //close connection connect.CloseConnection(); } } }
private void btnDelete_Click(object sender, EventArgs e) { if (cboStaffNo.Visible == false) { MessageBox.Show("Select Records to Delete", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboStaffNo.Visible = true; cboStaffNo.Focus(); } else if (cboStaffNo.Text.Replace(" ", "") == "" && cboStaffNo.Visible == true) { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboStaffNo.Focus(); } else if (txtPfNo.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPfNo.Focus(); } else if (txtStaffName.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtStaffName.Focus(); } else if (txtDesignation.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtDesignation.Focus(); } else if (cboDepCode.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboDepCode.Focus(); } else if (txtStaffID.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtStaffID.Focus(); } else if (txtPostalAddress.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPostalAddress.Focus(); } else if (txtPostalCode.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPostalCode.Focus(); } else if (txtTown.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtTown.Focus(); } else if (txtResidence.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtResidence.Focus(); } else if (txtEmail.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtEmail.Focus(); } else if (txtPhoneNo.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPhoneNo.Focus(); } else if (txtOffice.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtOffice.Focus(); } else if (txtTimeAvailable.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtTimeAvailable.Focus(); } else if (txtLoginName.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtLoginName.Focus(); } else if (txtPassword.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtPassword.Focus(); } else if (cboPriviledges.Text.Replace(" ", "") == "") { MessageBox.Show("Ensure all fields are filled!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); cboPriviledges.Focus(); } else { Conn connect = new Conn(); connect.CloseConnection(); if (connect.OpenConnection() == true) { if (MessageBox.Show("Are you sure you want to delete these details?", "MMUST CIMS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { query = "DELETE FROM staff WHERE Staff_No='" + cboStaffNo.Text + "'"; //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connect.connection); //Execute command cmd.ExecuteNonQuery(); //close connection clean(); MessageBox.Show("Records Successfully Deleted!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { clean(); MessageBox.Show("Records Not Deleted!", "MMUST CIMS", MessageBoxButtons.OK, MessageBoxIcon.Information); } connect.CloseConnection(); GetStaff(); } } }