/// <summary>
/// Delete row from database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DeleteAddress(object sender, RoutedEventArgs e)
{
if (updatingAddressID == null)
{
ShowInformationMessageBox("Select a row to delete", "No row selected");
return;
}
//Ask user to confirm action
MessageBoxResult removeResult = MessageBox.Show("Remove selected object from database?",
"Remove",
MessageBoxButton.YesNo,
MessageBoxImage.Warning,
MessageBoxResult.No);
if (removeResult == MessageBoxResult.Yes)
{
CarDealerManagementDBEntities context = new CarDealerManagementDBEntities();
var result = from d in context.TB_ADDRESS
where d.ID_ADDRESS == this.updatingAddressID
select d;
TB_ADDRESS obj = result.SingleOrDefault();
if (obj != null)
{
context.TB_ADDRESS.Remove(obj);
context.SaveChanges();
ResetFieldValue(textboxStreetUpdate, textboxCityUpdate, textboxZIPUpdate);
updatingAddressID = null;
ReloadGrid();
}
}
}
public AddressClass(TB_ADDRESS adres)
{
this.ID = adres.ID_ADDRESS;
this.Street = adres.STREET_NUMBER;
this.City = adres.CITY;
this.ZIP = adres.ZIP_CODE;
}
/// <summary>
/// Add new record to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AddAddress(object sender, RoutedEventArgs e)
{
bool validation = InputDataValidator(textboxStreet, textboxCity, textboxZIP);
if (validation)
{
CarDealerManagementDBEntities db = new CarDealerManagementDBEntities();
TB_ADDRESS address = new TB_ADDRESS()
{
STREET_NUMBER = this.textboxStreet.Text,
CITY = this.textboxCity.Text,
ZIP_CODE = this.textboxZIP.Text
};
// Add new object to DB
db.TB_ADDRESS.Add(address);
db.SaveChanges();
ResetFieldValue(this.textboxStreet, this.textboxCity, this.textboxZIP);
ReloadGrid();
}
}
/// <summary>
/// Update a record in database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void UpdateAddress(object sender, RoutedEventArgs e)
{
bool validation = InputDataValidator(textboxStreetUpdate, textboxCityUpdate, textboxZIPUpdate);
if (validation)
{
CarDealerManagementDBEntities db = new CarDealerManagementDBEntities();
if (updatingAddressID == null)
{
ShowInformationMessageBox("Please select a row from the DataGrid to update", "Row not selected");
return;
}
var result = from r in db.TB_ADDRESS where r.ID_ADDRESS == this.updatingAddressID select r;
TB_ADDRESS obj = result.SingleOrDefault();
//Check for null
if (obj != null)
{
//dodać walidacje czy user wprowadza poprawne dane
var id = obj.ID_ADDRESS;
obj.STREET_NUMBER = this.textboxStreetUpdate.Text;
obj.CITY = this.textboxCityUpdate.Text;
obj.ZIP_CODE = this.textboxZIPUpdate.Text;
db.SaveChanges();
//Reset values
ResetFieldValue(this.textboxStreetUpdate, this.textboxCityUpdate, this.textboxZIPUpdate);
updatingAddressID = null;
ManageIsFieldEnabled(false, textboxStreetUpdate, textboxStreetUpdate, textboxZIPUpdate);
ReloadGrid();
ShowInformationMessageBox("Item successfully updated!", "Update");
}
}
}