private void btnAdvisors_Click(object sender, EventArgs e) { ManageAdvisors manageAdvisors = ManageAdvisors.GetInstance(); manageAdvisors.Show(); this.Hide(); }
private void tabControl1_SelectedIndexChanged_1(object sender, EventArgs e) { if (tabControl1.SelectedIndex == 0) { Dashboard dashboard = Dashboard.GetInstance(); dashboard.Show(); this.Hide(); } if (tabControl1.SelectedIndex == 2) { ManageStudent f = ManageStudent.GetInstance(); f.Show(); this.Hide(); } if (tabControl1.SelectedIndex == 3) { ManageAdvisors f = ManageAdvisors.GetInstance(); f.Show(); this.Hide(); } if (tabControl1.SelectedIndex == 4) { CreateGroup createGroup = CreateGroup.GetInstance(); createGroup.Show(); this.Hide(); } }
public static ManageAdvisors GetInstance() { if (Instance == null) { ManageAdvisors new_Instance = new ManageAdvisors(); return(new_Instance); } return(Instance); }
private void btnSave_Click(object sender, EventArgs e) { DatabaseConnection.createStatement("update Person set FirstName = '" + txtFirstName.Text + "' , LastName = '" + txtLastName.Text + "', Contact = '" + txtContactNo.Text + "', Email = '" + txtEmail.Text + "'" + " where Id = " + TempData.CurrentAdvisor.AdvisorId1); DatabaseConnection.performAction(); DatabaseConnection.createStatement("update Advisor set Salary = " + txtSallary.Text + " where Id = " + TempData.CurrentAdvisor.AdvisorId1); DatabaseConnection.performAction(); MessageBox.Show("Changes are saved"); ManageAdvisors manageAdvisor = ManageAdvisors.GetInstance(); manageAdvisor.Show(); this.Hide(); }
private void btnAddAdvisor_Click(object sender, EventArgs e) { if (!IsAnyTextBoxEmpty()) { bool IsConnnected = DatabaseConnection.start(); bool ISValidAdvisor = true; Student student = new Student(); Advisor advisor = new Advisor(); try { student.FirstName = txtFirstName.Text; } catch (ArgumentException) { ISValidAdvisor = false; lblFNameWarning.Visible = true; } try { student.LastName = txtLastName.Text; } catch (ArgumentException) { ISValidAdvisor = false; lblLNameWarning.Visible = true; } try { student.Email = txtEmail.Text; } catch (ArgumentException) { ISValidAdvisor = false; lblEmailWarning.Visible = true; } if (ISValidAdvisor) { string StudentGender = "2"; if (cmbGender.Text == "Male") { StudentGender = "1"; } string day = cmbDay.Text; string month = cmbMonth.SelectedIndex.ToString(); string year = cmbYear.Text; string advisorDOB = year + " - " + month + " - " + day; bool IsException = false; if (!IsException) { try { DatabaseConnection.createStatement("INSERT INTO Person ( FirstName, LastName, Contact, Email, DateOfBirth, Gender)" + " VALUES('" + txtFirstName.Text + "' , '" + txtLastName.Text + "', '" + txtContactNo.Text + "', '" + txtEmail.Text + "', '" + advisorDOB + "'," + StudentGender + "); "); DatabaseConnection.performAction(); } catch (SqlException) { IsException = true; lblDOBwarning.Visible = true; } } if (!IsException) { DatabaseConnection.createStatement("Select @@identity as id from Person"); SqlDataReader reader = DatabaseConnection.getData(); string id = "0"; while (reader.Read()) { id = (reader["id"].ToString()); } string advisorDesignation = "6"; if (cmbDesignation.SelectedIndex == 1) { advisorDesignation = "7"; } if (cmbDesignation.SelectedIndex == 2) { advisorDesignation = "8"; } if (cmbDesignation.SelectedIndex == 3) { advisorDesignation = "9"; } if (cmbDesignation.SelectedIndex == 4) { advisorDesignation = "10"; } DatabaseConnection.createStatement("INSERT INTO Advisor (Id, Designation, Salary) VALUES (" + id + "," + advisorDesignation + "," + txtSalary.Text + ") "); DatabaseConnection.performAction(); if (!IsException) { MessageBox.Show("Advisor added"); ManageAdvisors manageAdvisors = ManageAdvisors.GetInstance(); manageAdvisors.Show(); this.Hide(); } } } } }