protected int RunCommand()
{
IEnumerable <ExcelRosterFileInfo> rosters;
if (_arg.Values.Count == 0)
{
Out.WriteLine("No table name specified - default to All");
rosters = Storage.GetRosters();
}
else if (_allOption.Equals(_arg.Values[0], StringComparison.InvariantCultureIgnoreCase))
{
rosters = Storage.GetRosters();
}
else
{
var r = new List <ExcelRosterFileInfo>(_arg.Values.Count);
foreach (var v in _arg.Values)
{
var rfi = Storage.Find(v);
if (rfi == null)
{
Out.WriteLine("Unknown roster " + v);
return(1);
}
r.Add(rfi);
}
rosters = r;
}
foreach (var r in rosters)
{
if (r.RosterType == ExcelRosterFileInfo.RosterTypes.ImplicitNames)
{
var sheetName = new TypeMap <ColumnMap>().SheetName;
using (var mapSS = new XLWorkbook(r.MapPath, XLEventTracking.Disabled))
{
var sheet = mapSS.Worksheets.FirstOrDefault(s => s.Name.Equals(sheetName, StringComparison.InvariantCultureIgnoreCase));
var map = FromSheet.DictionaryFromSheet(sheet, "Column", "ShiftCode");
IEnumerable <Appointment> roster;
if (r.MapPath == r.RosterPath)
{
roster = GetRows.FromInitialDict(mapSS, map, r.DateColumn);
}
else
{
using (var rosterSS = new XLWorkbook(r.RosterPath, XLEventTracking.Disabled))
{
roster = GetRows.FromInitialDict(rosterSS, map, r.DateColumn);
}
}
SendEntities.PostRosterUpsert(r.RosterId, r.Base64Secret, roster, Out, Error);
}
}
}
return(0);
}
public RowsViewModel(string updateButtonMessage, GetRows getRowsMethod, ShapeType shapeType)
: base()
{
Int64 startTicks = Log.CONSTRUCTOR("Enter", Common.LOG_CATEGORY);
UpdateButtonContent = updateButtonMessage;
_getRowsCommand = getRowsMethod;
_shapeType = shapeType;
InitializeViewModel();
Log.CONSTRUCTOR("Exit", Common.LOG_CATEGORY, startTicks);
}
