/// <summary>
/// Renvoie une chaine de connexion
/// </summary>
/// <param name="mars">Indique si la connexion doit accepter les jeux de résultats actifs multiples (Multiple Active Result Set)</param>
/// <exception cref="ArgumentException"></exception>
/// <exception cref="InvalidOperationException"></exception>
/// <returns>une connexion ouverte</returns>
public SqlConnection GetOpenConnection(string customConnectionString, bool mars)
{
if (!mars)
{
return(GetOpenConnection(customConnectionString));
}
var scsb = factory.CreateConnectionStringBuilder();
try
{
scsb.ConnectionString = string.IsNullOrWhiteSpace(customConnectionString) ? GetConnectionString() : customConnectionString;
((dynamic)scsb).MultipleActiveResultSets = true;
}
catch (Exception ex)
{
throw new ArgumentException("Creation connexion failed", ex);
}
var conn = (SqlConnection)factory.CreateConnection();
conn.ConnectionString = scsb.ConnectionString;
try
{
conn.Open();
return(conn);
}
catch (Exception ex2)
{
throw new InvalidOperationException("Opening connexion (Multiple Active Result Set) Fail", ex2);
}
}
private DbConnection CreateDbConnection()
{
var dbConnection = _sqlClientFactory.CreateConnection();
dbConnection.ConnectionString = _dbConnectionString;
return(dbConnection);
}
public User Get(string login, string password)
{
var factory = new SqlClientFactory();
using (var connection = factory.CreateConnection())
{
var command = factory.CreateCommand();
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = "select * from tb_user where login =@login and password=@password";
command.Parameters.Add(new SqlParameter("@login", login));
command.Parameters.Add(new SqlParameter("@password", password));
try
{
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
var objUser = GetFromReader(reader);
return(objUser);
}
return(null);
}
catch
{
return(null);
}
}
}
static DbConnection CreateDbConnection(string dbConnectionString)
{
var dbConnection = sqlClientFactory.CreateConnection();
dbConnection.ConnectionString = dbConnectionString;
return(dbConnection);
}
private DbConnection CreateDbConnection()
{
var dbConnection = sqlClientFactory.CreateConnection();
dbConnection.ConnectionString = @"Data Source=(localdb)\ProjectsV13;Initial Catalog=MovieDb;Integrated Security=True;TrustServerCertificate=True;";
return(dbConnection);
}
/**/
private bool mensajeError = true;
public bool MensajeError {
get { return(mensajeError); }
set { mensajeError = value; }
}
/**/
public DatabaseHelper(string connectionstring, Providers provider)
{
strConnectionString = connectionstring;
switch (provider)
{
case Providers.SqlServer:
objFactory = SqlClientFactory.Instance;
break;
case Providers.ConfigDefined:
string providername = ConfigurationManager.ConnectionStrings["DGP_cs"].ProviderName;
switch (providername)
{
case "System.Data.SqlClient":
objFactory = SqlClientFactory.Instance;
break;
}
break;
}
objConnection = (SqlConnection)objFactory.CreateConnection();
objCommand = (SqlCommand)objFactory.CreateCommand();
objConnection.ConnectionString = strConnectionString;
objCommand.Connection = objConnection;
}
private void MainForm_Load(object sender, EventArgs e)
{
SqlClientFactory factory = SqlClientFactory.Instance;
DbConnection connection = factory.CreateConnection();
DbCommand command = factory.CreateCommand();
command.Connection = connection;
command.CommandText = "query here";
command.ExecuteNonQuery();
}
public IDbConnection Create()
{
IDbConnection connection = provider.CreateConnection();
if (connection == null)
{
throw new KeyNotFoundException(
$"Failed to create a connection using the connection string named '{nameof(connectionString)}' in Data/web.config.");
}
connection.ConnectionString = connectionString;
return(connection);
}
public User Create(User user)
{
try
{
var command = "STP_Register_User";
using (var conn = factory.CreateConnection())
{
var parameters = new DynamicParameters();
parameters.Add("@NAME", user.Name, DbType.String, ParameterDirection.Input);
parameters.Add("@EMAIL", user.Email, DbType.String, ParameterDirection.Input);
parameters.Add("@LOGIN", user.Login, DbType.String, ParameterDirection.Input);
parameters.Add("@PASSWORD", user.Password, DbType.String, ParameterDirection.Input);
var result = conn.Query <User>(command, parameters, commandType: CommandType.StoredProcedure).AsList().FirstOrDefault();
return(result);
}
}
catch
{
return(null);
}
}
/// <summary>
/// Creates the connection.
/// </summary>
/// <returns></returns>
public override IDbConnection CreateConnection()
{
return(sqlClientFactory.CreateConnection());
}
public DataAccess(SqlClientFactory sQLClientFactory, ApplicationSettings applicationSettings)
{
Connection = sQLClientFactory.CreateConnection();
Connection.ConnectionString = applicationSettings.ConnectionString;
}
