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