public List <Rol> GetAll()
{
List <Dictionary <string, dynamic> > data = new List <Dictionary <string, dynamic> >();
List <Rol> roles = new List <Rol>();
data = dataBaseController.ExecuteQuery("SELECT * FROM rol", new List <SqlParameter>());
roles = FillObjects(data);
return(roles);
}
public List <Permiso> GetAll()
{
List <Dictionary <string, dynamic> > data = new List <Dictionary <string, dynamic> >();
List <Permiso> permisos = new List <Permiso>();
data = dataBaseController.ExecuteQuery("SELECT * FROM permiso", new List <SqlParameter>());
permisos = FillObjects(data);
return(permisos);
}
public Orden GetOrden(int id)
{
List <Dictionary <string, dynamic> > data;
Orden orden = null;
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter()
{
ParameterName = "@Id", Value = id
});
data = dataBaseController.ExecuteQuery("SELECT * FROM orden WHERE id = @Id AND activo = 1", param);
if (data.Count > 0)
{
orden = FillObject(data[0]);
}
return(orden);
}
public Producto GetProducto(int id)
{
List <Dictionary <string, dynamic> > data;
Producto producto = null;
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter()
{
ParameterName = "@Id", Value = id
});
data = dataBaseController.ExecuteQuery("SELECT * FROM producto WHERE id = @Id AND activo = 1", param);
if (data.Count > 0)
{
producto = FillObject(data[0]);
}
return(producto);
}
public Usuario GetUsuario(int id)
{
List <Dictionary <string, dynamic> > data;
Usuario usuario = null;
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter()
{
ParameterName = "@Id", Value = id
});
data = dataBaseController.ExecuteQuery("SELECT * FROM usuario WHERE id = @Id", param);
if (data.Count > 0)
{
usuario = FillObject(data[0]);
}
return(usuario);
}