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();
}
