private void buttonExtExcel_Click(object sender, EventArgs e) { SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "CSV export| *.csv"; dlg.Title = "Export current History view to Excel (csv)"; // 0 1 2 3 4 5 6 7 8 9 10 11 12 string[] colh = { "Time", "Event", "System", "Body", "Ship" , "Summary", "Description", "Detailed Info", "Note" , "Travel Dist", "Travel Time" , "Travel Jumps" , "Travelled MisJumps" }; if (dlg.ShowDialog() == DialogResult.OK) { Export.ExportGrid grd = new ExportGrid(); grd.onGetCell += delegate (int r, int c) { if (c == -1) // next line? return r < dataGridViewTravel.Rows.Count; else if (c < colh.Length && dataGridViewTravel.Rows[r].Visible) { HistoryEntry he = (HistoryEntry)dataGridViewTravel.Rows[r].Cells[TravelHistoryColumns.HistoryTag].Tag; if (c == 0) return dataGridViewTravel.Rows[r].Cells[0].Value; else if (c == 1) return he.journalEntry.EventTypeStr; else if (c == 2) return (he.System != null) ? he.System.name : "Unknown"; // paranoia else if (c == 3) return he.WhereAmI; else if (c == 4) return he.ShipInformation != null ? he.ShipInformation.Name : "Unknown"; else if (c == 5) return he.EventSummary; else if (c == 6) return he.EventDescription; else if (c == 7) return he.EventDetailedInfo; else if (c == 8) return dataGridViewTravel.Rows[r].Cells[4].Value; else if (c == 9) return he.isTravelling ? he.TravelledDistance.ToString("0.0") : ""; else if (c == 10) return he.isTravelling ? he.TravelledSeconds.ToString() : ""; else if (c == 11) return he.isTravelling ? he.Travelledjumps.ToStringInvariant() : ""; else return he.isTravelling ? he.TravelledMissingjump.ToStringInvariant() : ""; } else return null; }; grd.onGetHeader += delegate (int c) { return (c < colh.Length) ? colh[c] : null; }; grd.Csvformat = discoveryform.ExportControl.radioButtonCustomEU.Checked ? CSVFormat.EU : CSVFormat.USA_UK; if (grd.ToCSV(dlg.FileName)) System.Diagnostics.Process.Start(dlg.FileName); } }
public void AddNewSubDetailRow(bool checkLastRow) { var currentRowIndex = (SelectedMainRow.SubDetailList.IndexOf(SelectedSubDetailRow)); if (checkLastRow) { var lastrow = SelectedMainRow.SubDetailList.ElementAtOrDefault(currentRowIndex); var valiationCollection = new List <ValidationResult>(); var isvalid = Validator.TryValidateObject(lastrow, new ValidationContext(lastrow, null, null), valiationCollection, true); if (!isvalid) { return; } } if (AllowUpdate != true) { MessageBox.Show(strings.AllowAddMsg); return; } var newrow = new TblJournalSettingCostCenterViewModel { TblJournalSetting = SelectedMainRow.Iserial, }; SelectedMainRow.SubDetailList.Insert(currentRowIndex + 1, newrow); SelectedSubDetailRow = newrow; if (ExportGrid != null) { ExportGrid.BeginEdit(); } }
public void AddNewDetailRow(bool checkLastRow) { var currentRowIndex = (SelectedMainRow.DetailsList.IndexOf(SelectedDetailRow)); if (SelectedDetailRow == null) { currentRowIndex = 0; } if (checkLastRow) { var lastrow = SelectedMainRow.DetailsList.ElementAtOrDefault(currentRowIndex); var valiationCollection = new List <ValidationResult>(); var isvalid = Validator.TryValidateObject(lastrow, new ValidationContext(lastrow, null, null), valiationCollection, true); if (!isvalid) { return; } } if (AllowUpdate != true) { return; } var newrow = new TblJournalSettingEntityViewModel { TblJournalSetting = SelectedMainRow.Iserial, }; if (SelectedMainRow.DetailsList.Any(x => x.Iserial > -1)) { SelectedMainRow.DetailsList.Insert(currentRowIndex + 1, newrow); } else { if (currentRowIndex == -1) { currentRowIndex = 0; } SelectedMainRow.DetailsList.Insert(currentRowIndex, newrow); } SelectedDetailRow = newrow; if (ExportGrid != null) { ExportGrid.BeginEdit(); } }
public void OnDrawGizmos() { Gizmos.color = Color.gray; Gizmos.DrawWireCube(maxBounds.center, maxBounds.size); Gizmos.color = Color.red; Gizmos.DrawWireCube(fixedMaxBounds.center, fixedMaxBounds.size); if (gridList == null) { return; } Gizmos.color = Color.green; for (int i = 0; i < gridList.Count; i++) { ExportGrid grid = gridList[i]; if (!grid.showBounds || grid.perfabMap == null || grid.perfabMap.Count == 0) { continue; } Bounds bounds = grid.bounds; Gizmos.DrawWireCube(bounds.center, bounds.size); } }
private void buttonExtExcel_Click(object sender, EventArgs e) { SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "CSV export| *.csv"; dlg.Title = "Export current History view to Excel (csv)"; // 0 1 2 3 4 5 6 7 8 9 10 11 12 string[] colh = { "Time", "System", "Visits", "Other Info", "Visit List", "Body", "Ship", "Description", "Detailed Info", "Travel Dist", "Travel Time", "Travel Jumps", "Travelled MisJumps" }; if (dlg.ShowDialog() == DialogResult.OK) { Export.ExportGrid grd = new ExportGrid(); grd.onGetCell += delegate(int r, int c) { if (c == -1) // next line? { return(r < dataGridViewStarList.Rows.Count); } else if (c < colh.Length && dataGridViewStarList.Rows[r].Visible) { List <HistoryEntry> syslist = dataGridViewStarList.Rows[r].Tag as List <HistoryEntry>; HistoryEntry he = syslist[0]; if (c == 0) { return(dataGridViewStarList.Rows[r].Cells[0].Value); } else if (c == 1) { return(dataGridViewStarList.Rows[r].Cells[1].Value); } else if (c == 2) { return(dataGridViewStarList.Rows[r].Cells[2].Value); } else if (c == 3) { return(dataGridViewStarList.Rows[r].Cells[3].Value); } else if (c == 4) { string tlist = ""; if (syslist.Count > 1) { for (int i = 1; i < syslist.Count; i++) { tlist = tlist.AppendPrePad(syslist[i].EventTimeLocal.ToShortDateString() + " " + syslist[i].EventTimeLocal.ToShortTimeString(), ", "); } } return(tlist); } else if (c == 5) { return(he.WhereAmI); } else if (c == 6) { return(he.ShipInformation != null ? he.ShipInformation.Name : "Unknown"); } else if (c == 7) { return(he.EventDescription); } else if (c == 8) { return(he.EventDetailedInfo); } else if (c == 9) { return(he.isTravelling ? he.TravelledDistance.ToString("0.0") : ""); } else if (c == 10) { return(he.isTravelling ? he.TravelledSeconds.ToString() : ""); } else if (c == 11) { return(he.isTravelling ? he.Travelledjumps.ToStringInvariant() : ""); } else // 12 { return(he.isTravelling ? he.TravelledMissingjump.ToStringInvariant() : ""); } } else { return(null); } }; grd.onGetHeader += delegate(int c) { return((c < colh.Length) ? colh[c] : null); }; grd.Csvformat = discoveryform.ExportControl.radioButtonCustomEU.Checked ? BaseUtils.CVSWrite.CSVFormat.EU : BaseUtils.CVSWrite.CSVFormat.USA_UK; if (grd.ToCSV(dlg.FileName)) { System.Diagnostics.Process.Start(dlg.FileName); } } }
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 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 TradeAgreementViewModel() : base(PermissionItemName.TradeAgreementFabricView) { // ده هيحتاج تعديل productionServiceClient.GetTblTradeAgreementDetailListFabricViewCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TradeAgreementDetailModel(); newrow.TradeAgreementTransactionIserial = SelectedMainRow.Iserial; newrow.HeaderIserial = row.TblTradeAgreementHeader; newrow.ColorPerRow = new CRUDManagerService.TblColor(); if (row.TblColor1 != null) { newrow.ColorPerRow.InjectFrom(row.TblColor1); } newrow.ItemPerRow = new CRUDManagerService.ItemsDto(); newrow.ItemPerRow.InjectFrom(sv.itemsList.SingleOrDefault(x => x.Iserial == row.ItemCode && x.ItemGroup == row.ItemType)); newrow.ItemType = row.ItemType; newrow.VendorPerRow = new CRUDManagerService.Vendor { vendor_code = row.TblTradeAgreementHeader1.Vendor }; newrow.VendorPurchaseGroupPerRow = new CRUDManagerService.GenericTable(); newrow.VendorPerRow.InjectFrom(sv.VendorList.FirstOrDefault(x => x.vendor_code == row.TblTradeAgreementHeader1.Vendor)); if (row.TblVendorPurchaseGroup1 != null) { newrow.VendorPurchaseGroupPerRow.InjectFrom(row.TblVendorPurchaseGroup1); } newrow.TradeAgreementTransactionIserial = row.TblTradeAgreementHeader1.TblTradeAgreementTransaction.Value; newrow.HeaderIserial = row.TblTradeAgreementHeader; newrow.InjectFrom(row); SelectedMainRow.DetailsList.Insert(0, newrow); } Loading = false; if (DetailFullCount == 0 && SelectedMainRow.DetailsList.Count == 0) { AddNewDetailRow(false); } if (Export) { Export = false; ExportGrid.ExportExcel("TradeAgreement"); } } ; calculationClient.GetGenericCompleted += (s, sv) => { VendorPurchaseGroupList = sv.Result; }; Client.GetAxCurrencyAsync("CCM"); Client.GetAxCurrencyCompleted += (s, sv) => { AxCurrencyList = sv.Result; }; Client.SearchForColorCompleted += (s, sv) => { if (sv.Error != null) { return; } SelectedDetailRow.Colors = sv.Result; }; var currentUi = Thread.CurrentThread.CurrentUICulture; productionServiceClient.GetTblTradeAgreementDetailListCompleted += (d, sv) => { foreach (var row in sv.Result) { var newrow = new TradeAgreementDetailModel(); newrow.InjectFrom(row); newrow.HeaderIserial = row.TblTradeAgreementHeader; newrow.TradeAgreementTransactionIserial = SelectedMainRow.Iserial; newrow.ColorPerRow = new CRUDManagerService.TblColor(); if (row.TblColor1 != null) { newrow.ColorPerRow.InjectFrom(row.TblColor1); } newrow.TblColor = row.TblColor; newrow.ItemPerRow = new CRUDManagerService.ItemsDto(); var itemsDto = sv.itemsList.SingleOrDefault(x => x.Iserial == row.ItemCode && x.ItemGroup == row.ItemType); if (itemsDto != null) { newrow.ItemPerRow.InjectFrom(itemsDto); } newrow.ItemCode = row.ItemCode; newrow.ItemType = row.ItemType; newrow.FromDate = row.TblTradeAgreementHeader1.FromDate; newrow.ToDate = row.TblTradeAgreementHeader1.ToDate; newrow.VendorPurchaseGroupPerRow = VendorPurchaseGroupList.FirstOrDefault(vpg => vpg.Iserial == newrow.TblVendorPurchaseGroup); newrow.VendorPerRow = new CRUDManagerService.Vendor(); newrow.VendorPerRow.InjectFrom(sv.vendorsList.FirstOrDefault(v => v.vendor_code == row.TblTradeAgreementHeader1.Vendor)); newrow.Vendor = row.TblTradeAgreementHeader1.Vendor; SelectedMainRow.DetailsList.Add(newrow); } Loading = false; DetailFullCount = sv.fullCount; if (DetailFullCount == 0 && SelectedMainRow.DetailsList.Count == 0) { AddNewDetailRow(false); } }; productionServiceClient.UpdateOrInsertTblTradeAgreementDetailCompleted += (s, x) => { var savedRow = SelectedMainRow.DetailsList.ElementAtOrDefault(x.outindex); if (savedRow != null) { savedRow.InjectFrom(x.Result); } }; productionServiceClient.GetTblTradeAgreementTransactionCompleted += (d, s) => { foreach (var variable in s.Result) { var newrow = new TradeAgreementTransaction(); newrow.InjectFrom(variable); MainRowList.Add(newrow); } Loading = false; FullCount = s.fullCount; if (SearchWindow != null) { SearchWindow.FullCount = s.fullCount; SearchWindow.Loading = false; } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(true); } }; productionServiceClient.DeleteTblTradeAgreementDetailCompleted += (s, ev) => { Loading = false; if (ev.Error != null) { throw ev.Error; } var oldrow = SelectedMainRow.DetailsList.FirstOrDefault(x => x.Iserial == ev.Result); if (oldrow != null) { SelectedMainRow.DetailsList.Remove(oldrow); } }; productionServiceClient.SaveTradeAgreementCompleted += (s, sv) => { if (SelectedMainRow == null) { SelectedMainRow = new TradeAgreementTransaction(); } SelectedMainRow.InjectFrom(sv.savedHeader); SelectedMainRow.TblLkpSeason = sv.savedHeader.TblLkpSeason; SelectedMainRow.TblLkpSeason1 = SeasonList.FirstOrDefault(r => r.Iserial == SelectedMainRow.TblLkpSeason); //SelectedMainRow.DetailsList.Clear(); foreach (var item in SelectedMainRow.DetailsList) { var newRow = sv.Result.FirstOrDefault(d => d.ItemCode == item.ItemCode && d.TblColor == item.TblColor && d.TblTradeAgreementHeader == item.HeaderIserial && d.AccSize == item.AccSize); if (newRow != null) { item.Iserial = newRow.Iserial; item.HeaderIserial = newRow.TblTradeAgreementHeader; item.TradeAgreementTransactionIserial = newRow.TblTradeAgreementHeader1.TblTradeAgreementTransaction.Value; } } RaisePropertyChanged(nameof(IsHeaderSaved)); MessageBox.Show(strings.Saved); Loading = true; }; productionServiceClient.DeleteTradeAgreementHeaderCompleted += (d, s) => { SelectedMainRow = new TradeAgreementTransaction(); if (currentUi.DisplayName == "العربية") { MessageBox.Show("Deleted"); } else { MessageBox.Show("Deleted"); } }; // ده هيحتاج تعديل LoadingDetail = new RelayCommand <DataGridRowEventArgs>((e) => { if (SelectedMainRow.DetailsList.Count < PageSize) { return; } if (SelectedMainRow.DetailsList.Count - 2 < e.Row.GetIndex() && SelectedMainRow.DetailsList.Count < DetailFullCount && !Loading) { string size = null, vendor = null, color = null, ItemType = null, ItemCode = null; string key = "AccSize"; if (valueObjecttemp.Any(w => w.Key.StartsWith(key))) { size = (string)valueObjecttemp.First(w => w.Key.StartsWith(key)).Value; } key = "Vendor"; if (valueObjecttemp.Any(w => w.Key.StartsWith(key))) { vendor = (string)valueObjecttemp.First(w => w.Key.StartsWith(key)).Value; } key = "Color"; if (valueObjecttemp.Any(w => w.Key.StartsWith(key))) { color = (string)valueObjecttemp.First(w => w.Key.StartsWith(key)).Value; } key = "ItemType"; if (valueObjecttemp.Any(w => w.Key.StartsWith(key))) { ItemType = (string)valueObjecttemp.First(w => w.Key.StartsWith(key)).Value; } key = "ItemCode"; if (valueObjecttemp.Any(w => w.Key.StartsWith(key))) { ItemCode = Convert.ToString(valueObjecttemp.First(w => w.Key.StartsWith(key)).Value); } productionServiceClient.GetTblTradeAgreementDetailListFabricViewAsync( SelectedMainRow.DetailsList.Count, PageSize, SelectedMainRow.Iserial, ItemCode, color, size, vendor, ItemType); } }); // ده هيحتاج تعديل FilterCommand = new RelayCommand <FilterEvent>((e) => { SelectedMainRow.DetailsList.Clear(); valueObjecttemp.Clear(); foreach (var f in e.FiltersPredicate) { valueObjecttemp.Add(f.FilterColumnInfo.PropertyPath, f.FilterText); } string size = null, vendor = null, color = null, ItemType = null, ItemCode = null; string key = "AccSize"; if (valueObjecttemp.Any(w => w.Key.StartsWith(key))) { size = (string)valueObjecttemp.First(w => w.Key.StartsWith(key)).Value; } key = "Vendor"; if (valueObjecttemp.Any(w => w.Key.StartsWith(key))) { vendor = (string)valueObjecttemp.First(w => w.Key.StartsWith(key)).Value; } key = "Color"; if (valueObjecttemp.Any(w => w.Key.StartsWith(key))) { color = (string)valueObjecttemp.First(w => w.Key.StartsWith(key)).Value; } key = "ItemType"; if (valueObjecttemp.Any(w => w.Key.StartsWith(key))) { ItemType = (string)valueObjecttemp.First(w => w.Key.StartsWith(key)).Value; } key = "ItemCode"; if (valueObjecttemp.Any(w => w.Key.StartsWith(key))) { ItemCode = Convert.ToString(valueObjecttemp.First(w => w.Key.StartsWith(key)).Value); } productionServiceClient.GetTblTradeAgreementDetailListFabricViewAsync( 0, PageSize, SelectedMainRow.Iserial, ItemCode, color, size, vendor, ItemType); }); NewDetail = new RelayCommand <KeyEventArgs>((e) => { if (e.Key == Key.Down) { //var currentRowIndex = (SelectedMainRow.DetailsList.IndexOf(SelectedDetailRow)); //if (currentRowIndex == (SelectedMainRow.DetailsList.Count - 1)) //{ // AddNewDetailRow(true); //} } }); DeleteDetail = new RelayCommand <KeyEventArgs>((e) => { if (e.Key == Key.Delete) { var DetailGrid = e.OriginalSource as OsGrid; SelectedDetailRows.Clear(); foreach (var row in DetailGrid.SelectedItems) { SelectedDetailRows.Add(row as TradeAgreementDetailModel); } DeleteDetailRow(); } }); SaveDetail = new RelayCommand <DataGridRowEditEndedEventArgs>((e) => { SaveDetailRow(); }); Client.GetAllSeasonsCompleted += (s, e) => { SeasonList.Clear(); foreach (var row in e.Result) { TblLkpSeason temp = new TblLkpSeason(); temp.InjectFrom(row); SeasonList.Add(temp); } }; AddNewMainRow(false); GetComboData(); 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 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 BankTransactionTypeViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.BankTransactionType.ToString()); Glclient = new GlServiceClient(); var currencyClient = new GlServiceClient(); currencyClient.GetGenericCompleted += (s, sv) => { BankTransactionTypeGroupList = sv.Result; }; currencyClient.GetGenericAsync("TblBankTransactionTypeGroup", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); MainRowList = new SortableCollectionView <TblBankTransactionTypeViewModel>(); SelectedMainRow = new TblBankTransactionTypeViewModel(); Glclient.GetTblBankTransactionTypeCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblBankTransactionTypeViewModel { BankTransactionTypeGroupPerRow = new GenericTable() }; newrow.InjectFrom(row); if (row.TblBankTransactionTypeGroup1 != null) { newrow.BankTransactionTypeGroupPerRow.InjectFrom(row.TblBankTransactionTypeGroup1); } MainRowList.Add(newrow); } Loading = false; FullCount = sv.fullCount; if (MainRowList.Any()) { SelectedMainRow = MainRowList.FirstOrDefault(); } if (FullCount == 0 && MainRowList.Count == 0) { AddNewMainRow(false); } if (Export) { Export = false; ExportGrid.ExportExcel("BankTransactionType"); } }; Glclient.UpdateOrInsertTblBankTransactionTypesCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } }; Glclient.DeleteTblBankTransactionTypeCompleted += (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 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 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 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(); }
public JournalSettingViewModel() { if (!IsDesignTime) { GetItemPermissions(PermissionItemName.JournalSetting.ToString()); Glclient = new GlServiceClient(); MainRowList = new ObservableCollection <TblJournalSettingViewModel>(); SelectedMainRow = new TblJournalSettingViewModel(); var journalAccountTypeClient = new GlServiceClient(); journalAccountTypeClient.GetGenericCompleted += (s, sv) => { JournalAccountTypeList = sv.Result; }; journalAccountTypeClient.GetGenericAsync("TblJournalAccountType", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); Glclient.GetTblJournalSettingCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblJournalSettingViewModel(); 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; AllowExport = true; //ExportGrid.ExportExcel("Account"); } }; Glclient.UpdateOrInsertTblJournalSettingsCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } try { MainRowList.ElementAt(ev.outindex).InjectFrom(ev.Result); } catch (Exception) { } Loading = false; }; Glclient.DeleteTblJournalSettingCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } foreach (var item in ev.Result.ToList()) { var oldrow = MainRowList.FirstOrDefault(x => x.Iserial == item); if (oldrow != null) { MainRowList.Remove(oldrow); } } if (!MainRowList.Any()) { AddNewMainRow(false); } }; Glclient.GetTblJournalSettingEntityCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblJournalSettingEntityViewModel(); newrow.JournalAccountTypePerRow = new GenericTable(); newrow.JournalAccountTypePerRow.InjectFrom(row.TblJournalAccountType1); newrow.JournalPerRow = new TblJournal(); newrow.JournalPerRow.InjectFrom(row.TblJournal1); newrow.EntityPerRow = sv.entityList.FirstOrDefault(x => x.TblJournalAccountType == row.TblJournalAccountType && x.Iserial == row.EntityAccount && x.scope == row.Scope); 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(x => x.Iserial >= 0) == 0) { AddNewDetailRow(false); } if (Export) { AllowExport = true; Export = false; } }; Glclient.UpdateOrInsertTblJournalSettingEntitysCompleted += (s, x) => { var savedRow = SelectedMainRow.DetailsList.ElementAt(x.outindex); if (savedRow != null) { savedRow.InjectFrom(x.Result); } Loading = false; }; Glclient.DeleteTblJournalSettingEntityCompleted += (s, ev) => { Loading = false; if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } foreach (var item in ev.Result.ToList()) { var oldrow = SelectedMainRow.DetailsList.FirstOrDefault(x => x.Iserial == item); if (oldrow != null) { SelectedMainRow.DetailsList.Remove(oldrow); } } if (!SelectedMainRow.DetailsList.Any()) { AddNewDetailRow(false); } }; var glRuleTypeClient = new GlServiceClient(); glRuleTypeClient.GetGenericCompleted += (s, sv) => { CostCenterTypeList = sv.Result; }; glRuleTypeClient.GetGenericAsync("TblCostCenterType", "%%", "%%", "%%", "Iserial", "ASC", LoggedUserInfo.DatabasEname); Glclient.GetTblJournalSettingCostCenterCompleted += (s, sv) => { foreach (var row in sv.Result) { var newrow = new TblJournalSettingCostCenterViewModel(); if (row.TblCostCenter1 != null) { newrow.CostCenterPerRow = new TblCostCenter(); newrow.CostCenterPerRow.InjectFrom(row.TblCostCenter1); if (row.TblCostCenter1.TblCostCenterType1 != null) { newrow.CostCenterTypePerRow.InjectFrom(row.TblCostCenter1.TblCostCenterType1); } } newrow.InjectFrom(row); SelectedMainRow.SubDetailList.Add(newrow); } Loading = false; DetailSubFullCount = sv.fullCount; if (SelectedMainRow.SubDetailList.Any() && (SelectedSubDetailRow == null)) { SelectedSubDetailRow = SelectedMainRow.SubDetailList.FirstOrDefault(); } if (DetailSubFullCount == 0 && SelectedMainRow.SubDetailList.Count(x => x.Iserial >= 0) == 0) { AddNewSubDetailRow(false); } if (ExportGrid != null) { ExportGrid.ScrollIntoView(SelectedSubDetailRow, ExportGrid.Columns[1]); ExportGrid.CurrentColumn = ExportGrid.Columns[1]; ExportGrid.Focus(); } }; Glclient.UpdateOrInsertTblJournalSettingCostCentersCompleted += (s, x) => { var savedRow = SelectedMainRow.SubDetailList.ElementAt(x.outindex); if (savedRow != null) { savedRow.InjectFrom(x.Result); } Loading = false; }; Glclient.DeleteTblJournalSettingCostCenterCompleted += (s, ev) => { if (ev.Error != null) { MessageBox.Show(ev.Error.Message); } foreach (var item in ev.Result.ToList()) { var oldrow = SelectedMainRow.DetailsList.FirstOrDefault(x => x.Iserial == item); if (oldrow != null) { SelectedMainRow.DetailsList.Remove(oldrow); } } if (!SelectedMainRow.SubDetailList.Any()) { AddNewSubDetailRow(false); } }; GetMaindata(); } }