public static List <REQUESTS> getRequest()
{
List <REQUESTS> requestData = new List <REQUESTS> {
};
string query = "SELECT DISTINCT [week] = replace((SELECT DISTINCT week AS [data()] FROM [WEEKS] FOR xml path('')), ' ', ', '), [REQUESTS].[request_id], [REQUESTS].[module], [REQUESTS].[room_code], [REQUESTS].[capacity], [REQUESTS].[wheelchair], [REQUESTS].[projector], [REQUESTS].[visualiser], [REQUESTS].[whiteboard], [REQUESTS].[computer], [REQUESTS].[lecture_capture], [REQUESTS].[pa_system], [REQUESTS].[radio_microphone], [REQUESTS].[video_dvd], [REQUESTS].[arrangement], [REQUESTS].[special_req], [REQUESTS].[priority], [REQUESTS].[day], [REQUESTS].[period], [REQUESTS].[duration], [REQUESTS].[status], [REQUESTS].[park], [REQUESTS].[semester], [REQUESTS].[year], [REQUESTS].[lecturer], [REQUESTS].[dept_code], [REQUESTS].[session] FROM [REQUESTS], [WEEKS] WHERE [REQUESTS].[request_id] = [WEEKS].[request_id] AND [REQUESTS].year = 2015 AND [REQUESTS].[status] = 'Pending'";
SqlCommand cmd = new SqlCommand(query);
DataSet ds = GetData(cmd);
DataTable dt = ds.Tables[0];
foreach (DataRow item in ds.Tables[0].Rows)
{
REQUESTS request = new REQUESTS();
//put database data into request object
request.request_id = Convert.ToInt32(item["request_id"]);
request.module = item["module"].ToString();
request.room_code = item["room_code"].ToString();
request.capacity = Convert.ToInt32(item["capacity"]);
request.wheelchair = Convert.ToInt32(item["wheelchair"]);
request.projector = Convert.ToInt32(item["projector"]);
request.visualiser = Convert.ToInt32(item["visualiser"]);
request.whiteboard = Convert.ToInt32(item["whiteboard"]);
request.computer = Convert.ToInt32(item["computer"]);
request.lecture_capture = Convert.ToInt32(item["lecture_capture"]);
request.pa_system = Convert.ToInt32(item["pa_system"]);
request.radio_microphone = Convert.ToInt32(item["radio_microphone"]);
request.video_dvd = Convert.ToInt32(item["video_dvd"]);
request.arrangement = item["arrangement"].ToString();
request.special_req = item["special_req"].ToString();
request.priority = Convert.ToInt32(item["priority"]);
request.day = item["day"].ToString();
request.period = Convert.ToInt32(item["period"]);
request.duration = Convert.ToInt32(item["duration"]);
request.park = item["park"].ToString();
request.status = item["status"].ToString();
request.semester = Convert.ToInt32(item["semester"]);
request.year = Convert.ToInt32(item["year"]);
request.lecturer = item["lecturer"].ToString();
request.dept_code = item["dept_code"].ToString();
request.session = item["session"].ToString();
request.week = item["week"].ToString();
//add request object to list
requestData.Add(request);
}
//return as array of record in javascript
return(requestData);
}
public static List <REQUESTS> getWeek(Request request)
{
List <REQUESTS> requestData = new List <REQUESTS> {
};
string query = "SELECT * FROM [WEEKS] WHERE [request_id] = " + Convert.ToInt32(request.request_id);
SqlCommand cmd = new SqlCommand(query);
DataSet ds = GetData(cmd);
DataTable dt = ds.Tables[0];
foreach (DataRow item in ds.Tables[0].Rows)
{
REQUESTS week = new REQUESTS();
//put database data into request object
week.week2 = Convert.ToInt32(item["week"]);
week.request_id = Convert.ToInt32(item["request_id"]);
//add request object to list
requestData.Add(week);
}
//return as array of record in javascript
return(requestData);
}