public static string GetDateGroupingExpression(DateGroupingType dgt, string field)
{
switch (dgt)
{
case DateGroupingType.Year:
field = string.Format("YEAR({0})", field);
break;
case DateGroupingType.Month:
field = string.Format("CONVERT(VARCHAR(7),{0},120)", field);
break;
case DateGroupingType.Day:
field = string.Format("CONVERT(VARCHAR(10),{0},120)", field);
break;
case DateGroupingType.Quarter:
field = string.Format("DATEPART(QUARTER,{0})", field);
break;
case DateGroupingType.Week:
field = string.Format("DATEPART(WEEK,{0})", field);
break;
}
return(field);
}
public CrmAttributeXml(
string name = "",
string alias = "",
AggregateType aggregate = AggregateType.None,
bool groupBy = false,
DateGroupingType dateGrouping = DateGroupingType.None
)
{
this.Name = name;
this.Alias = alias;
this.Aggregate = aggregate;
this.GroupBy = groupBy;
this.DateGrouping = dateGrouping;
}
public static string GetValue(DateGroupingType dateGroupingType)
{
switch (dateGroupingType)
{
case DateGroupingType.Day:
return "day";
case DateGroupingType.Week:
return "week";
case DateGroupingType.Month:
return "month";
case DateGroupingType.Quarter:
return "quarter";
case DateGroupingType.Year:
return "year";
case DateGroupingType.FiscalPeriod:
return "fiscal-period";
case DateGroupingType.FiscalYear:
return "fiscal-year";
default:
return string.Empty;
}
}
public static string GetFormatting(DateGroupingType dgt)
{
var result = "yyyy-MM-dd";
switch (dgt)
{
case DateGroupingType.Year:
result = "yyyy";
break;
case DateGroupingType.Month:
result = "yyyy-MM";
break;
case DateGroupingType.Day:
result = "yyyy-MM-dd";
break;
case DateGroupingType.Week:
result = "dddd";
break;
}
return(result);
}
