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