public Cliente devuelveClienteporDni(string dni)
{
Cliente cliente = new Cliente();
string storedprocedure = "datosclientepordni";
using (DbConnection con = dpf.CreateConnection())
{
con.ConnectionString = constr;
using (DbCommand cmd = dpf.CreateCommand())
{
cmd.Connection = con;
cmd.CommandText = storedprocedure;
cmd.CommandType = CommandType.StoredProcedure;
DbParameter param = cmd.CreateParameter();
param.DbType = DbType.String;
param.ParameterName = "dni";
param.Value = dni;
cmd.Parameters.Add(param);
con.Open();
using (DbDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
cliente = new Cliente(
(string)dr["dni"],
(string)dr["nombres"],
(string)dr["apellidos"],
(string)dr["direccion"],
(string)dr["celular"]
);
}
}
}
}
return cliente;
}
public Cliente devuelveCliente(string correo, string contrasena)
{
Cliente cliente = new Cliente();
string storedprocedure = "iniciasesion";
using (DbConnection con= dpf.CreateConnection())
{
con.ConnectionString = constr;
using (DbCommand cmd = dpf.CreateCommand())
{
cmd.Connection = con;
cmd.CommandText = storedprocedure;
cmd.CommandType = CommandType.StoredProcedure;
DbParameter paramCorreo = cmd.CreateParameter();
paramCorreo.DbType = DbType.String;
paramCorreo.ParameterName = "correo";
paramCorreo.Value = correo;
DbParameter paramContrasena = cmd.CreateParameter();
paramContrasena.DbType = DbType.String;
paramContrasena.ParameterName = "contrasena";
paramContrasena.Value = contrasena;
cmd.Parameters.Add(paramCorreo);
cmd.Parameters.Add(paramContrasena);
con.Open();
using (DbDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
cliente = new Cliente( (string)dr["dni"], (string)dr["nombres"] );
}
}
}
}
return cliente;
}