/// <summary>
/// Get the "timePeriod" rule type according to "TimePeriod" attribute.
/// /// </summary>
/// <returns>Last7Days, LastMonth etc.</returns>
public static eExcelConditionalFormattingRuleType GetTimePeriodType(
XmlNode topNode,
XmlNamespaceManager nameSpaceManager)
{
eExcelConditionalFormattingTimePeriodType timePeriod = ExcelConditionalFormattingTimePeriodType.GetTypeByAttribute(
ExcelConditionalFormattingHelper.GetAttributeString(
topNode,
ExcelConditionalFormattingConstants.Attributes.TimePeriod));
switch (timePeriod)
{
case eExcelConditionalFormattingTimePeriodType.Last7Days:
return(eExcelConditionalFormattingRuleType.Last7Days);
case eExcelConditionalFormattingTimePeriodType.LastMonth:
return(eExcelConditionalFormattingRuleType.LastMonth);
case eExcelConditionalFormattingTimePeriodType.LastWeek:
return(eExcelConditionalFormattingRuleType.LastWeek);
case eExcelConditionalFormattingTimePeriodType.NextMonth:
return(eExcelConditionalFormattingRuleType.NextMonth);
case eExcelConditionalFormattingTimePeriodType.NextWeek:
return(eExcelConditionalFormattingRuleType.NextWeek);
case eExcelConditionalFormattingTimePeriodType.ThisMonth:
return(eExcelConditionalFormattingRuleType.ThisMonth);
case eExcelConditionalFormattingTimePeriodType.ThisWeek:
return(eExcelConditionalFormattingRuleType.ThisWeek);
case eExcelConditionalFormattingTimePeriodType.Today:
return(eExcelConditionalFormattingRuleType.Today);
case eExcelConditionalFormattingTimePeriodType.Tomorrow:
return(eExcelConditionalFormattingRuleType.Tomorrow);
case eExcelConditionalFormattingTimePeriodType.Yesterday:
return(eExcelConditionalFormattingRuleType.Yesterday);
}
throw new Exception(
ExcelConditionalFormattingConstants.Errors.UnexistentTimePeriodTypeAttribute);
}
/// <summary>
///
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public static string GetAttributeByType(
eExcelConditionalFormattingTimePeriodType type)
{
switch (type)
{
case eExcelConditionalFormattingTimePeriodType.Last7Days:
return(ExcelConditionalFormattingConstants.TimePeriods.Last7Days);
case eExcelConditionalFormattingTimePeriodType.LastMonth:
return(ExcelConditionalFormattingConstants.TimePeriods.LastMonth);
case eExcelConditionalFormattingTimePeriodType.LastWeek:
return(ExcelConditionalFormattingConstants.TimePeriods.LastWeek);
case eExcelConditionalFormattingTimePeriodType.NextMonth:
return(ExcelConditionalFormattingConstants.TimePeriods.NextMonth);
case eExcelConditionalFormattingTimePeriodType.NextWeek:
return(ExcelConditionalFormattingConstants.TimePeriods.NextWeek);
case eExcelConditionalFormattingTimePeriodType.ThisMonth:
return(ExcelConditionalFormattingConstants.TimePeriods.ThisMonth);
case eExcelConditionalFormattingTimePeriodType.ThisWeek:
return(ExcelConditionalFormattingConstants.TimePeriods.ThisWeek);
case eExcelConditionalFormattingTimePeriodType.Today:
return(ExcelConditionalFormattingConstants.TimePeriods.Today);
case eExcelConditionalFormattingTimePeriodType.Tomorrow:
return(ExcelConditionalFormattingConstants.TimePeriods.Tomorrow);
case eExcelConditionalFormattingTimePeriodType.Yesterday:
return(ExcelConditionalFormattingConstants.TimePeriods.Yesterday);
}
return(string.Empty);
}
/// <summary>
///
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public static string GetAttributeByType(
eExcelConditionalFormattingTimePeriodType type)
{
switch (type)
{
case eExcelConditionalFormattingTimePeriodType.Last7Days:
return ExcelConditionalFormattingConstants.TimePeriods.Last7Days;
case eExcelConditionalFormattingTimePeriodType.LastMonth:
return ExcelConditionalFormattingConstants.TimePeriods.LastMonth;
case eExcelConditionalFormattingTimePeriodType.LastWeek:
return ExcelConditionalFormattingConstants.TimePeriods.LastWeek;
case eExcelConditionalFormattingTimePeriodType.NextMonth:
return ExcelConditionalFormattingConstants.TimePeriods.NextMonth;
case eExcelConditionalFormattingTimePeriodType.NextWeek:
return ExcelConditionalFormattingConstants.TimePeriods.NextWeek;
case eExcelConditionalFormattingTimePeriodType.ThisMonth:
return ExcelConditionalFormattingConstants.TimePeriods.ThisMonth;
case eExcelConditionalFormattingTimePeriodType.ThisWeek:
return ExcelConditionalFormattingConstants.TimePeriods.ThisWeek;
case eExcelConditionalFormattingTimePeriodType.Today:
return ExcelConditionalFormattingConstants.TimePeriods.Today;
case eExcelConditionalFormattingTimePeriodType.Tomorrow:
return ExcelConditionalFormattingConstants.TimePeriods.Tomorrow;
case eExcelConditionalFormattingTimePeriodType.Yesterday:
return ExcelConditionalFormattingConstants.TimePeriods.Yesterday;
}
return string.Empty;
}
