private void btnTestSMTP_Click(object sender, EventArgs e)
{
SaveConfig();
//FormInputDialog testDialog = new FormInputDialog(txtBxSMTPSendTo.Text);
string recipient = txtBxSMTPSendTo.Text;
FormInputDialog inputDialog = new FormInputDialog("SMTP-Test", "Recipient of Test-Email:", "Send!");
inputDialog.txtBxInput.Text = recipient;
if (inputDialog.ShowDialog(this) == DialogResult.OK)
{
recipient = inputDialog.txtBxInput.Text;
MailHandler.GetInstance.SendTestMail(recipient);
inputDialog.Dispose();
}
}
public string Evaluate(string input, DocumentContract doc = null, bool testmode = false, bool isForSearchOrUpdate = false)
{
var start = DateTime.Now;
Hashtable hTenteredIDX = new Hashtable();
string returnvalue = "";
Expression e = new Expression(input);
e.Parameters["TodayDate"] = DateTime.Now.Date;
e.Parameters["TodayTime"] = DateTime.Now;
int year = DateTime.Now.Year;
e.Parameters["EndYear"] = new DateTime(year, 12, 31);
foreach (KeyValuePair <string, string> kvp in variables)
{
e.Parameters[kvp.Key] = new Expression(kvp.Value);
}
e.EvaluateFunction += delegate(string name, FunctionArgs args)
{
if (name == "AddDays")
{
var date1 = args.Parameters[0].Evaluate();
var days = args.Parameters[1].Evaluate();
//Check if days are a TimeSpan
if (days.GetType() == typeof(TimeSpan))
{
args.Result = ((DateTime)date1).Add((TimeSpan)days);
}
//Check if are a string.
else if (days.GetType() == typeof(string))
{
args.Result = ((DateTime)date1).AddDays(0);
}
//Else they are a double. (Use AddDays)
else
{
args.Result = ((DateTime)date1).AddDays(Convert.ToDouble(days));
}
}
if (name == "DateDiff")
{
var date1 = args.Parameters[0].Evaluate();
var date2 = args.Parameters[1].Evaluate();
//args.Result = ((DateTime)args.Parameters[0].Evaluate() - (DateTime)args.Parameters[1].Evaluate()).TotalDays;
args.Result = (DateTime)date2 - (DateTime)date1;
}
if (name == "IDX")
{
string index = args.Parameters[0].Evaluate().ToString();
string idxvalue = "";
//Get IDX Value from DocumentContract if available.
if (doc != null)
{
var propID = WCFHandler.GetInstance.GetPropertyTypeID(index);
string[] values = doc.Properties.Where(x => x.PropertyTypeId == propID).Select(x => x.Values).FirstOrDefault();
if (values == null)
{
throw new Exception(string.Format("Document did not contain a value for '{0}'.", index));
}
//if (values.Count() > 1)
//{
idxvalue = values.First();
//}
}
if (testmode)
{
if (hTenteredIDX.ContainsKey(index))
{
idxvalue = hTenteredIDX[index].ToString();
}
else
{
FormInputDialog inputDialog = new FormInputDialog("IDX Value", "Set Value for '" + index.ToString() + "':", "OK");
if (inputDialog.ShowDialog(null) == DialogResult.OK)
{
//recipient = inputDialog.txtBxInput.Text;
idxvalue = inputDialog.txtBxInput.Text;
hTenteredIDX.Add(index.ToString(), idxvalue);
inputDialog.Dispose();
}
}
}
//Check if its a Date
DateTime idxValueDate;
string[] formats = { "dd.MM.yyyy", "dd.MM.yyyy HH:mm", "dd.MM.yyyy HH:mm:ss", "yyyy-MM-ddTHH:mm:ss" };
if (DateTime.TryParseExact(idxvalue, formats, new CultureInfo(Properties.Settings.Default.Culture), DateTimeStyles.None, out idxValueDate))
{
//AEPH 03.01.2019: Convert DateTime to UNIX Timestamp as needed by WCFWebService
args.Result = idxValueDate;
return;
}
//Check if its a number
int idxValueInt;
if (int.TryParse(idxvalue, out idxValueInt) && idxValueInt != 0)
{
args.Result = idxValueInt;
return;
}
//Check if its a Decimal
decimal idxValueDecimal;
if (decimal.TryParse(idxvalue.Replace(',', '.'), NumberStyles.Any, CultureInfo.InvariantCulture, out idxValueDecimal) && idxValueDecimal != 0)
{
args.Result = idxValueDecimal;
return;
}
//Else, forward it as a string.
args.Result = idxvalue;
}
if (name == "SQL")
{
string connection = ((NCalc.Domain.ValueExpression)(args.Parameters[0].ParsedExpression)).Value.ToString();
var selectstatement = args.Parameters[1].Evaluate();
SqlConnection sqlCon = (sqlConnections.Find(item => item.name == connection.ToString())).connection;
if (sqlCon == null)
{
throw new System.ArgumentException(string.Format("SQL-Connection '{0}' not defined.", connection));
}
if (sqlCon != null && sqlCon.State == ConnectionState.Closed)
{
sqlCon.Open();
}
SqlCommand command = new SqlCommand(selectstatement.ToString())
{
Connection = sqlCon
};
//AEPH 03.02.2016
//If testmode is on, command is only tested on server, not executed. (noexec mode)
//This is used to validate the markerproperties prior to output processing.
if (testmode)
{
command.CommandType = CommandType.Text;
command.CommandText = "SET NOEXEC ON;";
}
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
args.Result = (string)reader[0].ToString();
}
}
if (args.Result == null)
{
args.Result = "";
}
}
if (name == "RegEx")
{
var value = args.Parameters[0].Evaluate();
string expression = ((NCalc.Domain.ValueExpression)(args.Parameters[1].ParsedExpression)).Value.ToString();
Regex regex = new Regex(@expression);
Match match = regex.Match(value.ToString());
args.Result = match.Success;
}
if (name == "RegExReplace")
{
var sInput = args.Parameters[0].Evaluate();
var sReplacement = args.Parameters[1].Evaluate();
string expression = ((NCalc.Domain.ValueExpression)(args.Parameters[2].ParsedExpression)).Value.ToString();
Regex regex = new Regex(@expression);
args.Result = regex.Replace(sInput.ToString(), sReplacement.ToString());
}
if (name == "SS")
{
var sInput = args.Parameters[0].Evaluate();
string arg1 = args.Parameters[1].Evaluate().ToString();
string arg2 = args.Parameters[2].Evaluate().ToString();
int iStartIndex;
int.TryParse(arg1, out iStartIndex);
int iEndIndex;
int.TryParse(arg2, out iEndIndex);
string output = sInput.ToString();
args.Result = output.Substring(iStartIndex, iEndIndex);
}
};
if (e.HasErrors())
{
throw new Exception(e.Error);
}
else
{
try
{
var output = e.Evaluate().ToString();
//AEPH 05.02.2016
//Decimal sign is used based on system settings.
//AEPH 03.01.2019
//Convert Date or DateTime Values to correct format for new WCF-WebServices.
//yyyy-MM-ddTHH:mm:ss for DateTime.
//yyyy-MM-dd for dates.
if (isForSearchOrUpdate)
{
DateTime idxValueDate;
string[] formats = { "dd.MM.yyyy", "dd.MM.yyyy HH:mm", "dd.MM.yyyy HH:mm:ss" };
IFormatProvider culture = CultureInfo.InvariantCulture;
if (DateTime.TryParseExact(output, formats, culture, DateTimeStyles.None, out idxValueDate))
{
//Check if its a Date or DateTime
//Source: https://stackoverflow.com/questions/15893339/check-if-date-time-string-contains-time
if (idxValueDate.TimeOfDay.TotalSeconds == 0)
{
output = idxValueDate.ToString("yyyy-MM-dd");
}
else
{
output = idxValueDate.ToString("yyyy-MM-ddTHH:mm:ss");
}
}
}
returnvalue = output;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
var end = DateTime.Now - start;
log4.Debug(string.Format("Evaluation of expression took {0}ms. in:'{1}' out:'{2}'", end.TotalMilliseconds.ToString(), input, returnvalue));
return(returnvalue);
}
