public void Exporters_XlsExporter_insertRowLinks_RelativeLink()
{
FileInfo outfile = new FileInfo(@"X:\noWhere.xlsx");
string[] exportFields = new string[] { "DOCID", "BEGATT", "VOLUME", "NATIVE" };
Representative.FileType type = Representative.FileType.Native;
string display = null;
int index = 3;
docs.First().Metadata["NATIVE"] = @"\NATIVE\0001\DOC000001.XLSX";
docs.First().Representatives.First().Files["DOC000001"] = @"\NATIVE\0001\DOC000001.XLSX";
HyperLinkInfo link = new HyperLinkInfo(type, display, index);
HyperLinkInfo[] links = new HyperLinkInfo[] { link };
TestExporter tester = new TestExporter(outfile, exportFields, links);
DataTable dt = tester.getMetaDataTable(this.docs);
FileInfo file = new FileInfo("test.xlsx");
ExcelPackage package = new ExcelPackage(file);
ExcelWorksheet ws = package.Workbook.Worksheets.Add("Sheet1");
ws.Cells[1, 1].LoadFromDataTable(dt, true);
Document doc = docs.First();
int row = 0;
int col = 3;
string linkValue = @".\NATIVE\0001\DOC000001.XLSX";
tester.insertRowLinks(ws, dt, doc, row);
string expected = String.Format(
"HYPERLINK(\"{0}\", \"{1}\")", linkValue, "\\NATIVE\\0001\\DOC000001.XLSX");
string actual = ws.Cells[row + 2, col + 1].Formula;
Assert.AreEqual(expected, actual);
}
public void Exporters_XlsExporter_insertRowLinks_NoLink()
{
FileInfo outfile = new FileInfo(@"X:\noWhere.xlsx");
string[] exportFields = new string[] { "DOCID", "BEGATT", "VOLUME", "NATIVE" };
Representative.FileType type = Representative.FileType.Native;
string display = null;
int index = 3;
HyperLinkInfo link = new HyperLinkInfo(type, display, index);
HyperLinkInfo[] links = new HyperLinkInfo[] { link };
TestExporter tester = new TestExporter(outfile, exportFields, links);
DataTable dt = tester.getMetaDataTable(this.docs);
FileInfo file = new FileInfo("test.xlsx");
ExcelPackage package = new ExcelPackage(file);
ExcelWorksheet ws = package.Workbook.Worksheets.Add("Sheet1");
ws.Cells[1, 1].LoadFromDataTable(dt, true);
Document doc = docs[1];
int row = 0;
int col = 3;
tester.insertRowLinks(ws, dt, doc, row);
string expected = String.Empty;
string actual = ws.Cells[row + 2, col + 1].Formula;
Assert.AreEqual(expected, actual);
}
public void Exporters_XlsExporter_getMetaDataTable()
{
FileInfo outfile = new FileInfo(@"X:\noWhere.xlsx");
string[] exportFields = new string[] { "DOCID", "BEGATT", "VOLUME", "NATIVE" };
HyperLinkInfo[] links = new HyperLinkInfo[] { };
TestExporter tester = new TestExporter(outfile, exportFields, links);
DataTable dt = tester.getMetaDataTable(this.docs);
for (int i = 0; i < dt.Columns.Count; i++)
{
string expected = exportFields[i];
string actual = dt.Columns[i].ColumnName;
Assert.AreEqual(expected, actual);
}
for (int row = 0; row < dt.Rows.Count; row++)
{
for (int col = 0; col < dt.Columns.Count; col++)
{
string expected = docs[row].Metadata[dt.Columns[col].ColumnName];
string actual = dt.Rows[row][col].ToString();
Assert.AreEqual(expected, actual);
}
}
}
void GetGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.ToLower() != "add")
{
return;
}
var row = (e.CommandSource as Control).Parent.Parent as GridViewRow;
var htd = new Hashtable();
foreach (TemplateField tf in GridViewManager1.GridView.Columns)
{
var item = tf.FooterTemplate as GenericItem;
if (item == null)
{
continue;
}
try
{
foreach (DictionaryEntry de in item.ExtractValues(row))
{
htd.Add(de.Key, de.Value);
}
}
catch (Exception ex)
{
Exceptions.Logger.Error(ex);
HtmlHelper.Alert(ex.Message, Page);
return;
}
}
try
{
var ctrl = new HyperLinkController();
var info = new HyperLinkInfo();
foreach (System.Reflection.PropertyInfo property in CBO.GetPropertyInfo(typeof(HyperLinkInfo)))
{
if (htd[property.Name] != null)
{
property.SetValue(info, htd[property.Name], null);
}
}
ctrl.InsertHyperLink(info);
GridViewManager1.GridView.PageIndex = GridViewManager1.GridView.PageCount;
GridViewManager1.LoadData();
}
catch (Exception ex)
{
Exceptions.Logger.Error(ex);
HtmlHelper.Alert(ex.Message, Page);
}
}
public void Exporters_XlsExporter_insertLinkColumns_ExLinkIndex()
{
DataTable dt = new DataTable();
dt.Columns.Add("one");
dt.Columns.Add("two");
List <HyperLinkInfo> links = new List <HyperLinkInfo>();
Representative.FileType type = Representative.FileType.Native;
string display = "display text";
int index = 5;
HyperLinkInfo link = new HyperLinkInfo(type, display, index);
links.Add(link);
TestExporter tester = new TestExporter();
tester.insertLinkColumns(dt, links.ToArray());
}
public void Exporters_XlsExporter_insertLinkColumns_NullName()
{
DataTable dt = new DataTable();
dt.Columns.Add("one");
dt.Columns.Add("two");
List <HyperLinkInfo> links = new List <HyperLinkInfo>();
Representative.FileType type = Representative.FileType.Native;
string display = null;
int index = 1;
HyperLinkInfo link = new HyperLinkInfo(type, display, index);
links.Add(link);
TestExporter tester = new TestExporter();
tester.insertLinkColumns(dt, links.ToArray());
Assert.AreEqual(dt.Columns[index].ColumnName, "two");
}
/// <summary>
/// Initializes a new instance of <see cref="Hyperlink"/>.
/// </summary>
/// <param name="link">The settings used to build this object.</param>
public Hyperlink(HyperLinkInfo link)
{
this.FileType = link.GetFileType();
this.DisplayText = link.GetDisplayText();
this.ColumnIndex = link.GetColumnIndex();
}