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