/// <summary>
/// Loads and Excel spreadsheet with the items list
/// </summary>
public void LoadItemList()
{
OpenExcel();
int rowCount = 25;
int colCount = 25;
int roomnumber = -1;
var currentRoom = new RoomVM(null, 0);
for (int row = 0; row < rowCount; row++)
{
// Import job information
if (WorkSheet.Cells[row, 1] == "Job")
{
ViewModel.Job.SetProperty(WorkSheet.Cells[row, 2], WorkSheet.Cells[row, 3]);
}
if (WorkSheet.Cells[row, 1] == "Room")
{
roomnumber++;
ViewModel.AddRoom(WorkSheet.Cells[row, 3]);
currentRoom = ViewModel.Rooms[roomnumber];
}
if (WorkSheet.Cells[row, 1] == "Strip")
{
var strip = new Strip
{
RoomNumber = roomnumber,
Color = WorkSheet.Cells[row, COLOR_COL],
Length = WorkSheet.Cells[row, LENGTH_COL]
};
currentRoom.StripViewModel.AddStrip(strip);
}
}
CloseExcel();
}
public void AddRoomToJob()
{
room = job.AddRoom();
}
public void Execute(object parameter)
{
ViewModel.AddRoom();
}
public JobVM Load()
{
DataSet = new DataSet(DataSetName);
DataSet.ReadXml("Tyler Holstead.xml");
JobData = DataSet.Tables[JobDataName];
RoomData = DataSet.Tables[RoomDataName];
StripData = DataSet.Tables[StripDataName];
PanelData = DataSet.Tables[PanelDataName];
ShelfData = DataSet.Tables[ShelfDataName];
AccessoryData = DataSet.Tables[AccessoryDataName];
var newJob = new JobVM();
//===================================
// Import Job Information
//===================================
var job = new Job();
foreach (DataColumn propertyName in JobData.Columns)
{
var propertyValue = JobData.Rows[0][propertyName].ToString();
job.SetProperty(propertyName.ColumnName, propertyValue);
}
newJob.Job = job;
//===================================
// Import Room Information
//===================================
if (RoomData != null)
{
for (int row = 0; row < RoomData.Rows.Count; row++)
{
newJob.AddRoom();
RoomVM roomvm = newJob.Rooms[row];
foreach (string propertyName in roomvm.Room.Properties)
{
if (RoomData.Columns[propertyName] != null)
{
roomvm.Room.SetProperty(propertyName, RoomData.Rows[row][propertyName].ToString());
}
}
}
}
//===================================
// Import Strip Information
//===================================
if (PanelData != null)
{
for (int row = 0; row < StripData.Rows.Count; row++)
{
var strip = new Strip();
foreach (string propertyName in strip.Properties)
{
strip.SetProperty(propertyName, StripData.Rows[row][propertyName].ToString());
}
foreach (RoomVM roomvm in newJob.Rooms)
{
if (roomvm.Room.RoomNumber == strip.RoomNumber)
{
roomvm.StripViewModel.AddStrip(strip);
}
}
}
}
//===================================
// Import Panel Information
//===================================
if (PanelData != null)
{
for (int row = 0; row < PanelData.Rows.Count; row++)
{
var panel = new Panel();
foreach (string propertyName in panel.Properties)
{
panel.SetProperty(propertyName, PanelData.Rows[row][propertyName].ToString());
}
foreach (RoomVM roomvm in newJob.Rooms)
{
if (roomvm.Room.RoomNumber == panel.RoomNumber)
{
roomvm.PanelViewModel.Add(panel);
}
}
}
}
//===================================
// Import Shelf Information
//===================================
if (ShelfData != null)
{
for (int row = 0; row < ShelfData.Rows.Count; row++)
{
var shelf = new Shelf();
foreach (string propertyName in shelf.Properties)
{
if (ShelfData.Columns[propertyName] != null)
{
shelf.SetProperty(propertyName, ShelfData.Rows[row][propertyName].ToString());
}
}
foreach (RoomVM roomvm in newJob.Rooms)
{
if (roomvm.Room.RoomNumber == shelf.RoomNumber)
{
roomvm.ShelfViewModel.Add(shelf);
}
}
}
}
//===================================
// Import Accessory Information
//===================================
if (AccessoryData != null)
{
for (int row = 0; row < AccessoryData.Rows.Count; row++)
{
var accessory = new Accessory();
foreach (string propertyName in accessory.Properties)
{
if (AccessoryData.Columns[propertyName] != null)
{
accessory.SetProperty(propertyName, AccessoryData.Rows[row][propertyName].ToString());
}
}
foreach (RoomVM roomvm in newJob.Rooms)
{
if (roomvm.Room.RoomNumber == accessory.RoomNumber)
{
roomvm.AccessoryViewModel.Add(accessory);
}
}
}
}
return(newJob);
}