public void ValidateRowDeletion(DevExpress.Mvvm.Xpf.ValidateRowDeletionArgs args)
{
var item = (EFCoreIssues.Issues.Issue)args.Items.Single();
var context = new EFCoreIssues.Issues.IssuesContext();
context.Entry(item).State = EntityState.Deleted;
context.SaveChanges();
}
void OnValidateRowDeletion(System.Object sender, DevExpress.Xpf.Grid.GridValidateRowDeletionEventArgs e)
{
var row = (EFCoreIssues.Issues.Issue)e.Rows.Single();
var context = new EFCoreIssues.Issues.IssuesContext();
context.Entry(row).State = EntityState.Deleted;
context.SaveChanges();
}
public void GetTotalSummaries(DevExpress.Mvvm.Xpf.GetSummariesAsyncArgs args)
{
args.Result = Task.Run(() =>
{
var context = new EFCoreIssues.Issues.IssuesContext();
var queryable = context.Issues.Where(MakeFilterExpression((DevExpress.Data.Filtering.CriteriaOperator)args.Filter));
return(queryable.GetSummaries(args.Summaries));
});
}
void OnGetTotalSummaries(System.Object sender, DevExpress.Xpf.Data.GetSummariesAsyncEventArgs e)
{
e.Result = Task.Run(() =>
{
var context = new EFCoreIssues.Issues.IssuesContext();
var queryable = context.Issues.Where(MakeFilterExpression(e.Filter));
return(queryable.GetSummaries(e.Summaries));
});
}
public void FetchRows(DevExpress.Mvvm.Xpf.FetchRowsAsyncArgs args)
{
args.Result = Task.Run <DevExpress.Xpf.Data.FetchRowsResult>(() =>
{
var context = new EFCoreIssues.Issues.IssuesContext();
var queryable = context.Issues.AsNoTracking()
.SortBy(args.SortOrder, defaultUniqueSortPropertyName: nameof(EFCoreIssues.Issues.Issue.Id))
.Where(MakeFilterExpression((DevExpress.Data.Filtering.CriteriaOperator)args.Filter));
return(queryable.Skip(args.Skip).Take(args.Take ?? 100).ToArray());
});
}
void OnFetchRows(System.Object sender, DevExpress.Xpf.Data.FetchRowsAsyncEventArgs e)
{
e.Result = Task.Run <DevExpress.Xpf.Data.FetchRowsResult>(() =>
{
var context = new EFCoreIssues.Issues.IssuesContext();
var queryable = context.Issues.AsNoTracking()
.SortBy(e.SortOrder, defaultUniqueSortPropertyName: nameof(EFCoreIssues.Issues.Issue.Id))
.Where(MakeFilterExpression(e.Filter));
return(queryable.Skip(e.Skip).Take(e.Take ?? 100).ToArray());
});
}
public void ValidateRow(DevExpress.Mvvm.Xpf.RowValidationArgs args)
{
var item = (EFCoreIssues.Issues.Issue)args.Item;
var context = new EFCoreIssues.Issues.IssuesContext();
context.Entry(item).State = args.IsNewItem ? EntityState.Added : EntityState.Modified;
try {
context.SaveChanges();
} finally {
context.Entry(item).State = EntityState.Detached;
}
}
void OnValidateRow(System.Object sender, DevExpress.Xpf.Grid.GridRowValidationEventArgs e)
{
var row = (EFCoreIssues.Issues.Issue)e.Row;
var context = new EFCoreIssues.Issues.IssuesContext();
context.Entry(row).State = e.IsNewItem
? EntityState.Added
: EntityState.Modified;
try {
context.SaveChanges();
} finally {
context.Entry(row).State = EntityState.Detached;
}
}
void LoadLookupData()
{
var context = new EFCoreIssues.Issues.IssuesContext();
usersLookup.ItemsSource = context.Users.Select(user => new { Id = user.Id, Name = user.FirstName + " " + user.LastName }).ToArray();
}
void LoadData()
{
_Context = new EFCoreIssues.Issues.IssuesContext();
grid.ItemsSource = _Context.Users.ToList();
}
public void DataSourceRefresh(DevExpress.Mvvm.Xpf.DataSourceRefreshArgs args)
{
_ItemsSource = null;
_Context = null;
RaisePropertyChanged(nameof(ItemsSource));
}
