-
Notifications
You must be signed in to change notification settings - Fork 0
/
PanelMember.aspx.cs
125 lines (92 loc) · 4.25 KB
/
PanelMember.aspx.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
namespace WebApplication1
{
public partial class PanelMember : System.Web.UI.Page
{
string FMID;
protected void Page_Load(object sender, EventArgs e)
{
FMID = Session["ID"].ToString();
using (SqlConnection connection = new SqlConnection(@"Data Source=(local)\SQLEXPRESS;initial Catalog=FYPDB;Integrated Security=True;"))
{
connection.Open();
string statusQuery = "SELECT P.Title FROM PanelMember PM, FYP_GROUPS FG, Project P WHERE(PM.PanelID = FG.PanelID) AND(PM.FacultyID = @FMID) AND(P.ProjectID = FG.ProjectID)";
using (SqlCommand cmd = new SqlCommand(statusQuery, connection))
{
cmd.Parameters.AddWithValue("@FMID", FMID);
SqlDataAdapter d = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
d.Fill(dt);
GridView3.DataSource = dt;
GridView3.DataBind();
cmd.ExecuteNonQuery();
}
connection.Close();
}
}
//View Group members
protected void Button1_Click(object sender, EventArgs e)
{
// Select S.Name from Student S inner join FYP_GROUP_MEMBERS F on S.RollNo = F.StudentID where F.GroupID = (Select GroupID from FYP_GROUPS where Supervisor = 221)
using (SqlConnection connection = new SqlConnection(@"Data Source=(local)\SQLEXPRESS;initial Catalog=FYPDB;Integrated Security=True;"))
{
connection.Open();
string statusQuery = "Select S.Name from Student S inner join FYP_GROUP_MEMBERS F on S.RollNo = F.StudentID where F.GroupID = (Select GroupID from FYP_GROUPS where Supervisor = @FMID)";
SqlCommand cmd = new SqlCommand(statusQuery, connection);
cmd.Parameters.AddWithValue("@FMID", FMID);
SqlDataReader reader = cmd.ExecuteReader();
GridView4.DataSource = reader;
GridView4.DataBind();
connection.Close();
}
}
//view description
protected void Button2_Click(object sender, EventArgs e)
{
using (SqlConnection connection = new SqlConnection(@"Data Source=(local)\SQLEXPRESS;initial Catalog=FYPDB;Integrated Security=True;"))
{
connection.Open();
string statusQuery = "Select Description = P.Details from Project P, FYP_Groups FG where P.ProjectID = FG.ProjectID and FG.Supervisor = @FMID";
SqlCommand cmd = new SqlCommand(statusQuery, connection);
cmd.Parameters.AddWithValue("@FMID", FMID);
SqlDataReader reader = cmd.ExecuteReader();
GridView2.DataSource = reader;
GridView2.DataBind();
connection.Close();
}
}
//Check evaluation form
protected void Button3_Click(object sender, EventArgs e)
{
using (SqlConnection connection = new SqlConnection(@"Data Source=(local)\SQLEXPRESS;initial Catalog=FYPDB;Integrated Security=True;"))
{
connection.Open();
Response.Write(FMID);
string statusQuery = "Select EvaluationStatus from PanelMember where FacultyID=@FMID";
using (SqlCommand cmd = new SqlCommand(statusQuery, connection))
{
cmd.Parameters.AddWithValue("@FMID", FMID);
SqlDataAdapter d = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
d.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
cmd.ExecuteNonQuery();
}
connection.Close();
}
}
//Fill evaluation form
protected void Button4_Click(object sender, EventArgs e)
{
Response.Redirect("EvaluationForm.aspx");
}
}
}