void AddValidationErrors(ErrorResultTO allErrors)
{
if (DataListUtil.HasNegativeIndex(SqlQuery))
{
allErrors.AddError(string.Format("Negative Recordset Index for SqlQuery: {0}", SqlQuery));
}
}
void AddValidationErrors(ErrorResultTO allErrors)
{
if (DataListUtil.HasNegativeIndex(InputFormat))
{
allErrors.AddError(string.Format("Negative Recordset Index for Input Format: {0}", InputFormat));
}
if (DataListUtil.HasNegativeIndex(OutputFormat))
{
allErrors.AddError(string.Format("Negative Recordset Index for Output Format: {0}", OutputFormat));
}
if (DataListUtil.HasNegativeIndex(TimeModifierAmountDisplay))
{
allErrors.AddError(string.Format("Negative Recordset Index for Add Time: {0}", TimeModifierAmountDisplay));
}
}
private void TryExecute(IDSFDataObject dataObject, int update, ErrorResultTO allErrors)
{
IsSingleValueRule.ApplyIsSingleValueRule(Result, allErrors);
if (dataObject.IsDebugMode())
{
if (string.IsNullOrEmpty(DateTime))
{
var defaultDateTimeDebugItem = new DebugItem();
AddDebugItem(new DebugItemStaticDataParams("System Date Time", "Input"), defaultDateTimeDebugItem);
AddDebugItem(new DebugItemStaticDataParams(System.DateTime.Now.ToString(CultureInfo.CurrentCulture), "="), defaultDateTimeDebugItem);
_debugInputs.Add(defaultDateTimeDebugItem);
}
else
{
AddDebugInputItem(new DebugEvalResult(DateTime, "Input", dataObject.Environment, update));
}
var cultureType = typeof(CultureInfo);
var fieldInfo = cultureType.GetField("s_userDefaultCulture", BindingFlags.NonPublic | BindingFlags.Static);
if (fieldInfo != null)
{
var val = fieldInfo.GetValue(CultureInfo.CurrentCulture);
var newCul = val as CultureInfo;
if (newCul != null)
{
Thread.CurrentThread.CurrentCulture = newCul;
}
}
var dateTimePattern = string.Format("{0} {1}", Thread.CurrentThread.CurrentCulture.DateTimeFormat.ShortDatePattern, Thread.CurrentThread.CurrentCulture.DateTimeFormat.LongTimePattern);
if (string.IsNullOrEmpty(InputFormat))
{
var defaultDateTimeDebugItem = new DebugItem();
AddDebugItem(new DebugItemStaticDataParams("System Date Time Format", "Input Format"), defaultDateTimeDebugItem);
AddDebugItem(new DebugItemStaticDataParams(dateTimePattern, "="), defaultDateTimeDebugItem);
_debugInputs.Add(defaultDateTimeDebugItem);
}
else
{
AddDebugInputItem(new DebugEvalResult(InputFormat, "Input Format", dataObject.Environment, update));
}
var debugItem = new DebugItem();
AddDebugItem(new DebugItemStaticDataParams(TimeModifierType, "Add Time"), debugItem);
AddDebugItem(new DebugEvalResult(TimeModifierAmountDisplay, "", dataObject.Environment, update), debugItem);
_debugInputs.Add(debugItem);
if (string.IsNullOrEmpty(OutputFormat))
{
var defaultDateTimeDebugItem = new DebugItem();
AddDebugItem(new DebugItemStaticDataParams("System Date Time Format", "Output Format"), defaultDateTimeDebugItem);
AddDebugItem(new DebugItemStaticDataParams(dateTimePattern, "="), defaultDateTimeDebugItem);
_debugInputs.Add(defaultDateTimeDebugItem);
}
else
{
AddDebugInputItem(new DebugEvalResult(OutputFormat, "Output Format", dataObject.Environment, update));
}
}
if (DataListUtil.HasNegativeIndex(InputFormat))
{
allErrors.AddError(string.Format("Negative Recordset Index for Input Format: {0}", InputFormat));
}
if (DataListUtil.HasNegativeIndex(OutputFormat))
{
allErrors.AddError(string.Format("Negative Recordset Index for Output Format: {0}", OutputFormat));
}
if (DataListUtil.HasNegativeIndex(TimeModifierAmountDisplay))
{
allErrors.AddError(string.Format("Negative Recordset Index for Add Time: {0}", TimeModifierAmountDisplay));
}
if (!allErrors.HasErrors())
{
UpdateDatalist(dataObject, update, allErrors);
}
}
protected override void ExecuteTool(IDSFDataObject dataObject)
{
_debugInputs = new List <DebugItem>();
_debugOutputs = new List <DebugItem>();
ErrorResultTO allErrors = new ErrorResultTO();
InitializeDebug(dataObject);
// Process if no errors
try
{
IsSingleValueRule.ApplyIsSingleValueRule(Result, allErrors);
if (dataObject.IsDebugMode())
{
if (string.IsNullOrEmpty(DateTime))
{
var defaultDateTimeDebugItem = new DebugItem();
AddDebugItem(new DebugItemStaticDataParams("System Date Time", "Input"), defaultDateTimeDebugItem);
AddDebugItem(new DebugItemStaticDataParams(System.DateTime.Now.ToString(CultureInfo.CurrentCulture), "="), defaultDateTimeDebugItem);
_debugInputs.Add(defaultDateTimeDebugItem);
}
else
{
AddDebugInputItem(new DebugEvalResult(DateTime, "Input", dataObject.Environment));
}
var cultureType = typeof(CultureInfo);
var fieldInfo = cultureType.GetField("s_userDefaultCulture", BindingFlags.NonPublic | BindingFlags.Static);
if (fieldInfo != null)
{
var val = fieldInfo.GetValue(CultureInfo.CurrentCulture);
var newCul = val as CultureInfo;
if (newCul != null)
{
Thread.CurrentThread.CurrentCulture = newCul;
}
}
var dateTimePattern = string.Format("{0} {1}", Thread.CurrentThread.CurrentCulture.DateTimeFormat.ShortDatePattern, Thread.CurrentThread.CurrentCulture.DateTimeFormat.LongTimePattern);
if (string.IsNullOrEmpty(InputFormat))
{
var defaultDateTimeDebugItem = new DebugItem();
AddDebugItem(new DebugItemStaticDataParams("System Date Time Format", "Input Format"), defaultDateTimeDebugItem);
AddDebugItem(new DebugItemStaticDataParams(dateTimePattern, "="), defaultDateTimeDebugItem);
_debugInputs.Add(defaultDateTimeDebugItem);
}
else
{
AddDebugInputItem(new DebugEvalResult(InputFormat, "Input Format", dataObject.Environment));
}
var debugItem = new DebugItem();
AddDebugItem(new DebugItemStaticDataParams(TimeModifierType, "Add Time"), debugItem);
AddDebugItem(new DebugEvalResult(TimeModifierAmountDisplay, "", dataObject.Environment), debugItem);
_debugInputs.Add(debugItem);
if (string.IsNullOrEmpty(OutputFormat))
{
var defaultDateTimeDebugItem = new DebugItem();
AddDebugItem(new DebugItemStaticDataParams("System Date Time Format", "Output Format"), defaultDateTimeDebugItem);
AddDebugItem(new DebugItemStaticDataParams(dateTimePattern, "="), defaultDateTimeDebugItem);
_debugInputs.Add(defaultDateTimeDebugItem);
}
else
{
AddDebugInputItem(new DebugEvalResult(OutputFormat, "Output Format", dataObject.Environment));
}
}
if (DataListUtil.HasNegativeIndex(InputFormat))
{
allErrors.AddError(string.Format("Negative Recordset Index for Input Format: {0}", InputFormat));
}
if (DataListUtil.HasNegativeIndex(OutputFormat))
{
allErrors.AddError(string.Format("Negative Recordset Index for Output Format: {0}", OutputFormat));
}
if (DataListUtil.HasNegativeIndex(TimeModifierAmountDisplay))
{
allErrors.AddError(string.Format("Negative Recordset Index for Add Time: {0}", TimeModifierAmountDisplay));
}
if (!allErrors.HasErrors())
{
var colItr = new WarewolfListIterator();
var dtItr = CreateDataListEvaluateIterator(string.IsNullOrEmpty(DateTime) ? GlobalConstants.CalcExpressionNow : DateTime, dataObject.Environment);
colItr.AddVariableToIterateOn(dtItr);
var ifItr = CreateDataListEvaluateIterator(InputFormat, dataObject.Environment);
colItr.AddVariableToIterateOn(ifItr);
var ofItr = CreateDataListEvaluateIterator(OutputFormat, dataObject.Environment);
colItr.AddVariableToIterateOn(ofItr);
var tmaItr = CreateDataListEvaluateIterator(TimeModifierAmountDisplay, dataObject.Environment);
colItr.AddVariableToIterateOn(tmaItr);
if (!allErrors.HasErrors())
{
while (colItr.HasMoreData())
{
IDateTimeOperationTO transObj = ConvertToDateTimeTo(colItr.FetchNextValue(dtItr),
colItr.FetchNextValue(ifItr),
colItr.FetchNextValue(ofItr),
TimeModifierType,
colItr.FetchNextValue(tmaItr)
);
IDateTimeFormatter format = DateTimeConverterFactory.CreateFormatter();
string result;
string error;
if (format.TryFormat(transObj, out result, out error))
{
string expression = Result;
dataObject.Environment.Assign(expression, result);
}
else
{
allErrors.AddError(error);
}
}
if (dataObject.IsDebugMode() && !allErrors.HasErrors())
{
AddDebugOutputItem(new DebugEvalResult(Result, "", dataObject.Environment));
}
}
}
}
catch (Exception e)
{
Dev2Logger.Log.Error("DSFDateTime", e);
allErrors.AddError(e.Message);
}
finally
{
// Handle Errors
var hasErrors = allErrors.HasErrors();
if (hasErrors)
{
DisplayAndWriteError("DsfDateTimeActivity", allErrors);
var errorString = allErrors.MakeDisplayReady();
dataObject.Environment.AddError(errorString);
}
if (dataObject.IsDebugMode())
{
if (hasErrors)
{
AddDebugOutputItem(new DebugItemStaticDataParams("", Result, ""));
}
DispatchDebugState(dataObject, StateType.Before);
DispatchDebugState(dataObject, StateType.After);
}
}
}
