public AppListInfo LinkListToColumn(TableBase.TableEnum listName, DevExpress.XtraBars.BarEditItem col)
{
AppListInfo l = AppListStore.Find(x => x.AppListName == listName);
l.LinkListToColumn(col);
return(l);
}
public AppListInfo LinkListToColumn(TableBase.TableEnum listName, DevExpress.XtraTreeList.Columns.TreeListColumn col)
{
AppListInfo l = AppListStore.Find(x => x.AppListName == listName);
l.LinkListToColumn(col);
return(l);
}
public AppListInfo LinkListToColumn(TableBase.TableEnum listName, DevExpress.XtraEditors.SearchLookUpEdit col)
{
AppListInfo l = AppListStore.Find(x => x.AppListName == listName);
l.LinkListToColumn(col);
l.AddButtonsToList(col);
return(l);
}
private void LGAppList_InitObj(SqlConnection conn)
{
//.LG_CustomerVendorAccountList
LG_AppListDSTableAdapters.LG_CustomerVendorAccountListTableAdapter lG_CustomerVendorAccountListTableAdapter = new LG_AppListDSTableAdapters.LG_CustomerVendorAccountListTableAdapter()
{
Connection = conn
};
lG_CustomerVendorAccountListTableAdapter.GetData(0); //for load SelectCommand to Adapter
AppListInfo l = new AppListInfo()
{
AppListName = AppListEnum.LG_CustomerVendorAccountList, Conn = conn, RepositoryItem = LG_CustVendListRISearchLookUpEdit, DataMember = lG_AppListDS.LG_CustomerVendorAccountList, DataAdapter = lG_CustomerVendorAccountListTableAdapter.Adapter
};
l.LayoutObject = LG_CustVendListRISearchLookUpEdit.View;
AppListStore.Add(l);
//.LG_BankList
LG_AppListDSTableAdapters.LetterOfGuranateeBankListTableAdapter LG_BankListTableAdapter = new LG_AppListDSTableAdapters.LetterOfGuranateeBankListTableAdapter()
{
Connection = conn
};
LG_BankListTableAdapter.GetData(Convert.ToByte(1));
l = new AppListInfo()
{
AppListName = AppListEnum.LG_BankList, Conn = conn, RepositoryItem = LG_BankListRISearchLookUpEdit, DataMember = lG_AppListDS.LetterOfGuranateeBankList, DataAdapter = LG_BankListTableAdapter.Adapter
};
l.LayoutObject = LG_BankListRISearchLookUpEdit.View;
AppListStore.Add(l);
//. LG_StatusList
LG_AppListDSTableAdapters.LetterOfGuaranteeStatusListTableAdapter lG_StatusListTableAdapter = new LG_AppListDSTableAdapters.LetterOfGuaranteeStatusListTableAdapter()
{
Connection = conn
};
lG_StatusListTableAdapter.GetData();
l = new AppListInfo()
{
AppListName = AppListEnum.LG_StatusList, Conn = conn, RepositoryItem = LG_StatusListRILookUpEdit, DataMember = lG_AppListDS.LetterOfGuaranteeStatusList, DataAdapter = lG_StatusListTableAdapter.Adapter
};
l.LayoutObject = LG_StatusListRILookUpEdit;
AppListStore.Add(l);
//.LG_DocumentType
LG_AppListDSTableAdapters.LGDocumentTypeListTableAdapter lG_DocumentTypeListTableAdapter = new LG_AppListDSTableAdapters.LGDocumentTypeListTableAdapter()
{
Connection = conn
};
lG_DocumentTypeListTableAdapter.GetData();
l = new AppListInfo()
{
AppListName = AppListEnum.LG_DocumentTypeList, Conn = conn, RepositoryItem = LG_DocumentTypeListRILookUpEdit, DataMember = lG_AppListDS.LGDocumentTypeList, DataAdapter = lG_DocumentTypeListTableAdapter.Adapter
};
l.LayoutObject = LG_DocumentTypeListRILookUpEdit;
AppListStore.Add(l);
}
private void InitGridView()
{
//myGridView1.Columns.ColumnByFieldName("TableId").OptionsEditForm.Visible = DevExpress.Utils.DefaultBoolean.False;
//myGridView1.Columns.ColumnByFieldName("TableName").OptionsEditForm.Visible = DevExpress.Utils.DefaultBoolean.False;
//myGridView1.Columns.ColumnByFieldName("TableDBName").OptionsEditForm.Visible = DevExpress.Utils.DefaultBoolean.False;
myGridView1.OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.False;
myGridView1.OptionsBehavior.AllowDeleteRows = DevExpress.Utils.DefaultBoolean.False;
AppLists.AppListInfo lst = new AppLists.AppListInfo(unitOfWork1);
lst.LinkLookupsToGrid(myGridView1, xpCollectionExt1);
}
private void IVAppList_InitObj(SqlConnection conn)
{
//OmarERP.InventoryStoreList
XPCollection InvStoreXPC = new XPCollection(session1, typeof(OmarERP.InventoryStore), false);
AppListInfo l = new AppListInfo()
{
AppListName = AppListEnum.InventoryStoreList, RepositoryItem = inventoryStoreRILookUpEdit, DataMemberXPCollection = InvStoreXPC, IsORMDataUsed = true
};
l.LayoutObject = inventoryStoreRILookUpEdit;
AppListStore.Add(l);
}
private void FXAppList_InitObj(Session conn)
{
#region OldCodeUsingDataSet
//.FixedAssetCategoryTreeList
//FX_AppListDSTableAdapters.FixedAssetCategoryListTableAdapter fixedAssetCategoryListTableAdapter = new FX_AppListDSTableAdapters.FixedAssetCategoryListTableAdapter(){Connection = conn};
//fixedAssetCategoryListTableAdapter.GetData(); //for load SelectCommand to Adapter
//AppListInfo l = new AppListInfo() { AppListName = AppListEnum.FixedAssetCategoryTreeList, Conn = conn, RepositoryItem = fXACategoryRITreeListLookUpEdit, DataMember = fX_AppListDS.FixedAssetCategoryList, DataAdapter = fixedAssetCategoryListTableAdapter.Adapter };
//l.LayoutObject = fXACategoryRITreeListLookUpEdit.TreeList;
//AppListStore.Add(l);
//.FixedAssetGeoLocationList
//FX_AppListDSTableAdapters.FixedAssetGeoLocationListTableAdapter fixedAssetGeoLocationListTableAdapter = new FX_AppListDSTableAdapters.FixedAssetGeoLocationListTableAdapter() { Connection = conn};
//fixedAssetGeoLocationListTableAdapter.GetData();
//l = new AppListInfo() { AppListName = AppListEnum.FixedAssetGeoLocationTreeList, Conn = conn, RepositoryItem = geoLocationRITreeListLookUpEdit, DataMember = fX_AppListDS.FixedAssetGeoLocationList, DataAdapter = fixedAssetGeoLocationListTableAdapter.Adapter };
//l.LayoutObject = geoLocationRITreeListLookUpEdit.TreeList;
//AppListStore.Add(l);
////FixedAssetTypeList
//FX_AppListDSTableAdapters.FixedAssetTypeListTableAdapter fixedAssetTypeListTableAdapter = new FX_AppListDSTableAdapters.FixedAssetTypeListTableAdapter() { Connection = conn };
//fixedAssetTypeListTableAdapter.GetData();
//l = new AppListInfo() { AppListName = AppListEnum.FixedAssetTypeList, Conn = conn, RepositoryItem = fixedAssetTypeRILookUpEdit, DataMember = fX_AppListDS.FixedAssetTypeList, DataAdapter = fixedAssetTypeListTableAdapter.Adapter };
//l.LayoutObject = fixedAssetTypeRILookUpEdit;
//AppListStore.Add(l);
#endregion
//AppLists.OmarERP.FXCategoryList
XPCollection FXCatXPC = new XPCollection(session1, typeof(OmarERP.FXCategoryList), false);
AppListInfo l = new AppListInfo()
{
AppListName = AppListEnum.FixedAssetCategoryTreeList, RepositoryItem = fXACategoryRITreeListLookUpEdit, DataMemberXPCollection = FXCatXPC, IsORMDataUsed = true
};
l.LayoutObject = fXACategoryRITreeListLookUpEdit.TreeList;
AppListStore.Add(l);
//OmarERP.FXGeolocationList
XPCollection FXGeoXPC = new XPCollection(session1, typeof(OmarERP.FXGeolocationList), false);
l = new AppListInfo()
{
AppListName = AppListEnum.FixedAssetGeoLocationTreeList, RepositoryItem = geoLocationRITreeListLookUpEdit, DataMemberXPCollection = FXGeoXPC, IsORMDataUsed = true
};
l.LayoutObject = geoLocationRITreeListLookUpEdit.TreeList;
AppListStore.Add(l);
//OmarERP.FXTypeList
XPCollection FXTypeXPC = new XPCollection(session1, typeof(OmarERP.FXTypeList), false);
l = new AppListInfo()
{
AppListName = AppListEnum.FixedAssetTypeList, RepositoryItem = fixedAssetTypeRILookUpEdit, DataMemberXPCollection = FXTypeXPC, IsORMDataUsed = true
};
l.LayoutObject = fixedAssetTypeRILookUpEdit;
AppListStore.Add(l);
}
private void HRAppList_InitObj(SqlConnection conn)
{
//.EmployeeSimpleList
HR_AppListDSTableAdapters.EmployeeFullDataViewListTableAdapter employeeFullDataViewListTableAdapter = new HR_AppListDSTableAdapters.EmployeeFullDataViewListTableAdapter()
{
Connection = conn
};
employeeFullDataViewListTableAdapter.GetData(); //for load SelectCommand to Adapter
AppListInfo l = new AppListInfo()
{
AppListName = AppListEnum.EmployeeSimpleList, Conn = conn, RepositoryItem = empsRISearchLookUpEdit, DataMember = hR_AppListDS.EmployeeFullDataViewList, DataAdapter = employeeFullDataViewListTableAdapter.Adapter
};
l.LayoutObject = empsRISearchLookUpEdit.View;
AppListStore.Add(l);
}
private void GLAppList_InitObj(SqlConnection conn)
{
//OmarERP.AccountTypeList
XPCollection ActTypeXPC = new XPCollection(session1, typeof(MainAccountType), false);
AppListInfo l = new AppListInfo()
{
AppListName = TableBase.TableEnum.MainAccountType, RepositoryItem = accountTypeRILookUpEdit, DataMemberXPCollection = ActTypeXPC, IsORMDataUsed = true
};
accountTypeRILookUpEdit.DisplayMember = "DisplayName";
accountTypeRILookUpEdit.ValueMember = "AccountType";
l.LayoutObject = accountTypeRILookUpEdit;
AppListStore.Add(l);
//OmarERP.BankList For GL Bank Acccount
XPCollection BankListXPC = new XPCollection(session1, typeof(OmarERP.BankList), true)
{
Criteria = DevExpress.Data.Filtering.CriteriaOperator.Parse("BankGroup = 'B' ")
};
l = new AppListInfo()
{
AppListName = AppListEnum.BankListForGL, RepositoryItem = bankAccountRISearchLookUpEdit, DataMemberXPCollection = BankListXPC, IsORMDataUsed = true
};
bankAccountRISearchLookUpEdit.DisplayMember = "Name";
bankAccountRISearchLookUpEdit.ValueMember = "AccountID";
l.LayoutObject = bankAccountRISearchLookUpEdit.View;
AppListStore.Add(l);
//OmarERP.BankList for Treasuery for AP
XPCollection TreasueryListXPC = new XPCollection(session1, typeof(OmarERP.BankList), true)
{
Criteria = DevExpress.Data.Filtering.CriteriaOperator.Parse("BankGroup = 'C' ")
};
l = new AppListInfo()
{
AppListName = AppListEnum.BankListForTreasuery, RepositoryItem = bankAccountRISearchLookUpEdit, DataMemberXPCollection = TreasueryListXPC, IsORMDataUsed = true
};
bankAccountRISearchLookUpEdit.DisplayMember = "Name";
bankAccountRISearchLookUpEdit.ValueMember = "AccountID";
l.LayoutObject = bankAccountRISearchLookUpEdit.View;
AppListStore.Add(l);
}
private void CTAppList_InitObj(SqlConnection conn)
{
//.CostAccountList
//CT_AppListDSTableAdapters.CostAccountEntityViewListTableAdapter costAccountEntityViewListTableAdapter = new CT_AppListDSTableAdapters.CostAccountEntityViewListTableAdapter() { Connection = conn };
//costAccountEntityViewListTableAdapter.GetData(); //for load SelectCommand to Adapter
//AppListInfo l = new AppListInfo() { AppListName = AppListEnum.CostAccountList, Conn = conn, RepositoryItem = costList, DataMember = cT_AppListDS.CostAccountEntityViewList, DataAdapter = costAccountEntityViewListTableAdapter.Adapter };
//l.LayoutObject = costList.View;
//AppListStore.Add(l);
//.POSAccountList
//CT_AppListDSTableAdapters.POSAccountListTableAdapter pOSAccountListTableAdapter = new CT_AppListDSTableAdapters.POSAccountListTableAdapter() { Connection = conn };
//pOSAccountListTableAdapter.GetData();
//l = new AppListInfo() { AppListName = AppListEnum.POSAccountList, Conn = conn, RepositoryItem = pOSAccountList, DataMember = cT_AppListDS.POSAccountList, DataAdapter = pOSAccountListTableAdapter.Adapter };
//l.LayoutObject = pOSAccountList.View;
//AppListStore.Add(l);
//AppLists.OmarERP.CostAccountList
XPCollection <AppLists.OmarERP.CostAccountList> CostXPC = new XPCollection <OmarERP.CostAccountList>(this.session1, false);
AppListInfo l = new AppListInfo()
{
AppListName = AppListEnum.CostAccountList, RepositoryItem = costList, DataMemberXPCollection = CostXPC, IsORMDataUsed = true
};
l.LayoutObject = costList.View;
AppListStore.Add(l);
//AppLists.OmarERP.POSAccountList
XPCollection POSXPC = new XPCollection(session1, typeof(OmarERP.POSAccountList), false)
{
Sorting = new SortingCollection {
new SortProperty("Name", DevExpress.Xpo.DB.SortingDirection.Ascending)
}
};
l = new AppListInfo()
{
AppListName = AppListEnum.POSAccountList, RepositoryItem = pOSAccountList, DataMemberXPCollection = POSXPC, IsORMDataUsed = true
};
l.LayoutObject = pOSAccountList.View;
AppListStore.Add(l);
}
private void MISAppList_InitObj(SqlConnection conn)
{
//.CurrencyList
SYS_AppListDSTableAdapters.CurrencyEntityViewListTableAdapter currencyEntityViewListTableAdapter = new SYS_AppListDSTableAdapters.CurrencyEntityViewListTableAdapter()
{
Connection = conn
};
currencyEntityViewListTableAdapter.GetData(); //for load SelectCommand to Adapter
AppListInfo l = new AppListInfo()
{
AppListName = AppListEnum.CurrencyList, Conn = conn, RepositoryItem = currencyRILookUpEdit, DataMember = sYS_AppListDS.CurrencyEntityViewList, DataAdapter = currencyEntityViewListTableAdapter.Adapter
};
l.LayoutObject = currencyRILookUpEdit;
AppListStore.Add(l);
//DocumentType
SYS_AppListDSTableAdapters.DocumentTypeTableListTableAdapter documentTypeTableListTableAdapter = new SYS_AppListDSTableAdapters.DocumentTypeTableListTableAdapter()
{
Connection = conn
};
documentTypeTableListTableAdapter.GetData();
l = new AppListInfo()
{
AppListName = AppListEnum.DocumentTypeList, Conn = conn, RepositoryItem = documentTypeRILookUpEdit, DataMember = sYS_AppListDS.DocumentTypeTableList, DataAdapter = documentTypeTableListTableAdapter.Adapter
};
l.LayoutObject = documentTypeRILookUpEdit;
AppListStore.Add(l);
SYS_AppListDSTableAdapters.FinancialPeriodListTableAdapter financialPeriodListTableAdapter = new SYS_AppListDSTableAdapters.FinancialPeriodListTableAdapter()
{
Connection = conn
};
financialPeriodListTableAdapter.GetData();
l = new AppListInfo()
{
AppListName = AppListEnum.FinancialPeriodList, Conn = conn, RepositoryItem = finPeriodListRISearchLookUpEdit, DataMember = sYS_AppListDS.FinancialPeriodList, DataAdapter = financialPeriodListTableAdapter.Adapter
};
l.LayoutObject = finPeriodListRISearchLookUpEdit.View;
AppListStore.Add(l);
//JournalList
SYS_AppListDSTableAdapters.JournalEntityViewListTableAdapter journalEntityViewListTableAdapter = new SYS_AppListDSTableAdapters.JournalEntityViewListTableAdapter()
{
Connection = conn
};
journalEntityViewListTableAdapter.GetData();
l = new AppListInfo()
{
AppListName = AppListEnum.JournalList, Conn = conn, RepositoryItem = journalListRILookUpEdit, DataMember = sYS_AppListDS.JournalEntityViewList, DataAdapter = journalEntityViewListTableAdapter.Adapter
};
l.LayoutObject = journalListRILookUpEdit;
AppListStore.Add(l);
//JournalClass
//OmarERP.JournalCalssName
XPCollection JournalClassXPC = new XPCollection(session1, typeof(OmarERP.JournalCalssName), false);
l = new AppListInfo()
{
AppListName = AppListEnum.JournalClassName, RepositoryItem = journalClassLookupEdit, DataMemberXPCollection = JournalClassXPC, IsORMDataUsed = true
};
l.LayoutObject = journalClassLookupEdit;
AppListStore.Add(l);
//JournalPermittedList
SYS_AppListDSTableAdapters.F_ERPSys_PrincipalsJournalTableAdapter f_ERPSys_PrincipalsJournalTableAdapter = new SYS_AppListDSTableAdapters.F_ERPSys_PrincipalsJournalTableAdapter()
{
Connection = conn
};
f_ERPSys_PrincipalsJournalTableAdapter.GetData();
RepositoryItemLookUpEdit journalListRILookUpEditMirror2 = new RepositoryItemLookUpEdit();
l.CopySettings(journalListRILookUpEdit, journalListRILookUpEditMirror2);
l = new AppListInfo()
{
AppListName = AppListEnum.JournalPermittedList, Conn = conn, RepositoryItem = journalListRILookUpEditMirror2, DataMember = sYS_AppListDS.F_ERPSys_PrincipalsJournal, DataAdapter = f_ERPSys_PrincipalsJournalTableAdapter.Adapter
};
l.LayoutObject = journalListRILookUpEditMirror2;
AppListStore.Add(l);
}
public AppListInfo GetAppList(TableBase.TableEnum listName)
{
AppListInfo lst = AppListStore.Find(x => x.AppListName == listName);
return(lst);
}