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