private void ProjectDashboard_Load(object sender, EventArgs e)
{
if (gvGroupStudents.RowCount == 0)
{
btnChangeGroup.Text = "Add Group";
label1.Visible = true;
}
else
{
btnChangeGroup.Text = "Change Group";
label1.Visible = false;
}
lblTitle.Text = TempData.CurrentProject.Title;
txtDesc.Text = TempData.CurrentProject.Description;
List <Advisor> advisors = new List <Advisor>();
DatabaseConnection.createStatement("select AdvisorId, FirstName, LastName, AdvisorRole from ProjectAdvisor join Advisor on ProjectAdvisor.AdvisorId = Advisor.Id join Person on Advisor.Id = Person.Id where ProjectAdvisor.ProjectId = " + TempData.CurrentProject.Id.ToString());
SqlDataReader reader = DatabaseConnection.getData();
while (reader.Read())
{
Advisor advisor = new Advisor();
advisor.AdvisorId1 = int.Parse(reader["AdvisorId"].ToString());
advisor.BasicDetails.FirstName = reader["FirstName"].ToString();
advisor.BasicDetails.LastName = reader["LastName"].ToString();
advisor.Role = int.Parse(reader["AdvisorRole"].ToString());
advisors.Add(advisor);
}
foreach (Advisor a in advisors)
{
if (a.Role == 11)
{
lblMainAdvisorName.Text = a.BasicDetails.FirstName + " " + a.BasicDetails.LastName;
btnAddMainAdvisor.Text = "Change";
}
if (a.Role == 12)
{
lblCoAdvisorName.Text = a.BasicDetails.FirstName + " " + a.BasicDetails.LastName;
btnAddCoAdvisor.Text = "Change";
}
if (a.Role == 14)
{
lblIndustryAdvisorName.Text = a.BasicDetails.FirstName + " " + a.BasicDetails.LastName;
btnAddIndustryAdvisor.Text = "Change";
}
}
gvGroupStudents.Rows.Clear();
gvGroupStudents.Refresh();
DatabaseConnection.createStatement("select * from Project join GroupProject on Project.Id = GroupProject.ProjectId join GroupStudent on GroupProject.GroupId = GroupStudent.GroupId join Student on GroupStudent.StudentId = Student.Id join Person on Student.Id = Person.Id where Project.Id =" + TempData.CurrentProject.Id);
SqlDataReader newReader = DatabaseConnection.getData();
while (newReader.Read())
{
gvGroupStudents.Rows.Add(newReader["RegistrationNo"].ToString(), newReader["FirstName"].ToString() + " " + newReader["LastName"].ToString());
}
}
private void lblAdd_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(cmbSelctAdvisor.Text))
{
lblWarning.Visible = true;
}
else
{
string[] names = cmbSelctAdvisor.Text.Split(new char[] { ' ' });
DatabaseConnection.createStatement("select Advisor.Id[id] from Person join Advisor on Advisor.Id = Person.Id where FirstName = '" + names[0] + "'" +
" and LastName = '" + names[1] + "'");
SqlDataReader reader = DatabaseConnection.getData();
Advisor advisor = new Advisor();
if (reader.Read())
{
int x = advisor.AdvisorId1 = int.Parse(reader["id"].ToString());
MessageBox.Show(x.ToString());
TempData.CurrentAdvisor = advisor;
}
MessageBox.Show(TempData.CurrentAdvisor.AdvisorId1.ToString());
string sqlFormattedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
DatabaseConnection.createStatement("Insert into ProjectAdvisor (AdvisorId, ProjectId, AdvisorRole, AssignmentDate)" +
" Values (" + TempData.CurrentAdvisor.AdvisorId1.ToString() + ", " + TempData.CurrentProject.Id + "," +
TempData.CurrentRole.ToString() + ", '" + sqlFormattedDate + "') ");
try
{
DatabaseConnection.performAction();
}
catch
{
MessageBox.Show("Advisor already assigned to the group");
}
ProjectDashboard projectDashboard = ProjectDashboard.GetInstance();
projectDashboard.Show();
this.Hide();
}
}
private void gvAdvisors_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (gvAdvisors.Columns[e.ColumnIndex].Name.ToString() == "Action3")
{
if (MessageBox.Show("Are you sure you want to delete?", "Delete Confirmation", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
string id = gvAdvisors.Rows[e.RowIndex].Cells[0].Value.ToString();
DatabaseConnection.start();
DatabaseConnection.createStatement("Delete from ProjectAdvisor where AdvisorId =" + id);
DatabaseConnection.performAction();
DatabaseConnection.createStatement("Delete from Advisor where Id =" + id);
DatabaseConnection.performAction();
DatabaseConnection.createStatement("Delete from Person where Id =" + id);
DatabaseConnection.performAction();
}
}
if (gvAdvisors.Columns[e.ColumnIndex].Name.ToString() == "Action2")
{
Advisor advisor = new Advisor();
DatabaseConnection.start();
DatabaseConnection.createStatement("select Person.Id[id], FirstName[FName], LastName[LName], Contact[Contact], Email[Email], Salary[Salary] from Person join Advisor on Person.Id = Advisor.Id where Advisor.Id =" + gvAdvisors.Rows[e.RowIndex].Cells[0].Value.ToString());
SqlDataReader reader = DatabaseConnection.getData();
while (reader.Read())
{
advisor.AdvisorId1 = int.Parse(reader["id"].ToString());
advisor.BasicDetails.FirstName = reader["FName"].ToString();
advisor.BasicDetails.LastName = reader["LName"].ToString();
advisor.BasicDetails.Contact = reader["Contact"].ToString();
advisor.BasicDetails.Email = reader["Email"].ToString();
advisor.Salary = int.Parse(reader["Salary"].ToString());
}
TempData.CurrentAdvisor = advisor;
EditAdvisor editAdvisor = new EditAdvisor();
editAdvisor.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();
}
}
}
}
}
