private static ExamRoom ParseRoom(HtmlNode container, int row)
{
return(ExamRoom.Deserialize((new[] { 2, 4, 5, 6 }).Select((col) => {
var parsed = HTMLUtils.ParseHTML(container, String.Format("tr[{0}]/td[{1}]", row, col));
return parsed.FirstOrDefault()?.Replace(" ", "");
})));
}
public async Task <ExamRoom> Update(ExamRoom examRoom)
{
if (!await ExamRoomValidator.Update(examRoom))
{
return(examRoom);
}
using (UOW.Begin())
{
try
{
await UOW.ExamRoomRepository.Update(examRoom);
await UOW.Commit();
return(await UOW.ExamRoomRepository.Get(examRoom.Id));
}
catch (Exception e)
{
await UOW.Rollback();
examRoom.AddError(nameof(ExamRoomService), nameof(Update), CommonEnum.ErrorCode.SystemError);
return(examRoom);
}
}
}
public async Task <bool> Create(ExamRoom examRoom)
{
ExamRoomDAO examRoomDAO = examRegContext.ExamRoom.Where(e => e.Id.Equals(examRoom.Id)).FirstOrDefault();
if (examRoomDAO == null)
{
examRoomDAO = new ExamRoomDAO()
{
Id = examRoom.Id,
AmphitheaterName = examRoom.AmphitheaterName,
ComputerNumber = examRoom.ComputerNumber,
RoomNumber = examRoom.RoomNumber
};
await examRegContext.ExamRoom.AddAsync(examRoomDAO);
}
else
{
examRoomDAO.Id = examRoom.Id;
examRoomDAO.AmphitheaterName = examRoom.AmphitheaterName;
examRoomDAO.ComputerNumber = examRoom.ComputerNumber;
examRoomDAO.RoomNumber = examRoom.RoomNumber;
};
await examRegContext.SaveChangesAsync();
return(true);
}
/*
* Lấy danh sách phòng thi từ sql server
*/
public List <ExamRoom> GetExamRooms(string examlocation, int examorder, out string out_mess)
{
out_mess = "";
List <ExamRoom> data = new List <ExamRoom>();
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("SHOW_EXAM_ROOM", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@IN_EXAM_LOCATION", SqlDbType.NVarChar, 50);
cmd.Parameters["@IN_EXAM_LOCATION"].Value = examlocation;
cmd.Parameters.Add("@IN_EXAM_ORDER", SqlDbType.Int);
cmd.Parameters["@IN_EXAM_ORDER"].Value = examorder;
cmd.Parameters.Add("@OUT_MESSAGE", SqlDbType.NVarChar, 50).Direction = ParameterDirection.Output;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string x = reader[1].ToString();
x = x.ToString();
var erb = new ExamRoom(Convert.ToInt32(reader[0]), x, Convert.ToInt32(reader[2]), Convert.ToInt32(reader[3]));
data.Add(erb);
}
}
catch (Exception ex)
{
out_mess = ex.Message;
return(null);
}
return(data);
}
public async Task <bool> Delete(ExamRoom examRoom)
{
bool IsValid = true;
IsValid &= await ValidateId(examRoom);
return(IsValid);
}
/// <summary>
/// Return the Exam Room I am part of.
/// <param name="e"> Exam Room to set or nothing to retrieve.</param>
/// </summary>
public ExamRoom MyExamRoom(ExamRoom e = null)
{
if (e)
{
er = e;
}
return er;
}
public async Task <bool> Update(ExamRoom examRoom)
{
bool IsValid = true;
IsValid &= await ValidateId(examRoom);
IsValid &= ValidateStringLength(examRoom);
return(IsValid);
}
public void Seat_nominal()
{
var examRoom = new ExamRoom(10);
Assert.Equal(0, examRoom.Seat());
Assert.Equal(9, examRoom.Seat());
Assert.Equal(4, examRoom.Seat());
Assert.Equal(6, examRoom.Seat());
}
private void LoadFromModel(ExamRoom model)
{
RoomId = model.RoomId;
Columns = model.Columns;
Rows = model.Rows;
if (model.Room != null)
{
Room = new RoomModel(model.Room);
}
}
public async Task <bool> Update(ExamRoom examRoom)
{
await examRegContext.ExamRoom.Where(e => e.Id.Equals(examRoom.Id)).UpdateFromQueryAsync(e => new ExamRoomDAO()
{
AmphitheaterName = examRoom.AmphitheaterName,
ComputerNumber = examRoom.ComputerNumber,
RoomNumber = examRoom.RoomNumber
});
return(true);
}
public void Test1()
{
var r = new ExamRoom(10);
r.Seat().Should().Be(0);
r.Seat().Should().Be(9);
r.Seat().Should().Be(4);
r.Seat().Should().Be(2);
r.Leave(4);
r.Seat().Should().Be(5);
}
public void Test_case_0()
{
var examRoom = new ExamRoom(10);
Assert.Equal(0, examRoom.Seat());
Assert.Equal(9, examRoom.Seat());
Assert.Equal(4, examRoom.Seat());
Assert.Equal(2, examRoom.Seat());
examRoom.Leave(4);
Assert.Equal(5, examRoom.Seat());
}
public void Leave_nominal()
{
var examRoom = new ExamRoom(10);
Assert.Equal(0, examRoom.Seat());
Assert.Equal(9, examRoom.Seat());
Assert.Equal(4, examRoom.Seat());
Assert.Equal(6, examRoom.Seat());
examRoom.Leave(4);
Assert.Equal(3, examRoom.Seat());
}
public void Leave_at_boundaries()
{
var examRoom = new ExamRoom(10);
Assert.Equal(0, examRoom.Seat());
Assert.Equal(9, examRoom.Seat());
Assert.Equal(4, examRoom.Seat());
Assert.Equal(6, examRoom.Seat());
examRoom.Leave(0);
Assert.Equal(0, examRoom.Seat());
examRoom.Leave(9);
examRoom.Leave(6);
Assert.Equal(9, examRoom.Seat());
}
public PrepNeeView(ExamSlot sl)
{
mSlDB = sl;
Header = mSlDB.Dt.ToString(DT.hh);
Name = "_" + (Header as string).Replace(':', '_');
mSlTmp = new ExamSlot();
mSlTmp.Dt = mSlDB.Dt;
foreach (ExamRoom rom in mSlDB.vRoom.Values)
{
if (!mSlTmp.vRoom.ContainsKey(rom.uId))
{
ExamRoom r = new ExamRoom();
r.uId = rom.uId;
mSlTmp.vRoom.Add(r.uId, r);
}
}
}
protected void ListBox_Rooms_SelectedIndexChanged(object sender, EventArgs e)
{
int n = 0;
ListBox lb = (ListBox)sender;
int nmax = (int)ViewState["MaxDesksRequired"];
foreach (ListItem l in lb.Items)
{
if (l.Selected)
{
ExamRoom er = new ExamRoom(); er.Load(new Guid(l.Value));
n += er.m_capacity;
}
}
Label_RoomsAllcation.Text = "Allocated : " + n.ToString() + " Needed: " + nmax.ToString();
SetupRulesBoxesRooms();
}
public async Task <ExamRoomDTO> Delete([FromBody] ExamRoomDTO examRoomRequestDTO)
{
ExamRoom examRoom = new ExamRoom
{
Id = examRoomRequestDTO.Id
};
ExamRoom res = await ExamRoomService.Delete(examRoom);
return(new ExamRoomDTO
{
Id = res.Id,
Code = res.Code,
RoomNumber = res.RoomNumber,
AmphitheaterName = res.AmphitheaterName,
ComputerNumber = res.ComputerNumber,
Errors = res.Errors
});
}
/*private async Task<bool> ValidateExist(ExamRoom examRoom)
* {
* ExamRoomFilter filter = new ExamRoomFilter
* {
* Take = Int32.MaxValue,
* RoomNumber = new ShortFilter { Equal = examRoom.RoomNumber },
* AmphitheaterName = new StringFilter { Equal = examRoom.AmphitheaterName }
* };
*
* int count = await UOW.ExamRoomRepository.Count(filter);
* if (count == 0)
* {
* examRoom.AddError(nameof(ExamRoomValidator), nameof(examRoom), ERROR.NotExisted);
* return false;
* }
* return true;
* }*/
public async Task <bool> ValidateId(ExamRoom examRoom)
{
ExamRoomFilter filter = new ExamRoomFilter
{
Id = new GuidFilter {
Equal = examRoom.Id
}
};
int count = await UOW.ExamRoomRepository.Count(filter);
if (count == 0)
{
examRoom.AddError(nameof(ExamRoomValidator), nameof(examRoom), ERROR.IdNotFound);
}
return(count == 1);
}
private async Task <bool> ValidateNotExist(ExamRoom examRoom)
{
ExamRoomFilter filter = new ExamRoomFilter
{
Take = Int32.MaxValue,
RoomNumber = new ShortFilter {
Equal = examRoom.RoomNumber
},
AmphitheaterName = new StringFilter {
Equal = examRoom.AmphitheaterName
}
};
int count = await UOW.ExamRoomRepository.Count(filter);
if (count > 0)
{
examRoom.AddError(nameof(ExamRoomValidator), nameof(examRoom), ERROR.ExamRoomExisted);
return(false);
}
return(true);
}
private bool ValidateStringLength(ExamRoom examRoom)
{
if (examRoom.RoomNumber < 0)
{
examRoom.AddError(nameof(ExamRoomValidator), nameof(examRoom), ERROR.RoomNumberInvalid);
return(false);
}
if (examRoom.ComputerNumber <= 0)
{
examRoom.AddError(nameof(ExamRoomValidator), nameof(examRoom), ERROR.ComputerNumberInvalid);
return(false);
}
if (string.IsNullOrEmpty(examRoom.AmphitheaterName))
{
examRoom.AddError(nameof(ExamRoomValidator), nameof(examRoom), ERROR.AmphitheaterNameEmpty);
return(false);
}
else if (examRoom.AmphitheaterName.Length > 100)
{
examRoom.AddError(nameof(ExamRoomValidator), nameof(examRoom), ERROR.AmphitheaterNameInvalid);
return(false);
}
return(true);
}
protected bool AllocateDesksRoom(Guid roomid, DateTime t1, DateTime t2, ref string ErrorS)
{
ScheduledComponentList scl2 = new ScheduledComponentList();
scl2.LoadList_Room(t1, t2, roomid, " ORDER BY DateTime ASC, TimeAllowed DESC, ComponentId DESC, StudentExamNumber ASC");
if (scl2.m_List.Count == 0)
{
return(true);
}
ExamRoom exr1 = new ExamRoom(); exr1.Load(roomid);
SimpleRoom room1 = new SimpleRoom(); room1.Load(roomid.ToString());
ScheduledComponentList scl3 = new ScheduledComponentList();//used to check room empty below
string s = ""; bool found = false;
int column = 1; int desk = 1; int desk_inc = 1;
DateTime time_last = new DateTime(2000, 1, 1);
DateTime time_first = new DateTime(2000, 1, 1);
bool room_full = false;
int no_components = 1;
ScheduledComponent scX = new ScheduledComponent();
scX = (ScheduledComponent)scl2.m_List[0];
foreach (ScheduledComponent sc in scl2.m_List)
{
if (scX.m_ComponentId != sc.m_ComponentId)
{
scX = sc; no_components++;
}
}
int Free_space_min = (exr1.m_capacity - scl2.m_List.Count) / no_components;
//when we enter no deska allocated to this room so exr1.m_capacity is capacity
//if we have n students and m components and (capacity -n)> m then we can try to insert gaps...
// n< scl2.count ( might have later components...
scX = (ScheduledComponent)scl2.m_List[0];
foreach (ScheduledComponent sc in scl2.m_List)
{
if (scX.m_ComponentId != sc.m_ComponentId)
{
//new component...
scX = sc;
//if space insert blamk row
if ((exr1.columns[column].count < Free_space_min) && (CheckBox1.Checked))
{
desk = 1; column++; column++;
}
}
if ((sc.m_Date > time_last) && ((column != 1) || (desk != 1)))
{
scl3.LoadList_Room(sc.m_Date.AddMinutes(-10), sc.m_Date, roomid, "");
if (scl3.m_List.Count == 0)
{
//DialogResult d = MessageBox.Show("It looks as if we can reset the desk alocations at " + sc.m_Date.ToShortTimeString() + ". Are you sure you wna to do this... ie do we have two separate internal exmas in the same session?", "Warning while rooming " + room1.m_roomcode, MessageBoxButtons.YesNo);
//if (d == DialogResult.Yes)
{
column = 1; desk = 1; desk_inc = 1;
time_last = sc.m_Date.AddMinutes(sc.m_TimeAllowed);
time_first = sc.m_Date.AddMinutes(-1);
}
}
}
if (sc.m_Date.AddMinutes(sc.m_TimeAllowed) > time_last)
{
time_last = sc.m_Date.AddMinutes(sc.m_TimeAllowed);
}
//assign the lad a desk.....
//unless he already has one!!!!
found = false;
s = exr1.columns[column].name + desk.ToString();
foreach (ScheduledComponent sc1 in scl2.m_List)
{
if ((sc1.m_StudentId == sc.m_StudentId) && (sc1.m_Date > time_first))
{
if (sc1.m_Desk != "")
{
s = sc1.m_Desk; found = true; break;//he already had one
}
}
}
sc.m_Desk = s;
if (!found)
{//we have added one....
if (room_full)
{
ErrorS = "Room capacity exceeded....." + sc.m_ExamNumber.ToString() + ":" + sc.m_Surname + " " + sc.m_Givenname + "..." + sc.m_ComponentTitle;
return(false);
}
desk = desk + desk_inc;
if (desk > exr1.columns[column].count)
{
column++;
desk = exr1.columns[column].count;
desk_inc = desk_inc * (-1);
}
if (desk < 1)
{
desk_inc = desk_inc * (-1);
desk = 1;
column++;
}
}
sc.Save();
//check if we have exceeded capacity!
if (column > exr1.no_columns + 1)
{
room_full = true;
}
}
return(true);
}
protected void Button_Assign_Click(object sender, EventArgs e)
{
//now we are actually going to do it???
string ErrorS = "Success!";
bool Is_AM = (bool)ViewState["Session_is_AM"];
DateTime t0 = new DateTime();
t0 = (DateTime)ViewState["EditDate"];
DateTime t1 = new DateTime();
DateTime t2 = new DateTime();
t1 = (Is_AM) ? t0.AddHours(8) : t0.AddHours(13);
t2 = (Is_AM) ? t0.AddHours(13) : t0.AddHours(18);
DateTime time_last = new DateTime();
List <Guid> Rooms = new List <Guid>();
ListBox lb = ListBox_Rooms;
foreach (ListItem l in lb.Items)
{
if (l.Selected)
{
Rooms.Add(new Guid(l.Value));
}
}
//if no rooms allocated flag error
if (Rooms.Count == 0)
{
ErrorS = "...you haven't allocated Any rooms";
goto ErrorExit;
}
ExamsUtility eu = new ExamsUtility();
eu.ClearDeskAssignments(t1, t2);
//ought to clear all room allocations first...
//ought to do this by query
int n = 0;
ExamsUtility u = new ExamsUtility();
u.ClearRoomAssignments(t1, t2);
ExamRoom er = new ExamRoom();
n = 0;
List <int> Room_Capacity = new List <int>();
foreach (Guid d in Rooms)
{
er.Load(d);
Room_Capacity.Add(er.m_capacity);
n++;
}
int nmax = n - 1;
ScheduledComponentList scl1 = new ScheduledComponentList();
scl1.LoadList_Date(t1, t2); //order by DateTime
time_last = ((ScheduledComponent)scl1.m_List[0]).m_Date;
string s = GetQueryStringDay(t0.Year, t0.Month, t0.Day); // gets from sc ordered by datetime,NUMBER
List <Guid> Components = new List <Guid>();
List <int> number = new List <int>();
List <DateTime> Start_Time = new List <DateTime>();
Encode en = new Encode();
string db_connection = en.GetDbConnection();
using (SqlConnection cn = new SqlConnection(db_connection))
{
cn.Open();
using (SqlCommand cm = new SqlCommand(s, cn))
{
using (SqlDataReader dr = cm.ExecuteReader())
{
while (dr.Read())
{
Components.Add(dr.GetGuid(1));
number.Add(dr.GetInt32(4));
Start_Time.Add(dr.GetDateTime(3));
}
dr.Close();
}
}
cn.Close();
}
//first apply rules... hopefully these will fit ... if not flag error back to ui
int CurrentRoomCapacity = 0;
string s_rule = DropDownList_Rule1Source.SelectedItem.Text;
Guid rule_roomId = new Guid(DropDownList_Rule1Room.SelectedValue);
n = 0; foreach (Guid d in Rooms)
{
if (d == rule_roomId)
{
CurrentRoomCapacity = Room_Capacity[n]; break;
}
}
if (!Apply_Rule(s_rule, rule_roomId, scl1, ref ErrorS, Components, number, ref CurrentRoomCapacity))
{
goto ErrorExit;
}
Room_Capacity[n] = CurrentRoomCapacity;
if ((s_rule != "None") && (CheckBox1.Checked))
{
Rooms.Remove(rule_roomId); nmax--;
}
s_rule = DropDownList_Rule2Source.SelectedItem.Text;
rule_roomId = new Guid(DropDownList_Rule2Room.SelectedValue);
n = 0; foreach (Guid d in Rooms)
{
if (d == rule_roomId)
{
CurrentRoomCapacity = Room_Capacity[n]; break;
}
}
if (!Apply_Rule(s_rule, rule_roomId, scl1, ref ErrorS, Components, number, ref CurrentRoomCapacity))
{
goto ErrorExit;
}
if ((s_rule != "None") && (CheckBox2.Checked))
{
Rooms.Remove(rule_roomId); nmax--;
}
Room_Capacity[n] = CurrentRoomCapacity;
s_rule = DropDownList_Rule3Source.SelectedItem.Text;
rule_roomId = new Guid(DropDownList_Rule3Room.SelectedValue);
n = 0; foreach (Guid d in Rooms)
{
if (d == rule_roomId)
{
CurrentRoomCapacity = Room_Capacity[n]; break;
}
}
if (!Apply_Rule(s_rule, rule_roomId, scl1, ref ErrorS, Components, number, ref CurrentRoomCapacity))
{
goto ErrorExit;
}
if ((s_rule != "None") && (CheckBox3.Checked))
{
Rooms.Remove(rule_roomId); nmax--;
}
Room_Capacity[n] = CurrentRoomCapacity;
s_rule = DropDownList_Rule4Source.SelectedItem.Text;
rule_roomId = new Guid(DropDownList_Rule4Room.SelectedValue);
n = 0; foreach (Guid d in Rooms)
{
if (d == rule_roomId)
{
CurrentRoomCapacity = Room_Capacity[n]; break;
}
}
if (!Apply_Rule(s_rule, rule_roomId, scl1, ref ErrorS, Components, number, ref CurrentRoomCapacity))
{
goto ErrorExit;
}
if ((s_rule != "None") && (CheckBox4.Checked))
{
Rooms.Remove(rule_roomId); nmax--;
}
Room_Capacity[n] = CurrentRoomCapacity;
s_rule = DropDownList_Rule5Source.SelectedItem.Text;
rule_roomId = new Guid(DropDownList_Rule5Room.SelectedValue);
n = 0; foreach (Guid d in Rooms)
{
if (d == rule_roomId)
{
CurrentRoomCapacity = Room_Capacity[n]; break;
}
}
if (!Apply_Rule(s_rule, rule_roomId, scl1, ref ErrorS, Components, number, ref CurrentRoomCapacity))
{
goto ErrorExit;
}
if ((s_rule != "None") && (CheckBox5.Checked))
{
Rooms.Remove(rule_roomId); nmax--;
}
Room_Capacity[n] = CurrentRoomCapacity;
ScheduledComponentList scl2 = new ScheduledComponentList();
foreach (ScheduledComponent c in scl1.m_List)
{
if (c.m_RoomId == Guid.Empty)
{
scl2.m_List.Add(c);
}
}
//now we apply the rest
//idea is we find the sc with most students.... and put into biggest room first
//first correct room capacity?
n = 0;
// well i think we have all the information....
//going to assign biggest exam to biggest room first
int index = 0;
foreach (Guid d in Components)
{
//so new component....
//if there is a complete gap before we start this component we can clear room allocations....
//find the first (earliest) scheduled component
foreach (ScheduledComponent c in scl2.m_List)
{
if (c.m_ComponentId == d)
{
if (c.m_RoomId == Guid.Empty)
{
if (c.m_Date > time_last.AddMinutes(10))
{
//so this one starts at least 10 minutes after all sofar have finished....
time_last = c.m_Date.AddMinutes(c.m_TimeAllowed);
//so can reset rooms..... ie back to full capacity?
Room_Capacity.Clear(); n = 0;
foreach (Guid d1 in Rooms)
{
er.Load(d1);
Room_Capacity.Add(er.m_capacity);
n++;
}
nmax = n - 1;
}
}
}
}
n = 0;
while ((Room_Capacity[n] == 0) && (n <= nmax))
{
n++;
}
if (n > nmax)
{
ErrorS = "Ran out of room capacity !!"; goto ErrorExit;
}
//going to check if next one will fit in any room we have available... if so use it! search smallest first?
for (int i = nmax; i >= 0; i--)
{
if (Room_Capacity[i] >= number[index])
{
n = i; break;
}
}
foreach (ScheduledComponent c in scl2.m_List)
{
if (c.m_ComponentId == d)
{
if (c.m_RoomId == Guid.Empty)
{
if (c.m_Date.AddMinutes(c.m_TimeAllowed) > time_last)
{
time_last = c.m_Date.AddMinutes(c.m_TimeAllowed);
}
//really ought to check to see if he has any other componets in this session and assign the same room/...
foreach (ScheduledComponent c1 in scl1.m_List)
{
if (c1.m_StudentId == c.m_StudentId)
{
c.m_RoomId = c1.m_RoomId;
}
}
if (c.m_RoomId == Guid.Empty)
{
c.m_RoomId = Rooms[n];
Room_Capacity[n]--;
}
c.Save();
foreach (ScheduledComponent c1 in scl2.m_List)
{
if ((c1.m_StudentId == c.m_StudentId) && (c1.m_RoomId == Guid.Empty))
{
c.m_RoomId = Rooms[n];
c.Save();
//Room_Capacity[n]--; should already have cleared clashes
}
}
}
}
while ((Room_Capacity[n] == 0) && (n < nmax))
{
n++;
}
if (n > nmax)
{
ErrorS = "Ran out of room capacity !!"; goto ErrorExit;
}
}
index++;
}
//check??
//success; open the summary panel
Panel_left1.Visible = false; Panel_right1.Visible = false;
Label_message.Text = "Rooms Allocated Successfully.";
Label_message.Visible = true;
SqlDataSource3.SelectCommand = GetQueryStringRoomSummary(t1, t2, true);
SqlDataSource3.ConnectionString = en.GetDbConnection();
SqlDataSource3.DataBind();
return;
ErrorExit : Label_message.Text = ErrorS;
Label_message.BackColor = System.Drawing.Color.Red;
return;
}
protected bool Apply_Rule(string rule, Guid rule_roomId, ScheduledComponentList scl1, ref string ErrorS, List <Guid> Components, List <int> number, ref int RoomCapacity)
{
int n = 0;
ExamRoom er = new ExamRoom();
switch (rule)
{
case "None": break;
case "ExtraTime":
n = 0;
ExamComponent ec1 = new ExamComponent(); int time1 = 0;
foreach (ScheduledComponent c in scl1.m_List)
{
ec1.Load(c.m_ComponentId); time1 = Convert.ToInt32(ec1.m_Time);
if ((c.m_TimeAllowed > time1) && (c.m_RoomId == Guid.Empty))
{
n++;
}
}
er.Load(rule_roomId);
if (n > er.m_capacity)
{
ErrorS = "Rule" + rule + " Exceeds capacity in" + DropDownList_Rule1Room.Text; return(false);
}
foreach (ScheduledComponent c in scl1.m_List)
{
ec1.Load(c.m_ComponentId); time1 = Convert.ToInt32(ec1.m_Time);
if ((c.m_TimeAllowed > time1) && (c.m_RoomId == Guid.Empty))
{
c.m_RoomId = rule_roomId;
c.Save(); n = 0; RoomCapacity--;
foreach (Guid d in Components)
{
if (d == c.m_ComponentId)
{
number[n]--;
}
n++;
}
}
}
break;
case "Typists":
n = 0;
foreach (ScheduledComponent c in scl1.m_List)
{
if ((c.m_Will_Type) && (c.m_RoomId == Guid.Empty))
{
n++;
}
}
er.Load(rule_roomId);
if (n > er.m_capacity)
{
ErrorS = "Rule" + rule + " Exceeds capacity in" + DropDownList_Rule1Room.Text; return(false);
}
foreach (ScheduledComponent c in scl1.m_List)
{
if ((c.m_Will_Type) && (c.m_RoomId == Guid.Empty))
{
c.m_RoomId = rule_roomId;
c.Save(); n = 0; RoomCapacity--;
foreach (Guid d in Components)
{
if (d == c.m_ComponentId)
{
number[n]--;
}
n++;
}
}
}
break;
default:
//it is a rule based on a component
foreach (ScheduledComponent c in scl1.m_List)
{
if ((c.m_ComponentCode == rule) && (c.m_RoomId == Guid.Empty))
{
n++;
}
}
er.Load(rule_roomId);
if (n > er.m_capacity)
{
ErrorS = "Rule" + rule + " Exceeds capacity in" + DropDownList_Rule1Room.Text; return(false);
}
foreach (ScheduledComponent c in scl1.m_List)
{
if ((c.m_ComponentCode == rule) && (c.m_RoomId == Guid.Empty))
{
c.m_RoomId = rule_roomId;
c.Save(); n = 0; RoomCapacity--;
foreach (Guid d in Components)
{
if (d == c.m_ComponentId)
{
number[n]--;
}
n++;
}
}
}
break;
}
ErrorS += "Success_Rule1";
return(true);
}
private void UpdateDeskGrid()
{
DateTime t1 = System.Convert.ToDateTime(DropDownListDeskTimes.SelectedValue);
string s1 = "";
string dateS = Request.QueryString["Date"];
DateTime t0 = new DateTime();
string sess = Request.QueryString["Session"];
bool Is_AM = true;
try
{
t0 = Convert.ToDateTime(Request.QueryString["Date"]);
if (sess.Contains("PM"))
{
Is_AM = false;
}
ViewState["Session_is_AM"] = Is_AM;
ViewState["EditDate"] = t0;
}
catch
{
//try to get from session state?
Is_AM = (bool)ViewState["Session_is_AM"];
t0 = (DateTime)ViewState["EditDate"];
}
DateTime t2 = new DateTime();
t2 = (Is_AM) ? t0.AddHours(13) : t0.AddHours(18);
System.Drawing.Color[] cell_colours = GetColors();
Guid[] papers = new Guid[10]; string[] paper_title = new string[10];
string s = "";
int no_papers = 0;
bool found = false;
Label_DeskDate.Text = t1.ToLongDateString();
ScheduledComponentList scl2 = new ScheduledComponentList(); scl2.LoadList(t0, t2);
scl2.LoadList_orderbyComponent(t0, t2);
//need to restrict to those current
ScheduledComponentList scl1 = new ScheduledComponentList();
foreach (ScheduledComponent sc in scl2.m_List)
{
if (sc.m_Date.AddMinutes(sc.m_TimeAllowed) > t1)
{
scl1.m_List.Add(sc);
}
}
t0 = System.Convert.ToDateTime(DropDownListDeskTimes.SelectedValue);
TableDeskView.Rows.Clear();
Guid Current_Room = new Guid();
Current_Room = new Guid(DropDownListDeskRooms.SelectedValue);
if (Current_Room == Guid.Empty)
{
return;
}
ExamRoom exr1 = new ExamRoom(); exr1.Load(Current_Room);
int nrows = 0; int ncols = 0;
foreach (ExamColumn ec in exr1.columns)
{
if (ec.count > nrows)
{
nrows = ec.count;
}
}
TableDeskView.CssClass = "EventsTable";
TableRow r0 = new TableRow();
TableDeskView.Rows.Add(r0);
TableCell c3 = new TableCell(); r0.Cells.Add(c3); ncols++;
foreach (ExamColumn ec in exr1.columns)
{
if (ec.count > 0)
{
TableCell c = new TableCell();
c.Width = 40; c.Text = ec.name;//header row
r0.Cells.Add(c); ncols++;
}
}
TableCell c4 = new TableCell(); r0.Cells.Add(c4);
TableCell c2 = new TableCell();
r0.Cells.Add(c2);
c2.Text = "Colour Code for Papers";
c2.Width = 200;
//for (int i = 0; i < nrows; i++)
for (int i = nrows - 1; i > -1; i--)
{
TableRow r = new TableRow();
TableDeskView.Rows.Add(r);
TableCell c1 = new TableCell(); c1.Text = (i + 1).ToString(); r.Cells.Add(c1);
c1.Width = 40; c1.BackColor = System.Drawing.Color.LightGray;
foreach (ExamColumn ec in exr1.columns)
{
if (ec.count > 0)
{
TableCell c = new TableCell();
c.Width = 40; c.Text = "";
r.Cells.Add(c);
}
}
TableCell c5 = new TableCell(); r.Cells.Add(c5); c5.Width = 40;
TableCell c6 = new TableCell(); r.Cells.Add(c6); c6.Width = 40;
}
t0 = t0.AddMinutes(2);
try
{
s1 = TableDeskView.Rows[1].Cells[1].Text;
}
catch { }
foreach (ScheduledComponent sc in scl1.m_List)
{
if ((Current_Room == sc.m_RoomId))
{
if ((sc.m_Date < t0) && (sc.m_Date.AddMinutes(sc.m_TimeAllowed) > t0))
{
s = sc.m_Desk;
if ((s != "") && (s != null))
{
int col = 0;
foreach (TableCell tc in TableDeskView.Rows[0].Cells)
{
if (tc.Text == s.Substring(0, 1))
{
col = TableDeskView.Rows[0].Cells.GetCellIndex(tc);
break;
}
}
int row = System.Convert.ToInt32(s.Substring(1));
row = nrows + 1 - row;
TableDeskView.Rows[row].Cells[col].Text = sc.m_ExamNumber.ToString();
found = false;
for (int i = 0; i < no_papers; i++)
{
if (papers[i] == sc.m_ComponentId)
{
found = true;
TableDeskView.Rows[row].Cells[col].BackColor = cell_colours[i];
}
}
if (!found)
{
no_papers++;
papers[no_papers - 1] = sc.m_ComponentId;
TableDeskView.Rows[row].Cells[col].BackColor = cell_colours[no_papers - 1];
paper_title[no_papers - 1] = sc.m_ComponentCode + ":" + sc.m_ComponentTitle;
}
}
}
}
}
for (int i = 0; i < no_papers; i++)
{
TableDeskView.Rows[i + 1].Cells[ncols + 1].Text = paper_title[i];
TableDeskView.Rows[i + 1].Cells[ncols + 1].BackColor = cell_colours[i];
}
}
public ExamRoomModel(ExamRoom model) : base(model)
{
LoadFromModel(model);
}
