private SqliteParameterCollection DataSql_Parameters(string[] data)
{
SqliteCommand SqliteCommand = new SqliteCommand();
SqliteParameterCollection ReturnParamter = SqliteCommand.Parameters;
ReturnParamter.AddWithValue(LibraryWords.Row, data[0]);
ReturnParamter.AddWithValue(LibraryWords.Row + 1.ToString(), data[1]);
return(ReturnParamter);
}
/// <summary>
/// null verification
/// </summary>
public static SqliteParameter AddWithNullableValue(this SqliteParameterCollection collection, string parameterName, object value)
{
if (value == null)
{
return(collection.AddWithValue(parameterName, DBNull.Value));
}
else
{
return(collection.AddWithValue(parameterName, value));
}
}
public static SqliteParameter AddWithNullable <T>(this SqliteParameterCollection parms,
string parameterName, T?nullable) where T : struct
{
if (nullable.HasValue)
{
return(parms.AddWithValue(parameterName, nullable.Value));
}
else
{
return(parms.AddWithValue(parameterName, DBNull.Value));
}
}
public static SqliteParameter AddWithNullable(this SqliteParameterCollection parms,
string parameterName, object nullable)
{
if (nullable != null)
{
return(parms.AddWithValue(parameterName, nullable));
}
else
{
return(parms.AddWithValue(parameterName, DBNull.Value));
}
}
private SqliteParameterCollection DataSql_Parameters()
{
SqliteCommand SqliteCommand = new SqliteCommand();
SqliteParameterCollection ReturnParamter = SqliteCommand.Parameters;
ReturnParamter.AddWithValue(LibraryWords.Row + 0.ToString(), txt);
ReturnParamter.AddWithValue(LibraryWords.Row + 1.ToString(), txtport);
return(ReturnParamter);
}
//private void Save_image(queue Finsh_queue) {
// var myByteArray = File.ReadAllBytes(Finsh_queue.Filename);
// _DataSql.process(library.File(2), library.INSERT(2), DataSql_Parameters(Finsh_queue.Filename + ".jpg", myByteArray, "Image"));
//}
//change
private static SqliteParameterCollection DataSql_Parameters(string date, byte[] m, byte[] g, string j)
{
// var date = DateTime.Now.ToString(" HH:mm:ss");
SqliteCommand SqliteCommand = new SqliteCommand();
SqliteParameterCollection ReturnParamter = SqliteCommand.Parameters;
ReturnParamter.AddWithValue(LibraryWords.Row + 0.ToString(), date);
ReturnParamter.AddWithValue(LibraryWords.Row + 1.ToString(), m);
ReturnParamter.AddWithValue(LibraryWords.Row + 2.ToString(), g);
ReturnParamter.AddWithValue(LibraryWords.Row + 3.ToString(), j);
return(ReturnParamter);
}
public static SqliteParameterCollection AddSlidingExpirationInSeconds(
this SqliteParameterCollection parameters,
TimeSpan?value)
{
if (value.HasValue)
{
return(parameters.AddWithValue(
Columns.Names.SlidingExpirationInSeconds, SqliteType.Integer, value.Value.TotalSeconds));
}
else
{
return(parameters.AddWithValue(Columns.Names.SlidingExpirationInSeconds, SqliteType.Integer, DBNull.Value));
}
}
public static SqliteParameterCollection AddAbsoluteExpirationSQLite(
this SqliteParameterCollection parameters,
DateTimeOffset?utcTime)
{
if (utcTime.HasValue)
{
return(parameters.AddWithValue(
Columns.Names.AbsoluteExpiration, SqliteType.Integer, utcTime.Value.ToUnixTimeMilliseconds()));
}
else
{
return(parameters.AddWithValue(
Columns.Names.AbsoluteExpiration, SqliteType.Integer, DBNull.Value));
}
}
public static SqliteParameterCollection AddCacheItemValue(this SqliteParameterCollection parameters, byte[] value)
{
if (value != null && value.Length < DefaultValueColumnWidth)
{
return(parameters.AddWithValue(
Columns.Names.CacheItemValue,
SqliteType.Blob,
DefaultValueColumnWidth,
value));
}
else
{
// do not mention the size
return(parameters.AddWithValue(Columns.Names.CacheItemValue, SqliteType.Blob, value));
}
}
public static void AddIdParameter (
this SqliteParameterCollection source, ITasqueCore item)
{
if (source == null)
throw new NullReferenceException ("source");
if (item == null)
throw new ArgumentNullException ("item");
source.AddWithValue ("@id", int.Parse (item.Id));
}
private SqliteParameterCollection DataSql_Parameters(string String)
{
SqliteCommand SqliteCommand = new SqliteCommand();
SqliteParameterCollection ReturnParamter = SqliteCommand.Parameters;
ReturnParamter.AddWithValue(LibraryWords.Row, String);
// ReturnParamter.AddWithValue("@port", field2.Text);
return(ReturnParamter);
}
public static SqliteParameterCollection AddExpiresAtTimeSQLite(
this SqliteParameterCollection parameters,
DateTimeOffset utcTime)
{
return(parameters.AddWithValue(Columns.Names.ExpiresAtTime, SqliteType.Integer, utcTime.ToUnixTimeMilliseconds()));
}
public static SqliteParameterCollection AddCacheItemId(this SqliteParameterCollection parameters, string value)
{
return(parameters.AddWithValue(Columns.Names.CacheItemId, SqliteType.Text, CacheItemIdColumnWidth, value));
}
