public static IDatabase GetDatabase(EnumDatabaseType sTypeConnection, string sConnectionString)
{
IDatabase oReturnDatabase = null;
switch (sTypeConnection)
{
case EnumDatabaseType.SqlServer:
oReturnDatabase = new DatabaseSqlServer(sConnectionString);
break;
case EnumDatabaseType.Oracle:
oReturnDatabase = new DatabaseOracle(sConnectionString);
break;
case EnumDatabaseType.MySQL:
oReturnDatabase = new DatabaseMySQL(sConnectionString);
break;
case EnumDatabaseType.SQLite:
oReturnDatabase = new DatabaseSQLite(sConnectionString);
break;
default:
oReturnDatabase = null;
break;
}
return(oReturnDatabase);
}
public bool checkLogin(string _username, string _password)
{
int Count = 0;
var connect = DatabaseMySQL.GetProvider().GetConnection;
connect.Open();
var command = new MySql.Data.MySqlClient.MySqlCommand("SELECT * FROM users WHERE username = '******' and password = '******'", connect);
var reader = command.ExecuteReader();
while (reader.Read())
{
Count++;
}
connect.Close();
if (Count == 1)
{
return(true);
}
else
{
return(false);
}
}
public static DataSet SQLExec(string sql)
{
DataSet sql_CommonDS = new DataSet();
DatabaseMySQL sql_Common = new DatabaseMySQL();
sql_CommonDS = sql_Common.getDataSet(sql);
return(sql_CommonDS);
}
public void modify(string _id, string _username, string _password)
{
var connect = DatabaseMySQL.GetProvider().GetConnection;
connect.Open();
var command = new MySql.Data.MySqlClient.MySqlCommand("UPDATE users SET [username]='" + _username + "',[password]='" + _password + "' WHERE [id]= '" + _id + "'", connect);
command.ExecuteNonQuery();
connect.Close();
}
public void delete(string _username)
{
var connect = DatabaseMySQL.GetProvider().GetConnection;
connect.Open();
var command = new MySql.Data.MySqlClient.MySqlCommand("DELETE FROM users WHERE username = '******'", connect);
command.ExecuteNonQuery();
connect.Close();
}
public void create(string _username, string _password)
{
var connect = DatabaseMySQL.GetProvider().GetConnection;
connect.Open();
var command = new MySql.Data.MySqlClient.MySqlCommand("INSERT INTO users ([username],[password]) VALUES ('" + _username + "','" + _password + "')", connect);
command.ExecuteNonQuery();
connect.Close();
}
public System.Data.DataTable load()
{
var connect = DatabaseMySQL.GetProvider().GetConnection;
connect.Open();
var command = new MySql.Data.MySqlClient.MySqlCommand("SELECT * FROM users", connect);
var adaper = new MySql.Data.MySqlClient.MySqlDataAdapter(command);
var table = new System.Data.DataTable();
adaper.Fill(table);
connect.Close();
return(table);
}
public static bool testConnection()
{
var MySqlConnect = DatabaseMySQL.GetProvider().GetConnection;
MySqlConnect.Open();
if (MySqlConnect.State == ConnectionState.Open)
{
MySqlConnect.Close();
return(true);
}
else
{
MySqlConnect.Close();
return(false);
}
}
public static DataSet SQLExec(string sql)
{
DataSet sql_CommonDS = new DataSet();
DatabaseMySQL sql_Common = new DatabaseMySQL();
sql_CommonDS = sql_Common.getDataSet(sql);
return sql_CommonDS;
}
