public void ConvertDateTimeConstructorTest1()
{
DateTimeTypes dataType = new DateTimeTypes(); // TODO: Initialize to an appropriate value
Expression expression = null; // TODO: Initialize to an appropriate value
ConvertDateTime target = new ConvertDateTime(dataType, expression);
Assert.Inconclusive("TODO: Implement code to verify target");
}
static ReporterParameter CreateDateTime(this ReporterParameter param, DateTimeTypes dateTimeType, string displayFormat, bool roller = false)
{
param.ValueType = ParameterValueType.DateTime;
string typeString = "";
string defDisplayFormat = "";
switch (dateTimeType)
{
default:
case DateTimeTypes.Date:
typeString = "date";
defDisplayFormat = "dd.MM.yyyy";
break;
case DateTimeTypes.Time:
typeString = "time";
defDisplayFormat = "HH:mm";
break;
case DateTimeTypes.DateTime:
typeString = "datetime";
defDisplayFormat = "dd.MM.yyyy HH:mm";
break;
}
if (displayFormat.isNullOrWhiteSpace())
{
displayFormat = defDisplayFormat;
}
param.Html = $@"<div class='option'><span>parameter_text</span><div id='parameter_name'></div></div>";
param.Js = @"
<script>$(function() {
$('#parameter_name').dxDateBox({
type: '" + typeString + @"',
displayFormat:'" + displayFormat + @"',
value: new Date(),
onValueChanged: function (e) {
var previousValue = e.previousValue;
var newValue = e.value;
jQuery.data(document.body, 'parameter_name_value', dateToString(e.value));
}
});
jQuery.data(document.body, 'parameter_name_value', dateToString(getDate('parameter_name').option('value')));
}
)
</script>
";
return(param.ReplaceParamTextName());
}
public DateTimeMsSqlColumnType(DateTimeTypes dateTimeTypes)
{
DateTimeType = dateTimeTypes;
}
//The conversion of the given non-numerical value to DateTime would be different depending upon the given secondary type (i.e., DateTimeTypes). This function performs the corresponding analysis
private double valueFromDateTimeType(DateTime curDateTime, DateTimeTypes curType)
{
double outVal = 0.0;
if (curType == DateTimeTypes.Time)
{
outVal = (double)(10000 * curDateTime.Hour + 100 * curDateTime.Minute + curDateTime.Second);
}
else if (curType == DateTimeTypes.Year)
{
outVal = (double)curDateTime.Year;
}
else if (curType == DateTimeTypes.Month)
{
outVal = (double)curDateTime.Month;
}
else if (curType == DateTimeTypes.Weekday)
{
outVal = (double)((int)curDateTime.DayOfWeek);
}
else if (curType == DateTimeTypes.Day)
{
outVal = (double)curDateTime.Day;
}
return outVal;
}
//Function called to adapt the given column to match the DateTime type
private Input updateTime(Input curInput, DateTimeTypes curType)
{
for (int i = 0; i < curInput.vals2.Count; i++)
{
if (curInput.vals.Count - 1 < i) curInput.vals.Add(0.0);
DateTime tempVal = new DateTime(1900, 1, 1);
if (DateTime.TryParse(curInput.vals2[i], Common.curCulture, System.Globalization.DateTimeStyles.None, out tempVal))
{
double newVal = valueFromDateTimeType(tempVal, curType);
if (!curInput.conversionDict.ContainsKey(curInput.vals2[i])) curInput.conversionDict.Add(curInput.vals2[i], newVal);
curInput.vals[i] = newVal;
}
else
{
curInput.wrongRowsCount = curInput.wrongRowsCount + 1;
}
}
return curInput;
}
private string DateTimeAdd(string input, string pattern, DateTimeTypes dtType)
{
//Include a percent ("%") format specifier before the single custom date and time specifier. like d,m e.t.c
//Bellow creates two regex groups, one of them contains the values in the middle (.*)
Match innerMatch = Regex.Match(pattern, @"%Add[MonthsDayYer]+\(([-]?\d+,.*)\)%");
if (innerMatch.Success == false)
{
throw new ArgumentException($"No match for regex {pattern}", "DateTimeAdd");
}
char[] delimiterChar = { ',' };
string innerValue = String.Empty;
foreach (Group item in innerMatch.Groups)
{
if (item.Value.StartsWith("%Add") == false && item.Success == true) //Success == false = empty values
{
innerValue = item.Value;
string[] values = innerValue.Split(delimiterChar, StringSplitOptions.RemoveEmptyEntries);
if (values.Count() != 2)
{
return(input.Replace(innerMatch.Value, String.Empty));
}
try
{
string dateformat = String.Empty;
switch (dtType)
{
case DateTimeTypes.Day:
long days = long.Parse(values[0]);
dateformat = DateTime.Now.AddDays(days).ToString(values[1]);
break;
case DateTimeTypes.Month:
int months = int.Parse(values[0]);
dateformat = DateTime.Now.AddMonths(months).ToString(values[1]);
break;
case DateTimeTypes.Year:
int years = int.Parse(values[0]);
dateformat = DateTime.Now.AddYears(years).ToString(values[1]);
break;
}
input = input.Replace(innerMatch.Value, dateformat);
}
catch (System.FormatException fe)
{
throw new Exception("Invalid dateformat " + innerMatch.Value, fe);
}
}
}
return(input);
}
