private void populatingForm() //of Supplier Details form
{
while (rdr.Read())
{
txtSuppID.Text = rdr.GetString(0);
txtSuppName.Text = rdr.GetString(1);
txtSuppAddress.Text = rdr.GetString(2);
txtSuppPhone1.Text = rdr.GetString(3);
txtSuppPhone2.Text = rdr.GetString(4);
txtSuppMobile1.Text = rdr.GetString(5);
txtSuppMobile2.Text = rdr.GetString(6);
if (rdr.GetChar(7) == 'M')
{
comboBoxSuppGender.Text = "Male";
}
else if (rdr.GetChar(7) == 'F')
{
comboBoxSuppGender.Text = "Female";
}
else
{
comboBoxSuppGender.Text = "";
}
txtSuppEmail1.Text = rdr.GetString(8);
txtSuppEmail2.Text = rdr.GetString(9);
txtSuppRemarks.Text = rdr.GetString(10);
}
}
public List <Tilmeldinger> readList()
{
List <Tilmeldinger> tilmeldingerList = new List <Tilmeldinger>();
openConnection();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connection;
cmd.CommandText = string.Format("select arrangementId, brugerId, createTs, erTilmeldt, spiser from Tilmeldinger");
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Tilmeldinger tilmeldinger = new Tilmeldinger();
tilmeldinger.arrangementId = reader.GetInt64("arrangementId");
tilmeldinger.brugerId = reader.GetString("brugerId");
tilmeldinger.createTs = reader.GetDateTime("createTs");
tilmeldinger.erTilmeldtChar = reader.GetChar("erTilmeldt");
tilmeldinger.spiserChar = reader.GetChar("spiser");
tilmeldingerList.Add(tilmeldinger);
}
closeConnection();
return(tilmeldingerList);
}
private void populatingForm()
{
while (rdr.Read())
{
txtCustID.Text = rdr.GetString(0);
txtCustName.Text = rdr.GetString(1);
txtCustAddress.Text = rdr.GetString(2);
txtCustShippingAddress.Text = rdr.GetString(3);
txtCustPhone1.Text = rdr.GetString(4);
txtCustPhone2.Text = rdr.GetString(5);
txtCustMobile1.Text = rdr.GetString(6);
txtCustMobile2.Text = rdr.GetString(7);
if (rdr.GetChar(8) == 'M')
{
comboBoxCustGender.Text = "Male";
}
else if (rdr.GetChar(8) == 'F')
{
comboBoxCustGender.Text = "Female";
}
else
{
comboBoxCustGender.Text = "";
}
txtCustEmail1.Text = rdr.GetString(9);
txtCustEmail2.Text = rdr.GetString(10);
dateTimePickerCustDOB.Value = rdr.GetDateTime(11);
txtCustRemarks.Text = rdr.GetString(12);
}
}
public void getUser(string brugerId)
{
openConnection();
cmd.CommandText = string.Format("select brugerId, createTs, password, salt, email, prim, erAdmin from users where brugerId = '{0}'", brugerId);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
this.brugerId = reader.GetString("brugerId");
this.createTs = reader.GetDateTime("createTs");
this.password = reader.GetString("password");
this.salt = reader.GetString("salt");
this.email = reader.GetString("email");
this.primChar = reader.GetChar("prim");
this.erAdminChar = reader.GetChar("erAdmin");
}
else
{
this.brugerId = "";
// ToDo: clear class properties
}
closeConnection();
}
public Dictionary <Speler, Deelname> GetSpelersAndDeelnames(int ecode)
{
Dictionary <Speler, Deelname> Deelnames = new Dictionary <Speler, Deelname>();
try
{
conn.Open();
string selectQuery = @"SELECT * FROM deelname d JOIN inschrijving i on d.volgnummer = i.volgnummer and d.e_code = i.e_code JOIN speler s on i.p_code = s.p_code WHERE d.e_code = @ecode;";
MySqlCommand cmd = new MySqlCommand(selectQuery, conn);
MySqlParameter EcodeParam = new MySqlParameter("@ecode", MySqlDbType.Int32);
EcodeParam.Value = ecode;
cmd.Parameters.Add(EcodeParam);
MySqlDataReader dataReader = cmd.ExecuteReader();
ToernooiController TC = new ToernooiController();
while (dataReader.Read())
{
int p_code = dataReader.GetInt32("p_code");
string roepnaam = dataReader.GetString("roepnaam");
string voorletters = dataReader.GetString("voorletters");
string tussenvoegsels = dataReader[3] as string;
string achternaam = dataReader.GetString("achternaam");
char geslacht = dataReader.GetChar("geslacht");
string postcode = dataReader.GetString("postcode");
string straat = dataReader.GetString("straat");
int huisnummer = dataReader.GetInt32("huisnummer");
string woonplaats = dataReader.GetString("woonplaats");
string emailadres = dataReader.GetString("emailadres");
string IBAN_nummer = dataReader.GetString("IBAN_nummer");
int rating = dataReader.GetInt32("rating");
bool staat_op_blacklist = dataReader.GetChar("staat_op_blacklist") == 'J';
int e_code = dataReader.GetInt32("e_code");
int volgnummer = dataReader.GetInt32("volgnummer");
int rondenr = dataReader.GetInt32("ronde_nr");
bool doetnogmee = dataReader.GetString("doet_nog_mee") == "J";
int tafelnummer = dataReader.GetInt32("tafelnummer");
Speler s = new Speler(p_code, roepnaam, voorletters, tussenvoegsels, achternaam, geslacht, postcode, straat, huisnummer, woonplaats, emailadres, IBAN_nummer, rating, staat_op_blacklist);
Deelname d = new Deelname(e_code, volgnummer, rondenr, doetnogmee, tafelnummer);
Deelnames.Add(s, d);
}
}
catch (Exception ex)
{
Console.WriteLine("Ophalen van bekende locaties mislukt" + ex);
}
finally
{
conn.Close();
}
return(Deelnames);
}
public Dictionary <Speler, Inschrijving> GetSpelersAndVolgnummers(int ecode)
{
Dictionary <Speler, Inschrijving> SpelersVolgnummers = new Dictionary <Speler, Inschrijving>();
try
{
conn.Open();
string selectQuery = @"SELECT * FROM inschrijving i JOIN speler s on i.p_code = s.p_code WHERE e_code = @ecode";
MySqlCommand cmd = new MySqlCommand(selectQuery, conn);
MySqlParameter EcodeParam = new MySqlParameter("@ecode", MySqlDbType.Int32);
EcodeParam.Value = ecode;
cmd.Parameters.Add(EcodeParam);
MySqlDataReader dataReader = cmd.ExecuteReader();
ToernooiController TC = new ToernooiController();
while (dataReader.Read())
{
int p_code = dataReader.GetInt32("p_code");
string roepnaam = dataReader.GetString("roepnaam");
string voorletters = dataReader.GetString("voorletters");
string tussenvoegsels = dataReader[3] as string;
string achternaam = dataReader.GetString("achternaam");
char geslacht = dataReader.GetChar("geslacht");
string postcode = dataReader.GetString("postcode");
string straat = dataReader.GetString("straat");
int huisnummer = dataReader.GetInt32("huisnummer");
string woonplaats = dataReader.GetString("woonplaats");
string emailadres = dataReader.GetString("emailadres");
string IBAN_nummer = dataReader.GetString("IBAN_nummer");
int rating = dataReader.GetInt32("rating");
bool staat_op_blacklist = dataReader.GetChar("staat_op_blacklist") == 'J';
int volgnummer = dataReader.GetInt32("volgnummer");
bool heeftbetaald = dataReader.GetChar("heeft_betaald") == 'J';
Speler s = new Speler(p_code, roepnaam, voorletters, tussenvoegsels, achternaam, geslacht, postcode, straat, huisnummer, woonplaats, emailadres, IBAN_nummer, rating, staat_op_blacklist);
Inschrijving i = new Inschrijving(ecode, volgnummer, p_code, heeftbetaald);
SpelersVolgnummers.Add(s, i);
}
}
catch (Exception ex)
{
Console.WriteLine("Ophalen van bekende locaties mislukt" + ex);
}
finally
{
conn.Close();
}
return(SpelersVolgnummers);
}
public BindingList <Natural> listarClienteNatural()
{
BindingList <Natural> lista = new BindingList <Natural>();
Conexion con = new Conexion();
if (con.IsConnected())
{
MySqlCommand comando = new MySqlCommand();
comando.CommandType = System.Data.CommandType.StoredProcedure;
comando.CommandText = "LISTAR_CLIENTE_NATURAL";
comando.Connection = con.Connection;
MySqlDataReader reader = comando.ExecuteReader();
while (reader.Read())
{
Natural n = new Natural();
n.ApMat = reader.GetString("AP_MATERNO");
n.ApPat = reader.GetString("AP_PATERNO");
n.Direccion = reader.GetString("DIRECCION");
n.Dni = reader.GetString("DNI");
n.Email = reader.GetString("EMAIL");
n.FechaNac = (DateTime)reader.GetMySqlDateTime("FECHA_NACIMIENTO");
n.IdPersona = reader.GetInt32("ID_PERSONA").ToString();
n.Nombre = reader.GetString("NOMBRE");
n.Sexo = reader.GetChar("SEXO");
n.Telefono = reader.GetString("TELEFONO");
lista.Add(n);
}
con.Close();
}
return(lista);
}
//AE4-3
internal List <ApuestasMercado> ApuestasMercado(int idmercado)
{
MySqlConnection con = Connect();
MySqlCommand command = con.CreateCommand();
// EJERCICIO 2
command.CommandText = "select usuarios.email,mercado.idmercado,apuestas.tipo_O_U,apuestas.cuota,apuestas.dinero from mercado inner join apuestas on apuestas.mercado_idmercado1=mercado.ID inner join usuarios on apuestas.usuarios_id_usuarios1=usuarios.id_usuarios where apuestas.dinero>100 AND mercado.ID=" + idmercado;
try
{
con.Open();
MySqlDataReader res = command.ExecuteReader();
ApuestasMercado a = null;
List <ApuestasMercado> apuesta = new List <ApuestasMercado>();
while (res.Read())
{
//Debug.WriteLine("Recuperado: " + res.GetFloat(1) + " " + res.GetFloat(2) + " " + res.GetChar(3));
a = new ApuestasMercado(res.GetString(0), res.GetFloat(1), res.GetChar(2), res.GetFloat(3), res.GetFloat(4));
apuesta.Add(a);
}
con.Close();
return(apuesta);
}
catch (MySqlException e)
{
Debug.WriteLine("Error de conexión");
return(null);
}
}
public Ticket PullFullTicket(TicketStub stub)
{
MySqlConnection dataBase = new MySqlConnection(connectionString);
MySqlCommand pullThreadsCommand = new MySqlCommand("SELECT * FROM `ost_ticket_thread` WHERE `ticket_id` = " + stub.trueNumber + ";", dataBase);
Ticket newTicket = new Ticket(stub);
try
{
dataBase.Open();
MySqlDataReader reader = pullThreadsCommand.ExecuteReader();
newTicket.responses = new List <Message>();
while (reader.Read())
{
Message currentMessage = new Message();
currentMessage.responseNumber = reader.GetInt32("id");
currentMessage.threadType = reader.GetChar("thread_type");
currentMessage.posterName = reader.GetString("poster");
currentMessage.messageTitle = reader.GetString("title");
currentMessage.messageData = reader.GetString("body");
currentMessage.timeRecieved = DateTime.Parse(reader.GetString(Constants.creationDate));
newTicket.responses.Add(currentMessage);
}
reader.Close();
}
catch (Exception)
{
throw;
}
finally
{
dataBase.Close();
}
return(newTicket);
}
public override void Load()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.PERSONAL_DETAILS);
query.Add(Database.Tables.PersonalDetails.FirstName);
query.Add(Database.Tables.PersonalDetails.LastName);
query.Add(Database.Tables.PersonalDetails.Address);
query.Add(Database.Tables.PersonalDetails.PostcodeId);
query.Add(Database.Tables.PersonalDetails.DateOfBirth);
query.Add(Database.Tables.PersonalDetails.Sex);
MySqlDataReader reader = DoLoad(query);
if (Loaded)
{
FirstName = reader.GetString(0);
LastName = reader.GetString(1);
Address = reader.GetString(2);
Postcode = AddressManager.GetPostcode(reader.GetInt32(3));
DateOfBirth = reader.GetDateTime(4);
Sex = reader.GetChar(5);
DetailsManager.Add(this);
}
reader.Close();
Identifications = DetailsManager.GetIdentificationsWithOwner(this);
ContactNumbers = DetailsManager.GetContactNumbersWithOwner(this);
}
public JefeProyecto obtenerJefeProyecto(int idJefeProyecto)
{
MySqlConnection con = new MySqlConnection(DBManager.cadena);
con.Open();
MySqlCommand cmd = new MySqlCommand();
String sql = "SELECT * FROM TRABAJADOR T, PERSONA P WHERE T.ID_PERSONA = P.ID_PERSONA AND T.ID_TRABAJADOR = " + idJefeProyecto + ";";
cmd.CommandText = sql;
cmd.Connection = con;
MySqlDataReader lector = cmd.ExecuteReader();
lector.Read();
JefeProyecto jefeProyecto = new JefeProyecto();
jefeProyecto.IdTrabajador = lector.GetInt32("ID_TRABAJADOR");
jefeProyecto.Dni = lector.GetString("DNI");
jefeProyecto.Nombre = lector.GetString("NOMBRE");
jefeProyecto.ApellidoPaterno = lector.GetString("APELLIDO_PATERNO");
jefeProyecto.ApellidoMaterno = lector.GetString("APELLIDO_MATERNO");
jefeProyecto.Sexo = lector.GetChar("SEXO");
jefeProyecto.FechaNac = lector.GetDateTime("FECHA_NACIMIENTO");
jefeProyecto.Correo = lector.GetString("CORREO");
jefeProyecto.Telefono = lector.GetString("TELEFONO");
lector.Close();
con.Close();
return(jefeProyecto);
}
public void agregarFacultad(BindingList <Especialidad> lista)
{
String cadena = "server=quilla.lab.inf.pucp.edu.pe;" + "user=inf282g6;" + "database=inf282g6;" + "port=3306;" + "password=Nk2ewy;" + "SslMode=none;";
MySqlConnection con = new MySqlConnection(cadena);
MySqlCommand comando = new MySqlCommand();
comando.CommandText = "SELECT * FROM FACULTAD";
comando.Connection = con;
con.Open();
MySqlDataReader rs = comando.ExecuteReader();
while (rs.Read())
{
int id_facultad = rs.GetInt32("ID_FACULTAD");
foreach (Especialidad e in lista)
{
if (id_facultad == e.Facultad.Id_facultad)
{
e.Facultad.Nombre = rs.GetString("NOMBRE_FACULTAD");
e.Facultad.Pabellon = rs.GetChar("PABELLON");
}
}
}
con.Close();
}
public Account getAccount()
{
Account account = new Models.Account();
MySqlConnection conn = null;
using (conn = new MySqlConnection(db.getConnString()))
{
conn.Open();
using (MySqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT * FROM user WHERE userID LIKE '11425598';";
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
account.userID = reader.GetInt32(0);
account.lastName = reader.GetString(1);
account.firstName = reader.GetString(2);
account.middleName = reader.GetString(3);
account.gender = reader.GetChar(4);
account.birthYear = reader.GetInt32(5);
account.birthMonth = reader.GetInt32(6);
account.birthDay = reader.GetInt32(7);
account.citizenship = reader.GetString(8);
}
}
}
}
conn.Close();
return(account);
}
//hecho por Francisco, se usa en frmBuscarPersona_F
public BindingList <Persona> listar_Persona_F()
{
BindingList <Persona> lista = new BindingList <Persona>();
String cadena = "server=quilla.lab.inf.pucp.edu.pe;" + "user=inf282g6;" + "database=inf282g6;" + "port=3306;" + "password=Nk2ewy;" + "SslMode=none;";
MySqlConnection con = new MySqlConnection(cadena);
MySqlCommand comando = new MySqlCommand();
comando.CommandText = "SELECT * FROM PERSONA";
comando.Connection = con;
con.Open();
MySqlDataReader rs = comando.ExecuteReader();
while (rs.Read())
{
Persona p = new Persona();
p.Id_persona = rs.GetInt32("ID_PERSONA");
p.Id_usuario = rs.GetInt32("ID_USUARIO");
p.CodigoPUCP = rs.GetInt32("CODIGO_PUCP");
p.Nombres = rs.GetString("NOMBRES");
p.Apellidos = rs.GetString("APELLIDOS");
p.Sexo = rs.GetChar("SEXO");
p.Dni = rs.GetInt32("DNI");
p.Fecha_nacimiento = rs.GetDateTime("FECHA_NACIMIENTO");
p.CorreoPUCP = rs.GetString("CORREO_PUCP");
p.CorreoAlternativo = rs.GetString("CORREO_ALTERNATIVO");
p.TelfMovil = rs.GetString("TELF_MOVIL");
p.TelfFijo = rs.GetString("TELF_FIJO");
p.Estado = rs.GetString("ESTADO");
lista.Add(p);
}
con.Close();
return(lista);
}
public List <EPeriodo> getPerBloqueado(string bloqueado)
{
List <EPeriodo> lstPeriodos = new List <EPeriodo>();
string sql = "SELECT * FROM bloq_per WHERE bloqueado = '" + bloqueado + "' AND periodo <> '00' ORDER BY periodo";
using (conexion cnx = new conexion())
{
cnx.cadena = Configuracion.Instanciar.conexionBD();
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.CommandText = sql;
cmd.Connection = cnx.getConexion();
if (cnx.abrirConexion())
{
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
EPeriodo objPer = new EPeriodo();
objPer.periodo = dr.GetString("periodo");
objPer.bloqueado = dr.GetChar("bloqueado");
lstPeriodos.Add(objPer);
}
cnx.cerrarConexion();
}
}
}
return(lstPeriodos);
}
public PersonneDTO getPersonneByCodeBarre(String codeBarre)
{
MySqlCommand cmd = new MySqlCommand(queryReadPersonneByCodeBarre, connexion);
MySqlDataReader reader = null;
PersonneDTO result = new PersonneDTO();
try
{
connexion.Open();
cmd.Parameters.AddWithValue("@codebarre", codeBarre);
reader = cmd.ExecuteReader();
reader.Read();
result.IdPersonne = reader.GetString("idpersonne");
result.Prenom = reader.GetString("prenom");
result.Nom = reader.GetString("nom");
result.Sexe = reader.GetChar("sexe");
result.DateNaissance = reader.GetDateTime("datenaissance");
result.Email = reader.GetString("email");
result.MotDePasse = reader.GetString("motdepasse");
result.CodeBarre = reader.GetString("codebarre");
result.Role = reader.GetString("role");
}
catch (Exception e)
{
Console.Write(e.Message);
}
finally
{
connexion.Close();
}
return(result);
}
public char?GetGradeByCourseAndStudentID(int CRN, string studentUID)
{
MySqlConnection dbConnection = DbConnection.GetConnection();
using (dbConnection)
{
dbConnection.Open();
var selectQuery = "select * from student_has_courses WHERE student_uid=@studentID AND courses_CRN=@CRNCheck";
using (MySqlCommand cmd = new MySqlCommand(selectQuery, dbConnection))
{
cmd.Parameters.AddWithValue("@CRNCheck", CRN);
cmd.Parameters.AddWithValue("@studentID", studentUID);
using (MySqlDataReader reader = cmd.ExecuteReader())
{
int gradeOrdinal = reader.GetOrdinal("grade_earned");
while (reader.Read())
{
char grade = reader[gradeOrdinal] == DBNull.Value
? default(char)
: reader.GetChar(gradeOrdinal);
return(grade);
}
}
}
return(null);
}
}
public BindingList <Becado> listarBecadosPorCiclo(string ciclo)
{
BindingList <Becado> lstBecados = new BindingList <Becado>();
String cadena = "server=quilla.lab.inf.pucp.edu.pe;" +
"user=inf282g6;database=inf282g6;" +
"port=3306;password=Nk2ewy;SslMode=none;" +
"";
MySqlConnection con = new MySqlConnection(cadena);
con.Open();
MySqlCommand comando = new MySqlCommand();
comando.CommandText = "SELECT p.NOMBRES, p.APELLIDOS, p.CORREO_PUCP, p.CODIGO_PUCP, p.SEXO, e.NOMBRE_ESPECIALIDAD FROM BECADO b , PERSONA p, ESPECIALIDAD e " +
"where '" + ciclo + "'= CICLO_INGRESO and p.ID_PERSONA = b.ID_PERSONA and b.ID_ESPECIALIDAD_INGRESO = e.ID_ESPECIALIDAD;";
comando.Connection = con;
MySqlDataReader reader = comando.ExecuteReader();
while (reader.Read())
{
Becado becado = new Becado();
becado.Nombres = reader.GetString("NOMBRES");
becado.Apellidos = reader.GetString("APELLIDOS");
becado.CorreoPUCP = reader.GetString("CORREO_PUCP");
becado.CodigoPUCP = reader.GetInt32("CODIGO_PUCP");
becado.Sexo = reader.GetChar("SEXO");
becado.NombreEspecialidad = reader.GetString("NOMBRE_ESPECIALIDAD");
lstBecados.Add(becado);
}
con.Close();
return(lstBecados);
}
public static SQLType GetSQLTypeByNotypeAndLettrecategorie(MySqlConnection mySqlConnection, int notype, char lettrecategorie)
{
SQLType sqlType = null;
try
{
mySqlConnection.Open();
MySqlCommand mySqlCommand = new MySqlCommand("Select * From type where notype = @noType and lettrecategorie = @lettreCategorie", mySqlConnection);
mySqlCommand.Parameters.AddWithValue("@noType", notype);
mySqlCommand.Parameters.AddWithValue("@lettreCategorie", lettrecategorie);
using (MySqlDataReader reader = mySqlCommand.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
sqlType = new SQLType(reader.GetChar(0), reader.GetInt16(1), reader.GetString(2));
}
}
}
mySqlConnection.Close();
}
finally
{
if (mySqlConnection.State.Equals(ConnectionState.Open))
{
mySqlConnection.Close();
}
}
return(sqlType);
}
public static List <SQLCategorie> GetAllSQLCategorie(MySqlConnection mySqlConnection)
{
List <SQLCategorie> listSQLCategorie = new List <SQLCategorie>();
try
{
mySqlConnection.Open();
MySqlCommand mySqlCommand = new MySqlCommand("Select * From categorie", mySqlConnection);
using (MySqlDataReader reader = mySqlCommand.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
listSQLCategorie.Add(new SQLCategorie(reader.GetChar(0), reader.GetString(1)));
}
}
}
mySqlConnection.Close();
}
finally
{
if (mySqlConnection.State.Equals(ConnectionState.Open))
{
mySqlConnection.Close();
}
}
return(listSQLCategorie);
}
//Listado de registros DTO
internal List <ApuestaDTO> RetrieveDTO()
{
MySqlConnection con = Connect();
MySqlCommand command = con.CreateCommand();
command.CommandText = "select * from apuestas";
try
{
con.Open();
MySqlDataReader res = command.ExecuteReader();
ApuestaDTO a = null;
List <ApuestaDTO> apuesta = new List <ApuestaDTO>();
while (res.Read())
{
Debug.WriteLine("Recuperado: " + res.GetFloat(1) + " " + res.GetFloat(2) + " " + res.GetChar(3));
a = new ApuestaDTO(res.GetFloat(1), res.GetFloat(2), res.GetChar(3));
apuesta.Add(a);
}
con.Close();
return(apuesta);
}
catch (MySqlException e)
{
Debug.WriteLine("Error de conexión");
return(null);
}
}
public static Pessoa GetPessoa(Pessoa p)
{
try
{
using var con = new MySqlConnection(CS);
con.Open();
// string sql = "SELECT * FROM pessoas WHERE (nome = '" + p.Nome + "' AND cpf = '" + p.Cpf + "' AND dataNascimento = '" + p.DataNascimento + "' AND sexo = '" + p.Sexo + "')";
string sql = "SELECT * FROM pessoas WHERE cpf = '" + p.Cpf + "'";
using var cmd = new MySqlCommand(sql, con);
using MySqlDataReader rdr = cmd.ExecuteReader();
Pessoa retornada = new Pessoa();
while (rdr.Read())
{
// Console.WriteLine("{0} {1} {2} {3} {4}", rdr.GetString(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetChar(4));
// consulta += "" + rdr.GetString(1) + " " + rdr.GetString(2) + " " + rdr.GetString(3) + " " + rdr.GetChar(4) + "";
retornada.Nome = rdr.GetString(1);
retornada.Cpf = rdr.GetString(2);
retornada.DataNascimento = rdr.GetString(3);
retornada.Sexo = rdr.GetChar(4);
}
con.Close();
if(retornada.Cpf.Equals(p.Cpf)) return retornada;
else throw new Exception("NÃO ENCONTRADO");
}
catch (Exception ex)
{
throw ex;
}
}
public BindingList <Producto> listarProductos()
{
Conexion con = new Conexion();
if (con.IsConnected())
{
MySqlCommand comando = new MySqlCommand();
comando.CommandType = System.Data.CommandType.StoredProcedure;
comando.CommandText = "LISTAR_PRODUCTOS";
comando.Connection = con.Connection;
MySqlDataReader reader = comando.ExecuteReader();
BindingList <Producto> lista = new BindingList <Producto>();
while (reader.Read())
{
Producto u = new Producto();
u.Id = reader.GetString("ID_PRODUCTO");
u.Nombre = reader.GetString("NOMBRE");
u.Descripcion = reader.GetString("DESCRIPCION");
u.Color = reader.GetString("COLOR");
u.Precio = reader.GetDouble("PRECIO");
u.StockActual = reader.GetInt32("STOCK_ACTUAL");
u.Activo1 = reader.GetInt32("ACTIVO");
u.Talla = reader.GetChar("TALLA");
lista.Add(u);
}
con.Close();
return(lista);
}
return(null);
}
public void GetChar()
{
execSQL("INSERT INTO Test (id, name) VALUES (1, 'a')");
MySqlCommand cmd = new MySqlCommand("SELECT * FROM Test", conn);
MySqlDataReader reader = null;
try
{
reader = cmd.ExecuteReader();
reader.Read();
char achar = reader.GetChar(1);
Assert.AreEqual('a', achar);
}
catch (Exception ex)
{
Assert.Fail(ex.Message);
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
public static List <ClaseClientes> MostrarClientes()
{
List <ClaseClientes> _lista = new List <ClaseClientes>();
MySqlConnection conexion = Conexion.ObtenerConexion();
MySqlCommand _comando = new MySqlCommand(String.Format("SELECT * FROM clientes"), conexion);
MySqlDataReader _reader = _comando.ExecuteReader();
while (_reader.Read())
{
ClaseClientes clientes = new ClaseClientes();
clientes.ID = _reader.GetInt32(0);
clientes.Nombre = _reader.GetString(1);
clientes.Apellido = _reader.GetString(2);
clientes.Correo = _reader.GetString(3);
clientes.Edad = _reader.GetInt32(4);
clientes.Sexo = _reader.GetChar(5);
clientes.Domicilio = _reader.GetString(6);
clientes.Telefono = _reader.GetInt32(7);
clientes.RFC = _reader.GetString(8);
clientes.Activo = _reader.GetBoolean(9);
_lista.Add(clientes);
}
conexion.Close();
return(_lista);
}
public IEnumerable <PetEntity> GetPets()
{
List <PetEntity> pets = new List <PetEntity>();
MySqlConnection databaseConnection = new MySqlConnection(connectionString);
MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection);
commandDatabase.CommandTimeout = 60;
databaseConnection.Open();
MySqlDataReader _reader = commandDatabase.ExecuteReader();
if (_reader.HasRows)
{
while (_reader.Read())
{
PetEntity pet = new PetEntity();
pet.Id = _reader.GetInt32(0);
pet.Name = _reader.GetString(1);
pet.Sex = _reader.GetChar(2);
pet.Description = _reader.GetString(3);
pets.Add(pet);
}
databaseConnection.Close();
}
return(pets);
}
public override char GetChar(int ordinal)
{
if (types[ordinal].ClrEquivalentType != reader.GetFieldType(ordinal))
{
return((char)GetValue(ordinal));
}
return(reader.GetChar(ordinal));
}
private void dataGridUser_Click(object sender, EventArgs e)
{
try
{
con.Open();
user_id = Convert.ToInt32(dataGridUser.CurrentRow.Cells[0].Value.ToString());
command = new MySqlCommand("SELECT * FROM `users` WHERE `id` = '" + user_id + "'", con);
reader = command.ExecuteReader();
if (reader.Read())
{
textFname.Text = reader.GetString("first_name");
textLname.Text = reader.GetString("last_name");
textRegid.Text = reader.GetString("regid");
textEmail.Text = reader.GetString("email");
richAddress.Text = reader.GetString("address");
textPhone.Text = reader.GetString("phone");
// Chuulgan combobox selected item
get_chuulgan = category.categoryName("chuulgan", reader.GetInt32("chuulgan_id"));
if (reader.GetString("gender").Equals("m"))
{
rbMale.Checked = true;
}
else
{
rbFemale.Checked = true;
}
switch (reader.GetChar("type"))
{
case 't':
cbType.SelectedIndex = 0;
break;
case 's':
cbType.SelectedIndex = 1;
break;
case 'w':
cbType.SelectedIndex = 2;
break;
case 'g':
cbType.SelectedIndex = 3;
break;
}
Byte[] image = (Byte[])dataGridUser.CurrentRow.Cells[1].Value;
ms = new MemoryStream(image);
pictureProfile.Image = Image.FromStream(ms);
}
cbChuulgan.SelectedItem = get_chuulgan;
con.Close();
}
catch (MySqlException ex)
{
showMessage(ex.Message);
}
}
/// <summary>
/// Read a char value in the specified field. Field index starts with 0.
/// </summary>
/// <param name="i"></param>
/// <returns></returns>
public char GetChar(int i)
{
lastUpdate = MySQL.MSTime;
if (r.FieldCount > i && !r.IsDBNull(i))
{
return(r.GetChar(i));
}
return('\0');
}
public static void SELECTFROMcourse()
{
refreshLoL();
string query = "SELECT * FROM course WHERE admin = '" + currentSesionInfo[0] + "';";
command = new MySqlCommand(query, connection);
reader = command.ExecuteReader();
while (reader.Read())
{
LoL[0].Add(reader["name"] + "");
LoL[1].Add(reader["admin"] + "");
LoL[2].Add(reader.GetChar("grade").ToString());
LoL[3].Add(reader.GetChar("group").ToString());
LoL[4].Add(reader["ID"].ToString() + "");
}
reader.Close();
}
