private int createNewAddress() { using (var ctx = new DataLayer.ScheduleEntities()) { DataLayer.address newAddress = new DataLayer.address(); newAddress.address1 = textBoxAddress1.Text; newAddress.address2 = textBoxAddress2.Text; newAddress.cityId = comboBoxCity.SelectedIndex + 1; newAddress.createDate = DateTime.Now.ToUniversalTime(); newAddress.createdBy = CurrentUserName; newAddress.postalCode = textBoxPostCode.Text; newAddress.lastUpdate = DateTime.Now.ToUniversalTime(); newAddress.lastUpdateBy = CurrentUserName; newAddress.phone = textBoxPhone.Text; Validate(); // validate the input fields //addressBindingSource.EndEdit(); // try to save changes try { ctx.addresses.Add(newAddress); ctx.SaveChanges(); // write changes to database file } catch (DbEntityValidationException) { MessageBox.Show("Something has gone wrong saving this data", "Entity Validation Exception"); } return(newAddress.addressId); } }
private void customerDataGridView_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { if (e.Value is DataLayer.address) { DataLayer.address thisAddress = (DataLayer.address)e.Value; e.Value = FormatAddressString(thisAddress.addressId); } }