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); }
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(); }
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); }
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); }