/// <summary>
/// Take sample data and convert it into two other
/// delimitted representations
/// </summary>
private void cmdRun_Click(object sender, EventArgs e)
{
CustomersVerticalBar[] customers = (CustomersVerticalBar[]) grid1.SelectedObject;
//
DelimitedFileEngine engine = new DelimitedFileEngine(typeof (CustomersVerticalBar));
txtOut1.Text = engine.WriteString(customers);
engine.Options.Delimiter = ";";
txtOut2.Text = engine.WriteString(customers);
engine.Options.Delimiter = "\t";
txtOut3.Text = engine.WriteString(customers);
}
public void ArrayWriteMinErrorNull()
{
Assert.Throws<InvalidOperationException>(
() =>
{
var engine = new DelimitedFileEngine<ArrayModel2To4>();
var res =
engine.WriteString(new[]
{
new ArrayModel2To4()
{Id = 1, Name = "name1", Weighting = null}
});
});
}
public void ArrayWriteMaxError5()
{
Assert.Throws<InvalidOperationException>(
() =>
{
var engine = new DelimitedFileEngine<ArrayModel2To4>();
var res =
engine.WriteString(new[]
{
new ArrayModel2To4()
{Id = 1, Name = "name1", Weighting = new float[] {10.2f, 1,2,3,4}}
});
});
}
public void ArrayWriteFloatFieldsNullable()
{
var dataToExport = new List<ArrayModelNullable>();
dataToExport.Add(new ArrayModelNullable() { Id = 1, Name = "name1", Weighting = new float?[] { } });
var engine = new DelimitedFileEngine<ArrayModelNullable>();
var res = engine.WriteString(dataToExport);
Assert.AreEqual("1,name1," + Environment.NewLine, res);
var vals = engine.ReadString(res);
vals.Length.AssertEqualTo(1);
vals[0].Weighting.Length.AssertEqualTo(0);
}
public void ArrayWriteFloatFields3()
{
var dataToExport = new List<ArrayModel1>();
dataToExport.Add(new ArrayModel1() { Id = 1, Name = "name1", Weighting = new float[] { 10.2f, 30.5f, 11f } });
var engine = new DelimitedFileEngine<ArrayModel1>();
var res = engine.WriteString(dataToExport);
Assert.AreEqual("1,name1,10.2,30.5,11" + Environment.NewLine, res);
}
public ActionResult ExportToFile()
{
var exportTasks = Query(new ExportClosedTasksQuery());
var taskDtos = exportTasks.Select(x => new TaskDto
{
ProjectSku = x.ProjectSku,
ClientSku = x.ClientSku,
Timestamp = x.Timestamp,
Sku = x.Sku,
Quantity = x.Quantity,
Price = x.Price.ToString("0.00", CultureInfo.GetCultureInfo("en-US")),
Description = x.Description.Replace('\n', ' ').Replace("\r", "")
});
var encoding = Encoding.GetEncoding(1252);
var engine = new DelimitedFileEngine<TaskDto>(encoding);
var result = engine.WriteString(taskDtos);
var data = encoding.GetBytes(result);
Session.CreateSQLQuery("update Task set Status = :posted where Status = :closed")
.SetEnum("posted", TaskStatus.Posted)
.SetEnum("closed", TaskStatus.Closed)
.ExecuteUpdate();
return File(data, "application/vnd.ms-excel", string.Format("export-{0:yyyyMMddHHmmss}.csv", DateTime.Now));
}
