private void InstantFeedbackSourceItem_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { if (BL.ApplicationDataContext.Instance.Modules.Any(n => n.Id == (byte)BL.SYS.SYS_Modules.GLX && n.Code == "YES")) { e.QueryableSource = DataContext.ReadonlyContext.VW_LineItem.Where(n => n.Archived == false && ( ( (new int[] { (byte)BL.SYS.SYS_Type.Account, (byte)BL.SYS.SYS_Type.BuyOut, (byte)BL.SYS.SYS_Type.Message }).Contains(n.TypeId) && (new int[] { (byte)BL.GLX.GLX_Type.Expenses, (byte)BL.GLX.GLX_Type.CurrentAssets }).Contains(n.AccountTypeId.Value) && !(new List <String>() { BL.ApplicationDataContext.Instance.SiteAccounts.DebtorsEntity.CodeMain, BL.ApplicationDataContext.Instance.SiteAccounts.CreditorsEntity.CodeMain }).Contains(n.CodeMain) ) || (n.AccountCostofSalesId.HasValue == true && n.TypeId == (byte)BL.SYS.SYS_Type.Inventory && n.InventorySiteId == BL.ApplicationDataContext.Instance.LoggedInUser.DefaultSiteId) ) ); } else { e.QueryableSource = DataContext.ReadonlyContext.VW_LineItem.Where(n => n.Archived == false && (((new int[] { (byte)BL.SYS.SYS_Type.BuyOut, (byte)BL.SYS.SYS_Type.Message }).Contains(n.TypeId)) || (n.TypeId == (byte)BL.SYS.SYS_Type.Inventory && n.InventorySiteId == BL.ApplicationDataContext.Instance.LoggedInUser.DefaultSiteId))); } }
private void InstantFeedbackSourceSalesHistory_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { DB.SYS_Period currentPeriod = BL.SYS.SYS_Period.GetCurrentPeriod(DataContext); DateTime dateAfter = DateTime.Today.AddYears(-2); e.QueryableSource = DataContext.ReadonlyContext.VW_ItemHistory.Where(n => n.EntityId == itmInventory.EntityId && n.Date > dateAfter && n.Date <= currentPeriod.EndDate && n.SiteId == defaultSiteId); }
private void InstantFeedbackSourceHistory_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { DB.SYS_Period currentPeriod = BL.SYS.SYS_Period.GetCurrentPeriod(DataContext); DateTime dateAfter = DateTime.Today.AddYears(-2); e.QueryableSource = DataContext.ReadonlyContext.VW_CompanyHistory.Where(n => n.CompanyId == orgCompany.Id && n.Date > dateAfter && n.Date <= currentPeriod.EndDate); }
private void EntityInstantFeedbackSource_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { FlextourEntities context = new FlextourEntities(Connection.EFConnectionString); e.QueryableSource = context.REGION; e.Tag = context; }
private void InstantFeedbackSourceAccount_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { if ((BL.ApplicationDataContext.Instance.AccessGranted(BL.SEC.AccessCodes.FIENRE03))) // Harcoded Access: FIEN05 = 544, // Write to Control accounts ) { //Check for Master accountant if (!BL.ApplicationDataContext.Instance.AccessGranted(BL.SEC.AccessCodes.FIAARECR)) { e.QueryableSource = DataContext.ReadonlyContext.VW_Account.Where(n => n.Archived == false && n.SiteId == defaultSiteId); } else { e.QueryableSource = DataContext.ReadonlyContext.VW_Account.Where(n => n.Archived == false); } } else { //Check for Master accountant if (!BL.ApplicationDataContext.Instance.AccessGranted(BL.SEC.AccessCodes.FIAARECR)) { e.QueryableSource = DataContext.ReadonlyContext.VW_Account.Where(n => n.Archived.Equals(false) && n.CodeSub != "00000" && n.SiteId == defaultSiteId); } else { e.QueryableSource = DataContext.ReadonlyContext.VW_Account.Where(n => n.Archived.Equals(false) && n.CodeSub != "00000"); } } }
// This event is generated by Data Source Configuration Wizard void entityInstantFeedbackSource1_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { // Instantiate a new DataContext //Csur.Datos.DBcsurEntities dataContext = new Csur.Datos.DBcsurEntities(); // Assign a queryable source to the EntityInstantFeedbackSource e.QueryableSource = dbContext.CLIENTE; // Assign the DataContext to the Tag property, // to dispose of it in the DismissQueryable event handler e.Tag = dbContext; }
// This event is generated by Data Source Configuration Wizard void linqInstantFeedbackSource1_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { // Instantiate a new DataContext DXApplication9.NegocioDataContext dataContext = new DXApplication9.NegocioDataContext(); // Assign a queryable source to the LinqInstantFeedbackSource e.QueryableSource = dataContext.AgrupacionDeArtista; // Assign the DataContext to the Tag property, // to dispose of it in the DismissQueryable event handler e.Tag = dataContext; }
void entityInstantFeedbackSource1_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { // Instantiate a new DataContext OtelOtomasyonu.db.cyper8Entities dataContext = new OtelOtomasyonu.db.cyper8Entities(); // Assign a queryable source to the EntityInstantFeedbackSource e.QueryableSource = dataContext.TBL_SIRKET_SECIMI; // Assign the DataContext to the Tag property, // to dispose of it in the DismissQueryable event handler e.Tag = dataContext; }
// This event is generated by Data Source Configuration Wizard void linqInstantFeedbackSource1_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { // Instantiate a new DataContext QLNS28.QLNSDataContext dataContext = new QLNS28.QLNSDataContext(); // Assign a queryable source to the LinqInstantFeedbackSource e.QueryableSource = dataContext.NHANVIENs; // Assign the DataContext to the Tag property, // to dispose of it in the DismissQueryable event handler e.Tag = dataContext; }
// This event is generated by Data Source Configuration Wizard void entityInstantFeedbackSource2_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { // Instantiate a new DataContext Entity_Framework_Data.DBContext dataContext = new Entity_Framework_Data.DBContext(); // Assign a queryable source to the EntityInstantFeedbackSource e.QueryableSource = dataContext.DimProducts; // Assign the DataContext to the Tag property, // to dispose of it in the DismissQueryable event handler e.Tag = dataContext; }
// This event is generated by Data Source Configuration Wizard void entityInstantFeedbackSource1_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { // Instantiate a new DataContext OgrenciOtomasyonu.DataBase.TestDevexpresOgrenciOtomasyonEntities3 dataContext = new OgrenciOtomasyonu.DataBase.TestDevexpresOgrenciOtomasyonEntities3(); // Assign a queryable source to the EntityInstantFeedbackSource e.QueryableSource = dataContext.TBL_TELEFONREHBERİ; // Assign the DataContext to the Tag property, // to dispose of it in the DismissQueryable event handler e.Tag = dataContext; }
private void InstantFeedbackSourceAccount_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { if ((BL.ApplicationDataContext.Instance.AccessGranted(BL.SEC.AccessCodes.FIAARECR) && isNew) || (BL.ApplicationDataContext.Instance.AccessGranted(BL.SEC.AccessCodes.FIAAREED) && !isNew)) { e.QueryableSource = DataContext.ReadonlyContext.VW_Account.Where(n => n.Archived == false); } else { long?defaultSiteId = BL.ApplicationDataContext.Instance.LoggedInUser.DefaultSiteId; e.QueryableSource = DataContext.ReadonlyContext.VW_Account.Where(n => n.Archived == false && n.SiteId == defaultSiteId); } }
private void InstantFeedbackSourceDocument_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { e.QueryableSource = DataContext.ReadonlyContext.VW_Document.Where(n => SelectedTypes.Contains(n.TypeId.Value) && n.DatePosted > GetPeriod.StartDate && n.DatePosted < GetPeriod.EndDate && (System.Data.Entity.SqlServer.SqlFunctions.StringConvert((decimal)n.DocumentNumber).Contains(txtSearch.Text) || n.ReferenceLong1.Contains(txtSearch.Text) || n.ReferenceLong2.Contains(txtSearch.Text) || n.ReferenceLong3.Contains(txtSearch.Text) || n.ReferenceLong4.Contains(txtSearch.Text) || n.ReferenceLong5.Contains(txtSearch.Text) || n.ReferenceShort1.Contains(txtSearch.Text) || n.ReferenceShort2.Contains(txtSearch.Text) || n.ReferenceShort3.Contains(txtSearch.Text) || n.ReferenceShort4.Contains(txtSearch.Text) || n.ReferenceShort5.Contains(txtSearch.Text)) ); }
// This event is generated by Data Source Configuration Wizard void entityInstantFeedbackSource1_DismissQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { // Dispose of the DataContext ((OgrenciOtomasyonu.DataBase.TestDevexpresOgrenciOtomasyonEntities3)e.Tag).Dispose(); }
private void InstantFeedbackSourceCompany_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { e.QueryableSource = DataContext.ReadonlyContext.VW_Organisations; }
private void InstantFeedbackSourceItem_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { e.QueryableSource = DataContext.EntityCatalogueContext.CAT_Item.Where(n => n.CAT_ItemData.Any(nn => nn.ItemId != nn.ParentItemId)); }
private void InstantFeedbackSourceStockItem_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { e.QueryableSource = DataContext.ReadonlyContext.VW_LineItem.Where(n => n.Archived == false && (n.TypeId == (byte)BL.SYS.SYS_Type.Inventory)); }
private void InstantFeedbackSourceItem_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { e.QueryableSource = DataContext.ReadonlyContext.VW_LineItem.Where(n => n.InventorySiteId == defaultSiteId ); }
private void InstantFeedbackSourceSupplierRepository_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { e.QueryableSource = DataContext.ReadonlyContext.VW_Company.Where(n => n.TypeId == (byte)BL.ORG.ORG_Type.Supplier); }
private void InstantFeedbackSourceCompany_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { long?defaultSiteId = BL.ApplicationDataContext.Instance.LoggedInUser.DefaultSiteId; e.QueryableSource = DataContext.ReadonlyContext.VW_Company.Where(n => n.TypeId == (byte)BL.ORG.ORG_Type.Customer && n.SiteId == defaultSiteId); }
private void InstantFeedbackSourceVariance_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { e.QueryableSource = DataContext.ReadonlyContext.VW_StockTakeVariance.Where(n => n.StockTakeId == itmStockTake.Id); }
private void InstantFeedbackSourceAlternative_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { e.QueryableSource = DataContext.ReadonlyContext.VW_Alternative.Where(n => n.SearchItemName == SearchItem); }
private void InstantFeedbackSource_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { e.QueryableSource = DataContext.ReadonlyContext.VW_LineItem.Where(n => n.Archived == false && ((new int[] { (byte)BL.SYS.SYS_Type.BuyOut, (byte)BL.SYS.SYS_Type.Message }).Contains(n.TypeId)) || (n.TypeId == (byte)BL.SYS.SYS_Type.Inventory)); }
private void InstantFeedbackSourceRole_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { e.QueryableSource = DataContext.ReadonlyContext.VW_User.Where(n => n.Archived == false); }
private void EntityInstantFeedbackSource_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { }
private void InstantFeedbackSourceCompany_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { e.QueryableSource = DataContext.ReadonlyContext.VW_Entity.Where(n => n.HasCustomer && !n.Archived && n.CompanySiteId == defaultSiteId); }
private void InstantFeedbackSourceRecons_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { e.QueryableSource = DataContext.ReadonlyContext.VW_Recon.Where(n => n.EntityId == glxAccount.EntityId); }
private void InstantFeedbackSourceSupplier_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { e.QueryableSource = DataContext.ReadonlyContext.VW_Company.Where(n => n.TypeId == (byte)BL.ORG.ORG_Type.Supplier && !n.Archived && n.SiteId == defaultSiteId); }
private void EntityInstantFeedbackSource_DismissQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { ((FlextourEntities)e.Tag).Dispose(); }
private void InstantFeedbackSourceRepositoryInventory_GetQueryable(object sender, DevExpress.Data.Linq.GetQueryableEventArgs e) { e.QueryableSource = DataContext.ReadonlyContext.VW_Inventory.Where(n => !n.Archived && n.SiteId == defaultSiteId); }