public Inquilino ObtenerPorId(int id)
{
Inquilino i = null;
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sql = $"SELECT Id, Dni, Nombre, Apellido, DomicilioLaboral, Email, TelefonoInquilino, NombreGarante, DniGarante, TelefonoGarante FROM Inquilino" +
$" WHERE Id=@id;";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@id", id);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
i = new Inquilino
{
Id = reader.GetInt32(0),
Dni = reader.GetString(1),
Nombre = reader.GetString(2),
Apellido = reader.GetString(3),
DomicilioLaboral = reader.GetString(4),
Email = reader.GetString(5),
TelefonoInquilino = reader.GetString(6),
NombreGarante = reader.GetString(7),
DniGarante = reader.GetString(8),
TelefonoGarante = reader.GetString(9),
};
}
connection.Close();
}
return(i);
}
}
public IList <Inquilino> ObtenerTodos()
{
IList <Inquilino> res = new List <Inquilino>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sql = $"SELECT Id, Dni, Nombre, Apellido, DomicilioLaboral, Email, TelefonoInquilino, NombreGarante, DniGarante, TelefonoGarante" +
$" FROM Inquilino";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.CommandType = CommandType.Text;
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
Inquilino i = new Inquilino
{
Id = reader.GetInt32(0),
Dni = reader.GetString(1),
Nombre = reader.GetString(2),
Apellido = reader.GetString(3),
DomicilioLaboral = reader.GetString(4),
Email = reader.GetString(5),
TelefonoInquilino = reader.GetString(6),
NombreGarante = reader.GetString(7),
DniGarante = reader.GetString(8),
TelefonoGarante = reader.GetString(9),
};
res.Add(i);
}
connection.Close();
}
}
return(res);
}
public int Modificacion(Inquilino i)
{
int res = -1;
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sql = $"UPDATE Inquilino SET Dni='{i.Dni}',Nombre='{i.Nombre}', Apellido='{i.Apellido}', DomicilioLaboral='{i.DomicilioLaboral}', Email='{i.Email}',, TelefonoInquilino='{i.TelefonoInquilino}', NombreGarante='{i.NombreGarante}',DniGarante='{i.DniGarante}', TelefonoGarante='{i.TelefonoGarante}' " +
$"WHERE Id = {i.Id}";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.CommandType = CommandType.Text;
connection.Open();
res = command.ExecuteNonQuery();
connection.Close();
}
}
return(res);
}
public int Alta(Inquilino i)
{
int res = -1;
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sql = $"INSERT INTO Inquilino ( Dni, Nombre, Apellido, DomicilioLaboral, Email, TelefonoInquilino, NombreGarante, DniGarante, TelefonoGarante) " +
$"VALUES ('{i.Dni}', '{i.Nombre}','{i.Apellido}', '{i.DomicilioLaboral}', '{i.Email}', '{i.TelefonoInquilino}', '{i.NombreGarante}', '{i.DniGarante}', '{i.TelefonoGarante}')";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.CommandType = System.Data.CommandType.Text;
connection.Open();
res = command.ExecuteNonQuery();
command.CommandText = "SELECT SCOPE_IDENTITY()";
var id = command.ExecuteScalar();
i.Id = Convert.ToInt32(id);
connection.Close();
}
}
return(res);
}