private void btnCancel_Click(object sender, EventArgs e) { ProjectDashboard projectDashboard = ProjectDashboard.GetInstance(); projectDashboard.Show(); this.Hide(); }
private void gvStudents_CellContentClick_1(object sender, DataGridViewCellEventArgs e) { if (gvStudents.Columns[e.ColumnIndex].Name.ToString() == "Action") { Project project = new Project(); project.Title = gvStudents.Rows[e.RowIndex].Cells[1].Value.ToString(); DatabaseConnection.createStatement("select Description from Project where Id = " + gvStudents.Rows[e.RowIndex].Cells[0].Value.ToString()); SqlDataReader newReader = DatabaseConnection.getData(); if (newReader.Read()) { project.Description = newReader["Description"].ToString(); } project.Id = int.Parse(gvStudents.Rows[e.RowIndex].Cells[0].Value.ToString()); TempData.CurrentProject = project; ProjectDashboard projectDashboard = ProjectDashboard.GetInstance(); projectDashboard.Show(); this.Hide(); } if (gvStudents.Columns[e.ColumnIndex].Name.ToString() == "Action3") { if (MessageBox.Show("Are you sure you want to delete?", "Delete Confirmation", MessageBoxButtons.YesNo) == DialogResult.Yes) { string id = gvStudents.Rows[e.RowIndex].Cells[0].Value.ToString(); DatabaseConnection.start(); DatabaseConnection.createStatement("Delete from ProjectAdvisor where ProjectId =" + id); DatabaseConnection.performAction(); DatabaseConnection.createStatement("Delete from GroupProject where ProjectId =" + id); DatabaseConnection.performAction(); DatabaseConnection.createStatement("Delete from Project where Id =" + id); DatabaseConnection.performAction(); } } }
private void btnAddProject_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(txtTitle.Text)) { lblTitleWarning.Visible = true; } else if (string.IsNullOrWhiteSpace(txtDescription.Text)) { lblDescriptionWarning.Visible = true; } else { DatabaseConnection.createStatement("INSERT INTO Project ( Title, Description)" + " VALUES('" + txtTitle.Text + "' , '" + txtDescription.Text + "') "); DatabaseConnection.performAction(); Project project = new Project(); project.Title = txtTitle.Text; DatabaseConnection.createStatement("Select @@identity as id from Project"); SqlDataReader reader = DatabaseConnection.getData(); while (reader.Read()) { project.Id = int.Parse(reader["id"].ToString()); } TempData.CurrentProject = project; ProjectDashboard dashboard = ProjectDashboard.GetInstance(); dashboard.Show(); this.Hide(); } }
private void gvStudents_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (gvStudents.Columns[e.ColumnIndex].Name.ToString() == "Assign") { bool IsAlready = false; DatabaseConnection.createStatement("select ProjectId from GroupProject where GroupId = " + gvStudents.Rows[e.RowIndex].Cells[0].Value.ToString()); SqlDataReader newReader = DatabaseConnection.getData(); if (newReader.Read()) { IsAlready = true; } if (IsAlready) { MessageBox.Show("This group is already assigned"); } else { string sqlFormattedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); DatabaseConnection.start(); DatabaseConnection.createStatement("Insert into GroupProject (ProjectId, GroupId, AssignmentDate)" + " Values (" + TempData.CurrentProject.Id + ", " + gvStudents.Rows[e.RowIndex].Cells[0].Value.ToString() + ", '" + sqlFormattedDate + "')"); DatabaseConnection.performAction(); DatabaseConnection.createStatement("Update GroupStudent set Status = 4 where GroupId = " + gvStudents.Rows[e.RowIndex].Cells[0].Value.ToString()); DatabaseConnection.performAction(); ProjectDashboard projectDashboard = ProjectDashboard.GetInstance(); projectDashboard.Show(); this.Hide(); } } }
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(); } }