private void button12_Click(object sender, EventArgs e)
{
this.Hide();
ProjectReport a = new ProjectReport();
a.Show();
}
private void button1_Click(object sender, EventArgs e)
{
ProjectReport p = new ProjectReport();
this.Hide();
p.Show();
}
private void ProjectReports_Load(object sender, EventArgs e)
{
try
{
SqlConnection con = new SqlConnection(AddProject.conStr);
con.Open();
SqlCommand cmd = new SqlCommand("SELECT Id FROM Project", con);
SqlDataReader reader = cmd.ExecuteReader();
List <string> Members_RegNo = new List <string>();
List <string> Members_Name = new List <string>();
List <int> Advisor_IDs = new List <int>();
List <string> AdvisorRoles = new List <string>();
while (reader.Read())
{
if (con.State == ConnectionState.Open)
{
Members_Name.Clear();
Members_RegNo.Clear();
Advisor_IDs.Clear();
AdvisorRoles.Clear();
ProjectReport projectReport = new ProjectReport();
string fetch1 = "SELECT Title, StudentId FROM Project P JOIN GroupProject GP on P.Id = GP.ProjectId JOIN GroupStudent GS on GP.GroupId = GS.GroupId WHERE P.Id = '" + Convert.ToInt32(reader["Id"]) + "' group by StudentId, Title";
SqlCommand cmd1 = new SqlCommand(fetch1, con);
SqlDataReader StudentIds = cmd1.ExecuteReader();
while (StudentIds.Read())
{
projectReport.P_Title = Convert.ToString(StudentIds["Title"]);
string fetch3 = "SELECT RegistrationNo, FirstName, LastName FROM Student JOIN Person ON Student.Id = Person.Id WHERE Student.Id = '" + Convert.ToInt32(StudentIds["StudentId"]) + "'";
SqlCommand cmd3 = new SqlCommand(fetch3, con);
SqlDataReader StudentData = cmd3.ExecuteReader();
if (StudentData.Read())
{
Members_Name.Add(Convert.ToString(StudentData["FirstName"]) + " " + Convert.ToString(StudentData["LastName"]));
Members_RegNo.Add(Convert.ToString(StudentData["RegistrationNo"]));
}
}
if (Members_Name.Count == 1)
{
projectReport.Student_1_Name = Members_Name[0];
projectReport.Student_1_RegNo = Members_RegNo[0];
}
else if (Members_Name.Count == 2)
{
projectReport.Student_1_Name = Members_Name[0];
projectReport.Student_1_RegNo = Members_RegNo[0];
projectReport.Student_2_Name = Members_Name[1];
projectReport.Student_2_RegNo = Members_RegNo[1];
}
else if (Members_Name.Count == 3)
{
projectReport.Student_1_Name = Members_Name[0];
projectReport.Student_1_RegNo = Members_RegNo[0];
projectReport.Student_2_Name = Members_Name[1];
projectReport.Student_2_RegNo = Members_RegNo[1];
projectReport.Student_3_Name = Members_Name[2];
projectReport.Student_3_RegNo = Members_RegNo[2];
}
else if (Members_Name.Count == 4)
{
projectReport.Student_1_Name = Members_Name[0];
projectReport.Student_1_RegNo = Members_RegNo[0];
projectReport.Student_2_Name = Members_Name[1];
projectReport.Student_2_RegNo = Members_RegNo[1];
projectReport.Student_3_Name = Members_Name[2];
projectReport.Student_3_RegNo = Members_RegNo[2];
projectReport.Student_4_Name = Members_Name[3];
projectReport.Student_4_RegNo = Members_RegNo[3];
}
string fetch2 = "SELECT AdvisorId, Value FROM ProjectAdvisor PA JOIN Lookup L ON PA.AdvisorRole = L.Id WHERE PA.ProjectId = '" + Convert.ToInt32(reader["Id"]) + "'";
SqlCommand cmd2 = new SqlCommand(fetch2, con);
SqlDataReader AdvisorIDs = cmd2.ExecuteReader();
while (AdvisorIDs.Read())
{
Advisor_IDs.Add(Convert.ToInt32(AdvisorIDs["AdvisorId"]));
AdvisorRoles.Add(Convert.ToString(AdvisorIDs["Value"]));
}
if (Advisor_IDs.Count == 1)
{
projectReport.Advisor_1_Id = Advisor_IDs[0];
projectReport.Advisor_1_Role = AdvisorRoles[0];
}
else if (Advisor_IDs.Count == 2)
{
projectReport.Advisor_1_Id = Advisor_IDs[0];
projectReport.Advisor_1_Role = AdvisorRoles[0];
projectReport.Advisor_2_Id = Advisor_IDs[1];
projectReport.Advisor_2_Role = AdvisorRoles[1];
}
else if (Advisor_IDs.Count == 3)
{
projectReport.Advisor_1_Id = Advisor_IDs[0];
projectReport.Advisor_1_Role = AdvisorRoles[0];
projectReport.Advisor_2_Id = Advisor_IDs[1];
projectReport.Advisor_2_Role = AdvisorRoles[1];
projectReport.Advisor_3_Id = Advisor_IDs[2];
projectReport.Advisor_3_Role = AdvisorRoles[2];
}
if (projectReport.P_Title != null)
{
projectReports.Add(projectReport);
}
}
}
setGrid();
}
catch
{
MessageBox.Show("Some Error Occured");
}
}
