public void Values(params object[] Values)
{
if (Values.Length != this._columns.Count)
{
throw new Exception("Number of values does not match the number of columns. Make sure columns are specified before values are added.");
}
this._values.Clear();
foreach (object value in Values)
{
string valueasstring = string.Empty;
if (value != null)
{
valueasstring = value.ToString();
#region BOOLEAN
if (value.GetType().Name.ToLower() == "boolean")
{
if (valueasstring.ToLower() == "true")
{
valueasstring = "1";
}
else
{
valueasstring = "0";
}
}
#endregion
#region ENUM
if (value.GetType().BaseType.Name.ToLower() == "enum")
{
valueasstring = ((int)value).ToString();
}
#endregion
#region DECIMAL
if (value.GetType().Name.ToLower() == "decimal")
{
valueasstring = value.ToString().Replace(",", ".");
}
#endregion
#region LIST
if (value.GetType().Name.ToLower() == "list`1")
{
valueasstring = SNDK.Serializer.SerializeObjectToString(value);
}
#endregion
}
this._values.Add(QueryBuilder.MakeSafe(valueasstring));
}
}
public void OrderBy(string Column, QueryBuilderOrder Order)
{
if (Order == QueryBuilderOrder.Accending)
{
this._orderby = "ORDER BY '" + QueryBuilder.MakeSafe(Column) + "' ASC";
}
else if (Order == QueryBuilderOrder.Decending)
{
this._orderby = "ORDER BY '" + QueryBuilder.MakeSafe(Column) + "' DESC";
}
}
public void AddWhere(string Column, string Expression, object Value)
{
string valueasstring = string.Empty;
if (Value != null)
{
valueasstring = Value.ToString();
#region BOOLEAN
if (Value.GetType().Name.ToLower() == "boolean")
{
if (valueasstring.ToLower() == "true")
{
valueasstring = "1";
}
else
{
valueasstring = "0";
}
}
#endregion
#region ENUM
if (Value.GetType().BaseType.Name.ToLower() == "enum")
{
valueasstring = ((int)Value).ToString();
}
#endregion
#region DECIMAL
if (Value.GetType().Name.ToLower() == "decimal")
{
valueasstring = Value.ToString().Replace(",", ".");
}
#endregion
}
this._wheres.Add("(" + Column + " " + Expression + " '" + QueryBuilder.MakeSafe(valueasstring) + "')");
}