public IEnumerable<Local> getAll()
        {
            MySqlCommand cmm = new MySqlCommand();

            StringBuilder sql = new StringBuilder();
            sql.Append("select  * ");
            sql.Append(" FROM locais  ");

            cmm.CommandText = sql.ToString();

            MySqlDataReader dr = conn.executarConsultas(cmm);
            while (dr.Read())
            {

                Local loc = new Local
                {
                    idLocal = (int)dr["idLocal"],
                    sigla = (string)dr["sigla"],
                    nomeEstado = (string)dr["nomeEstado"],
                    nomeCidade = (string)dr["nomeCidade"],

                };
                local.Add(loc);
            }
            dr.Dispose();
            return local;
        }

 public override Statement VisitAssignmentStatement(AssignmentStatement assignment)
 {
   MemberBinding binding = assignment.Target as MemberBinding;
   if (binding != null) 
   {
     Expression target = VisitExpression(binding.TargetObject);
     Field boundMember = (Field) binding.BoundMember;
     Expression source = VisitExpression(assignment.Source);
     if (!boundMember.IsStatic && !boundMember.DeclaringType.IsValueType && boundMember.DeclaringType.Contract != null && boundMember.DeclaringType.Contract.FramePropertyGetter != null && boundMember != boundMember.DeclaringType.Contract.FrameField) 
     {
       Local targetLocal = new Local(boundMember.DeclaringType);
       Statement evaluateTarget = new AssignmentStatement(targetLocal, target, assignment.SourceContext);
       Local sourceLocal = new Local(boundMember.Type);
       Statement evaluateSource = new AssignmentStatement(sourceLocal, source, assignment.SourceContext);
       Expression guard = new MethodCall(new MemberBinding(targetLocal, boundMember.DeclaringType.Contract.FramePropertyGetter), null, NodeType.Call, SystemTypes.Guard);
       Statement check = new ExpressionStatement(new MethodCall(new MemberBinding(guard, SystemTypes.Guard.GetMethod(Identifier.For("CheckIsWriting"))), null, NodeType.Call, SystemTypes.Void));
       Statement stfld = new AssignmentStatement(new MemberBinding(targetLocal, boundMember), sourceLocal, assignment.SourceContext);
       return new Block(new StatementList(new Statement[] {evaluateTarget, evaluateSource, check, stfld}));
     } 
     else
     {
       binding.TargetObject = target;
       assignment.Source = source;
       return assignment;
     }
   }
   else
   {
     return base.VisitAssignmentStatement(assignment);
   }
 }

        public void agregarLocal(String _nombre, String _telefono, int _preferencia, int _provincia, String _url, String _descripcion = "")
        {
            try
            {
                Local local = new Local(0,_nombre, _url, _telefono, _descripcion, _preferencia, _provincia);

                if (local.IsValid)
                {
                   LocalRepositorio.Instance.Insert(local);
                   LocalRepositorio.Instance.Save();
                }
                else
                {
                    StringBuilder sb = new StringBuilder();
                    foreach (RuleViolation rv in local.GetRuleViolations())
                    {
                        sb.AppendLine(rv.ErrorMessage);
                    }
                    throw new ApplicationException(sb.ToString());
                }

            }
            catch (DataAccessException ex)
            {
                throw ex;
            }
            catch (Exception ex)
            {
                throw new Exception(String.Format("Error: {0}", ex.Message));
            }
        }

 public frmRegistarRevisionInventario(Local local)
 {
     InitializeComponent();
     this.local = local;
     btnQuitar.Enabled = false;
     CargaPorFecha();
 }

        public Reserva_AlterarHorario()
        {
            local = MockRepository.GenerateStub<Local>();
            data = DateTime.Now.Date;

            reserva = new Reserva(local, data, new List<HoraReservaEnum> { HoraReservaEnum.Manha });
        }

        /// <summary>
        /// Returns true if the local variable has no name in the IL and the name was introduced by the IL reader.
        /// </summary>
        public static bool IsAnonymousLocal(Local local)
        {
            if (local == null)
                return false;

            return local.Anonymous;
        }

        public byte Delete(Local instance)
        {
            ISession hisession = null;
            try
            {
                hisession = NHibernateHelper.GetCurrentSession();
                hisession.BeginTransaction();
                hisession.Delete(instance);
                hisession.Transaction.Commit();
                hisession.Close();
                return 1;
            }
            catch (Exception ex)
            {
                if (hisession != null)
                {
                    if (hisession.IsOpen)
                    {
                        hisession.Close();
                    }
                }

            }
            return 0;
        }

 public Empresas(int pIdEmpresa, string pNomeEmpresa, Local pLocalEmpresa, string pEnderecoEmpresa)
 {
     idEmpresa = pIdEmpresa;
     nomeEmpresa = pNomeEmpresa;
     enderecoEmpresa = pEnderecoEmpresa;
     localEmpresa = pLocalEmpresa;
 }

        public IHttpActionResult PutLocal(int id, Local local)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

            if (id != local.Id)
            {
                return BadRequest();
            }

            db.Entry(local).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!LocalExists(id))
                {
                    return NotFound();
                }
                else
                {
                    throw;
                }
            }

            return StatusCode(HttpStatusCode.NoContent);
        }

 public Musico(int pIdMusico, string pNomeMusico, string pEnderecoMusico, Local pLocalMusico)
 {
     idMusico = pIdMusico;
     nomeMusico = pNomeMusico;
     enderecoMusico = pEnderecoMusico;
     localMusico = pLocalMusico;
 }

 public frmIngresarProductos(Local local)
 {
     if (!local.Estado.Equals("Activo"))
     {
         Utils.Utils.Mensaje("El local del cual está realizando la transacción no está activo", MessageBoxButtons.OK, MessageBoxIcon.Error);
         return;
     }
     InitializeComponent();
     this.local = local;
     dgvProductos.AllowUserToAddRows = false;
     dgvProductos.AllowUserToDeleteRows = false;
     txtNroDocumento.KeyPress += new System.Windows.Forms.KeyPressEventHandler(Utils.Utils.ValidaNumerico);
     this.AcceptButton = btnCargarDatos;
     List<ListItem> listItem = new List<ListItem>();
     ListItem e1 = new ListItem("Compra", (int)TipoMov.Compra);
     ListItem e3 = new ListItem("Consignacion", (int)TipoMov.Consignacion);
     ListItem e4 = new ListItem("Transferencia", (int)TipoMov.Transferencia);
     listItem.Add(e1);
     listItem.Add(e3);
     listItem.Add(e4);
     cboTipoMovimiento.DataSource = listItem;
     cboTipoMovimiento.DisplayMember = "Mostrar";
     cboTipoMovimiento.ValueMember = "Valor";
     lblFecha.Show();
     zonas = (new ZonasBL()).ObtenerDatos(this.local);
 }

 public Local CopyTo(Local local)
 {
     local.Type = this.Type;
     local.Name = this.Name;
     local.PdbAttributes = this.PdbAttributes;
     return local;
 }

        public List<Local> GetAll()
        {
            try
            {
                var lista = new List<Local>();

                var sql = "select * from " + this.Tabela;

                var dataSet = new DataSet();
                var query = new MySqlDataAdapter(sql, CorridaDAO.StringConexao);
                query.Fill(dataSet);

                foreach (var item in dataSet.Tables[0].AsEnumerable().ToList())
                {
                    var local = new Local()
                    {
                        Id = Convert.ToInt16(item["Id"]),
                        Cidade = item["Cidade"].ToString(),
                        Uf = item["Uf"].ToString()
                    };

                    lista.Add(local);
                }

                return lista;
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                return null;
            }
        }

 public frmAgregarZonaIni(Local local)
 {
     InitializeComponent();
     this.local = local;
     cargarDatosAnaqueles();
     revisarFuncionalidades();
 }

        internal bool IsSame(Local other)
        {
            if((object)this == (object)other) return true;

            object ourVal = value; // use prop to ensure obj-disposed etc
            return other != null && ourVal == (object)(other.value); 
        }

        static void Main(string[] args)
        {
            Centralita centralita = new Centralita("Telefonica");
            Local unaLlamada = new Local("Quilmes", 30f, "Avellaneda", 0.98f);
            Provincial dosLlamada = new Provincial("Cordoba", Franja.Franja_1, 21f, "Santa Fe");
            Local tresLlamada = new Local("Bernal", 45f, "Termperley", 0.98f);
            Provincial cuatroLlamada = new Provincial("Buenos Aires",Franja.Franja_3, 14f, "Tucuman");

            //Cargamos la lista
            centralita.Lista.Add(unaLlamada);
            centralita.Lista.Add(dosLlamada);
            centralita.Lista.Add(tresLlamada);
            centralita.Lista.Add(cuatroLlamada);

            //Mostramos el contenido
            centralita.Mostrar();

            //Ordenamos la lista y la mostramos
            centralita.OrdenarLlamadas();

            Console.WriteLine("------ Lista ordenada -------");
            centralita.Mostrar();

            Console.ReadLine();
        }

 public IEnumerable<Instruction> EmitDerivation(MethodDef method, ConfuserContext ctx, Local dst, Local src)
 {
     for (int i = 0; i < 0x10; i++) {
         yield return Instruction.Create(OpCodes.Ldloc, dst);
         yield return Instruction.Create(OpCodes.Ldc_I4, i);
         yield return Instruction.Create(OpCodes.Ldloc, dst);
         yield return Instruction.Create(OpCodes.Ldc_I4, i);
         yield return Instruction.Create(OpCodes.Ldelem_U4);
         yield return Instruction.Create(OpCodes.Ldloc, src);
         yield return Instruction.Create(OpCodes.Ldc_I4, i);
         yield return Instruction.Create(OpCodes.Ldelem_U4);
         switch (i % 3) {
             case 0:
                 yield return Instruction.Create(OpCodes.Xor);
                 yield return Instruction.Create(OpCodes.Ldc_I4, (int)k1);
                 yield return Instruction.Create(OpCodes.Add);
                 break;
             case 1:
                 yield return Instruction.Create(OpCodes.Mul);
                 yield return Instruction.Create(OpCodes.Ldc_I4, (int)k2);
                 yield return Instruction.Create(OpCodes.Xor);
                 break;
             case 2:
                 yield return Instruction.Create(OpCodes.Add);
                 yield return Instruction.Create(OpCodes.Ldc_I4, (int)k3);
                 yield return Instruction.Create(OpCodes.Mul);
                 break;
         }
         yield return Instruction.Create(OpCodes.Stelem_I4);
     }
 }

        public IList<OrdenCompra> Filtrar(DateTime fechaInicio, DateTime fechaFin, string estado, Proveedor proveedor, string numeroOC, Local local)
        {
            List<string> properties = new List<string>();
            List<object> values = new List<object>();

            properties.Add("FechaPedido >=");
            properties.Add("FechaPedido <=");

            values.Add(fechaInicio);
            values.Add(fechaFin);

            if (estado != "Todos")
            {
                properties.Add("Estado = ");
                values.Add(estado);
            }
            if (proveedor != null)
            {
                properties.Add("Proveedor.Id = ");
                values.Add(proveedor.Id);
            }
            if (numeroOC.Trim().Length > 0)
            {
                properties.Add("Id = ");
                values.Add(numeroOC);
            }

            if (local != null) {
                properties.Add("LugarEntrega = ");
                values.Add(local.Nombre);
            }

            return new OrdenCompraDA().FindByProperties(properties, values);
        }

        public Reserva_Nova_Criada_Corretamente()
        {
            local = new Local("Um Local");
            data = DateTime.Now.Date;

            reserva = new Reserva(local, data, new List<HoraReservaEnum> { HoraReservaEnum.Manha });
        }

        /// <summary>
        /// This method returns true if <paramref name="local"/> is a reference to
        /// anonymous variable generated by C# compiler for expression trees.
        /// </summary>
        /// <remarks>C# compiler generates code for expression trees that would be invalid from
        /// Code Contracts perspective (for instance, local assinment before Requires could happen etc).
        /// </remarks>
        public static bool IsExpressionTreeLocal(Local local)
        {
            if (local == null)
                return false;

            return IsAnonymousLocal(local) && IsOfType(local, typeof(System.Linq.Expressions.ParameterExpression).FullName);
        }