public IEnumerable <DocumentViewModel> FilterFilesByGuid(string currentSid)
{
_logger.LogDebug($"Return files from database by current sid");
Select select = Qb.Select(nameof(Document.path), nameof(Document.upload_time_stamp), nameof(Document.short_name), nameof(Document.picture), nameof(Document.doc_id))
.From(Tables.Document)
.Where(
Cond.Equal(nameof(Document.user_sid), currentSid),
Cond.Equal(nameof(Document.type), Convert.ToByte(IO.FileExtension.Extensions.Pdf))
);
IEnumerable <DocumentViewModel> documents;
try
{
using (AnyDbConnection connection = _factory.OpenConnection())
{
return(documents = connection.Query <DocumentViewModel>(select));
}
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
}
_logger.LogDebug($"FileDbService.FilterFilesByGuid....OK");
return(null);
}
public void SelectTest()
{
Select sel = Qb.Select("*")
.From("customer").OrderBy("id");
using (AnyDbConnection con = _factory.OpenConnection())
{
var res = con.Query(sel);
Assert.Equal(100, res.Count());
}
}
public static IEnumerable <T> Query <T>(this AnyDbConnection cnn, Select query, IDbTransaction transaction = null, bool buffered = true, int?commandTimeout = null)
{
string sql = GetSelectSql(cnn, query);
if (!commandTimeout.HasValue)
{
commandTimeout = cnn.DefaultCommandTimeout;
}
DynamicParameters parameters = GetParameters(query.Query.CommandParams);
return(cnn.Query <T>(sql, parameters, transaction, buffered, commandTimeout, CommandType.Text));
}
public void GetPageSqlTest()
{
Select sel = Qb.Select("*")
.From("customer").OrderBy("id").Page(1, 10);
string sql = _factory.GetSql(sel);
using (AnyDbConnection con = _factory.OpenConnection())
{
var res = con.Query(sel);
Assert.Equal(10, res.Count());
}
}
public static IEnumerable <TReturn> Query <TFirst, TSecond, TThird, TFourth, TFifth, TSixth, TSeventh, TReturn>(this AnyDbConnection cnn, Select query, Func <TFirst, TSecond, TThird, TFourth, TFifth, TSixth, TSeventh, TReturn> func, IDbTransaction transaction = null,
bool buffered = true, int?commandTimeout = null, string splitOn = "Id")
{
string sql = GetSelectSql(cnn, query);
if (!commandTimeout.HasValue)
{
commandTimeout = cnn.DefaultCommandTimeout;
}
DynamicParameters parameters = GetParameters(query.Query.CommandParams);
return(cnn.Query <TFirst, TSecond, TThird, TFourth, TFifth, TSixth, TSeventh, TReturn>(sql, func, parameters, transaction, buffered, commandTimeout: commandTimeout, splitOn: splitOn));
}
IEnumerable <Customer> GetAll(AnyDbConnection con)
{
Select sel = Qb.Select("*").From("customer");
return(con.Query <Customer>(sel));
}