private void dgParameters_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
if (e.EditAction == DataGridEditAction.Commit)
{
SystemParametersDataContext context = new SystemParametersDataContext();
SystemParameter sysParams = e.Row.DataContext as SystemParameter;
var matchedData = (from sp in context.SystemParameters
where sp.ParameterID == sysParams.ParameterID
select sp).SingleOrDefault();
if (matchedData == null)
{
SystemParameter sysParam = new SystemParameter();
sysParam.Description = sysParams.Description;
sysParam.Value = sysParams.Value;
sysParam.MiscDescription = sysParams.MiscDescription;
sysParam.Created = DateTime.Now;
context.SystemParameters.InsertOnSubmit(sysParam);
context.SubmitChanges();
}
else
{
matchedData.Description = sysParams.Description;
matchedData.Value = sysParams.Value;
matchedData.MiscDescription = sysParams.MiscDescription;
context.SubmitChanges();
}
}
LoadDataGrid();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
IsEditing = false;
IsInserting = false;
systemParameters = new SystemParametersDataContext();
LoadDataGrid();
}
