public ContextProvider(IHttpContextAccessor contextAccessor, IMapper mapper,
BusinessBaseProvider businessProvider, ProtDbContext dbContext, DbDialect dbDialect)
{
HttpContext = contextAccessor.HttpContext;
Mapper = mapper;
BusinessProvider = businessProvider;
DbContext = dbContext;
DbDialect = dbDialect;
IDAppUser = HttpContext.Session.GetInt32(CurrentUserIDSessionKey);
}
public virtual string GetListSQL(DbDialect dialect, string listName, string parameter)
{
return("Select " + dialect.Encapsulate(names[PrimaryKeys[0]]) + " As ID, "
+ dialect.Encapsulate(firstStringProperty.FieldName) + " From " + tableNameEncapsulated
+ " Order By " + dialect.Encapsulate(firstStringProperty.FieldName));
}
