public SearchChequeViewModel() { if (!IsDesignTime) { Glclient = new GlServiceClient(); MainRowList = new SortableCollectionView <TblBankCheque>(); SelectedMainRow = new TblBankCheque(); Glclient.CreateChequeCompleted += (s, sv) => GetMaindata(); Glclient.GetTblBankChequeCompleted += (s, sv) => { foreach (var row in sv.Result) { MainRowList.Add(row); } if (Bank != 0 && ValuesObjects != null && (!MainRowList.Any() && ValuesObjects.ContainsKey("Cheque0"))) { var res = MessageBox.Show("This Cheque is Not Found Do You Want To Create It ?", "Create Cheque", MessageBoxButton.OKCancel); if (res == MessageBoxResult.OK) { Glclient.CreateChequeAsync(Bank, (long)ValuesObjects.FirstOrDefault(w => w.Key == "Cheque0").Value, 1, LoggedUserInfo.DatabasEname); } } Loading = false; FullCount = sv.fullCount; }; } }
public SearchAssetsTransactionViewModel() { if (!DesignerProperties.IsInDesignTool) { MainRowList = new SortableCollectionView <TblAssetsTransactionViewModel>(); SelectedMainRow = new TblAssetsTransactionViewModel(); Client.GetTblAssetsTransactionCompleted += (s, sv) => { foreach (var row in sv.Result) { if (sv.Stores != null) { var newrow = new TblAssetsTransactionViewModel { StorePerRow = sv.Stores.FirstOrDefault( x => x.Code == row.StoreCode && x.Organization == row.OrganizationId) }; var tempEmp = sv.employees.FirstOrDefault(x => x.EMPLID == row.Empid); if (tempEmp != null) { newrow.EmpPerRow = new EmployeesView { Emplid = row.Empid, Name = tempEmp.name }; } newrow.AssetPerRow.InjectFrom(row.TblAsset); newrow.InjectFrom(row); MainRowList.Add(newrow); } } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null || SelectedMainRow.Iserial == 0)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (Export) { Export = false; //var handler = ExportCompleted; //if (handler != null) handler(this, EventArgs.Empty); //ExportGrid.ExportExcel("Style"); } }; GetMaindata(); } }
public CostDimChildViewModel(LedgerHeaderViewModel ledgerHeaderViewModel) { if (!IsDesignTime) { LedgerHeaderViewModel = ledgerHeaderViewModel; GetItemPermissions(PermissionItemName.Account.ToString()); Glclient = new GlServiceClient(); MainRowList = new SortableCollectionView <TblCostDimDetailViewModel>(); SelectedMainRow = new TblCostDimDetailViewModel(); Glclient.GetTblCostDimSetupHeaderForAccountCompleted += (s, sv) => { if (sv.Result != null) { foreach (var row in sv.Result.TblCostDimDetails) { var newrow = new TblCostDimDetailViewModel(); newrow.InjectFrom(row); newrow.CostCenterPerRow = row.TblCostCenter1; MainRowList.Add(newrow); } } Loading = false; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } }; Glclient.SaveTblCostDimHeaderCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { ledgerHeaderViewModel.SelectedDetailRow.TblCostDimHeader = ev.Result; ledgerHeaderViewModel.SaveMainRow(); } catch (Exception) { } }; GetMaindata(); } }
public SearchAssetsViewModel() { if (!DesignerProperties.IsInDesignTool) { MainRowList = new SortableCollectionView <TblAssetsViewModel>(); SelectedMainRow = new TblAssetsViewModel(); Client.GetTblAssetsCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblAssetsViewModel(); newrow.InjectFrom(row); if (row.TblAssetsType1 != null) { newrow.AssetTypePerRow.InjectFrom(row.TblAssetsType1); } if (row.TblHardDisk1 != null) { newrow.HardDiskPerRow.InjectFrom(row.TblHardDisk1); } if (row.TblMemory1 != null) { newrow.MemoryPerRow.InjectFrom(row.TblMemory1); } if (row.TblProcessor1 != null) { newrow.ProcessorPerRow.InjectFrom(row.TblProcessor1); } newrow.Pending = sv.PendingAssets.Any(x => x == row.Iserial); MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null || SelectedMainRow.Iserial == 0)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (Export) { Export = false; //var handler = ExportCompleted; //if (handler != null) handler(this, EventArgs.Empty); //ExportGrid.ExportExcel("Style"); } }; GetMaindata(); } }
public GlGenEntityViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.GlGenEntity.ToString()); Glclient = new GlServiceClient(); Glclient.GetTblJournalAccountTypeCompleted += (s, sv) => { JournalAccountTypeList = sv.Result; }; Glclient.GetTblJournalAccountTypeAsync(true, LoggedUserInfo.DatabasEname); MainRowList = new SortableCollectionView <TblGlGenEntityGroupViewModel>(); SelectedMainRow = new TblGlGenEntityGroupViewModel(); Glclient.GetTblGlGenEntityGroupCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblGlGenEntityGroupViewModel(); newrow.InjectFrom(row); MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } }; Glclient.UpdateOrInsertTblGlGenEntityGroupCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } Loading = false; }; Glclient.DeleteTblGlGenEntityGroupCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; Glclient.GetTblGlGenEntityCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblGlGenEntityViewModel(); newrow.InjectFrom(row); SelectedMainRow.DetailsList.Add(newrow); } Loading = false; DetailFullCount = sv.fullCount; if (SelectedMainRow.DetailsList.Any() && (SelectedDetailRow == null)) { SelectedDetailRow = SelectedMainRow.DetailsList.FirstOrDefault(); } if (DetailFullCount == 0 && SelectedMainRow.DetailsList.Count == 0) { AddNewDetailRow(false); } }; Glclient.UpdateOrInsertTblGlGenEntityCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { SelectedMainRow.DetailsList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } }; Glclient.DeleteTblGlGenEntityCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = SelectedMainRow.DetailsList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { SelectedMainRow.DetailsList.Remove(oldrow); } if (!SelectedMainRow.DetailsList.Any()) { AddNewDetailRow(false); } }; } }
public InventPostingViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.InventPosting.ToString()); Glclient = new GlServiceClient(); MainRowList = new SortableCollectionView <TblInventPostingViewModel>(); SelectedMainRow = new TblInventPostingViewModel(); Glclient.GetGlItemGroupAsync(LoggedUserInfo.DatabasEname); Glclient.GetGlItemGroupCompleted += (s, sv) => { ItemGroupList = sv.Result; }; Glclient.GetTblInventPostingTypeAsync(LoggedUserInfo.DatabasEname); Glclient.GetTblInventPostingTypeCompleted += (s, sv) => { InventPostingTypeList = sv.Result; Items = new ObservableCollection <TblInventAccountType>(InventPostingTypeList.Where(x => x.TabName == "SalesOrder")); }; Glclient.GetTblInventPostingCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblInventPostingViewModel { AccountPerRow = row.TblAccount1, ItemGroupPerRow = ItemGroupList.FirstOrDefault(x => x.Iserial == row.ItemScopeRelation) }; newrow.InjectFrom(row); newrow.JournalAccountTypePerRow = JournalAccountTypePerRow; if (sv.entityList != null && sv.entityList.Any(x => x.scope == row.SupCustScope && x.Iserial == row.SupCustRelation)) { newrow.EntityAccountPerRow = sv.entityList.First(x => x.scope == row.SupCustScope && x.Iserial == row.SupCustRelation); } MainRowList.Add(newrow); } Loading = false; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (MainRowList.Count == 0) { AddNewMainRow(false); } }; Glclient.UpdateOrInsertTblInventPostingsCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } // ReSharper disable once EmptyGeneralCatchClause catch { } }; Glclient.DeleteTblInventPostingCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; } }
public IncomeStatmentDesignViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.IncomeStatmentDesign.ToString()); Glclient = new GlServiceClient(); MainRowList = new SortableCollectionView <TblIncomeStatmentDesignHeaderViewModel>(); SelectedMainRow = new TblIncomeStatmentDesignHeaderViewModel(); JournalAccountTypeList = new ObservableCollection <GenericTable>(); JournalAccountTypeList.Add(new GenericTable { Code = "Label" }); JournalAccountTypeList.Add(new GenericTable { Code = "Account" }); JournalAccountTypeList.Add(new GenericTable { Code = "Account With Subs" }); JournalAccountTypeList.Add(new GenericTable { Code = "Cost Of Good Sold" }); JournalAccountTypeList.Add(new GenericTable { Code = "Income Tax" }); JournalAccountTypeList.Add(new GenericTable { Code = "Seprator" }); JournalAccountTypeList.Add(new GenericTable { Code = "Double Seprator" }); JournalAccountTypeList.Add(new GenericTable { Code = "Total" }); Glclient.GetTblIncomeStatmentDesignHeaderCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblIncomeStatmentDesignHeaderViewModel(); newrow.InjectFrom(row); MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Count == 1) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } if (Export) { Export = false; AllowExport = true; //ExportGrid.ExportExcel("IncomeStatmentDesign"); } }; Glclient.UpdateOrInsertTblIncomeStatmentDesignHeaderCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } Loading = false; }; Glclient.DeleteTblIncomeStatmentDesignHeaderCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; Glclient.GetTblIncomeStatmentDesignDetailCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblIncomeStatmentDesignDetailViewModel(); newrow.InjectFrom(row); if (row.Type.StartsWith("Account")) { newrow.Type = row.Type; newrow.AccountPerRow = new TblAccount { Code = row.Description }; } SelectedMainRow.DetailsList.Add(newrow); } Loading = false; DetailFullCount = sv.fullCount; if (SelectedMainRow.DetailsList.Count == 1) { SelectedDetailRow = SelectedMainRow.DetailsList.FirstOrDefault(); } if (DetailFullCount == 0 && SelectedMainRow.DetailsList.Count == 0) { AddNewDetailRow(false); } }; Glclient.UpdateOrInsertIncomeStatmentDesignDetailCompleted += (s, x) => { var savedRow = (TblIncomeStatmentDesignDetailViewModel)SelectedMainRow.DetailsList.GetItemAt(x.outindex); if (savedRow != null) { savedRow.InjectFrom(x.Result); } Loading = false; }; Glclient.DeleteIncomeStatmentDesignDetailCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } Loading = false; var oldrow = SelectedMainRow.DetailsList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { SelectedMainRow.DetailsList.Remove(oldrow); } if (!SelectedMainRow.DetailsList.Any()) { AddNewDetailRow(false); } }; GetMaindata(); } }
public PostingProfileHeaderViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.PostingProfile.ToString()); Glclient = new GlServiceClient(); MainRowList = new SortableCollectionView <TblPostingProfileHeaderViewModel>(); SelectedMainRow = new TblPostingProfileHeaderViewModel(); var journalAccountTypeClient = new GlServiceClient(); journalAccountTypeClient.GetGenericCompleted += (s, sv) => { JournalAccountTypeList = sv.Result; }; journalAccountTypeClient.GetGenericAsync("TblJournalAccountType", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); Glclient.GetTblPostingProfileHeaderCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblPostingProfileHeaderViewModel(); newrow.InjectFrom(row); MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } }; Glclient.UpdateOrInsertTblPostingProfileHeadersCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } }; Glclient.DeleteTblPostingProfileHeaderCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; Glclient.GetTblPostingProfileDetailCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblPostingProfileDetailViewModel { AccountPerRow = row.TblAccount1, JournalAccountTypePerRow = new GenericTable() }; newrow.JournalAccountTypePerRow.InjectFrom(row.TblJournalAccountType); newrow.InjectFrom(row); newrow.EntityAccountPerRow = sv.entityList.FirstOrDefault(x => x.TblJournalAccountType == newrow.Type && x.scope == newrow.Scope && x.Iserial == newrow.Entity); SelectedMainRow.DetailsList.Add(newrow); } Loading = false; DetailFullCount = sv.fullCount; if (SelectedMainRow.DetailsList.Any() && (SelectedDetailRow == null)) { SelectedDetailRow = SelectedMainRow.DetailsList.FirstOrDefault(); } if (DetailFullCount == 0 && SelectedMainRow.DetailsList.Count == 0) { AddNewDetailRow(false); } if (Export) { Export = false; ExportGrid.ExportExcel("Users"); } }; Glclient.UpdateOrInsertTblPostingProfileDetailsCompleted += (s, x) => { var savedRow = (TblPostingProfileDetailViewModel)SelectedMainRow.DetailsList.GetItemAt(x.outindex); if (savedRow != null) { savedRow.InjectFrom(x.Result); } Loading = false; }; Glclient.DeleteTblPostingProfileDetailCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } Loading = false; var oldrow = SelectedMainRow.DetailsList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { SelectedMainRow.DetailsList.Remove(oldrow); } if (!SelectedMainRow.DetailsList.Any()) { AddNewDetailRow(false); } }; GetMaindata(); } }
public GlRuleJobViewModel() { if (!IsDesignTime) { Client.GetGenericAsync("TblAuthJob", "%%", "%%", "%%", "Iserial", "ASC"); Client.GetGenericCompleted += (s, sv) => { JobList = sv.Result; }; GetItemPermissions(PermissionItemName.GlRuleJob.ToString()); Glclient = new GlServiceClient(); var glRuleHeaderClient = new GlServiceClient(); glRuleHeaderClient.GetGenericCompleted += (s, sv) => { GlRuleHeaderList = sv.Result; }; glRuleHeaderClient.GetGenericAsync("TblGlRuleHeader", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); MainRowList = new SortableCollectionView <TblGlRuleJobViewModel>(); SelectedMainRow = new TblGlRuleJobViewModel(); Glclient.GetTblGlRuleJobCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblGlRuleJobViewModel(); newrow.InjectFrom(row); newrow.GlRuleHeaderPerRow = new GenericTable(); if (sv.userList.FirstOrDefault(x => x.Iserial == row.TblJob) != null) { newrow.JobPerRow = new CRUDManagerService.GenericTable(); newrow.JobPerRow.InjectFrom(sv.userList.FirstOrDefault(x => x.Iserial == row.TblJob)); } newrow.GlRuleHeaderPerRow.InjectFrom(row.TblGlRuleHeader1); MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } }; Glclient.UpdateOrInsertTblGlRuleJobsCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } // ReSharper disable once EmptyGeneralCatchClause catch (Exception) { } }; Glclient.DeleteTblGlRuleJobCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; GetMaindata(); } }
public StandardBomViewModel() { if (!DesignerProperties.IsInDesignTool) { GetItemPermissions(PermissionItemName.StandardBomForm.ToString()); GetSeason(); var calculationClient = new CRUD_ManagerServiceClient(); calculationClient.GetGenericCompleted += (s, sv) => { BomCalcMethodList = sv.Result; }; calculationClient.GetGenericAsync("BOM_CalcMethod", "%%", "%%", "%%", "Iserial", "ASC"); //Client.GetTblPaymentScheduleCompleted += (s, sv) => //{ // PaymentScheduleList = sv.Result; //}; //Client.GetTblPaymentScheduleAsync(0, int.MaxValue, "it.Iserial", null, null); var uomClient = new CRUD_ManagerServiceClient(); uomClient.GetGenericCompleted += (s, sv) => { UomList = sv.Result; }; uomClient.GetGenericAsync("tbl_lkp_UoM", "%%", "%%", "%%", "Iserial", "ASC"); MainRowList = new SortableCollectionView <TblStandardBomHeaderViewModel>(); SelectedMainRow = new TblStandardBomHeaderViewModel(); // MainRowList.CollectionChanged += MainRowList_CollectionChanged; var factorGroupClient = new CRUD_ManagerServiceClient(); factorGroupClient.GetGenericCompleted += (s, sv) => { FactoryGroupList = sv.Result; }; factorGroupClient.GetGenericAsync("TblFactoryGroup", "%%", "%%", "%%", "Iserial", "ASC"); var complixtyGroupClient = new CRUD_ManagerServiceClient(); complixtyGroupClient.GetGenericCompleted += (s, sv) => { //complix GroupList = sv.Result; }; factorGroupClient.GetGenericAsync("TblFactoryGroup", "%%", "%%", "%%", "Iserial", "ASC"); Client.GetAllBrandsCompleted += (s, sv) => { BrandList = sv.Result; }; Client.GetAllBrandsAsync(LoggedUserInfo.Iserial); Client.GetTblStandardBOMHeaderCompleted += (s, sv) => { Loading = false; if (sv.Result != null) { foreach (var row in sv.Result) { var newrow = new TblStandardBomHeaderViewModel(); newrow.InjectFrom(row); if (!MainRowList.Contains(newrow)) { newrow.SeasonPerRow = new TblLkpSeason(); newrow.FactoryGroupPerRow = new GenericTable(); newrow.ComplexityGroupPerRow = new GenericTable(); if (BrandSectionList.All(x => x.Iserial != row.TblLkpBrandSection1.Iserial)) { BrandSectionList.Add(new LkpData.TblLkpBrandSection().InjectFrom(row.TblLkpBrandSection1) as LkpData.TblLkpBrandSection); } if (SeasonList.All(x => x.Iserial != row.TblLkpSeason)) { SeasonList.Add(new TblLkpSeason().InjectFrom(row.TblLkpSeason1) as TblLkpSeason); } newrow.FactoryGroupPerRow = new GenericTable().InjectFrom(row.TblFactoryGroup1) as GenericTable; if (row.TblComplexityGroup1 != null) { newrow.ComplexityGroupPerRow = new GenericTable().InjectFrom(row.TblComplexityGroup1) as GenericTable; } newrow.SectionPerRow = row.TblLkpBrandSection1; newrow.SeasonPerRow = SeasonList.FirstOrDefault(x => x.Iserial == newrow.TblLkpSeason); MainRowList.Add(newrow); } } } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null || SelectedMainRow.Iserial == 0)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } if (Export) { Export = false; var handler = ExportCompleted; if (handler != null) { handler(this, EventArgs.Empty); } //ExportGrid.ExportExcel("Style"); } }; GetMaindata(); Client.UpdateOrInsertTblStandardBOMHeaderCompleted += (s, sv) => { var savedRow = MainRowList.ElementAt(sv.outindex); if (savedRow != null) { savedRow.InjectFrom(sv.Result); } Loading = false; }; Client.DeleteTblStandardBOMHeaderCompleted += (s, ev) => { var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result.Iserial); if (oldrow != null) { MainRowList.Remove(oldrow); } Loading = false; if (!MainRowList.Any()) { AddNewMainRow(false); } }; Client.DeleteTblStandardBOMCompleted += (s, sv) => { Loading = false; if (sv.Error != null) { throw sv.Error; } var oldrow = SelectedMainRow.BomList.FirstOrDefault(x => x.Iserial == sv.Result); if (oldrow != null) { SelectedMainRow.BomList.Remove(oldrow); } }; Client.GetTblStandardBOMCompleted += (s, sv) => { SelectedMainRow.BomList.Clear(); foreach (var row in sv.Result) { var newrow = new BomViewModel { BOM_CalcMethodPerRow = new GenericTable().InjectFrom(row.BOM_CalcMethod) as GenericTable, BOM_FabricTypePerRow = new GenericTable().InjectFrom(row.BOM_FabricType) as GenericTable }; newrow.ColorPerRow = new TblColor(); newrow.ColorPerRow = row.TblColor1; newrow.InjectFrom(row); newrow.ItemPerRow = sv.itemsList.SingleOrDefault(x => x.Iserial == row.BOM_Fabric); SelectedMainRow.BomList.Add(newrow); } if (SelectedMainRow.BomList.Count == 0) { AddBom(false); } }; Client.UpdateOrInsertTblStandardBOMCompleted += (s, sv) => { Loading = false; if (sv.Error != null) { MessageBox.Show(sv.Error.Message); return; } GetSalesOrderBom(); }; } }
public CashDepositeTypeViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.CashdepositeTypeForm.ToString()); Glclient = new GlServiceClient(); MainRowList = new SortableCollectionView <TblCashDepositeTypeViewModel>(); SelectedMainRow = new TblCashDepositeTypeViewModel(); if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } //if (FullCount == 0 && MainRowList.Count == 0) //{ // AddNewMainRow(false); //} Glclient.GetTblCashDepositTypeCompleted += (s, sv) => { CashDepositTypeList = sv.Result; foreach (var row in sv.Result) { var newrow = new TblCashDepositeTypeViewModel(); newrow.TblSequencePerRow = new GenericTable(); newrow.DepositeTypeGroupPerRow = new GenericTable(); newrow.InjectFrom(row); if (row.TblSequence1 != null) { newrow.TblSequencePerRow.InjectFrom(row.TblSequence1); } if (row.DepositeTypeGroup != null && row.DepositeTypeGroup != 0) { newrow.DepositeTypeGroupPerRow.InjectFrom(CashDepositTypeList.FirstOrDefault(x => x.Iserial == newrow.DepositeTypeGroup)); } MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } if (Export) { Export = false; ExportGrid.ExportExcel("CashDepositeType"); } }; Glclient.UpdateOrInsertTblCashDepositTypeCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } }; Glclient.DeleteTblCashDepositTypesCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; Glclient.GetCashDepositeSequenceCompleted += (s, sv) => { SequenceList = sv.Result; }; Glclient.GetCashDepositeSequenceAsync(LoggedUserInfo.DatabasEname); GetMaindata(); } }
public MarkupViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.Markup.ToString()); Glclient = new GlServiceClient(); var tblRecInvHeaderTypeClient = new GlServiceClient(); tblRecInvHeaderTypeClient.GetGenericCompleted += (s, sv) => { MarkupGroupList = sv.Result; }; tblRecInvHeaderTypeClient.GetGenericAsync("TblMarkupGroup", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); DirectionList = new ObservableCollection <GenericTable> { new GenericTable { Iserial = 1, Code = "1", Ename = "1", Aname = "1" }, new GenericTable { Iserial = -1, Code = "-1", Ename = "-1", Aname = "-1" } }; MainRowList = new SortableCollectionView <TblMarkupViewModel>(); SelectedMainRow = new TblMarkupViewModel(); Glclient.GetTblMarkupCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblMarkupViewModel { MarkupGroupPerRow = new GenericTable() }; newrow.MarkupGroupPerRow.InjectFrom(row.TblMarkupGroup1); newrow.InjectFrom(row); MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } }; Glclient.UpdateOrInsertTblMarkupsCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } }; Glclient.DeleteTblMarkupCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; GetMaindata(); } }
public FamilyViewModel() { if (!DesignerProperties.IsInDesignTool) { GetItemPermissions(PermissionItemName.FamilyForm.ToString()); MainRowList = new SortableCollectionView <TblFamilyViewModel>(); SelectedMainRow = new TblFamilyViewModel(); SelectedDetailRow = new TblSubFamilyViewModel(); lkpClient.GetTblFamilyCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblFamilyViewModel(); newrow.InjectFrom(row); MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null || SelectedMainRow.Iserial == 0)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } if (Export) { Export = false; } }; lkpClient.GetTblSubFamilyCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblSubFamilyViewModel(); newrow.InjectFrom(row); SelectedMainRow.DetailsList.Add(newrow); } Loading = false; DetailFullCount = sv.fullCount; if (DetailFullCount == 0 && SelectedMainRow.DetailsList.Count == 0) { AddNewDetailRow(false); } else if (SelectedMainRow.DetailsList.Count <= PageSize) { SelectedDetailRow = SelectedMainRow.DetailsList.FirstOrDefault(); } if (Export) { Export = false; } }; lkpClient.UpdateOrInsertTblFamilyCompleted += (s, x) => { var savedRow = (TblFamilyViewModel)MainRowList.GetItemAt(x.outindex); if (savedRow != null) { savedRow.InjectFrom(x.Result); } }; lkpClient.UpdateOrInsertTblSubFamilyCompleted += (s, x) => { var savedRow = (TblSubFamilyViewModel)SelectedMainRow.DetailsList.ElementAt(x.outindex); if (savedRow != null) { savedRow.InjectFrom(x.Result); } }; lkpClient.DeleteTblFamilyCompleted += (s, ev) => { if (ev.Error != null) { throw ev.Error; } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; lkpClient.DeleteTblSubFamilyCompleted += (s, ev) => { if (ev.Error != null) { throw ev.Error; } var oldrow = SelectedMainRow.DetailsList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { SelectedMainRow.DetailsList.Remove(oldrow); } if (!SelectedMainRow.DetailsList.Any()) { AddNewDetailRow(false); } }; GetMaindata(); } }
public UserCheckListViewModel() { if (!DesignerProperties.IsInDesignTool) { MainRowList = new SortableCollectionView <TblUserCheckListViewModel>(); SelectedMainRow = new TblUserCheckListViewModel(); Client.GetGenericAsync("TblCheckListGroup", "%%", "%%", "%%", "Iserial", "ASC"); Client.GetGenericCompleted += (s, sv) => { CheckListGroupList = new ObservableCollection <GenericTable>(); foreach (var variable in sv.Result) { CheckListGroupList.Add(variable); } }; Client.GetTblUserCheckListCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblUserCheckListViewModel(); newrow.InjectFrom(row); newrow.CheckListGroupPerRow = new GenericTable(); newrow.CheckListGroupPerRow.InjectFrom(row.TblCheckListGroup1); MainRowList.Add(newrow); } Loading = false; if (MainRowList.Any() && (SelectedMainRow == null || SelectedMainRow.Iserial == 0)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } if (Export) { Export = false; //var handler = ExportCompleted; //if (handler != null) handler(this, EventArgs.Empty); //ExportGrid.ExportExcel("Style"); } }; Client.UpdateOrInsertTblUserCheckListCompleted += (s, x) => { var savedRow = (TblUserCheckListViewModel)MainRowList.GetItemAt(x.outindex); if (savedRow != null) { savedRow.InjectFrom(x.Result); } }; Client.DeleteTblUserCheckListCompleted += (s, ev) => { if (ev.Error != null) { throw ev.Error; } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; } }
public SalesOrderColorThemeViewModel() { if (!DesignerProperties.IsInDesignTool) { GetItemPermissions(PermissionItemName.ColorThemesForm.ToString()); lkpClient.GetTblBrandSectionLinkCompleted += (s, sv) => { BrandSectionList.Clear(); foreach (var row in sv.Result) { BrandSectionList.Add(new GenericTable().InjectFrom(row.TblLkpBrandSection1) as GenericTable); } }; var seasonClient = new CRUD_ManagerServiceClient(); seasonClient.GetGenericCompleted += (s, sv) => { SeasonList = sv.Result; }; seasonClient.GetGenericAsync("TblLkpSeason", "%%", "%%", "%%", "Iserial", "ASC"); MainRowList = new SortableCollectionView <TblSalesOrderColorThemeViewModel>(); MainRowList.CollectionChanged += MainRowList_CollectionChanged; SelectedMainRow = new TblSalesOrderColorThemeViewModel(); Client.GetAllBrandsCompleted += (s, sv) => { BrandList = sv.Result; }; Client.GetAllBrandsAsync(LoggedUserInfo.Iserial); Client.GetTblSalesOrderColorThemeCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblSalesOrderColorThemeViewModel(); newrow.InjectFrom(row); MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null || SelectedMainRow.Iserial == 0)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } if (Export) { Export = false; ExportGrid.ExportExcel("Style"); } }; Client.UpdateOrInsertTblSalesOrderColorThemeCompleted += (s, x) => { var savedRow = (TblSalesOrderColorThemeViewModel)MainRowList.GetItemAt(x.outindex); if (savedRow != null) { savedRow.InjectFrom(x.Result); } }; Client.DeleteTblSalesOrderColorThemeCompleted += (s, ev) => { if (ev.Error != null) { throw ev.Error; } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result.Iserial); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; // Client.GetSeasonalMasterListNotLinkedToSalesorder } }
public CostCenterViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.CostCenter.ToString()); Glclient = new GlServiceClient(); var costDimSetupTypeClient = new GlServiceClient(); costDimSetupTypeClient.GetGenericCompleted += (s, sv) => { CostCenterTypeList = sv.Result; }; costDimSetupTypeClient.GetGenericAsync("TblCostCenterType", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); MainRowList = new SortableCollectionView <TblCostCenterViewModel>(); SelectedMainRow = new TblCostCenterViewModel(); Glclient.GetTblCostCenterCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblCostCenterViewModel(); newrow.InjectFrom(row); newrow.CostCenterTypePerRow = new GenericTable(); if (row.TblCostCenterType1 != null) { newrow.CostCenterTypePerRow.InjectFrom(row.TblCostCenterType1); } newrow.CostCenterPerRow = row.TblCostCenter2; MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } }; Glclient.UpdateOrInsertTblCostCentersCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } Loading = false; }; Glclient.DeleteTblCostCenterCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; GetMaindata(); } }
public BankViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.Bank.ToString()); Glclient = new GlServiceClient(); var currencyClient = new GlServiceClient(); currencyClient.GetGenericCompleted += (s, sv) => { CurrencyList = sv.Result; }; currencyClient.GetGenericAsync("TblCurrency", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); var BankAccountTypeClient = new GlServiceClient(); BankAccountTypeClient.GetGenericCompleted += (s, sv) => { BankAccountTypeList = sv.Result; }; BankAccountTypeClient.GetGenericAsync("TblBankAccountType", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); var bankClient = new GlServiceClient(); bankClient.GetGenericCompleted += (s, sv) => { BankGroupList = sv.Result; }; bankClient.GetGenericAsync("TblBankGroup", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); MainRowList = new SortableCollectionView <TblBankViewModel>(); SelectedMainRow = new TblBankViewModel(); Glclient.GetTblBankChequeCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblBankChequeViewModel(); newrow.InjectFrom(row); if (row.TblCurrency1 != null) { newrow.CurrencyPerRow.InjectFrom(row.TblCurrency1); } if (row.TblBank1 != null) { newrow.BankPerRow.InjectFrom(row.TblBank1); } if (row.TblJournalAccountType1 != null) { newrow.JournalAccountTypePerRow.InjectFrom(row.TblJournalAccountType1); } newrow.EntityPerRow = sv.entityList.FirstOrDefault(x => x.TblJournalAccountType == row.TblJournalAccountType && x.Iserial == row.EntityAccount); SelectedMainRow.DetailsList.Add(newrow); } Loading = false; FullCount = sv.fullCount; } ; Glclient.GetTblBankCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblBankViewModel(); newrow.CurrencyPerRow = new GenericTable(); newrow.BankAccountTypePerRow = new GenericTable(); newrow.BankGroupPerRow = new GenericTable(); newrow.InjectFrom(row); if (row.TblCurrency1 != null) { newrow.CurrencyPerRow.InjectFrom(row.TblCurrency1); } if (row.TblBankAccountType1 != null) { newrow.BankAccountTypePerRow.InjectFrom(row.TblBankAccountType1); } if (row.TblBankGroup1 != null) { newrow.BankGroupPerRow.InjectFrom(row.TblBankGroup1); } MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } }; Glclient.UpdateOrInsertTblBanksCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } Loading = false; }; Glclient.DeleteTblBankCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; Glclient.CreateChequeCompleted += (s, sv) => MessageBox.Show("Cheques Generated"); Glclient.DeleteTblBankChequeCompleted += (s, sv) => { MessageBox.Show("Cheques Deleted"); SelectedMainRow.DetailsList.Clear(); GetDetailRow(); }; GetMaindata(); } }
public DepreciationViewModel() { if (!IsDesignTime) { GetItemPermissions("Depreciation"); GetCustomePermissions("Depreciation"); Glclient = new GlServiceClient(); Glclient.GetTblRetailCurrencyCompleted += (s, sv) => { CurrencyList = sv.Result; }; Glclient.GetTblRetailCurrencyAsync(0, int.MaxValue, "It.Iserial", null, null, LoggedUserInfo.DatabasEname); var depreciationMethodClient = new GlServiceClient(); depreciationMethodClient.GetGenericCompleted += (s, sv) => { DepreciationMethodList = sv.Result; }; depreciationMethodClient.GetGenericAsync("TblDepreciationMethod", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); MainRowList = new SortableCollectionView <TblDepreciationTransactionHeaderViewModel>(); SelectedMainRow = new TblDepreciationTransactionHeaderViewModel(); Glclient.GetTblDepreciationTransactionHeaderCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblDepreciationTransactionHeaderViewModel(); newrow.InjectFrom(row); MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } }; Glclient.GetTblDepreciationTransactionDetailCompleted += (s, sv) => { foreach (var row in sv.Result) { SelectedMainRow.DetailList.Add(row); } Loading = false; }; //Glclient.GetLockupFromPreTransactionCompleted += (s, sv) => //{ // foreach (var row in sv.Result) // { // if (SelectedMainRow.DetailsList.All(x => x.TblDepreciationTransactionDetail1 != row.Iserial)) // { // var newrow = new TblDepreciationTransactionDetailViewModel(); // newrow.InjectFrom(row); // newrow.ChequePerRow = new TblBankCheque(); // newrow.Iserial = 0; // newrow.TblDepreciationTransactionHeader = 0; // newrow.TblDepreciationTransactionDetail1 = row.Iserial; // if (row.TblBankCheque1 != null) newrow.ChequePerRow.InjectFrom(row.TblBankCheque1); // newrow.TblJournalAccountTypePerRow = new GenericTable(); // if (row.TblJournalAccountType != null) // newrow.TblJournalAccountTypePerRow.InjectFrom(row.TblJournalAccountType); // newrow.TblJournalAccountType1PerRow = new GenericTable(); // if (row.TblJournalAccountType1 != null) // newrow.TblJournalAccountType1PerRow.InjectFrom(row.TblJournalAccountType1); // newrow.EntityDetail1TblJournalAccountType = row.EntityDetail1TblJournalAccountType; // newrow.EntityDetail2TblJournalAccountType = row.EntityDetail2TblJournalAccountType; // newrow.EntityPerRow = // sv.entityList.FirstOrDefault( // x => x.TblJournalAccountType == row.EntityDetail1TblJournalAccountType // && x.Iserial == row.EntityDetail1); // newrow.OffsetEntityPerRow = // sv.entityList.FirstOrDefault( // x => x.TblJournalAccountType == row.EntityDetail2TblJournalAccountType // && x.Iserial == row.EntityDetail2); // newrow.Saved = true; // SelectedMainRow.DetailsList.Add(newrow); // } // } // Loading = false; // SelectedDetailRow = SelectedMainRow.DetailsList.FirstOrDefault(); //}; Glclient.UpdateOrInsertTblDepreciationTransactionHeaderCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } Loading = false; }; Glclient.DeleteTblDepreciationTransactionHeaderCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; Glclient.GetTblLedgerDetailForDepreciationCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblLedgerMainDetailViewModel { CurrencyPerRow = new TblCurrencyTest() }; newrow.CurrencyPerRow.InjectFrom(row.TblCurrency1); if (row.TblBankTransactionType1 != null) { newrow.BankTransactionTypePerRow = new GenericTable(); newrow.BankTransactionTypePerRow.InjectFrom(row.TblBankTransactionType1); } newrow.MethodOfPaymentPerRow = row.TblMethodOfPayment1; newrow.JournalAccountTypePerRow = new GenericTable(); newrow.OffsetAccountTypePerRow = new GenericTable(); if (row.TblJournalAccountType1 != null) { newrow.JournalAccountTypePerRow.InjectFrom(row.TblJournalAccountType1); } if (row.TblJournalAccountType2 != null) { newrow.OffsetAccountTypePerRow.InjectFrom(row.TblJournalAccountType2); } newrow.EntityPerRow = sv.entityList.FirstOrDefault(x => x.TblJournalAccountType == row.TblJournalAccountType && x.Iserial == row.EntityAccount); newrow.OffsetEntityPerRow = sv.entityList.FirstOrDefault(x => x.TblJournalAccountType == row.OffsetAccountType && x.Iserial == row.OffsetEntityAccount); newrow.InjectFrom(row); if (newrow.DrOrCr == true) { if (row.Amount != null) { newrow.DrAmount = row.Amount; } } else { if (row.Amount != null) { newrow.CrAmount = row.Amount; } } if (row.TblBankCheque1 != null) { newrow.ChequePerRow = row.TblBankCheque1; } newrow.TransactionExists = sv.TransactionExist.FirstOrDefault(x => x.Key == newrow.Iserial).Value; if (row.TblAccount != null) { newrow.AccountPerRow = new TblAccount { Code = row.TblAccount.Code, Iserial = row.TblAccount.Iserial, Ename = row.TblAccount.Ename, Aname = row.TblAccount.Aname }; } TblLedgerDetailsList.Add(newrow); } Loading = false; DetailFullCount = sv.fullCount; }; } }
public JournalViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.Journal.ToString()); Glclient = new GlServiceClient(); MainRowList = new SortableCollectionView <TblJournalViewModel>(); SelectedMainRow = new TblJournalViewModel(); var currencyClient = new GlServiceClient(); currencyClient.GetGenericCompleted += (s, sv) => { CurrencyList = sv.Result; }; currencyClient.GetGenericAsync("TblCurrency", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); var journalAccountTypeClient = new GlServiceClient(); journalAccountTypeClient.GetGenericCompleted += (s, sv) => { JournalAccountTypeList = sv.Result; }; journalAccountTypeClient.GetGenericAsync("TblJournalAccountType", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); var journalTypeClient = new GlServiceClient(); journalTypeClient.GetGenericCompleted += (s, sv) => { JournalTypeList = sv.Result; }; journalTypeClient.GetGenericAsync("TblJournalType", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); Glclient.GetTblJournalCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblJournalViewModel(); newrow.InjectFrom(row); newrow.JournalAccountTypePerRow = new GenericTable(); if (row.TblJournalAccountType1 != null) { newrow.JournalAccountTypePerRow.InjectFrom(row.TblJournalAccountType1); } newrow.JournalTypePerRow = new GenericTable(); newrow.JournalTypePerRow.InjectFrom(row.TblJournalType1); newrow.CurrencyPerRow = new GenericTable(); newrow.CurrencyPerRow.InjectFrom(row.TblCurrency1); newrow.HeaderSequencePerRow = row.TblSequence; newrow.DetailSequencePerRow = row.TblSequence1; newrow.OffsetEntityAccountPerRow = sv.entityList.FirstOrDefault(x => x.TblJournalAccountType == row.TblJournalAccountType && x.Iserial == row.Entity); MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } if (Export) { Export = false; ExportGrid.ExportExcel("Journal"); } }; Glclient.UpdateOrInsertTblJournalsCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } Loading = false; }; Glclient.DeleteTblJournalCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; GetMaindata(); } }
public MethodOfPaymentViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.MethodOfPayment.ToString()); Glclient = new GlServiceClient(); MainRowList = new SortableCollectionView <TblMethodOfPaymentViewModel>(); SelectedMainRow = new TblMethodOfPaymentViewModel(); var bankTransactionTypeClient = new GlServiceClient(); bankTransactionTypeClient.GetGenericCompleted += (s, sv) => { BankTransactionTypeList = sv.Result; }; bankTransactionTypeClient.GetGenericAsync("TblBankTransactionType", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); var journalAccountTypeClient = new GlServiceClient(); journalAccountTypeClient.GetGenericCompleted += (s, sv) => { JournalAccountTypeList = sv.Result; }; journalAccountTypeClient.GetGenericAsync("TblJournalAccountType", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); Glclient.GetTblMethodOfPaymentCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblMethodOfPaymentViewModel(); if (row.TblBankTransactionType1 != null) { newrow.BankTransactionTypePerRow = new GenericTable(); newrow.BankTransactionTypePerRow.InjectFrom(row.TblBankTransactionType1); } if (row.TblJournalAccountType1 != null) { newrow.JournalAccountTypePerRow = new GenericTable(); newrow.JournalAccountTypePerRow.InjectFrom(row.TblJournalAccountType1); } newrow.EntityAccountPerRow = sv.entityList.FirstOrDefault(x => x.TblJournalAccountType == row.TblJournalAccountType && x.Iserial == row.Entity); newrow.AccountPerRow = row.TblAccount; newrow.InjectFrom(row); MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } }; Glclient.UpdateOrInsertTblMethodOfPaymentsCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } }; Glclient.DeleteTblMethodOfPaymentCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; GetMaindata(); } }
public GlExpensisViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.GlExpensis.ToString()); Glclient = new GlServiceClient(); var glExpensisClient = new GlServiceClient(); glExpensisClient.GetGenericCompleted += (s, sv) => { GlExpensisGroupList = sv.Result; }; glExpensisClient.GetGenericAsync("TblGLExpensisGroup", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); MainRowList = new SortableCollectionView <TblGlExpensisViewModel>(); SelectedMainRow = new TblGlExpensisViewModel(); Glclient.GetTblGlExpensisCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblGlExpensisViewModel(); newrow.InjectFrom(row); newrow.GlExpensisGroupPerRow = new GenericTable(); if (row.TblGLExpensisGroup1 != null) { newrow.GlExpensisGroupPerRow.InjectFrom(row.TblGLExpensisGroup1); } MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } if (Export) { Export = false; AllowExport = true; //ExportGrid.ExportExcel("Account"); } }; Glclient.UpdateOrInsertTblGlExpensisCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } Loading = false; }; Glclient.DeleteTblGlExpensisCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; GetMaindata(); } }
public SequenceViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.Sequence.ToString()); Glclient = new GlServiceClient(); MainRowList = new SortableCollectionView <TblSequenceViewModel>(); SelectedMainRow = new TblSequenceViewModel(); Glclient.GetTblSequenceCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblSequenceViewModel(); newrow.InjectFrom(row); MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } if (Export) { Export = false; ExportGrid.ExportExcel("Sequence"); } }; Glclient.UpdateOrInsertTblSequencesCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } }; Glclient.DeleteTblSequenceCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; GetMaindata(); } }
public VisaMachineViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.VisaMachineForm.ToString()); Glclient = new GlServiceClient(); MainRowList = new SortableCollectionView <TblVisaMachineViewModel>(); SelectedMainRow = new TblVisaMachineViewModel(); if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } Glclient.GetTblVisaMachineCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblVisaMachineViewModel(); newrow.TblbankPerRow = new TblBank(); newrow.InjectFrom(row); if (row.TblBank1 != null) { newrow.TblbankPerRow.InjectFrom(row.TblBank1); } newrow.JournalAccountTypePerRow = new GlService.GenericTable(); if (newrow.TblJournalAccountType.HasValue) { newrow.JournalAccountTypePerRow = JournalAccountTypeList.FirstOrDefault(jAT => jAT.Iserial == newrow.TblJournalAccountType.Value); } var entity = sv.EntityAccounts.FirstOrDefault(x => x.TblJournalAccountType == newrow.TblJournalAccountType && x.Iserial == row.EntityAccount); if (entity != null) { newrow.EntityPerRow.InjectFrom(entity); newrow.RaiseEntityChanged(); } MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } if (Export) { Export = false; ExportGrid.ExportExcel("VisaMachines"); } }; Glclient.UpdateOrInsertTblVisaMachineCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } }; Glclient.DeleteTblVisaMachineCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; Glclient.GetVisaMachineBanksCompleted += (s, sv) => { BankList = sv.Result; }; Glclient.GetVisaMachineBanksAsync(LoggedUserInfo.DatabasEname); GetMaindata(); } }
public GlRuleViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.GlRule.ToString()); Glclient = new GlServiceClient(); Glclient.GetGlInventoryGroupAsync(LoggedUserInfo.DatabasEname); Glclient.GetGlInventoryGroupCompleted += (s, sv) => { GlInventoryGroupList = sv.Result; }; var journalAccountTypeClient = new GlServiceClient(); journalAccountTypeClient.GetGenericCompleted += (s, sv) => { JournalAccountTypeList = sv.Result; JournalAccountTypeListFilter = new ObservableCollection <GenericTable>(sv.Result.Where(x => x.Iserial == 0 || x.Iserial == 8)); var newrow = JournalAccountTypeListFilter.FirstOrDefault(x => x.Iserial == 0); newrow.Code = "Group"; newrow.Ename = "Group"; newrow.Aname = "Group"; }; journalAccountTypeClient.GetGenericAsync("TblJournalAccountType", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); var glRuleTypeClient = new GlServiceClient(); glRuleTypeClient.GetGenericCompleted += (s, sv) => { CostCenterTypeList = sv.Result; }; glRuleTypeClient.GetGenericAsync("TblCostCenterType", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); var tblCostCenterOptionClient = new GlServiceClient(); tblCostCenterOptionClient.GetGenericCompleted += (s, sv) => { CostCenterOptionList = sv.Result; }; tblCostCenterOptionClient.GetGenericAsync("tblCostCenterOption", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); var tblCostAllocationMethodClient = new GlServiceClient(); tblCostAllocationMethodClient.GetGenericCompleted += (s, sv) => { CostAllocationMethodList = sv.Result; }; tblCostAllocationMethodClient.GetGenericAsync("TblCostAllocationMethod", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); MainRowList = new SortableCollectionView <TblGlRuleHeaderViewModel>(); SelectedMainRow = new TblGlRuleHeaderViewModel(); Glclient.GetTblGlRuleHeaderCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblGlRuleHeaderViewModel(); newrow.InjectFrom(row); MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any() && (SelectedMainRow == null)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } }; Glclient.UpdateOrInsertTblGlRuleHeadersCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } }; Glclient.DeleteTblGlRuleHeaderCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; Glclient.GetTblGlRuleMainDetailCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblGlRuleMainDetailViewModel(); newrow.EntityAccountPerRow = new Entity(); newrow.EntityAccountPerRow = sv.entityList.FirstOrDefault(x => x.TblJournalAccountType == row.TblJournalAccountType && x.Iserial == row.EntityAccount); if (row.TblJournalAccountType1 != null) { newrow.JournalAccountTypePerRow = new GenericTable(); newrow.JournalAccountTypePerRow.InjectFrom(row.TblJournalAccountType1); } if (row.TblCostCenterType1 != null) { newrow.CostCenterTypePerRow = new GenericTable(); newrow.CostCenterTypePerRow.InjectFrom(row.TblCostCenterType1); } if (row.TblCostCenterOption1 != null) { newrow.CostCenterOptionPerRow = new GenericTable(); newrow.CostCenterOptionPerRow.InjectFrom(row.TblCostCenterOption1); } if (row.TblCostAllocationMethod1 != null) { newrow.CostAllocationMethodPerRow = new GenericTable(); newrow.CostAllocationMethodPerRow.InjectFrom(row.TblCostAllocationMethod1); } newrow.InjectFrom(row); SelectedMainRow.DetailsList.Add(newrow); } Loading = false; DetailFullCount = sv.fullCount; if (SelectedMainRow.DetailsList.Any() && (SelectedDetailRow == null)) { SelectedDetailRow = SelectedMainRow.DetailsList.FirstOrDefault(); } if (DetailFullCount == 0 && SelectedMainRow.DetailsList.Count == 0) { AddNewDetailRow(false); } }; Glclient.UpdateOrInsertTblGlRuleMainDetailsCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { SelectedDetailRow.DetailsList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } }; Glclient.DeleteTblGlRuleMainDetailCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } var oldrow = SelectedMainRow.DetailsList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { SelectedMainRow.DetailsList.Remove(oldrow); } if (!SelectedMainRow.DetailsList.Any()) { AddNewDetailRow(false); } }; Glclient.GetTblGlRuleDetailCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblGlRuleDetailViewModel { CostCenterPerRow = row.TblCostCenter1, TblCostCenterType = SelectedDetailRow.TblCostCenterType, CostCenterTypePerRow = SelectedDetailRow.CostCenterTypePerRow, JournalAccountTypePerRow = JournalAccountTypeListFilter.FirstOrDefault(x => x.Iserial == row.TblJournalAccountType) }; if (row.TblJournalAccountType != null) { newrow.GlInventoryGroupPerRow = GlInventoryGroupList.FirstOrDefault( x => x.TblJournalAccountType == row.TblJournalAccountType && x.Iserial == row.GlInventoryGroup); } newrow.InjectFrom(row); SelectedDetailRow.DetailsList.Add(newrow); } Loading = false; DetailSubFullCount = sv.fullCount; if (SelectedDetailRow.DetailsList.Any() && (SelectedSubDetailRow == null)) { SelectedSubDetailRow = SelectedDetailRow.DetailsList.FirstOrDefault(); } if (DetailSubFullCount == 0 && SelectedDetailRow.DetailsList.Count == 0) { AddNewSubDetailRow(false); } }; Glclient.UpdateOrInsertTblGlRuleDetailsCompleted += (s, x) => { var savedRow = (TblGlRuleDetailViewModel)SelectedDetailRow.DetailsList.GetItemAt(x.outindex); if (savedRow != null) { savedRow.InjectFrom(x.Result); } Loading = false; }; Glclient.DeleteTblGlRuleDetailCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } Loading = false; var oldrow = SelectedDetailRow.DetailsList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { SelectedDetailRow.DetailsList.Remove(oldrow); } if (!SelectedDetailRow.DetailsList.Any()) { AddNewSubDetailRow(false); } }; GetMaindata(); } }
public GenericViewModelCollection(string tablEname, PermissionItemName userJobsForm) { if (DesignerProperties.IsInDesignTool) { return; } TablEname = tablEname; Client = new _Proxy.CRUD_ManagerServiceClient(); GetItemPermissions(userJobsForm.ToString()); Client.GetGenericCompleted += (s, ev) => { Loading = false; GenericMapper.InjectFromObCollection(MainRowList, ev.Result); //FullCount = ev.fullCount; if (MainRowList.Any() && (SelectedMainRow == null || SelectedMainRow.Iserial == 0)) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } if (Export) { Export = false; ExportGrid.ExportExcel(userJobsForm.ToString()); } }; MainRowList = new SortableCollectionView <GenericViewModel>(); Client.GenericUpdateOrInsertCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } Loading = false; MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); }; Client.DeleteGenericCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } Loading = false; var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { MainRowList.Remove(oldrow); } if (!MainRowList.Any()) { AddNewMainRow(false); } }; GetMaindata(); }