public Cliente GetCliente(String Mail, String Pass)
{
try
{
SqlCommand cmd = new SqlCommand(LOGIN_CLIENT, con);
cmd.Parameters.AddWithValue("@CORREO", Mail);
cmd.Parameters.AddWithValue("@PASS", CreateMD5(Pass));
//cmd.Parameters.AddWithValue("@Id", 1);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
Cliente cli = new Cliente()
{
Id = dr[0] != DBNull.Value ? dr.GetInt32(0) : 0,
Nombre = dr[1] != DBNull.Value ? dr.GetString(1) : string.Empty,
Edad = dr[2] != DBNull.Value ? dr.GetInt32(2) : 0,
Sexo = dr[3] != DBNull.Value ? dr.GetString(3) : string.Empty,
Telefono = dr[4] != DBNull.Value ? dr.GetString(4) : string.Empty,
Correo = dr[5] != DBNull.Value ? dr.GetString(5) : string.Empty,
Id_Lista = dr[6] != DBNull.Value ? dr.GetInt32(6) : 0,
Fecha_Nacimiento = dr.GetDateTime(7),
Nombre_Listado = dr[8] != DBNull.Value ? dr.GetString(8) : string.Empty,
TokenUser = dr[9] != DBNull.Value ? dr.GetString(9) : string.Empty,
TarjetaChalan = dr[10] != DBNull.Value ? dr.GetString(10) : string.Empty,
SoloNombre = dr[11] != DBNull.Value ? dr.GetString(11) : string.Empty,
Apellido_P = dr[12] != DBNull.Value ? dr.GetString(12) : string.Empty,
Apellido_M = dr[13] != DBNull.Value ? dr.GetString(13) : string.Empty,
TOKENOP = dr[14] != DBNull.Value ? dr.GetString(14) : string.Empty,
Direcciones = DAO_Dir.GetDireccionesCliente(dr.GetInt32(0))
};
cli.Pedidos = DAO_Ped.GetPedidosCliente(cli.Id);
return(cli);
}
return(null);
}
catch (Exception ex)
{
string sldd = ex.ToString();
return(null);
}
finally { con.Close(); }
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DAO.DAODireccion direcc = new DAO.DAODireccion();
List <Direccion> direcciones = direcc.GetDireccionesCliente(199);
rptMarkers.DataSource = direcciones;
rptMarkers.DataBind();
rptMaps.DataSource = direcciones;
rptMaps.DataBind();
}
}