private void importXMLToolStripMenuItem_Click(object sender, EventArgs e) { DialogResult nResult = this.openCsvFileDialog.ShowDialog(); if (nResult == DialogResult.OK) { this.objectListView1.ClearObjects(); this.mCheckIns = 0; CsvController csv = new CsvController(this.openCsvFileDialog.FileName); List <Guest> nGuestList = csv.Read(); if (nGuestList != null) { this.objectListView1.SetObjects(nGuestList); this.objectListView1.Sort(this.CategoryColumn); foreach (Guest nGuest in nGuestList) { if (nGuest.CheckIn) { this.mCheckIns++; } } this.RefreshGuestsCount(); } } }
public static CsvController GetInstance() //单例方法获取对象 { if (csv == null) { csv = new CsvController(); } return(csv); }
private void Mainform_FormClosing(object sender, FormClosingEventArgs e) { List <Guest> nGuestList = this.objectListView1.Objects.Cast <Guest>().ToList(); DataManager.SaveListToFile <Guest>(nGuestList, Constants.DATA_FILE); CsvController csv = new CsvController(Constants.CSV_FILE); csv.Write(nGuestList); }
private void exportXMLToolStripMenuItem_Click(object sender, EventArgs e) { DialogResult nResult = this.saveCsvFileDialog.ShowDialog(); if (nResult == DialogResult.OK) { List <Guest> nGuestList = this.objectListView1.Objects.Cast <Guest>().ToList(); CsvController csv = new CsvController(this.saveCsvFileDialog.FileName); csv.Write(nGuestList); } }
/// <summary> /// /// </summary> public MainViewModel() { // Utils CsvController = new CsvController(DateiPfad); // Listen Personen = new ObservableCollection <Person>(); // View FormViewModel = new FormViewModel(this, CsvController); // Lese aus Datei -> Lade Personen-Daten, wenn Datei verfügbar CsvController.leseDatei(Personen); }
public void TestInitialize() { _httpGatewayFactory = Substitute.For <IHttpGatewayFactory>(); _dataContainerConverterService = Substitute.For <IDataContainerConverterService>(); _controller = new CsvController(_dataContainerConverterService, _httpGatewayFactory); }
public void TestInitialize() { _remoteFileFetcherGateway = Substitute.For <IRemoteFileFetcherGateway>(); _dataContainerConverterService = Substitute.For <IDataContainerConverterService>(); _controller = new CsvController(_dataContainerConverterService, _remoteFileFetcherGateway); }
/// <summary> /// Konstruktor der Klasse FormViewModel /// </summary> /// <param name="mainViewModel"></param> public FormViewModel(MainViewModel mainViewModel, CsvController CsvController) { SpeichernCommand = new DelegateCommand(() => Speichern()); _csvController = CsvController; _mainViewModel = mainViewModel; }
public override ImportResult Import() { csvRegistry = new CsvController(CsvFilename, Encoding.Default, line => line.StartsWith("#")); return(base.Import()); }
protected override ExportResult TryExportItems(IEnumerable <HotWaterPayment> hotWaterCustomerPayments) { if (hotWaterCustomerPayments == null) { return(new ExportResult()); } IEnumerable <IEnumerable <string> > rows = hotWaterCustomerPayments .Where(payment => payment != null) .Select(payment => new[] { payment.CreateDate.ToString("dd-MM-yyyy"), payment.CreateDate.ToString("hh-mm-ss"), string.Empty, string.Empty, string.Empty, payment.HotWaterCustomer.Number.ToString("D3"), payment.HotWaterCustomer.Name, payment.HotWaterCustomer.Address, payment.CreateDate.ToString("MMyy"), (payment.Total + payment.CommisionTotal).ToString("0.00"), payment.Total.ToString("0.00"), payment.CommisionTotal.ToString("0.00") }); var countItemsForExport = rows.Count(); if (countItemsForExport == 0) { return(new ExportResult()); } decimal sumTotalWithCommission = hotWaterCustomerPayments.Sum(payment => payment.Total + payment.CommisionTotal); decimal sumTotal = hotWaterCustomerPayments.Sum(payment => payment.Total); decimal sumCommissionTotal = hotWaterCustomerPayments.Sum(payment => payment.CommisionTotal); rows = rows.Concat(new[] { new[] { $"={rows.Count()}", sumTotalWithCommission.ToString("0.00"), sumTotal.ToString("0.00"), sumCommissionTotal.ToString("0.00"), string.Empty, DateTime.Now.ToString("dd-MM-yyyy") } }); var filename = Path.Combine(Config.OutputDirectory, string.Format(Config.HotWaterPaymentTxtOutputFileFormat, DateTime.Now)); Exception exportException = null; try { var txtRegistry = new CsvController(filename, Encoding.GetEncoding(1251)); txtRegistry.SaveRows(rows); } finally { if (exportException != null) { throw exportException; } } return(new ExportResult(countItemsForExport, hotWaterCustomerPayments.Count() - countItemsForExport)); }