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();
}
}
}
}
}
