private void dgData_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e) { if (e.EditAction == DataGridEditAction.Commit) { VenusDbDataContext context = new VenusDbDataContext(); Familia famgrid = e.Row.DataContext as Familia; var matchedData = (from famtabla in context.GetTable <Familia>() where famgrid.xempresa_id == famtabla.xempresa_id && famgrid.xfamilia_id == famtabla.xfamilia_id select famtabla).SingleOrDefault(); if (matchedData == null) { Table <Familia> famTable = context.GetTable <Familia>(); Familia registroFamilia = new Familia(); registroFamilia.xempresa_id = famgrid.xempresa_id; registroFamilia.xfamilia_id = famgrid.xfamilia_id; registroFamilia.xdescripcion = famgrid.xdescripcion; famTable.InsertOnSubmit(registroFamilia); famTable.Context.SubmitChanges(); txtStatus.Text = "Success: Data Inserted"; } else { matchedData.xdescripcion = famgrid.xdescripcion; context.SubmitChanges(); txtStatus.Text = "Success: Data Updated"; } } }
private void dgData_PreviewExecuted(object sender, ExecutedRoutedEventArgs e) { VenusDbDataContext context = new VenusDbDataContext(); Familia RegFamiliaGrid = dgData.SelectedItem as Familia; if (RegFamiliaGrid != null) { var familiaSeleccionada = (from fam in context.GetTable <Familia>() where fam.xempresa_id == RegFamiliaGrid.xempresa_id && fam.xfamilia_id == RegFamiliaGrid.xfamilia_id select fam).SingleOrDefault(); if (e.Command == DataGrid.DeleteCommand) { if (!(MessageBox.Show("Are You Sure you want to Delete ?", "Confirm Delete !", MessageBoxButton.YesNo) == MessageBoxResult.Yes)) { e.Handled = true; } else { context.Familia.DeleteOnSubmit(familiaSeleccionada); context.SubmitChanges(); txtStatus.Text = "Success: Selected Data Deleted."; } } } }
private void cargaDatos(string DescFam = "") { VenusDbDataContext context = new VenusDbDataContext(); var result = from fam in context.Familia where System.Data.Linq.SqlClient.SqlMethods.Like(fam.xdescripcion, "%" + DescFam + "%") || DescFam == "" select fam; if (result.ToList().Count > 0) { txtStatus.Text = "Success: Read Operation"; } dgData.ItemsSource = result.ToList(); }