public void WorkUnitQueryParameter_Operator_UnknownOperatorsThrowExceptionOnStringValue() { var parameter = new WorkUnitQueryParameter { Operator = (WorkUnitQueryOperator)Int32.MaxValue }; Assert.Throws <InvalidOperationException>(() => parameter.GetOperatorString()); }
public void WorkUnitQueryParameter_DefaultConstructor_HasPropertyValues() { var parameter = new WorkUnitQueryParameter(); Assert.AreEqual(WorkUnitRowColumn.ProjectID, parameter.Column); Assert.AreEqual(WorkUnitQueryOperator.Equal, parameter.Operator); Assert.AreEqual("=", parameter.GetOperatorString()); }
public void WorkUnitQueryParameter_Operator_OperatorsHaveStringValue() { var parameter = new WorkUnitQueryParameter(); foreach (WorkUnitQueryOperator op in Enum.GetValues(typeof(WorkUnitQueryOperator))) { parameter.Operator = op; Console.WriteLine(parameter.GetOperatorString()); } }
private static PetaPoco.Sql BuildWhereCondition(PetaPoco.Sql sql, WorkUnitQueryParameter parameter) { string format = "[{0}] {1} @0"; if (parameter.Column.Equals(WorkUnitRowColumn.Assigned) || parameter.Column.Equals(WorkUnitRowColumn.Finished)) { format = "datetime([{0}]) {1} datetime(@0)"; } sql = sql.Append(String.Format(CultureInfo.InvariantCulture, format, ColumnNameOverrides.ContainsKey(parameter.Column) ? ColumnNameOverrides[parameter.Column] : parameter.Column.ToString(), parameter.GetOperatorString()), parameter.Value); return(sql); }