/// <summary>
/// Search until end or until another formula found; swap in latter case.
/// </summary>
/// <param name="sheet"></param>
/// <param name="formulaName"></param>
/// <param name="categoryShiftType"></param>
public static Boolean ShiftSheetFormula(Sheet sheet, String formulaName, ListOfTExtension.ShiftTypes shiftType)
{
Boolean returnValue = default(Boolean);
try
{
_ValueChanging = true;
sheet.Formulae.ShiftListItem <OrderedEquatableBindingList <Formula>, Formula>
(
shiftType,
(item => item.Value == formulaName), //match on Formula Name property
(item, itemSwap) => true //match on any Formula)
);
_ValueChanging = false;
//refresh
//Refresh();
returnValue = true;
}
catch (Exception ex)
{
Log.Write(ex, MethodBase.GetCurrentMethod(), EventLogEntryType.Error);
_ValueChanging = false;
throw;
}
return(returnValue);
}
/// <summary>
/// Search until end or until another category with same sheet-category-type found; swap in latter case.
/// </summary>
/// <param name="categoryName"></param>
/// <param name="categoryShiftType"></param>
public static Boolean ShiftSheetCategory(Sheet sheet, String categoryName, ListOfTExtension.ShiftTypes shiftType)
{
Boolean returnValue = default(Boolean);
try
{
_ValueChanging = true;
sheet.Categories.ShiftListItem <OrderedEquatableBindingList <Category>, Category>
(
shiftType,
(item => item.Name == categoryName), //match on Category Name property
(item, itemSwap) => item.CategoryType == itemSwap.CategoryType //match on item Category Type)
);
_ValueChanging = false;
//refresh
//Refresh();
returnValue = true;
}
catch (Exception ex)
{
Log.Write(ex, MethodBase.GetCurrentMethod(), EventLogEntryType.Error);
_ValueChanging = false;
throw;
}
return(returnValue);
}
/// <summary>
/// Search until end or until another category item found; swap in latter case.
/// </summary>
/// <param name="sheet"></param>
/// <param name="categoryName"></param>
/// <param name="categoryItemName"></param>
/// <param name="categoryShiftType"></param>
public static Boolean ShiftSheetCategoryItem(Sheet sheet, String categoryName, String categoryItemName, ListOfTExtension.ShiftTypes shiftType)
{
Boolean returnValue = default(Boolean);
Category category = default(Category);
try
{
_ValueChanging = true;
//find item's parent
category = sheet.Categories.Find(c => c.Name == categoryName);
if (category == null)
{
throw new ArgumentException(String.Format("Unable to find Category '{0}'.", categoryName));
}
category.Items.ShiftListItem <OrderedEquatableBindingList <CategoryItem>, CategoryItem>
(
shiftType,
(item) => item.Name == categoryItemName, //match on Category Item Name property
(item, itemSwap) => true //match on any Category Item)
);
_ValueChanging = false;
//refresh
//Refresh();
returnValue = true;
}
catch (Exception ex)
{
Log.Write(ex, MethodBase.GetCurrentMethod(), EventLogEntryType.Error);
_ValueChanging = false;
throw;
}
return(returnValue);
}
