public void readBenchReport(string path)
{
string temp;
this.numInBench = 0;
foreach (var worksheet in Workbook.Worksheets(@path)){
int rowNum = 0;
foreach (var row in worksheet.Rows){
Resource res = new Resource();
foreach (var cell in row.Cells){
if(cell != null){
if (cell.ColumnIndex == 9 && !String.Equals(cell.Text, "")){
System.Diagnostics.Debug.Write(cell.Text);
System.Diagnostics.Debug.WriteLine("");
temp = cell.Text;
string[] splitText = temp.Split('.');
if(rowNum != 0){
res.firstName = splitText[0];
res.lastName = splitText[splitText.Length-1];
benchReportNames.Add(res);
}
}else if (cell.ColumnIndex == 14){
if(cell.Text.Equals("In Bench")){
System.Diagnostics.Debug.WriteLine(" "+res.lastName+" "+cell.Text);
res.status = "In Bench";
numInBench++;
}else
res.status = cell.Text;
}
}//end if
}//end foreach
rowNum++;
}//end foreach
break;
}
}
private void OnInit(InitCommand command)
{
// Clear state.
processes.Clear();
readyQueue[0] = readyQueue[1] = readyQueue[2] = null;
resources.Clear();
resources["R1"] = new Resource("R1", 1);
resources["R2"] = new Resource("R2", 2);
resources["R3"] = new Resource("R3", 3);
resources["R4"] = new Resource("R4", 4);
resources["IO"] = new Resource("IO", 1);
// Start the Init process.
var init = new Process("Init", null, 0) {Status = ProcessStatus.Ready};
foreach (var resource in resources.Values)
init.HeldResources[resource.Name] = 0;
processes.Add(init.Name, init);
var readyQueueNode = new Node<Process>(init);
init.ReadyNode = readyQueueNode;
Node<Process>.AddToBack(ref readyQueue[0], readyQueueNode);
}
public void readTimeReport(string path)
{
string temp;
int rowNum = 0;
foreach (var worksheet in Workbook.Worksheets(@path)){
foreach (var row in worksheet.Rows){
foreach (var cell in row.Cells){
if(cell != null){
if(cell.ColumnIndex == 2){
System.Diagnostics.Debug.Write(cell.Text);
System.Diagnostics.Debug.WriteLine("");
temp = cell.Text;
string[] splitText = temp.Split(',');
if(rowNum != 0){
splitText[1] = splitText[1].Trim().Split(' ')[0];
Resource res = new Resource();
res.firstName = splitText[1].ToLower();
res.lastName = splitText[0].ToLower();
timeReportNames.Add(res);
System.Diagnostics.Debug.WriteLine(splitText[0]+" "+splitText[1]);
}
}//end if
}//end if
}//end foreach
rowNum++;
}//end foreach
break;
}
}
