public bool Consultar()
{
MySqlConnection cnn = new MySqlConnection();
conexionbd conectar = new conexionbd();
cnn = conectar.obtenerconexion();
string Consultasol = "select * from testadosol";
MySqlCommand cmd = new MySqlCommand(Consultasol, cnn);
OCommand = cmd;
// OCommand.Connection = cnn;
// OCommand.CommandText = Consultasol;
try
{
OReader = OCommand.ExecuteReader();
return(true);
}
catch (Exception ex)
{
_Error = ex.Message + "Consultar en Conexionbd.cs";
return(false);
}
}
public Boolean insertararchivo(string nombre, string ext, string contentType, byte[] imagen)
{
MySqlConnection cnn = new MySqlConnection();
conexionbd conectar = new conexionbd();
cnn = conectar.obtenerconexion();
String selectss = " insert into carga (nombre,ext,ctype,imagen) values ('" + nombre + " ','" + ext + "','" + contentType + "','" + imagen + "')";
try
{
MySqlCommand mycomand = new MySqlCommand(selectss, cnn);
mycomand.ExecuteNonQuery();
cnn.Close();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public MySqlDataReader consultarlogin(string struser, string strpass)
{
conexionbd conectar = new conexionbd();
String query = "select cod_auto,id_rol from logins where nom_usuario='" + struser + "' and pass='******' ";
MySqlCommand mycomand = new MySqlCommand(query, conectar.obtenerconexion());
MySqlDataReader myreader = mycomand.ExecuteReader();
try
{
myreader.Read();
}
catch (Exception erro)
{
// validausuario.Visible = true;
}
return(myreader);
}
public bool LlenarDataSet()
{
if (_MYSQL == "")
{
_Error = "No definio la instrucción SQL";
return(false);
}
if (_NombreTabla == "")
{
_Error = "No definio el nombre de la tabla";
return(false);
}
MySqlConnection cnn = new MySqlConnection();
conexionbd conectar = new conexionbd();
cnn = conectar.obtenerconexion();
// string Consultasol = "select * from testadosol";
string Consultasol = "SELECT Num_ticket as Ticket , nom_usr as Nombre, ape_usr as Apellido, ced_usr as Cedula,tel_usr as Telefono,placa_ve as Placa, testadosol.desc_estado as Estado , tresponsable.Nomb_resp as Responsable,fecha as Fecha_Creacion,fecUlmodificacion as Fecha_Ult_modificación from tsolicitudes inner join testadosol on testadosol.Id_estado_sol= tsolicitudes.Id_estado_sol inner join tresponsable on tresponsable.id_resp= tsolicitudes.id_resp order by fecha desc";
try
{
MySqlCommand cmd = new MySqlCommand(Consultasol, cnn);
OCommand = cmd;
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
OAdapter = da;
OAdapter.Fill(ODataSet, _NombreTabla);
return(true);
}
catch (Exception ex)
{
_Error = ex.Message + "Mamiño";
return(false);
}
}
public DataSet CargarSolicitudes(string ced, string tk, string placa, int llama)
{
MySqlConnection cnn = new MySqlConnection();
conexionbd conectar = new conexionbd();
cnn = conectar.obtenerconexion();
DataSet dt = new DataSet();
// using (SqlConnection cnn = new SqlConnection("Data Source=.;Initial Catalog=AdventureWorks2012;Integrated Security=True"))
conectar.obtenerconexion();
string Consultasol = "";
if (llama == 1)
{
Consultasol = "SELECT Num_ticket as Ticket , nom_usr as Nombre, ape_usr as Apellido, ced_usr as Cedula,tel_usr as Telefono,placa_ve as Placa, testadosol.desc_estado as Estado , tresponsable.Nomb_resp as Responsable,fecha as Fecha_Creacion,fecUlmodificacion as Fecha_Ult_modificación from tsolicitudes inner join testadosol on testadosol.Id_estado_sol= tsolicitudes.Id_estado_sol inner join tresponsable on tresponsable.id_resp= tsolicitudes.id_resp where ced_usr like'" + ced + "%' and Num_Ticket like'" + tk + "%' and placa_ve like'" + placa + "%' order by fecha desc";
}
else if (llama == 2)
{
Consultasol = "select Num_Ticket as Ticket, nom_usr as Nombre_Usuario, ape_usr as Apellido,placa_ve as Placa, tresponsable.Nomb_resp as Responsable, tsolicitudes.fecha from tsolicitudes inner join tresponsable on tsolicitudes.id_resp = tresponsable.id_resp where tsolicitudes.Id_estado_sol < 3 order by fecha desc";
}
if (llama == 3)
{
Consultasol = "select Num_Ticket as Ticket, nom_usr as Nombre_Usuario, ape_usr as Apellido,placa_ve as Placa, tresponsable.Nomb_resp as Responsable,testadosol.desc_estado as Estado_Solicitud, tsolicitudes.fecha from tsolicitudes inner join tresponsable on tsolicitudes.id_resp = tresponsable.id_resp inner join testadosol on tsolicitudes.Id_estado_sol = testadosol.Id_estado_sol order by fecha desc";
}
try
{
MySqlCommand cmd = new MySqlCommand(Consultasol, cnn);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
}
catch (Exception erro)
{
}
return(dt);
}
public DataSet llenarddl(int llama, int est)
{
MySqlConnection cnn = new MySqlConnection();
conexionbd conectar = new conexionbd();
cnn = conectar.obtenerconexion();
conectar.obtenerconexion();
string Consultasol = "";
if (llama == 2)
{
Consultasol = "select Id_estado_sol,desc_estado from testadosol ";
}
if (llama == 3)
{
Consultasol = "select Id_estado_sol,desc_estado from testadosol where Id_estado_sol='" + est + "' ";
}
DataSet dt = new DataSet();
conectar.obtenerconexion();
try
{
MySqlCommand cmd = new MySqlCommand(Consultasol, cnn);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
}
catch (Exception erro)
{
}
return(dt);
}