Exemplo n.º 1
0
        public IEnumerable <NetworkOperator> getNetworkOperatorDisplay(IEnumerable <NetworkOperator> listNetworkOperator, int idCustomer)
        {
            foreach (NetworkOperator networkOperator in listNetworkOperator)
            {
                networkOperator.NetworkOperatorAmount = db.Contacts.Count(p => p.IDNetworkOperator == networkOperator.IDNetworkOperator);
            }
            db.SubmitChanges();

            IEnumerable <NetworkOperator> listNetworkOperatorDisplay = db.NetworkOperators.Where(p => p.IndexCustomer == idCustomer);

            return(listNetworkOperatorDisplay);
        }
Exemplo n.º 2
0
        public void insertAccount(Users model)
        {
            model.Password = GetMD5(model.Password);
            Account account = new Account
            {
                Username = model.Username,
                Password = model.Password
            };

            db.Accounts.InsertOnSubmit(account);
            db.SubmitChanges();
        }
Exemplo n.º 3
0
        public IEnumerable <Position> getPositionDisplay(IEnumerable <Position> listPosition, int idCustomer)
        {
            foreach (Position position in listPosition)
            {
                position.PositionAmount = db.Contacts.Count(p => p.IDPosition == position.IDPosition);
            }
            db.SubmitChanges();

            IEnumerable <Position> listPositionDisplay = db.Positions.Where(p => p.IndexCustomer == idCustomer);

            return(listPositionDisplay);
        }
Exemplo n.º 4
0
        public IEnumerable <Address> getAddressDisplay(IEnumerable <Address> listAddress, int idCustomer)
        {
            foreach (Address address in listAddress)
            {
                address.AddressAmount = db.Contacts.Count(p => p.IDAddress == address.IDAddress);
            }
            db.SubmitChanges();

            IEnumerable <Address> listAddressDisplay = db.Addresses.Where(p => p.IndexCustomer == idCustomer);

            return(listAddressDisplay);
        }