public static void UpdateAddress(Client client) { var requiredData = (from x in database.Clients where x.ClientId == client.ClientId select x).First(); requiredData.Address = client.Address; database.SubmitChanges(); }
internal static void AddNewClient(string firstName, string lastName, string username, string password, string email, string streetAddress, int zipCode, int stateId) { Client newClient = new Client(); newClient.FirstName = firstName; newClient.LastName = lastName; newClient.UserName = username; newClient.Password = password; newClient.Email = email; Address addressFromDb = db.Addresses.Where(a => a.AddressLine1 == streetAddress && a.Zipcode == zipCode && a.USStateId == stateId).FirstOrDefault(); // if the address isn't found in the Db, create and insert it if (addressFromDb == null) { Address newAddress = new Address(); newAddress.AddressLine1 = streetAddress; newAddress.City = null; newAddress.USStateId = stateId; newAddress.Zipcode = zipCode; db.Addresses.InsertOnSubmit(newAddress); db.SubmitChanges(); addressFromDb = newAddress; } // attach AddressId to clientFromDb.AddressId newClient.AddressId = addressFromDb.AddressId; db.Clients.InsertOnSubmit(newClient); db.SubmitChanges(); }