public static void insertRequest(REQUEST_FORM request)
{
int id;
string constr = WebConfigurationManager.ConnectionStrings["myConnectionString"].ToString();
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO [REQUESTS] ([module], [room_code], [capacity], [wheelchair], [projector], [visualiser], [whiteboard], [computer], [lecture_capture], [pa_system], [radio_microphone], [video_dvd], [arrangement], [special_req], [priority], [day], [period], [duration], [status], [park], [semester], [year], [lecturer], [dept_code], [session]) OUTPUT INSERTED.[request_id] VALUES (@module, @room_code, @capacity, @wheelchair, @projector, @visualiser, @whiteboard, @computer, @lecture_capture, @pa_system, @radio_microphone, @video_dvd, @arrangement, @special_req, @priority, @day, @period, @duration, @status, @park, @semester, @year, @lecturer, @dept, @session)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@module", request.module);
cmd.Parameters.AddWithValue("@room_code", request.room_code1);
cmd.Parameters.AddWithValue("@capacity", Convert.ToInt32(request.capacity1));
cmd.Parameters.AddWithValue("@wheelchair", Convert.ToInt32(request.wheelchair));
cmd.Parameters.AddWithValue("@projector", Convert.ToInt32(request.projector));
cmd.Parameters.AddWithValue("@whiteboard", Convert.ToInt32(request.whiteboard));
cmd.Parameters.AddWithValue("@visualiser", Convert.ToInt32(request.visualiser));
cmd.Parameters.AddWithValue("@computer", Convert.ToInt32(request.computer));
cmd.Parameters.AddWithValue("@lecture_capture", Convert.ToInt32(request.lecture_capture));
cmd.Parameters.AddWithValue("@pa_system", Convert.ToInt32(request.pa_system));
cmd.Parameters.AddWithValue("@video_dvd", Convert.ToInt32(request.video_dvd));
cmd.Parameters.AddWithValue("@radio_microphone", Convert.ToInt32(request.radio_microphone));
cmd.Parameters.AddWithValue("@arrangement", request.arrangement);
cmd.Parameters.AddWithValue("@priority", Convert.ToInt32(request.priority));
cmd.Parameters.AddWithValue("@period", Convert.ToInt32(request.period));
cmd.Parameters.AddWithValue("@duration", Convert.ToInt32(request.duration));
cmd.Parameters.AddWithValue("@special_req", request.special_req1);
cmd.Parameters.AddWithValue("@day", request.day);
cmd.Parameters.AddWithValue("@status", request.status);
cmd.Parameters.AddWithValue("@park", request.park);
cmd.Parameters.AddWithValue("@semester", Convert.ToInt32(request.semester));
cmd.Parameters.AddWithValue("@lecturer", request.lecturer);
cmd.Parameters.AddWithValue("@session", request.session);
cmd.Parameters.AddWithValue("@year", request.year);
cmd.Parameters.AddWithValue("@dept", HttpContext.Current.Session["dept_code"].ToString());
cmd.Connection = con;
con.Open();
id = (int)cmd.ExecuteScalar();
con.Close();
}
}
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO [WEEKS] ([week], [request_id]) VALUES (@week, @request_id)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@request_id", id);
cmd.Parameters.AddWithValue("@week", Convert.ToInt32(request.week1));
cmd.Connection = con;
con.Open();
cmd.ExecuteScalar();
con.Close();
}
}
}
public static void insertRequest(REQUEST_FORM request)
{
//add week information to List 'week'
List <int> week = new List <int> {
};
if (Convert.ToInt32(request.week1) == 1)
{
week.Add(1);
}
if (Convert.ToInt32(request.week2) == 1)
{
week.Add(2);
}
if (Convert.ToInt32(request.week3) == 1)
{
week.Add(3);
}
if (Convert.ToInt32(request.week4) == 1)
{
week.Add(4);
}
if (Convert.ToInt32(request.week5) == 1)
{
week.Add(5);
}
if (Convert.ToInt32(request.week6) == 1)
{
week.Add(6);
}
if (Convert.ToInt32(request.week7) == 1)
{
week.Add(7);
}
if (Convert.ToInt32(request.week8) == 1)
{
week.Add(8);
}
if (Convert.ToInt32(request.week9) == 1)
{
week.Add(9);
}
if (Convert.ToInt32(request.week10) == 1)
{
week.Add(10);
}
if (Convert.ToInt32(request.week11) == 1)
{
week.Add(11);
}
if (Convert.ToInt32(request.week12) == 1)
{
week.Add(12);
}
if (Convert.ToInt32(request.week13) == 1)
{
week.Add(13);
}
if (Convert.ToInt32(request.week14) == 1)
{
week.Add(14);
}
if (Convert.ToInt32(request.week15) == 1)
{
week.Add(15);
}
if (Convert.ToInt32(request.week16) == 1)
{
week.Add(16);
}
int id;
string constr = WebConfigurationManager.ConnectionStrings["myConnectionString"].ToString();
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO [REQUESTS] ([module], [room_code], [capacity], [wheelchair], [projector], [visualiser], [whiteboard], [computer], [lecture_capture], [pa_system], [radio_microphone], [video_dvd], [arrangement], [special_req], [priority], [day], [period], [duration], [status], [park], [semester], [year], [lecturer], [dept_code], [session]) OUTPUT INSERTED.[request_id] VALUES (@module, @room_code, @capacity, @wheelchair, @projector, @visualiser, @whiteboard, @computer, @lecture_capture, @pa_system, @radio_microphone, @video_dvd, @arrangement, @special_req, @priority, @day, @period, @duration, @status, @park, @semester, @year, @lecturer, @dept, @session)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@module", request.module);
cmd.Parameters.AddWithValue("@room_code", request.room_code1);
cmd.Parameters.AddWithValue("@capacity", Convert.ToInt32(request.capacity1));
cmd.Parameters.AddWithValue("@wheelchair", Convert.ToInt32(request.wheelchair));
cmd.Parameters.AddWithValue("@projector", Convert.ToInt32(request.projector));
cmd.Parameters.AddWithValue("@whiteboard", Convert.ToInt32(request.whiteboard));
cmd.Parameters.AddWithValue("@visualiser", Convert.ToInt32(request.visualiser));
cmd.Parameters.AddWithValue("@computer", Convert.ToInt32(request.computer));
cmd.Parameters.AddWithValue("@lecture_capture", Convert.ToInt32(request.lecture_capture));
cmd.Parameters.AddWithValue("@pa_system", Convert.ToInt32(request.pa_system));
cmd.Parameters.AddWithValue("@video_dvd", Convert.ToInt32(request.video_dvd));
cmd.Parameters.AddWithValue("@radio_microphone", Convert.ToInt32(request.radio_microphone));
cmd.Parameters.AddWithValue("@arrangement", request.arrangement);
cmd.Parameters.AddWithValue("@priority", Convert.ToInt32(request.priority));
cmd.Parameters.AddWithValue("@period", Convert.ToInt32(request.period));
cmd.Parameters.AddWithValue("@duration", Convert.ToInt32(request.duration));
cmd.Parameters.AddWithValue("@special_req", request.special_req1);
cmd.Parameters.AddWithValue("@day", request.day);
cmd.Parameters.AddWithValue("@status", request.status);
cmd.Parameters.AddWithValue("@park", request.park);
cmd.Parameters.AddWithValue("@semester", Convert.ToInt32(request.semester));
cmd.Parameters.AddWithValue("@lecturer", request.lecturer);
cmd.Parameters.AddWithValue("@session", request.session);
cmd.Parameters.AddWithValue("@year", request.year);
cmd.Parameters.AddWithValue("@dept", HttpContext.Current.Session["dept_code"].ToString());
cmd.Connection = con;
con.Open();
id = (int)cmd.ExecuteScalar();
con.Close();
}
}
for (int i = 0; i < week.Count; i++)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO [WEEKS] ([week], [request_id]) VALUES (@week, @request_id)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@request_id", id);
cmd.Parameters.AddWithValue("@week", week[i]);
cmd.Connection = con;
con.Open();
cmd.ExecuteScalar();
con.Close();
}
}
}
if (Convert.ToInt32(request.noRooms) > 1)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO [REQUESTS] ([module], [room_code], [capacity], [wheelchair], [projector], [visualiser], [whiteboard], [computer], [lecture_capture], [pa_system], [radio_microphone], [video_dvd], [arrangement], [special_req], [priority], [day], [period], [duration], [status], [park], [semester], [year], [lecturer], [dept_code], [session]) OUTPUT INSERTED.[request_id] VALUES (@module, @room_code, @capacity, @wheelchair, @projector, @visualiser, @whiteboard, @computer, @lecture_capture, @pa_system, @radio_microphone, @video_dvd, @arrangement, @special_req, @priority, @day, @period, @duration, @status, @park, @semester, @year, @lecturer, @dept, @session)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@module", request.module);
cmd.Parameters.AddWithValue("@room_code", request.room_code2);
cmd.Parameters.AddWithValue("@capacity", Convert.ToInt32(request.capacity2));
cmd.Parameters.AddWithValue("@wheelchair", Convert.ToInt32(request.wheelchair2));
cmd.Parameters.AddWithValue("@projector", Convert.ToInt32(request.projector2));
cmd.Parameters.AddWithValue("@whiteboard", Convert.ToInt32(request.whiteboard2));
cmd.Parameters.AddWithValue("@visualiser", Convert.ToInt32(request.visualiser2));
cmd.Parameters.AddWithValue("@computer", Convert.ToInt32(request.computer2));
cmd.Parameters.AddWithValue("@lecture_capture", Convert.ToInt32(request.lecture_capture2));
cmd.Parameters.AddWithValue("@pa_system", Convert.ToInt32(request.pa_system2));
cmd.Parameters.AddWithValue("@video_dvd", Convert.ToInt32(request.video_dvd2));
cmd.Parameters.AddWithValue("@radio_microphone", Convert.ToInt32(request.radio_microphone2));
cmd.Parameters.AddWithValue("@arrangement", request.arrangement2);
cmd.Parameters.AddWithValue("@priority", Convert.ToInt32(request.priority));
cmd.Parameters.AddWithValue("@period", Convert.ToInt32(request.period));
cmd.Parameters.AddWithValue("@duration", Convert.ToInt32(request.duration));
cmd.Parameters.AddWithValue("@special_req", request.special_req2);
cmd.Parameters.AddWithValue("@day", request.day);
cmd.Parameters.AddWithValue("@status", request.status);
cmd.Parameters.AddWithValue("@park", request.park);
cmd.Parameters.AddWithValue("@semester", Convert.ToInt32(request.semester));
cmd.Parameters.AddWithValue("@lecturer", request.lecturer);
cmd.Parameters.AddWithValue("@session", request.session);
cmd.Parameters.AddWithValue("@year", request.year);
cmd.Parameters.AddWithValue("@dept", HttpContext.Current.Session["dept_code"].ToString());
cmd.Connection = con;
con.Open();
id = (int)cmd.ExecuteScalar();
con.Close();
}
}
for (int i = 0; i < week.Count; i++)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO [WEEKS] ([week], [request_id]) VALUES (@week, @request_id)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@request_id", id);
cmd.Parameters.AddWithValue("@week", week[i]);
cmd.Connection = con;
con.Open();
cmd.ExecuteScalar();
con.Close();
}
}
}
}
if (Convert.ToInt32(request.noRooms) > 2)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO [REQUESTS] ([module], [room_code], [capacity], [wheelchair], [projector], [visualiser], [whiteboard], [computer], [lecture_capture], [pa_system], [radio_microphone], [video_dvd], [arrangement], [special_req], [priority], [day], [period], [duration], [status], [park], [semester], [year], [lecturer], [dept_code], [session]) OUTPUT INSERTED.[request_id] VALUES (@module, @room_code, @capacity, @wheelchair, @projector, @visualiser, @whiteboard, @computer, @lecture_capture, @pa_system, @radio_microphone, @video_dvd, @arrangement, @special_req, @priority, @day, @period, @duration, @status, @park, @semester, @year, @lecturer, @dept, @session)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@module", request.module);
cmd.Parameters.AddWithValue("@room_code", request.room_code3);
cmd.Parameters.AddWithValue("@capacity", Convert.ToInt32(request.capacity3));
cmd.Parameters.AddWithValue("@wheelchair", Convert.ToInt32(request.wheelchair3));
cmd.Parameters.AddWithValue("@projector", Convert.ToInt32(request.projector3));
cmd.Parameters.AddWithValue("@whiteboard", Convert.ToInt32(request.whiteboard3));
cmd.Parameters.AddWithValue("@visualiser", Convert.ToInt32(request.visualiser3));
cmd.Parameters.AddWithValue("@computer", Convert.ToInt32(request.computer3));
cmd.Parameters.AddWithValue("@lecture_capture", Convert.ToInt32(request.lecture_capture3));
cmd.Parameters.AddWithValue("@pa_system", Convert.ToInt32(request.pa_system3));
cmd.Parameters.AddWithValue("@video_dvd", Convert.ToInt32(request.video_dvd3));
cmd.Parameters.AddWithValue("@radio_microphone", Convert.ToInt32(request.radio_microphone3));
cmd.Parameters.AddWithValue("@arrangement", request.arrangement3);
cmd.Parameters.AddWithValue("@priority", Convert.ToInt32(request.priority));
cmd.Parameters.AddWithValue("@period", Convert.ToInt32(request.period));
cmd.Parameters.AddWithValue("@duration", Convert.ToInt32(request.duration));
cmd.Parameters.AddWithValue("@special_req", request.special_req3);
cmd.Parameters.AddWithValue("@day", request.day);
cmd.Parameters.AddWithValue("@status", request.status);
cmd.Parameters.AddWithValue("@park", request.park);
cmd.Parameters.AddWithValue("@semester", Convert.ToInt32(request.semester));
cmd.Parameters.AddWithValue("@lecturer", request.lecturer);
cmd.Parameters.AddWithValue("@session", request.session);
cmd.Parameters.AddWithValue("@year", request.year);
cmd.Parameters.AddWithValue("@dept", HttpContext.Current.Session["dept_code"].ToString());
cmd.Connection = con;
con.Open();
id = (int)cmd.ExecuteScalar();
con.Close();
}
}
for (int i = 0; i < week.Count; i++)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO [WEEKS] ([week], [request_id]) VALUES (@week, @request_id)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@request_id", id);
cmd.Parameters.AddWithValue("@week", week[i]);
cmd.Connection = con;
con.Open();
cmd.ExecuteScalar();
con.Close();
}
}
}
}
if (Convert.ToInt32(request.noRooms) > 3)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO [REQUESTS] ([module], [room_code], [capacity], [wheelchair], [projector], [visualiser], [whiteboard], [computer], [lecture_capture], [pa_system], [radio_microphone], [video_dvd], [arrangement], [special_req], [priority], [day], [period], [duration], [status], [park], [semester], [year], [lecturer], [dept_code], [session]) OUTPUT INSERTED.[request_id] VALUES (@module, @room_code, @capacity, @wheelchair, @projector, @visualiser, @whiteboard, @computer, @lecture_capture, @pa_system, @radio_microphone, @video_dvd, @arrangement, @special_req, @priority, @day, @period, @duration, @status, @park, @semester, @year, @lecturer, @dept, @session)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@module", request.module);
cmd.Parameters.AddWithValue("@room_code", request.room_code4);
cmd.Parameters.AddWithValue("@capacity", Convert.ToInt32(request.capacity4));
cmd.Parameters.AddWithValue("@wheelchair", Convert.ToInt32(request.wheelchair4));
cmd.Parameters.AddWithValue("@projector", Convert.ToInt32(request.projector4));
cmd.Parameters.AddWithValue("@whiteboard", Convert.ToInt32(request.whiteboard4));
cmd.Parameters.AddWithValue("@visualiser", Convert.ToInt32(request.visualiser4));
cmd.Parameters.AddWithValue("@computer", Convert.ToInt32(request.computer4));
cmd.Parameters.AddWithValue("@lecture_capture", Convert.ToInt32(request.lecture_capture4));
cmd.Parameters.AddWithValue("@pa_system", Convert.ToInt32(request.pa_system4));
cmd.Parameters.AddWithValue("@video_dvd", Convert.ToInt32(request.video_dvd4));
cmd.Parameters.AddWithValue("@radio_microphone", Convert.ToInt32(request.radio_microphone4));
cmd.Parameters.AddWithValue("@arrangement", request.arrangement4);
cmd.Parameters.AddWithValue("@priority", Convert.ToInt32(request.priority));
cmd.Parameters.AddWithValue("@period", Convert.ToInt32(request.period));
cmd.Parameters.AddWithValue("@duration", Convert.ToInt32(request.duration));
cmd.Parameters.AddWithValue("@special_req", request.special_req4);
cmd.Parameters.AddWithValue("@day", request.day);
cmd.Parameters.AddWithValue("@status", request.status);
cmd.Parameters.AddWithValue("@park", request.park);
cmd.Parameters.AddWithValue("@semester", Convert.ToInt32(request.semester));
cmd.Parameters.AddWithValue("@lecturer", request.lecturer);
cmd.Parameters.AddWithValue("@session", request.session);
cmd.Parameters.AddWithValue("@year", request.year);
cmd.Parameters.AddWithValue("@dept", HttpContext.Current.Session["dept_code"].ToString());
cmd.Connection = con;
con.Open();
id = (int)cmd.ExecuteScalar();
con.Close();
}
}
for (int i = 0; i < week.Count; i++)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO [WEEKS] ([week], [request_id]) VALUES (@week, @request_id)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@request_id", id);
cmd.Parameters.AddWithValue("@week", week[i]);
cmd.Connection = con;
con.Open();
cmd.ExecuteScalar();
con.Close();
}
}
}
}
if (Convert.ToInt32(request.noRooms) > 4)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO [REQUESTS] ([module], [room_code], [capacity], [wheelchair], [projector], [visualiser], [whiteboard], [computer], [lecture_capture], [pa_system], [radio_microphone], [video_dvd], [arrangement], [special_req], [priority], [day], [period], [duration], [status], [park], [semester], [year], [lecturer], [dept_code], [session]) OUTPUT INSERTED.[request_id] VALUES (@module, @room_code, @capacity, @wheelchair, @projector, @visualiser, @whiteboard, @computer, @lecture_capture, @pa_system, @radio_microphone, @video_dvd, @arrangement, @special_req, @priority, @day, @period, @duration, @status, @park, @semester, @year, @lecturer, @dept, @session)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@module", request.module);
cmd.Parameters.AddWithValue("@room_code", request.room_code3);
cmd.Parameters.AddWithValue("@capacity", Convert.ToInt32(request.capacity5));
cmd.Parameters.AddWithValue("@wheelchair", Convert.ToInt32(request.wheelchair5));
cmd.Parameters.AddWithValue("@projector", Convert.ToInt32(request.projector5));
cmd.Parameters.AddWithValue("@whiteboard", Convert.ToInt32(request.whiteboard5));
cmd.Parameters.AddWithValue("@visualiser", Convert.ToInt32(request.visualiser5));
cmd.Parameters.AddWithValue("@computer", Convert.ToInt32(request.computer5));
cmd.Parameters.AddWithValue("@lecture_capture", Convert.ToInt32(request.lecture_capture5));
cmd.Parameters.AddWithValue("@pa_system", Convert.ToInt32(request.pa_system5));
cmd.Parameters.AddWithValue("@video_dvd", Convert.ToInt32(request.video_dvd5));
cmd.Parameters.AddWithValue("@radio_microphone", Convert.ToInt32(request.radio_microphone5));
cmd.Parameters.AddWithValue("@arrangement", request.arrangement5);
cmd.Parameters.AddWithValue("@priority", Convert.ToInt32(request.priority));
cmd.Parameters.AddWithValue("@period", Convert.ToInt32(request.period));
cmd.Parameters.AddWithValue("@duration", Convert.ToInt32(request.duration));
cmd.Parameters.AddWithValue("@special_req", request.special_req5);
cmd.Parameters.AddWithValue("@day", request.day);
cmd.Parameters.AddWithValue("@status", request.status);
cmd.Parameters.AddWithValue("@park", request.park);
cmd.Parameters.AddWithValue("@semester", Convert.ToInt32(request.semester));
cmd.Parameters.AddWithValue("@lecturer", request.lecturer);
cmd.Parameters.AddWithValue("@session", request.session);
cmd.Parameters.AddWithValue("@year", request.year);
cmd.Parameters.AddWithValue("@dept", HttpContext.Current.Session["dept_code"].ToString());
cmd.Connection = con;
con.Open();
id = (int)cmd.ExecuteScalar();
con.Close();
}
}
for (int i = 0; i < week.Count; i++)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO [WEEKS] ([week], [request_id]) VALUES (@week, @request_id)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@request_id", id);
cmd.Parameters.AddWithValue("@week", week[i]);
cmd.Connection = con;
con.Open();
cmd.ExecuteScalar();
con.Close();
}
}
}
}
}
