public Boolean EliminarSucursal(Sucursal Sucursal)
{
try
{
using (SqlConnection conn = new SqlConnection(strConnection))
{
conn.Open();
SqlCommand command = new SqlCommand("USP_ELIMINAR_SUCURSAL", conn);
command.CommandType = CommandType.StoredProcedure;
command.Connection = conn;
command.Parameters.AddWithValue("@Id", Sucursal.Id);
command.ExecuteNonQuery();
conn.Close();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public Boolean InsertarSucursal(Sucursal Sucursal)
{
try
{
using (SqlConnection conn = new SqlConnection(strConnection))
{
conn.Open();
SqlCommand command = new SqlCommand("USP_INSERTAR_SUCURSAL", conn);
command.CommandType = CommandType.StoredProcedure;
command.Connection = conn;
command.Parameters.AddWithValue("@Nombre", Sucursal.Nombre);
command.Parameters.AddWithValue("@Direccion", Sucursal.Direccion);
command.Parameters.AddWithValue("@FechaRegistro", Sucursal.FechaRegistro);
command.Parameters.AddWithValue("@IdBanco", Sucursal.IdBanco);
command.ExecuteNonQuery();
conn.Close();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public Sucursal ObtenerPorId(int Id)
{
try
{
using (SqlConnection conn = new SqlConnection(strConnection))
{
conn.Open();
SqlCommand command = new SqlCommand("USP_OBTENER_SUCURSAL_ID", conn);
command.CommandType = CommandType.StoredProcedure;
command.Connection = conn;
command.Parameters.AddWithValue("@Id", Id);
//List<Banco> lstBanco = new List<Banco>();
IDataReader lector = command.ExecuteReader();
Sucursal beSucursal = null;
while (lector.Read())
{
beSucursal = new Sucursal()
{
Id = lector.GetInt32(0),
Nombre = lector.GetString(1),
Direccion = lector.GetString(2),
FechaRegistro = lector.GetDateTime(3),
IdBanco = lector.GetInt32(4),
};
// lstBanco.Add(beBanco);
}
conn.Close();
return(beSucursal);//lstBanco;
}
}
catch (Exception ex)
{
throw;
}
}
