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();
}
}
}
public static ViewStudent GetInstance()
{
if (Instance == null)
{
ViewStudent new_Instance = new ViewStudent();
return(new_Instance);
}
return(Instance);
}
