/// <summary>
/// Display the list of values attached to the current lookup group
/// </summary>
private void UpdateDataView()
{
if (lookupGroupId != -1)
{
LookupValueList lookupValuesList = LookupGroup.GetByKey(lookupGroupId).Values;
dg.DataSource = lookupValuesList;
Utils.InitGridSort(ref dg, false);
dg.DataBind();
Utils.EnableIntelligentSort(ref dg, Convert.ToInt32(txtSortColPos.Value));
dg.DisplayLayout.AllowSortingDefault = AllowSorting.No;
dg.DisplayLayout.CellClickActionDefault = CellClickAction.Edit;
// Refresh tab title
UITools.RefreshTab(Page, "Values", lookupValuesList.Count);
if (dg.Rows.Count == 0)
{
UITools.HideToolBarButton(uwToolbar, "Delete");
UITools.HideToolBarSeparator(uwToolbar, "DeleteSep");
}
else
{
if (SessionState.User.HasCapability(CapabilitiesEnum.MANAGE_DICTIONARY))
{
UITools.ShowToolBarButton(uwToolbar, "Delete");
UITools.ShowToolBarSeparator(uwToolbar, "DeleteSep");
}
}
}
}
/// <summary>
/// Export the lookups List with values in Excel file
/// </summary>
/// <param name="page"></param>
public static void ExportLookups(Page page)
{
using (LookupGroupList lList = LookupGroup.GetAll())
{
// string contains html code to export
System.Text.StringBuilder sb = new System.Text.StringBuilder(string.Empty);
sb.Append("<html><body>");
sb.Append("<table border='1'>");
#region "Header"
sb.Append("<tr align='center' style='font-size: 14; font-weight: bold; background-color: lightgrey' wordwrap='true'>");
sb.Append("<td>Id</td>");
sb.Append("<td>Name</td>");
sb.Append("<td>Comment</td>");
sb.Append("<td>Multi choice</td>");
sb.Append("<td>Sep</td>");
sb.Append("<td>Value</td>");
sb.Append("<td>Comment</td>");
sb.Append("<td>Sort</td>");
sb.Append("</tr>");
#endregion
string cellColor = "#D0D0D0", defaultCellColor = "#D0D0D0";
for (int i = 0; i < lList.Count; i++)
{
LookupGroup curLookupGroup = lList[i];
LookupValueList lvList = LookupGroup.GetByKey(curLookupGroup.Id).Values;
for (int j = 0; j < lvList.Count; j++)
{
LookupValue curLookupValue = lvList[j];
sb.Append("<tr valign='top' style='background-color: " + cellColor + "; text-color: black;'>");
sb.Append("<td>" + curLookupGroup.Id + "</td>");
sb.Append("<td>" + curLookupGroup.Name + "</td>");
sb.Append("<td>" + curLookupGroup.Comment + "</td>");
sb.Append("<td>" + curLookupGroup.MultiChoice + "</td>");
sb.Append("<td>" + curLookupValue.Text + "</td>");
sb.Append("<td>" + curLookupValue.Comment + "</td>");
sb.Append("<td>" + curLookupValue.Sort + "</td>");
sb.Append("</tr>");
if (cellColor == defaultCellColor)
{
cellColor = "white";
}
else
{
cellColor = defaultCellColor;
}
}
}
sb.Append("</table>");
sb.Append("</body></html>");
string fileName = string.Empty;
fileName += "Lookups.xls";
string exportContent = sb.ToString();
page.Response.Clear();
page.Response.ClearContent();
page.Response.ClearHeaders();
page.Response.Charset = string.Empty;
page.Response.AddHeader("content-disposition", "attachment;filename=" + fileName);
page.Response.ContentType = "application/vnd.ms-excel;";
//Fix for CR 5109 - Prabhu R S
page.Response.ContentEncoding = System.Text.Encoding.UTF8;
page.EnableViewState = false;
page.Response.Write(exportContent);
page.Response.End();
}
}