public List <T> ExecuteQuery <T>(string query, Func <IDataRecord, T> materializeTable) { using (SQLiteConnection sqLite = new SQLiteConnection(_connectionString.GetConnectionString())) { sqLite.Open(); using (SQLiteCommand cmd = sqLite.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = query; return(cmd.Materialize(materializeTable).ToList()); } } }
public async Task <IActionResult> Login(LoginModel model) { Current_user = ""; if (ModelState.IsValid) { var user = new User() { Login = model.Login, Password = model.Password }; //после проверки логина и пароля -формируем строку для подключения к бд _connectionString.SetConnectionString(user); //пытаемся авторизироваться при помощи введенных логина и пароля try { var connString = _connectionString.GetConnectionString(); using (var conn = new NpgsqlConnection(connString)) { conn.Open(); using (var cmd = new NpgsqlCommand()) { cmd.Connection = conn; } conn.Close(); } await Authenticate(model.Login); // авторизация } catch (Exception ex) { //в случае ошибки авторизации ModelState.AddModelError("", "Некорректные логин и(или) пароль"); _logger.LogFatal(ex, "Некорректные логин и(или) пароль"); return(Content("Некорректные логин и(или) пароль")); } Current_user = model.Login; //даем пользователю права на работу с бд Give_Permission(); _logger.LogInfo($"User {Current_user} logged in"); return(RedirectToAction("Send", "File")); } return(View(model)); }
public static IServiceCollection AddDatabase(this IServiceCollection services, IConfiguration configuration, IConnectionString connectionString) { //var dbConnectionString = configuration.GetConnectionString("IQCareConnection"); var iqcareuri = configuration.GetSection("IQCareUri").Get <string>(); var db = connectionString.GetConnectionString(iqcareuri); _connectionString = db.Result.Replace("\"", "").Replace("Application Name=IQCare_EMR;", "").Replace("Server", "Data Source"). Replace("Type System Version=SQL Data Source 2005;", "").Replace("Database", "Initial Catalog") .Replace("Integrated Security=false;", "").Replace("packet size=4128;Min Pool Size=3;Max Pool Size=200;", ""); _connectionString = _connectionString.Replace(@"\\", @"\"); Log.Debug(_connectionString); services.AddDbContext <HtsDbContext>(b => b.UseSqlServer(_connectionString)); services.AddScoped(typeof(IHTSRepository <>), typeof(HTSRepository <>)); services.AddScoped <IHTSUnitOfWork>(c => new HTSUnitOfWork(c.GetRequiredService <HtsDbContext>())); return(services); }
public RecipeGenerator(IConnectionString connection, IUserAuth userAuth) { _connection = connection; _userAuth = userAuth; conStr = _connection.GetConnectionString(); }
public RecipeRepo(IConnectionString connection) { _connection = connection; conStr = _connection.GetConnectionString(); }
public MeasurementGenerator(IConnectionString connection, IUserAuth userAuth) { _connection = connection; _userAuth = userAuth; conStr = _connection.GetConnectionString(); }
public UserAuth(IConnectionString connection) { _connection = connection; conStr = _connection.GetConnectionString(); }
public DishRepo(IConnectionString connection, IUserAuth userAuth) { _connection = connection; _userAuth = userAuth; conStr = _connection.GetConnectionString(); }
public IActionResult Get(int id) { var connectionString = connectionStringRepository.GetConnectionString(id); return(connectionString == null?NotFound("Record not found") : (IActionResult)Ok(connectionString)); }
public IngredientRepo(IConnectionString connection, IUserAuth userAuth) { _connection = connection; _userAuth = userAuth; conStr = _connection.GetConnectionString(); }
public PokemonRaidBotDbContext(IConnectionString cstr, IStatMapper mapper) { _cstr = cstr.GetConnectionString(); _mapper = mapper; }
public UserAuth(IConnectionString connection, IUserAccessor userAccessor) { _userAccessor = userAccessor; _connection = connection; conStr = _connection.GetConnectionString(); }