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 gvStudents_CellContentClick_1(object sender, DataGridViewCellEventArgs e) { 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 GroupStudent where StudentId =" + id); DatabaseConnection.performAction(); DatabaseConnection.createStatement("Delete from Student where Id =" + id); DatabaseConnection.performAction(); DatabaseConnection.createStatement("Delete from Person where Id =" + id); DatabaseConnection.performAction(); } } if (gvStudents.Columns[e.ColumnIndex].Name.ToString() == "Action2") { Student student = new Student(); DatabaseConnection.start(); DatabaseConnection.createStatement("select Person.Id[id], FirstName[FName], LastName[LName], Contact[Contact], Email[Email] from Person join Student on Person.Id = Student.Id where Student.Id =" + gvStudents.Rows[e.RowIndex].Cells[0].Value.ToString()); SqlDataReader reader = DatabaseConnection.getData(); while (reader.Read()) { student.PersonId = int.Parse(reader["id"].ToString()); student.FirstName = reader["FName"].ToString(); student.LastName = reader["LName"].ToString(); student.Contact = reader["Contact"].ToString(); student.Email = reader["Email"].ToString(); } TempData.CurrentStudent = student; EditStudent editStudent = new EditStudent(); editStudent.Show(); this.Hide(); } if (gvStudents.Columns[e.ColumnIndex].Name.ToString() == "Action") { gvStudents.Rows[e.RowIndex].Cells[0].Value.ToString(); DatabaseConnection.createStatement("select * from Person join Student on Person.Id = Student.Id join GroupStudent on Student.Id = GroupStudent.StudentId join GroupProject on GroupStudent.GroupId = GroupProject.GroupId join Project on GroupProject.ProjectId = Project.Id where Student.Id =" + gvStudents.Rows[e.RowIndex].Cells[0].Value.ToString()); SqlDataReader dataReader = DatabaseConnection.getData(); if (dataReader.Read()) { Student student = new Student(); student.FirstName = dataReader["FirstName"].ToString(); student.LastName = dataReader["LastName"].ToString(); student.Contact = dataReader["Contact"].ToString(); student.Email = dataReader["Email"].ToString(); student.DateOfBirth = DateTime.Parse(dataReader["DateOfBirth"].ToString()); student.Gender = int.Parse(dataReader["Gender"].ToString()); student.RegistrationNo = dataReader["RegistrationNo"].ToString(); student.Status = int.Parse(dataReader["Status"].ToString()); student.ProjectTitle = dataReader["Title"].ToString(); TempData.CurrentStudent = student; ViewStudent view = ViewStudent.GetInstance(); this.Hide(); view.Show(); } } }
private void btnEvaluate_Click(object sender, EventArgs e) { if (ValidateForm()) { DatabaseConnection.start(); DatabaseConnection.createStatement("select GroupId from Project join GroupProject on Project.Id = GroupProject.ProjectId where Project.Title = '" + cmbTitles.Text + "' "); SqlDataReader dataReader = DatabaseConnection.getData(); if (dataReader.Read()) { TempData.CurrentGroupId = int.Parse(dataReader["GroupId"].ToString()); } DatabaseConnection.createStatement("Insert into Evaluation ( Name, TotalMarks, TotalWeightage) " + "Values ('Group', " + txtTotalMarks.Text + ", " + txtWeightage.Text + ")"); DatabaseConnection.performAction(); DatabaseConnection.createStatement("Select @@identity as id from Evaluation"); SqlDataReader reader = DatabaseConnection.getData(); string id = "0"; while (reader.Read()) { id = (reader["id"].ToString()); } string sqlFormattedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); DatabaseConnection.createStatement("INSERT INTO GroupEvaluation (GroupId, EvaluationId, ObtainedMarks, EvaluationDate) " + "VALUES (" + TempData.CurrentGroupId.ToString() + ", " + id + ", " + txtObtainedMarks.Text + ", '" + sqlFormattedDate + "') "); DatabaseConnection.performAction(); cmbTitles.Text = ""; lblObtainedMarks.Text = ""; MessageBox.Show("Project Evaluated"); } }
private void button2_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.CurrentStudent.PersonId); DatabaseConnection.performAction(); MessageBox.Show("Changes are saved"); ManageStudent manageStudent = ManageStudent.GetInstance(); manageStudent.Show(); this.Hide(); }
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 txtCreateGroup_Click(object sender, EventArgs e) { if (gvStudents.RowCount != 0) { // These queries are done without the Database class. string conStr = "Data Source=MUSHI\\MUSHISQL;Initial Catalog=LabProjectA;Integrated Security=True; MultipleActiveResultSets=true"; SqlConnection con = new SqlConnection(conStr); con.Open(); string sqlFormattedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); if (con.State == ConnectionState.Open) { string Insert = "INSERT INTO [dbo].[Group](Created_On) VALUES ('" + sqlFormattedDate + "')"; SqlCommand cmd = new SqlCommand(Insert, con); cmd.ExecuteNonQuery(); } string I = "Select @@identity as id from [Group]"; SqlCommand cm = new SqlCommand(I, con); SqlDataReader reader = cm.ExecuteReader(); string id = "0"; if (reader.Read()) { id = (reader["id"].ToString()); } foreach (Student s in TempData.GetGroupStudents()) { DatabaseConnection.createStatement("Insert into GroupStudent (GroupId, StudentId ,Status , AssignmentDate) " + "Values (" + id + "," + s.StudentId.ToString() + ", 4 ,'" + DateTime.Now.ToString("yyyy-MM-dd") + "')"); DatabaseConnection.performAction(); } TempData.Clear_GroupStudents(); gvStudents.Rows.Clear(); gvStudents.Refresh(); cmbSelectStudent.Text = ""; MessageBox.Show("Group has been Created"); } else { MessageBox.Show("Select at least one student"); } }
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 btnRegister_Click(object sender, EventArgs e) { if (!IsAnyTextBoxEmpty()) { bool IsConnnected = DatabaseConnection.start(); bool ISValidStudent = true; Student student = new Student(); try { student.FirstName = txtFirstName.Text; } catch (ArgumentException) { ISValidStudent = false; lblFNameWarning.Visible = true; } try { student.LastName = txtLastName.Text; } catch (ArgumentException) { ISValidStudent = false; lblLNameWarning.Visible = true; } try { student.RegistrationNo = txtRegNo.Text; } catch (ArgumentException) { ISValidStudent = false; lblRegWarning.Visible = true; } try { student.Email = txtEmail.Text; } catch (ArgumentException) { ISValidStudent = false; lblEmailWarning.Visible = true; } if (ISValidStudent) { string StudentGender = "0"; if (cmbGender.Text == "Male") { StudentGender = "1"; } string day = cmbDay.Text; string month = cmbMonth.SelectedIndex.ToString(); string year = cmbYear.Text; string studentDOB = year + " - " + month + " - " + day; bool IsException = false; DatabaseConnection.createStatement("select * from Student where RegistrationNo = '" + txtRegNo.Text + " '"); SqlDataReader r = DatabaseConnection.getData(); if (r.Read()) { IsException = true; MessageBox.Show("This Registration Number already exists"); } if (!IsException) { try { DatabaseConnection.createStatement("INSERT INTO Person ( FirstName, LastName, Contact, Email, DateOfBirth, Gender)" + " VALUES('" + txtFirstName.Text + "' , '" + txtLastName.Text + "', '" + txtContactNo.Text + "', '" + txtEmail.Text + "', '" + studentDOB + "' ," + 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()); } DatabaseConnection.createStatement("INSERT INTO Student (Id, RegistrationNo) VALUES (" + id + ", '" + txtRegNo.Text + "') "); DatabaseConnection.performAction(); if (!IsException) { MessageBox.Show("Student added"); ManageStudent manageStudent = ManageStudent.GetInstance(); manageStudent.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(); } } } } }