protected void RegisterUser(object sender, EventArgs e)
{
#region commented hardcode insert
//MySqlConnection con = new MySqlConnection();
//con.ConnectionString = "server=173.194.241.131;database=auction_powers;uid=root;pwd=root;";
//MySqlCommand cmd = null;
////add freetext to db
//con.Open();
//cmd = new MySqlCommand();
//cmd.Parameters.AddWithValue("?username", txtUsername.Text.Trim());
//cmd.Parameters.AddWithValue("?password", txtPassword.Text.Trim());
//cmd.Parameters.AddWithValue("?email", txtEmail.Text.Trim());
//cmd.Connection = con;
//cmd.CommandText = "INSERT INTO user (username, `password`, email) VALUES (?username, ?password, ?email)";
//cmd.ExecuteNonQuery();
//con.Close();
#endregion
User registering_user = new User(txtUsername.Text.Trim(), txtPassword.Text.Trim(), txtEmail.Text.Trim());
MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "server=173.194.241.131;database=auction_powers;uid=root;pwd=root;";
MySQLClient register_user = new MySQLClient(conn);
register_user.Insert_Users(registering_user);
}
public Counter(Options option, DiscordSocketClient client)
{
Client = client;
Option = option;
mySql = new MySQLClient(option.Server, option.User, option.Password);
Completed = false;
}
public void TestSelect3()
{
var ms = new MySQLClient(_conn);
List<InventoryFormat> invs = ms.Select<InventoryFormat>();
InventoryFormat inv = ms.Select<InventoryFormat>(invs.Random().ID);
Console.WriteLine(inv.Memo);
}
protected void RegisterUser(object sender, EventArgs e)
{
#region commented hardcode insert
//MySqlConnection con = new MySqlConnection();
//con.ConnectionString = "server=173.194.241.131;database=auction_powers;uid=root;pwd=root;";
//MySqlCommand cmd = null;
////add freetext to db
//con.Open();
//cmd = new MySqlCommand();
//cmd.Parameters.AddWithValue("?username", txtUsername.Text.Trim());
//cmd.Parameters.AddWithValue("?password", txtPassword.Text.Trim());
//cmd.Parameters.AddWithValue("?email", txtEmail.Text.Trim());
//cmd.Connection = con;
//cmd.CommandText = "INSERT INTO user (username, `password`, email) VALUES (?username, ?password, ?email)";
//cmd.ExecuteNonQuery();
//con.Close();
#endregion
User registering_user = new User(txtUsername.Text.Trim(), txtPassword.Text.Trim(), txtEmail.Text.Trim());
MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "server=173.194.241.131;database=auction_powers;uid=root;pwd=root;";
MySQLClient register_user = new MySQLClient(conn);
register_user.Insert_Users(registering_user);
}
public string CheckLan()
{
try
{
var client = new MySQLClient(ip, db, user, pass, Convert.ToInt32(port));
lan = client.Select("realmlist", "id='1'")["address"];
if (UnitTestDetector.IsInUnitTest)
{
return(lan);
}
if (lan == "127.0.0.1")
{
cbCh.Text = "Offline";
txbLanip.Text = "127.0.0.1";
}
else if (lan == Convert.ToString(LocalIPAddress()))
{
cbCh.Text = "Lan";
txbLanip.Text = lan;
}
else if (lan == GetPublic.IP())
{
cbCh.Text = "Internet";
txbLanip.Text = GetPublic.IP();
}
}
catch (Exception)
{
}
return(lan);
}
public void TestSelect2()
{
var ms = new MySQLClient(_conn);
List<Product> products = ms.Select<Product>();
Product product = ms.Select<Product>(products.Random().ID);
Console.WriteLine(product.Name);
}
private void verificarBase(string usuario, string senha, string servidor, string baseDados)
{
MySQLClient mySQLClient = new MySQLClient(servidor, baseDados, usuario, senha);
if (!mySQLClient.DatabaseExists())
{
logger.Warn(ThreadPrincipal.Name + " - base inexistente, tentando criar nova base.");
if (mySQLClient.CreateDatabase())
{
logger.Info(ThreadPrincipal.Name + " - base criada com sucesso.");
if (mySQLClient.FillUpDatabase())
{
logger.Info(threadPrincipal.Name + " - base preenchida com sucesso.");
}
else
{
logger.Error(threadPrincipal.Name + " - Problema ao preencher a base de dados");
}
}
else
{
logger.Error(ThreadPrincipal.Name + " - Problema ao criar base.");
}
}
else
{
logger.Info(ThreadPrincipal.Name + " - base encontrada, utilizando a existente.");
}
}
public void TestInsert()
{
var ms = new MySQLClient(_conn);
var product = new Product() { Name = "new" };
string id = ms.Insert<Product>(product);
Console.WriteLine(id);
product = ms.Select<Product>(id);
Assert.IsNotNull(product);
}
public void TestUpdate0()
{
var ms = new MySQLClient(_conn);
List<Product> products = ms.Select<Product>();
Product product = products.Random();
string name = "some";
string id = ms.Update<Product>(product.ID, nameof(product.Name), name);
Console.WriteLine(id);
product = ms.Select<Product>(id);
Assert.AreEqual(product.Name, name);
}
private void processarChecagem(string usuario, string senha, string servidor, string baseDados)
{
MySQLClient mySQLClient = new MySQLClient(servidor, baseDados, usuario, senha);
List <int> temperaturas = new List <int>();
DataTable dataTable = mySQLClient.Select("BancoCircuitoMaxTemp", "BancoNumero>0");
string rowData = "[";
double valueDouble;
float value;
foreach (DataRow row in dataTable.Rows)
{
// obter a temperatura
rowData += row[1];
if (Double.TryParse(row[1].ToString(), out valueDouble))
{
value = (float)valueDouble;
if (float.IsPositiveInfinity(value))
{
value = float.MaxValue;
}
else if (float.IsNegativeInfinity(value))
{
value = float.MinValue;
}
int[] values = Tools.IEEE754.GetBytesSingle(true, value);
temperaturas.Add(values[0]);
temperaturas.Add(values[1]);
}
// Não é o último
if (dataTable.Rows[dataTable.Rows.Count - 1] != row)
{
rowData += "|";
}
}
rowData += "]";
if (temperaturas.Count > 0)
{
escreverModBus(temperaturas);
}
logger.Info("Temperaturas Acessadas da base: " + rowData);
}
public MessageMonitor(DiscordSocketClient cli, Options options)
{
client = cli;
mysql = new MySQLClient(options);
}
public void UpdateSql()
{
var client = new MySQLClient(ip, db, user, pass, Convert.ToInt32(port));
client.Update("realmlist", "address='" + txbLanip.Text + "'", "id='1'");
}
public void TestDelete1()
{
var ms = new MySQLClient(_conn);
List<Employee> employees = ms.Select<Employee>();
Employee employee = employees.Random();
ms.Delete<Employee>(employee.ID);
employee = ms.Select<Employee>(employee.ID);
Assert.IsNull(employee);
}
public void TestSelect()
{
var ms = new MySQLClient(_conn);
List<Product> products = ms.Select<Product>();
products.ForEach(x => Console.WriteLine(x.Name));
}
public void TestDelete2()
{
var ms = new MySQLClient(_conn);
List<Maker> makers = ms.Select<Maker>();
Maker maker = makers.Random();
ms.Delete<Maker>(maker.ID);
maker = ms.Select<Maker>(maker.ID);
Assert.IsNull(maker);
}
internal ObservableInventoryManager(MySQLClient _db)
{
this._db = _db;
Load();
}
public void TestDelete0()
{
var ms = new MySQLClient(_conn);
List<Product> products = ms.Select<Product>();
Product product = products.Random();
ms.Delete<Product>(product.ID);
product = ms.Select<Product>(product.ID);
Assert.IsNull(product);
}
