public IActionResult Main()
{
ViewBag.LogErrors = new List <string>();
string email = HttpContext.Session.GetString("userpass");
if (email == null)
{
ViewBag.LogErrors.Add("You need to log in first");
TempData["LogErrors"] = ViewBag.LogErrors;
return(RedirectToAction("Index"));
}
else
{
ViewBag.MessageErrors = TempData["MessageErrors"];
ViewBag.CommentErrors = TempData["CommentErrors"];
if (ViewBag.MessageErrors == null)
{
ViewBag.MessageErrors = new List <string>();
}
if (ViewBag.CommentErrors == null)
{
ViewBag.CommentErrors = new List <string>();
}
string selectQuery = $"SELECT id FROM users WHERE email = '{email}'";
var younow = MySqlConnector.Query(selectQuery);
string selectMessages = $"SELECT users.firstName AS firstName,users.LastName AS lastName,messages.id AS id,messages.message AS message, messages.user_id AS message_user_id, messages.created_at AS created_at,messages.updated_at AS updated_at FROM users JOIN messages ON users.id = messages.user_id";
string selectComments = $"SELECT users.firstName AS user_firstName,users.LastName AS user_lastName,messages.id AS message_id,messages.message AS message, messages.user_id AS message_user_id,messages.created_at AS message_created_at,messages.updated_at AS message_updated_at,comments.id AS comment_id,comments.comment AS comment, comments.message_id AS comment_message_id,comments.user_id AS comment_user_id, comments.created_at AS comment_created_at,comments.updated_at AS comment_updated_at FROM users JOIN comments ON users.id = comments.user_id JOIN messages ON comments.message_id = messages.id";
var messages = MySqlConnector.Query(selectMessages);
var comments = MySqlConnector.Query(selectComments);
ViewBag.userid = (int)younow[0]["id"];
ViewBag.MessageList = messages;
ViewBag.CommentList = comments;
return(View("Main"));
}
}
public IActionResult quotes()
{
var allQuotes = MySqlConnector.Query("SELECT * FROM comments");
ViewBag.quotes = allQuotes;
return(View("quotes"));
}
public static UserAccount Create(string username, string password, bool admin)
{
string role = (admin ? "admin" : "user");
if (username.Length > 16 || string.IsNullOrEmpty(password))
{
return(null);
}
if (Find(username) != null)
{
return(null);
}
MySqlConnection connection = MySqlConnector.GetConnection();
if (connection != null)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `users` VALUES(NULL, @username, @password, NOW(), NOW(), @role)", connection);
command.Prepare();
command.Parameters.AddWithValue("@username", username);
command.Parameters.AddWithValue("@password", Hash(password));
command.Parameters.AddWithValue("@role", role);
command.ExecuteReader();
connection.Close();
return(Find(username));
}
return(null);
}
public ActionResult Post(string tablename, [FromBody] object value)
{
ActionResult result = null;
try
{
JArray array = (JArray)value;
MySqlConnector connector = new MySqlConnector(_connectionString);
foreach (JObject jObject in array.Children())
{
Dictionary <string, string> updateSet = GetValues(jObject);
connector.InsertSingleRecord(tablename, updateSet);
}
result = NoContent();
}
catch (Exception ex)
{
result = StatusCode(500, new { Error = ex.Message });
}
return(result);
}
public bool Exists(string name)
{
bool retVal = false;
MySqlConnection connection = MySqlConnector.GetConnection();
if (connection != null)
{
MySqlCommand command = new MySqlCommand("SELECT `id` FROM `channels` WHERE `channel_name`=@channel_name ORDER BY `id` ASC LIMIT 1", connection);
command.Prepare();
command.Parameters.AddWithValue("@channel_name", name);
try
{
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
retVal = true;
}
}
catch
{
Console.WriteLine("channels table: could not SELECT " + name);
}
connection.Close();
}
return(retVal);
}
public IActionResult CreateQuote(string author, string content)
{
string query = $"INSERT INTO quotes (content, author, created_at, updated_at) VALUES ('{content}', '{author}', NOW(), NOW())";
MySqlConnector.Execute(query);
return(RedirectToAction("Quotes"));
}
public static MySqlProviderAdapter GetInstance(string name)
{
if (name == ProviderName.MySqlConnector)
{
if (_mysqlConnectorInstance == null)
{
lock (_mysqlConnectorSyncRoot)
if (_mysqlConnectorInstance == null)
{
_mysqlConnectorInstance = MySqlConnector.CreateAdapter();
}
}
return(_mysqlConnectorInstance);
}
else
{
if (_mysqlDataInstance == null)
{
lock (_mysqlDataSyncRoot)
if (_mysqlDataInstance == null)
{
_mysqlDataInstance = MySqlData.CreateAdapter();
}
}
return(_mysqlDataInstance);
}
}
public void Store(TalkyChannel channel, bool writeToDB)
{
lock (_lock)
{
_channels.Add(channel);
string lobbyString = (channel is LobbyChannel ? "true" : "false");
string lockedString = (channel.Locked ? "true" : "false");
if (true == writeToDB)
{
MySqlConnection connection = MySqlConnector.GetConnection();
if (connection != null)
{
MySqlCommand command = new MySqlCommand("INSERT INTO `channels` VALUES(NULL, @channel_name, @lobby_type, @locked)", connection);
command.Prepare();
command.Parameters.AddWithValue("@channel_name", channel.Name);
command.Parameters.AddWithValue("@lobby_type", lobbyString);
command.Parameters.AddWithValue("@locked", lockedString);
try
{
command.ExecuteReader();
}
catch
{
Console.WriteLine("channels table: could not INSERT " + channel.Name);
}
connection.Close();
}
}
}
}
/// <summary>
/// Load all tables list for the connection (oracle does not apply)
/// </summary>
/// <returns>List for all tables name</returns>
public List <string> initAllTable(string scheme)
{
List <string> schemes = new List <string>();
try
{
// An attempt to perform a database operation is considered incorrect if an exception is thrown
if (DATABASE_TYPE == DataBaseType.MySql)
{
MySqlConnector connector = MySqlConnector.GetInstance(IP, PORT, USER_NAME, PASSWORD, scheme);
DataTable tb = connector.ExecuteDataTable(Database.MYSQL_ALL_TABLES_SCRIPT);
for (int i = 0; i < tb.Rows.Count; i++)
{
schemes.Add(tb.Rows[i][0].ToString());
}
}
else if (DATABASE_TYPE == DataBaseType.SqlServer)
{
// unsupport
}
else if (DATABASE_TYPE == DataBaseType.Oracle)
{
// unsupport
}
else
{
// unknow database, return the false
}
} catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.Message);
}
return(schemes);
}
public IActionResult Index()
{
var allNotes = MySqlConnector.Query("SELECT * FROM notes");
ViewBag.allNotes = allNotes;
return(View());
}
protected void Page_Load(object sender, EventArgs e)
{
string _UserRut = HttpContext.Current.Session["_UserRut"].ToString();
DataTable dt = new DataTable();
MySqlConnector mysql = new MySqlConnector();
mysql.ConnectionString = HttpContext.Current.Session["cnString"].ToString();
mysql.AddProcedure("GetEmpresaByRut");
mysql
.AddParameter("_UserRut", _UserRut);
// string x = mysql.ExecQuery().ToJson();
dt = mysql.ExecQuery().ToDataTable();
DropEmpresa.DataTextField = "RAZON_SOCIAL";
DropEmpresa.DataValueField = "ID_EMP";
DropEmpresa.DataSource = dt;
DropEmpresa.DataBind();
/*
* DropAmbiente.Items.Insert(0,new ListItem("Certificacion", "CERT"));
* DropAmbiente.Items.Insert(1, new ListItem("Produccion", "PROD"));*/
}
/// <summary>
/// Check if the current connection information is connected
/// </summary>
/// <param name="ip">Ip address</param>
/// <param name="port">Port</param>
/// <param name="userName">User name</param>
/// <param name="password">Password</param>
/// <param name="dbType">Type of DataBaseType</param>
/// <returns>Returns true if it can connect, otherwise returns false</returns>
public bool connect()
{
try
{
// An attempt to perform a database operation is considered incorrect if an exception is thrown
if (DATABASE_TYPE == DataBaseType.MySql)
{
MySqlConnector connector = MySqlConnector.GetInstance(IP, PORT, USER_NAME, PASSWORD, "");
DataTable tb = connector.ExecuteDataTable(Database.MYSQL_ALL_DATABASE_SCRIPT);
tb.Rows[0]["Database"].ToString();
}
else if (DATABASE_TYPE == DataBaseType.SqlServer)
{
SqlServerConnector connector = SqlServerConnector.GetInstance(IP, USER_NAME, PASSWORD, "");
DataTable tb = connector.ExecuteDataTable(Database.SQLSERVER_ALL_TABLE_SCRIPT);
tb.Rows[0]["NAME"].ToString();
}
else if (DATABASE_TYPE == DataBaseType.Oracle)
{
OracleConnector connector = OracleConnector.GetInstance(IP, USER_NAME, PASSWORD);
DataTable tb = connector.ExecuteDataTable(Database.ORACLE_ALL_USER_SCRIPT);
tb.Rows[0][0].ToString();
}
else
{
// unknow database, return the false
return(false);
}
}
catch
{
return(false);
}
return(true);
}
public void GetViews()
{
MySqlConnector connector = new MySqlConnector(this.config);
var views = connector.GetViews("sakila").Result.ToList();
CollectionAssert.Contains(views, "actor_info");
}
public void GetTables()
{
MySqlConnector connector = new MySqlConnector(this.config);
var tables = connector.GetTables("sakila").Result.ToList();
CollectionAssert.Contains(tables, "actor");
}
public void GetDatabases()
{
MySqlConnector connector = new MySqlConnector(this.config);
var databases = connector.GetDatabases().Result.ToList();
CollectionAssert.Contains(databases, "sakila");
}
public MainViewModel()
{
SendCmd = new SendCmd(this);
dbConnector = new MySqlConnector();
Users = dbConnector.GetAllUsers();
}
protected void Login_Click(object sender, EventArgs e)
{
string _rut = string.Empty;
string _pass = string.Empty;
_rut = rut.Value;
_pass = inputPassword.Value;
DataTable dt = new DataTable();
MySqlConnector mysql = new MySqlConnector();
Session.Clear();
HttpContext.Current.Session["cnString"] = cnString;
mysql.ConnectionString = HttpContext.Current.Session["cnString"].ToString();
mysql.AddProcedure("Login");
mysql
.AddParameter("Rut", _rut)
.AddParameter("Contrasenia", _pass);
dt = mysql.ExecQuery().ToDataTable();
if (dt.Rows[0][0].ToString() == "FALSE")
{
Response.Redirect("Login.aspx");
}
else
{
HttpContext.Current.Session["_UserRut"] = _rut;
}
Response.Redirect("SeleccionEmpresa.aspx");
}
public IActionResult addUser(string firstName, string lastName, int?age, string email, string password, string pw_confirm)
{
ViewBag.Errors = new List <string>();
if (firstName == null || firstName.Length < 4)
{
ViewBag.Errors.Add("First name field has to have at least 4 characters.");
}
if (lastName == null || lastName.Length < 4)
{
ViewBag.Errors.Add("Last name field has to have at least 4 characters.");
}
if (age == null)
{
ViewBag.Errors.Add("You have to provide your age.");
}
if (email == null)
{
ViewBag.Errors.Add("You have to provide an e-mail address");
}
else
{
if (isValidEmail(email) == false)
{
ViewBag.Errors.Add("The email format provided is not correct");
}
}
if (password == null || password.Length < 8)
{
ViewBag.Errors.Add("You have to provide a password");
}
if (pw_confirm == null || pw_confirm != password)
{
ViewBag.Errors.Add("Password and password confirmation do not match");
}
if (ViewBag.Errors.Count > 0)
{
TempData["Errors"] = ViewBag.Errors;
return(RedirectToAction("Index"));
}
else
{
string selectQuery = $"SELECT * FROM users WHERE email = '{email}'";
var emailVal = MySqlConnector.Query(selectQuery);
if (emailVal.Count > 0)
{
ViewBag.Errors.Add("This e-mail already belongs to a registered user");
TempData["Errors"] = ViewBag.Errors;
return(RedirectToAction("Index"));
}
else
{
string rightNow = DateTime.Now.ToString("yyyyMMddHHmmss");
string query = $"INSERT INTO users (firstName,lastName,age,email,password,created_at,updated_at) VALUES ('{firstName}','{lastName}','{age}','{email}','{password}',{rightNow},{rightNow})";
MySqlConnector.Execute(query);
HttpContext.Session.SetString("userpass", (string)email);
return(RedirectToAction("Index"));
}
}
}
public IActionResult quote()
{
string query = "SELECT * FROM quotes";
var quotes = MySqlConnector.Query(query);
ViewBag.quotes = quotes;
return(View("quotes"));
}
public async Task <IActionResult> Get()
{
// IEnumerable<Product> result = await _productService.GetProducts();
MySqlConnector conn = new MySqlConnector();
List <Sales> list = conn.GetSalesData();
return(Ok(list));
}
public void Ping()
{
MySqlConnector sql = new MySqlConnector();
sql.LoadConfig("IASERVER");
string query = @"UPDATE `aoidata`.`maquina` SET `ping` = NOW() WHERE `id` = " + mysql_id + " LIMIT 1;";
DataTable sp = sql.Query(query);
}
private Response SavePfx(structCertificadoDigital certificadoDigital)
{
Response r = new Response();
try
{
//paso 1 verificamos que el certificado y la password sean validos
byte[] Cert = System.Convert.FromBase64String(certificadoDigital.Base64);
bool _PASSWORD_OK = Utilities.VerifyPassword(Cert, certificadoDigital.Password);
//paso 2 si la password del certificado es ok seguimos con el proceso
if (_PASSWORD_OK == true)
{
string RutaCertificado = WebConfigurationManager.AppSettings["Certificados"];
//RutaCertificado = RutaCertificado + certificadoDigital.RutEmpresa+".pfx";
//creamos la carpeta de la empresa utilizando el rut de la empresa como nombre
String rutaGuardado = RutaCertificado + certificadoDigital.RutEmpresa + "\\" + certificadoDigital.RutEmpresa + ".pfx";
MySqlConnector mysql = new MySqlConnector();
mysql.ConnectionString = WebConfigurationManager.ConnectionStrings["MySqlProvider"].ConnectionString;
mysql.AddProcedure("sp_ins_certificado_digital");
mysql.
AddParameter("rutEmpresa", certificadoDigital.RutEmpresa)
.AddParameter("Pwd", Utilities.Encryption(certificadoDigital.Password))
.AddParameter("Path", rutaGuardado)
.AddParameter("TypeFile", certificadoDigital.TypeFile);
DataTable dt = new DataTable();
dt = mysql.ExecQuery().ToDataTable();
if (dt.Rows[0]["InsertStatus"].ToString() == "OK")
{
Directory.CreateDirectory(RutaCertificado + certificadoDigital.RutEmpresa);
File.WriteAllBytes(rutaGuardado, Convert.FromBase64String(certificadoDigital.Base64));
}
r.code = Code.OK;
r.type = Type.text;
r.ObjectResponse = "Se ha ingresado el certificado correctamente!";
}
else
{
r.code = Code.ERROR;
r.type = Type.text;
r.ObjectResponse = "La contraseña ingresada no es valida!";
}
return(r);
}
catch (Exception ex)
{
r.code = Code.ERROR;
r.type = Type.text;
r.ObjectResponse = ex.ToString();
return(r);
}
}
public static string sel_unidadmedida()
{
MySqlConnector mysql = new MySqlConnector();
mysql.ConnectionString = HttpContext.Current.Session["cnString"].ToString();
mysql.AddProcedure("sp_sel_unidadmedida");
return(mysql.ExecQuery().ToJson());
}
public IActionResult Register(User user)
{
if (ModelState.IsValid)
{
MySqlConnector.Execute($"INSERT INTO logregusers (first_name, last_name, email, password, created_at, updated_at) VALUES ('{user.firstName}', '{user.lastName}', '{user.email}', '{user.password}', NOW(), NOW())");
return(View("success"));
}
return(View("index"));
}
static void Main(string[] args)
{
var sql = new MySqlConnector("Server=localhost;Database=timelinelogger;Uid=root;Pwd=qL26^N6lp&WU2#a3in#9%qOG$Y^sQ^uO");
Console.WriteLine("Please enter Your MySql statement");
var queryString = Console.ReadLine();
sql.QueryDB(queryString);
Console.ReadKey();
}
public IActionResult Quotes()
{
string query = "SELECT * FROM quotes";
var quotes = MySqlConnector.Query(query);
ViewBag.Quotes = quotes;
Console.WriteLine("test");
Console.WriteLine(ViewBag.Quotes);
return(View());
}
public void MySqlExecuteQueryTest()
{
var sqlhelper = new Initializer();
Connector mySqlConnector = new MySqlConnector("Server=127.0.0.1;Database=dboptimove;Uid=astro;Pwd=1qazxc;Allow Zero Datetime=False;Convert Zero Datetime=True");
var dt = (System.Data.DataTable)sqlhelper.ExecuteQuery("SELECT * FROM promotions;", mySqlConnector);
Assert.IsNotNull(dt);
//Assert.AreEqual(2, dt.Rows.Count);
}
public static string GetReceptorByRut(string RutReceptor)
{
MySqlConnector mysql = new MySqlConnector();
mysql.ConnectionString = HttpContext.Current.Session["cnString"].ToString();
mysql.AddProcedure("sp_sel_receptorByRut");
mysql.AddParameter("RutReceptor", RutReceptor);
return(mysql.ExecQuery().ToJson());
}
public static string GetProductoByIdDte(string IdDte)
{
MySqlConnector mysql = new MySqlConnector();
mysql.ConnectionString = HttpContext.Current.Session["cnString"].ToString();
mysql.AddProcedure("sp_sel_detalle_productoByIdDte");
mysql.AddParameter("IdDte", IdDte);
return(mysql.ExecQuery().ToJson());
}
public static string GetRegion(string json)
{
//sp_sel_comuna
MySqlConnector mysql = new MySqlConnector();
mysql.ConnectionString = HttpContext.Current.Session["cnString"].ToString();
mysql.AddProcedure("sp_sel_region");
mysql.ParametersFromJson(json);
return(mysql.ExecQuery().ToJson());
}
private void connectdatabase_Click(object sender, EventArgs e)
{
try
{
connector = new MySqlConnector("127.0.0.1", "robottesting", "root", "");
}
catch (Exception er)
{
Console.WriteLine(er.Message);
}
}
public Form1(string version, bool restartWhenDone)
{
status = Status.Connecting;
allowedToClose = false;
currentGameVersion = version;
connector = null;
fileList = new DataTable();
receivedSize = 0;
restart = restartWhenDone;
InitializeComponent();
UpdateProgress();
Shown += Form1_Shown;
}
bool OpenMysqlConnection()
{
try
{
connector = new MySqlConnector(connectionString);
connector.OpenConnection();
return true;
}
catch (Exception e)
{
Console.WriteLine("Error: {0}", e.ToString());
return false;
}
}
