private void btnProcessStatements_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { using (ProcessStatementsDialogue dlg = new ProcessStatementsDialogue()) { LayoutControlGrid.Validate(); using (var uow = new DevExpress.Xpo.Session()) { XDB.ORG_Company company = null; foreach (XDB.GLX_Account account in this.XPCollection) { switch (IsCustomer) { case true: company = uow.Query <XDB.ORG_Company>().SingleOrDefault(n => n.TypeId.Id == (byte)BL.ORG.ORG_Type.Customer && n.EntityId.EntityId.CodeSub == account.EntityId.CodeSub); break; case false: company = uow.Query <XDB.ORG_Company>().SingleOrDefault(n => n.TypeId.Id == (byte)BL.ORG.ORG_Type.Supplier && n.EntityId.EntityId.CodeSub == account.EntityId.CodeSub); break; } if (account.PrintStatement || account.EmailStatement) { dlg.Statements.Add(new CDS.Client.DataAccessLayer.Types.Statement() { EntityId = account.EntityId.Id, Code = account.EntityId.CodeSub, Name = account.EntityId.Name, Contact = company.AccountsContactName, Email = company.AccountsContactEmail, ShouldPrint = account.PrintStatement, ShouldEmail = account.EmailStatement }); } } } dlg.ShowDialog(); } if (StatementTask != null && StatementTask.Status != System.Threading.Tasks.TaskStatus.RanToCompletion) { Essential.BaseAlert.ShowAlert("Processing statements", "Statements will now be processed in the background.\nClick on \"View Active Processing\" to check progress.", Essential.BaseAlert.Buttons.Ok, Essential.BaseAlert.Icons.Information); btnViewActiveProcessing.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; btnProcessStatements.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; UpdateTimer.Start(); } }
public void GetTotalSummaries(DevExpress.Mvvm.Xpf.GetSummariesAsyncArgs args) { args.Result = Task.Run(() => { using (var session = new DevExpress.Xpo.Session()) { return(session.Query <XPOIssues.Issues.Issue>().Where(MakeFilterExpression((DevExpress.Data.Filtering.CriteriaOperator)args.Filter)).GetSummaries(args.Summaries)); } }); }
void OnGetTotalSummaries(System.Object sender, DevExpress.Xpf.Data.GetSummariesAsyncEventArgs e) { e.Result = Task.Run(() => { using (var session = new DevExpress.Xpo.Session()) { return(session.Query <XPOIssues.Issues.Issue>().Where(MakeFilterExpression(e.Filter)).GetSummaries(e.Summaries)); } }); }
public void FetchRows(DevExpress.Mvvm.Xpf.FetchRowsAsyncArgs args) { args.Result = Task.Run <DevExpress.Xpf.Data.FetchRowsResult>(() => { using (var session = new DevExpress.Xpo.Session()) { var queryable = session.Query <XPOIssues.Issues.Issue>().SortBy(args.SortOrder, defaultUniqueSortPropertyName: nameof(XPOIssues.Issues.Issue.Oid)).Where(MakeFilterExpression((DevExpress.Data.Filtering.CriteriaOperator)args.Filter)); var items = queryable.Skip(args.Skip).Take(args.Take ?? 100).ToArray(); return(DetachedObjectsHelper.ConvertToDetachedObjects(items)); } }); }
void OnFetchRows(System.Object sender, DevExpress.Xpf.Data.FetchRowsAsyncEventArgs e) { e.Result = Task.Run <DevExpress.Xpf.Data.FetchRowsResult>(() => { using (var session = new DevExpress.Xpo.Session()) { var queryable = session.Query <XPOIssues.Issues.Issue>().SortBy(e.SortOrder, defaultUniqueSortPropertyName: nameof(XPOIssues.Issues.Issue.Oid)).Where(MakeFilterExpression(e.Filter)); var items = queryable.Skip(e.Skip).Take(e.Take ?? 100).ToArray(); return(_DetachedObjectsHelper.ConvertToDetachedObjects(items)); } }); }
void LoadLookupData() { var session = new DevExpress.Xpo.Session(); usersLookup.ItemsSource = session.Query <XPOIssues.Issues.User>().OrderBy(user => user.Oid).Select(user => new { Id = user.Oid, Name = user.FirstName + " " + user.LastName }).ToArray(); }
private void GridView_MouseDown(object sender, MouseEventArgs e) { GridView view = sender as GridView; Point p = view.GridControl.PointToClient(MousePosition); GridHitInfo info = view.CalcHitInfo(p); if (info.HitTest == GridHitTest.Column) { LayoutControlGrid.Validate(); var statements = this.XPCollection.Cast <CDS.Client.DataAccessLayer.XDB.GLX_Account>(); bool clearEmail = false, clearPrint = false; if (info.Column == colEmailStatement && statements.Count(n => n.EmailStatement) > 0) { clearEmail = true; } else if (info.Column == colPrintStatement && statements.Count(n => n.PrintStatement) > 0) { clearPrint = true; } using (var uow = new DevExpress.Xpo.Session()) { XDB.ORG_Company company = null; foreach (CDS.Client.DataAccessLayer.XDB.GLX_Account account in XPCollection) { if (account.EntityId.AccountBalance == 0.00M) { continue; } switch (IsCustomer) { case true: company = uow.Query <XDB.ORG_Company>().SingleOrDefault(n => n.TypeId.Id == (byte)BL.ORG.ORG_Type.Customer && n.EntityId.EntityId.CodeSub == account.EntityId.CodeSub); break; case false: company = uow.Query <XDB.ORG_Company>().SingleOrDefault(n => n.TypeId.Id == (byte)BL.ORG.ORG_Type.Supplier && n.EntityId.EntityId.CodeSub == account.EntityId.CodeSub); break; } if (clearEmail) { account.EmailStatement = false; } else if (info.Column == colEmailStatement) { if (company.StatementPreference == "Email" || (company.StatementPreference == "Email, Print" || company.StatementPreference == "Print, Email")) { account.EmailStatement = true; } if (account.EntityId.AccountBalance != 0) { account.EmailStatement = true; } } if (clearPrint) { account.PrintStatement = false; } else if (info.Column == colPrintStatement) { if (company.StatementPreference == "Print" || (company.StatementPreference == "Email, Print" || company.StatementPreference == "Print, Email")) { account.PrintStatement = true; } if (account.EntityId.AccountBalance != 0) { account.PrintStatement = true; } } } } clearEmail = false; clearPrint = false; if (statements.Count(n => n.EmailStatement) > 0 || statements.Count(n => n.PrintStatement) > 0) { btnProcessStatements.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; } else { btnProcessStatements.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; } GridView.RefreshData(); } }