internal static Int32 findUserId(CocodrinksContext context, string name)
{
Int32 userid = -1;
using (var command = context.Database.GetDbConnection().CreateCommand())
{
command.CommandText = "SELECT Id FROM users WHERE name='" + name + "'";
context.Database.OpenConnection();
DbDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
userid = reader.GetInt32(0);
log.Info("found userid " + userid.ToString());
}
reader.Close();
}
else
{
log.Info("no users found");
}
reader.Close();
return(userid);
}
}
internal static Int32 getAccessLevel(CocodrinksContext context, String userId)
{
if (userId != null)
{
var user = context.Users.Find(Int32.Parse(userId));
if (user != null)
{
return(user.AccessLevel);
}
}
return(99);
}
public OrderController(CocodrinksContext context, ILogger <OrderController> logger)
{
_context = context;
_logger = logger;
}
//private readonly ILogger<OnderdelenController> _logger;
public OnderdelenController(CocodrinksContext context, ILogger <OnderdelenController> logger)
{
_context = context;
// _logger = logger;
}
public ArticleController(CocodrinksContext context, IHostingEnvironment hostingEnvironment, ILogger <ArticleController> logger)
{
_context = context;
_hostingEnvironment = hostingEnvironment;
_logger = logger;
}
public OrderLinesController(CocodrinksContext context)
{
_context = context;
}
public HomeController(CocodrinksContext context, ILoggerFactory logger, IHttpContextAccessor accessor)
{
_context = context;
_logger = logger.CreateLogger("Cocodrinks.Controllers.HomeController");
_accessor = accessor;
}
