public IList <Propietario> ObtenerTodos() { IList <Propietario> res = new List <Propietario>(); using (SqlConnection connection = new SqlConnection(connectionString)) { string sql = $"SELECT IdPropietario, Nombre, Apellido, Dni, Telefono, Email, Clave" + $" FROM Propietarios"; using (SqlCommand command = new SqlCommand(sql, connection)) { command.CommandType = CommandType.Text; connection.Open(); var reader = command.ExecuteReader(); while (reader.Read()) { Propietario p = new Propietario { IdPropietario = reader.GetInt32(0), Nombre = reader.GetString(1), Apellido = reader.GetString(2), Dni = reader.GetString(3), Telefono = reader.GetString(4), Email = reader.GetString(5), Clave = reader.GetString(6), }; res.Add(p); } connection.Close(); } } return(res); }
public IList <Propietario> BuscarPorNombre(string nombre) { List <Propietario> res = new List <Propietario>(); Propietario p = null; using (SqlConnection connection = new SqlConnection(connectionString)) { string sql = $"SELECT IdPropietario, Nombre, Apellido, Dni, Telefono, Email, Clave FROM Propietarios" + $" WHERE Nombre LIKE %@nombre% OR Apellido LIKE %@nombre"; using (SqlCommand command = new SqlCommand(sql, connection)) { command.Parameters.Add("@nombre", SqlDbType.VarChar).Value = nombre; command.CommandType = CommandType.Text; connection.Open(); var reader = command.ExecuteReader(); while (reader.Read()) { p = new Propietario { IdPropietario = reader.GetInt32(0), Nombre = reader.GetString(1), Apellido = reader.GetString(2), Dni = reader.GetString(3), Telefono = reader.GetString(4), Email = reader.GetString(5), Clave = reader.GetString(6), }; res.Add(p); } connection.Close(); } } return(res); }
public Propietario ObtenerPorEmail(string email) { Propietario p = null; using (SqlConnection connection = new SqlConnection(connectionString)) { string sql = $"SELECT IdPropietario, Nombre, Apellido, Dni, Telefono, Email, Clave FROM Propietarios" + $" WHERE Email=@email"; using (SqlCommand command = new SqlCommand(sql, connection)) { command.Parameters.Add("@email", SqlDbType.VarChar).Value = email; command.CommandType = CommandType.Text; connection.Open(); var reader = command.ExecuteReader(); if (reader.Read()) { p = new Propietario { IdPropietario = reader.GetInt32(0), Nombre = reader.GetString(1), Apellido = reader.GetString(2), Dni = reader.GetString(3), Telefono = reader.GetString(4), Email = reader.GetString(5), Clave = reader.GetString(6), }; } connection.Close(); } } return(p); }
public int Modificacion(Propietario p) { int res = -1; using (SqlConnection connection = new SqlConnection(connectionString)) { string sql = $"UPDATE Propietarios SET Nombre='{p.Nombre}', Apellido='{p.Apellido}', Dni='{p.Dni}', Telefono='{p.Telefono}', Email='{p.Email}', Clave='{p.Clave}' " + $"WHERE PropietarioId = {p.PropietarioId}"; using (SqlCommand command = new SqlCommand(sql, connection)) { command.CommandType = CommandType.Text; connection.Open(); res = command.ExecuteNonQuery(); connection.Close(); } } return(res); }
public int Alta(Propietario p) { int res = -1; using (SqlConnection connection = new SqlConnection(connectionString)) { string sql = $"INSERT INTO Propietarios (Nombre, Apellido, Dni, Telefono, Email, Clave) " + $"VALUES ('{p.Nombre}', '{p.Apellido}','{p.Dni}','{p.Telefono}','{p.Email}','{p.Clave}')"; using (SqlCommand command = new SqlCommand(sql, connection)) { command.CommandType = CommandType.Text; connection.Open(); res = command.ExecuteNonQuery(); command.CommandText = "SELECT SCOPE_IDENTITY()"; var id = command.ExecuteScalar(); p.IdPropietario = Convert.ToInt32(id); connection.Close(); } } return(res); }
public int Modificacion(Propietario p) { int res = -1; using (SqlConnection connection = new SqlConnection(connectionString)) { string sql = $"UPDATE Propietarios SET Nombre=@nombre, Apellido=@apellido, Dni=@dni, Telefono=@telefono, Email=@mail " + $"WHERE IdPropietario = {p.IdPropietario}"; using (SqlCommand command = new SqlCommand(sql, connection)) { command.Parameters.Add("@nombre", SqlDbType.VarChar).Value = p.Nombre; command.Parameters.Add("@apellido", SqlDbType.VarChar).Value = p.Apellido; command.Parameters.Add("@dni", SqlDbType.VarChar).Value = p.Dni; command.Parameters.Add("@telefono", SqlDbType.VarChar).Value = p.Telefono; command.Parameters.Add("@mail", SqlDbType.VarChar).Value = p.Email; command.CommandType = CommandType.Text; connection.Open(); res = command.ExecuteNonQuery(); connection.Close(); } } return(res); }
public Conectado(Propietario p) { Usuario = p.Email; Nombre = p.Nombre + " " + p.Apellido; }
public Propietario FinalizarContrato(Propietario i) { throw new NotImplementedException(); }
public Propietario Update(Propietario p) { throw new NotImplementedException(); }