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