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 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 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 ManageAdvisors_Load(object sender, EventArgs e)
{
tabControl1.SelectedIndex = 3;
gvAdvisors.Rows.Clear();
gvAdvisors.Refresh();
bool IsConnnected = DatabaseConnection.start();
DatabaseConnection.createStatement("select Person.Id[id], FirstName[FName], LastName[LName], Designation[Des] from Person join Advisor on Person.Id = Advisor.Id");
SqlDataReader reader = DatabaseConnection.getData();
while (reader.Read())
{
string name = reader["FName"].ToString() + " " + reader["LName"].ToString();
string designation = "Professor";
string inputDesignation = reader["Des"].ToString();
if (inputDesignation == "7")
{
designation = "Associate Professor";
}
if (inputDesignation == "8")
{
designation = "Assistant Professor";
}
if (inputDesignation == "9")
{
designation = "Lecturer";
}
if (inputDesignation == "10")
{
designation = "Industry Professional";
}
gvAdvisors.Rows.Add(reader["id"].ToString(), name, designation);
}
}
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 frmRegisterStudent_Load(object sender, EventArgs e)
{
bool IsConnnected = DatabaseConnection.start();
cmbDay.SelectedIndex = 0;
cmbMonth.SelectedIndex = 0;
cmbYear.SelectedIndex = 0;
}
private void AddAdvisorToProject_Load(object sender, EventArgs e)
{
DatabaseConnection.start();
DatabaseConnection.createStatement("select FirstName[FName], LastName[LName] from Person join Advisor on Person.Id = Advisor.Id ");
SqlDataReader reader = DatabaseConnection.getData();
while (reader.Read())
{
cmbSelctAdvisor.Items.Add(reader["FName"].ToString() + " " + reader["LName"].ToString());
}
}
private void CreateGroup_Load(object sender, EventArgs e)
{
DatabaseConnection.start();
DatabaseConnection.createStatement("select RegistrationNo from Person join Student on Person.Id = Student.Id ");
SqlDataReader reader = DatabaseConnection.getData();
while (reader.Read())
{
cmbSelectStudent.Items.Add(reader["RegistrationNO"].ToString());
}
}
private void ManageProjects_Load(object sender, EventArgs e)
{
tabControl1.SelectedIndex = 1;
gvStudents.Rows.Clear();
gvStudents.Refresh();
bool IsConnnected = DatabaseConnection.start();
DatabaseConnection.createStatement("select * from Project");
SqlDataReader reader = DatabaseConnection.getData();
while (reader.Read())
{
gvStudents.Rows.Add(reader["Id"].ToString(), reader["Title"].ToString());
}
}
private void ManageStudent_Load(object sender, EventArgs e)
{
tabControl1.SelectedIndex = 2;
gvStudents.Rows.Clear();
gvStudents.Refresh();
bool IsConnnected = DatabaseConnection.start();
DatabaseConnection.createStatement("select Person.Id[id], FirstName[Name], RegistrationNo[Registration No] from Person join Student on Person.Id = Student.Id");
SqlDataReader reader = DatabaseConnection.getData();
while (reader.Read())
{
gvStudents.Rows.Add(reader["id"].ToString(), reader["Registration No"].ToString(), reader["Name"].ToString());
}
}
private void btnAddStudent_Click(object sender, EventArgs e)
{
string RegNo = cmbSelectStudent.Text;
bool IsConnnected = DatabaseConnection.start();
DatabaseConnection.createStatement("select * from GroupStudent join Student on GroupStudent.StudentId = Student.Id where Student.RegistrationNo = '" + RegNo + "'");
SqlDataReader sqlDataReader = DatabaseConnection.getData();
if (!sqlDataReader.Read())
{
DatabaseConnection.createStatement("Select Id from Student where RegistrationNo = '" + RegNo + "'");
SqlDataReader reader = DatabaseConnection.getData();
string StudentId = "";
if (reader.Read())
{
StudentId = reader.GetValue(reader.GetOrdinal("Id")).ToString();
}
DatabaseConnection.createStatement("Select * from Person where Id = " + StudentId);
reader = DatabaseConnection.getData();
Student student = new Student();
student.RegistrationNo = RegNo;
student.StudentId = int.Parse(StudentId);
if (reader.Read())
{
student.FirstName = reader.GetString(1).ToString();
student.LastName = reader.GetString(2).ToString();
student.Contact = reader.GetString(3).ToString();
student.Email = reader.GetString(4).ToString();
student.DateOfBirth = Convert.ToDateTime(reader.GetDateTime(5));
}
TempData.add_GroupStudent(student);
gvStudents.Rows.Clear();
gvStudents.Refresh();
foreach (Student s in TempData.GetGroupStudents())
{
gvStudents.Rows.Add(s.RegistrationNo, s.FirstName);
}
}
else
{
MessageBox.Show("Student already a part of another group");
}
}
private void AssignGroup_Load(object sender, EventArgs e)
{
DatabaseConnection.start();
gvStudents.Rows.Clear();
gvStudents.Refresh();
List <string> groupIds = new List <string>();
bool IsConnnected = DatabaseConnection.start();
DatabaseConnection.createStatement("select Id from [Group]");
SqlDataReader reader = DatabaseConnection.getData();
while (reader.Read())
{
groupIds.Add(reader["Id"].ToString());
}
foreach (string group in groupIds)
{
List <string> groupMembers = new List <string>();
DatabaseConnection.createStatement("select Student.RegistrationNo[reg] from GroupStudent join Student on GroupStudent.StudentId = Student.Id where GroupId = " + group);
SqlDataReader reader2 = DatabaseConnection.getData();
while (reader2.Read())
{
groupMembers.Add(reader2["reg"].ToString());
}
if (groupMembers.Count != 0)
{
DataGridViewRow row = (DataGridViewRow)gvStudents.Rows[0].Clone();
row.Cells[0].Value = group;
int i = 1;
foreach (string member in groupMembers)
{
row.Cells[i].Value = member;
++i;
}
gvStudents.Rows.Add(row);
}
}
}
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 ProjectsReport_Load(object sender, EventArgs e)
{
DatabaseConnection.start();
gvReport.Rows.Clear();
gvReport.Refresh();
List <string> ProjectIds = new List <string>();
bool IsConnnected = DatabaseConnection.start();
DatabaseConnection.createStatement("select Id from Project");
SqlDataReader reader = DatabaseConnection.getData();
while (reader.Read())
{
ProjectIds.Add(reader["Id"].ToString());
}
foreach (string project_id in ProjectIds)
{
ProjectReport report = new ProjectReport();
List <string> members = new List <string>();
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 where Project.Id = " + project_id);
SqlDataReader reader3 = DatabaseConnection.getData();
if (reader3.Read())
{
report.Title = reader3["Title"].ToString();
}
while (reader3.Read())
{
members.Add(reader3["RegistrationNo"].ToString());
}
// Adding Members accrording to number of group members
if (members.Count == 1)
{
report.Member1 = members[0];
}
if (members.Count == 2)
{
report.Member1 = members[0];
report.Member2 = members[1];
}
if (members.Count == 3)
{
report.Member1 = members[0];
report.Member2 = members[1];
report.Member3 = members[2];
}
if (members.Count == 3)
{
report.Member1 = members[0];
report.Member2 = members[1];
report.Member3 = members[2];
report.Member4 = members[3];
}
DatabaseConnection.createStatement("select * from Project join ProjectAdvisor on Project.Id = ProjectAdvisor.ProjectId join Advisor on ProjectAdvisor.AdvisorId = Advisor.Id join Person on Advisor.Id = Person.Id where Project.Id = " + project_id);
SqlDataReader reader4 = DatabaseConnection.getData();
while (reader4.Read())
{
string role = reader4["AdvisorRole"].ToString();
if (role == "11")
{
report.MainAdvisor = reader4["FirstName"].ToString() + " " + reader4["LastName"].ToString();
}
if (role == "12")
{
report.CoAdvisor = reader4["FirstName"].ToString() + " " + reader4["LastName"].ToString();
}
if (role == "14")
{
report.MainAdvisor = reader4["FirstName"].ToString() + " " + reader4["LastName"].ToString();
}
}
if (report.Title != null)
{
reports.Add(report);
}
}
var bindingSource = new BindingSource();
bindingSource.DataSource = reports;
gvReport.DataSource = bindingSource;
}
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();
}
}
}
}
}