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);
}
