public bool RequestClassRoom(int groupId, int groupSize, bool whiteboard, bool monitor, bool projector)
{
bool didRequest = false;
using (var con = new DBCon())
{
int whiteboardInt = 0, monitorInt = 0, projectorInt = 0;
if (whiteboard)
{
whiteboardInt = 1;
}
if (monitor)
{
monitorInt = 1;
}
if (projector)
{
projectorInt = 1;
}
string exString = string.Format("INSERT INTO ClassRoomWaitingList(groupId, size, whiteboard, monitor, projector) VALUES ({0}, {1}, {2}, {3}, {4});", groupId, groupSize, whiteboardInt, monitorInt, projectorInt);
didRequest = con.ExecuteStringPut(exString);
}
return(didRequest);
}
public bool CreateGroupRoom(string name, bool whiteboard, bool monitor)
{
bool didCreate = false;
using (var con = new DBCon())
{
string bitWhiteboard = "0";
string bitMonitor = "0";
if (whiteboard)
{
bitWhiteboard = "1";
}
if (monitor)
{
bitMonitor = "1";
}
String command = string.Format(
"insert into GroupRoom (name, whiteboard, monitor) VALUES ('{0}', {1}, {2});",
name, bitWhiteboard, bitMonitor);
didCreate = con.ExecuteStringPut(command);
}
return(didCreate);
}
public bool CreateGroup(string name, List <int> studentId)
{
int groupId = 0;
int groupSize = studentId.Count();
bool done = false;
using (var con = new DBCon())
{
SqlDataReader rs = con.ExecuteStringGet("INSERT INTO [Group] (name, size) OUTPUT Inserted.id VALUES('" + name + "', '" + groupSize + "');");
while (rs.Read())
{
groupId = (int)rs.GetValue(0);
done = true;
}
}
using (var con = new DBCon())
{
foreach (int id in studentId)
{
done = con.ExecuteStringPut("UPDATE Student SET groupId = " + groupId + " WHERE id = " + id + ";");
}
}
return(done);
}
public bool ClearRents()
{
bool didClear = false;
using (var con = new DBCon())
{
string sqlCmd = "DELETE FROM Rent WHERE ClassRoomId is not null";
didClear = con.ExecuteStringPut(sqlCmd);
}
return(didClear);
}
internal bool UpdateGroupRoom(string name, bool whiteboard, bool monitor)
{
bool didUpdate = false;
using (var con = new DBCon())
{
int whiteboardBit = 0;
int monitorBit = 0;
if (whiteboard)
{
whiteboardBit = 1;
}
if (monitor)
{
monitorBit = 1;
}
string sqlCommand = string.Format("UPDATE GroupRoom SET whiteboard={0}, monitor={1} WHERE name='{2}'", whiteboardBit, monitorBit, name);
didUpdate = con.ExecuteStringPut(sqlCommand);
}
return(didUpdate);
}