public TableRow CreateEditableTableRow(SPSite site, SPWeb web, SPList library, int index, String details)
{
TableRow row = new TableRow();
row.ID = MakeControlID(index, "row");
row.CssClass = "wbf-edit-action-row";
string[] parts = details.Split('|');
string zone = parts[0];
string recordID = parts[1];
SPListItem recordItem = null;
if (zone == "Public Extranet")
{
if (extranetRecordsLibrary == null)
{
string extranetRecordsLibraryURL = WBFWebPartsUtils.GetExtranetLibraryURL(SPContext.Current.Site);
extranetRecordsSite = new SPSite(extranetRecordsLibraryURL);
extranetRecordsWeb = extranetRecordsSite.OpenWeb();
extranetRecordsLibrary = extranetRecordsWeb.GetList(extranetRecordsLibraryURL);
}
recordItem = WBFWebPartsUtils.GetRecord(extranetRecordsSite, extranetRecordsWeb, extranetRecordsLibrary, zone, recordID);
}
else
{
recordItem = WBFWebPartsUtils.GetRecord(site, web, library, zone, recordID);
}
if (recordItem == null)
{
return(row);
}
String displayName = recordItem.WBxGetAsString(WBColumn.Title);
if (String.IsNullOrEmpty(displayName))
{
displayName = recordItem.WBxGetAsString(WBColumn.Name);
}
string extension = Path.GetExtension(recordItem.Name).Replace(".", "").ToUpper();
Image image = new Image();
image.ImageUrl = WBUtils.DocumentIcon16(recordItem.Name);
image.Width = Unit.Pixel(16);
image.Height = Unit.Pixel(16);
row.WBxAddInTableCell(image);
Label label = new Label();
label.Text = recordItem.WBxGetAsString(WBColumn.Title);
row.WBxAddInTableCell(label);
label = new Label();
label.Text = recordItem.WBxGetAsString(WBColumn.Name);
row.WBxAddInTableCell(label);
Label extensionLabel = new Label();
extensionLabel.Text = extension;
row.WBxAddInTableCell(extensionLabel);
Button upButton = (Button)row.WBxAddWithIDInTableCell(new Button(), MakeControlID(index, "UpButton"));
upButton.Text = "/\\";
upButton.CommandName = "Up";
upButton.CommandArgument = index.ToString();
upButton.Command += new CommandEventHandler(upButton_OnClick);
Button downButton = (Button)row.WBxAddWithIDInTableCell(new Button(), MakeControlID(index, "DownButton"));
downButton.Text = "\\/";
downButton.CommandName = "Down";
downButton.CommandArgument = index.ToString();
downButton.Command += new CommandEventHandler(downButton_OnClick);
Button replaceButton = (Button)row.WBxAddWithIDInTableCell(new Button(), MakeControlID(index, "ReplaceButton"));
replaceButton.Text = "Replace";
replaceButton.OnClientClick = "WorkBoxFramework_pickADocument(" + index + "); return false;";
Button removeButton = (Button)row.WBxAddWithIDInTableCell(new Button(), MakeControlID(index, "RemoveButton"));
removeButton.Text = "Remove";
removeButton.OnClientClick = "WBF_DeleteRow(" + index + ",\"" + recordItem.Name + "\"); return false;";
HiddenField documentDetails = (HiddenField)row.WBxAddWithIDInTableCell(new HiddenField(), MakeControlID(index, "DocumentDetails"));
if (!IsPostBack)
{
documentDetails.Value = details;
}
return(row);
}
protected void Page_Load(object sender, EventArgs e)
{
webPart = this.Parent as PickedDocumentsGroup;
SPWebPartManager webPartManager = (SPWebPartManager)WebPartManager.GetCurrentWebPartManager(this.Page);
Guid WebPartGuid = webPartManager.GetStorageKey(webPart);
WebPartUniqueID = WebPartGuid.ToString().Replace("-", String.Empty);;
//EditRelatedDocumentsButton.OnClientClick = "WorkBoxFramework_editRelatedDocuments(WBF_EditDialogCallback" + WebPartUniqueID + ", \"" + webPart.PickedDocumentsDetails + "\"); return false;";
String[] detailsToSave = new String[5];
detailsToSave[0] = WBUtils.ReplaceDelimiterCharacters(webPart.Title);
detailsToSave[1] = WBUtils.ReplaceDelimiterCharacters(webPart.DocumentsGroupDescription);
detailsToSave[2] = WBUtils.ReplaceDelimiterCharacters(webPart.DocumentsGroupSubjectTags);
detailsToSave[3] = WBUtils.ReplaceDelimiterCharacters(webPart.DocumentsGroupCoverage);
detailsToSave[4] = WBUtils.ReplaceDelimiterCharacters(webPart.PickedDocumentsDetails.WBxTrim());
String currentDetails = String.Join(",", detailsToSave);
WBLogging.Debug("Current details: " + currentDetails);
if (IsPostBack)
{
if (NeedToSave.Value == "true")
{
WBLogging.Debug("Trying to save value: " + NewDocumentsGroupDetails.Value);
string[] newDetails = NewDocumentsGroupDetails.Value.WBxTrim().Split(',');
if (newDetails.Length != 5)
{
WBLogging.Debug("The details sent to this page have the wrong structure: " + NewDocumentsGroupDetails.Value);
Description.Text = "(the web part has not yet been edited).";
return;
}
webPart.Title = WBUtils.PutBackDelimiterCharacters(newDetails[0]);
webPart.DocumentsGroupDescription = WBUtils.PutBackDelimiterCharacters(newDetails[1]);
webPart.DocumentsGroupSubjectTags = WBUtils.PutBackDelimiterCharacters(newDetails[2]);
webPart.DocumentsGroupCoverage = WBUtils.PutBackDelimiterCharacters(newDetails[3]);
webPart.PickedDocumentsDetails = WBUtils.PutBackDelimiterCharacters(newDetails[4]);
webPartManager.SaveChanges(WebPartGuid);
SPContext.Current.File.Update();
SPContext.Current.Web.Update();
currentDetails = NewDocumentsGroupDetails.Value.WBxTrim();
WBLogging.Debug("New current details: " + currentDetails);
}
}
if (!String.IsNullOrEmpty(currentDetails) && !currentDetails.Contains(","))
{
WBLogging.Generic.Unexpected("The PickRelatedDocuments web part had an odd value: " + currentDetails);
currentDetails = "";
}
if ((SPContext.Current.FormContext.FormMode == SPControlMode.Edit) ||
(webPartManager.DisplayMode == WebPartManager.EditDisplayMode))
{
EditPanel.Visible = true;
InEditMode = true;
EditDocumentsGroupButton.OnClientClick = "WorkBoxFramework_editDocumentsGroup(WBF_EditDialogCallback" + WebPartUniqueID + ", \"" + currentDetails + "\"); return false;";
}
else
{
EditPanel.Visible = false;
EditDocumentsGroupButton.OnClientClick = "";
}
WBLogging.Debug("PickedDocumentsGroup currentDetails: " + currentDetails);
Title.Text = webPart.Title;
Description.Text = WBUtils.MaybeAddParagraphTags(webPart.DocumentsGroupDescription);
WBTermCollection <WBTerm> allSubjects = new WBTermCollection <WBTerm>(null, webPart.DocumentsGroupSubjectTags);
SubjectTags.Text = allSubjects.Names();
Coverage.Text = webPart.DocumentsGroupCoverage;
if (String.IsNullOrEmpty(webPart.PickedDocumentsDetails))
{
DocumentsList.Text = "<ul><li>(No documents picked)</li></ul>";
DocumentsToView = false;
return;
}
String extranetRecordsLibraryURL = WBFWebPartsUtils.GetExtranetLibraryURL(SPContext.Current.Site);
SPSite extranetRecordsSite = null;
SPWeb extranetRecordsWeb = null;
SPList extranetRecordsLibrary = null;
try
{
string[] documentsDetailsArray = webPart.PickedDocumentsDetails.Split(';');
String publicRecordsLibraryURL = WBFWebPartsUtils.GetRecordsLibraryURL(SPContext.Current.Site);
using (SPSite publicRecordsSite = new SPSite(publicRecordsLibraryURL))
using (SPWeb publicRecordsWeb = publicRecordsSite.OpenWeb())
{
SPList publicRecordsLibrary = publicRecordsWeb.GetList(publicRecordsLibraryURL);
String html = "<ul>\n";
foreach (string documentDetails in documentsDetailsArray)
{
string[] documentDetailsArray = documentDetails.Split('|');
if (documentDetailsArray.Length != 4)
{
WBLogging.Generic.Unexpected("Badly formatted document details in PickRelatedDocuments web part: " + currentDetails + " - Ignoring these details");
continue;
}
string zone = documentDetailsArray[0];
string recordID = documentDetailsArray[1];
string sourceID = documentDetailsArray[2];
string filename = documentDetailsArray[3];
SPListItem item = null;
if (zone == "Public Extranet")
{
if (extranetRecordsLibrary == null)
{
extranetRecordsSite = new SPSite(extranetRecordsLibraryURL);
extranetRecordsWeb = extranetRecordsSite.OpenWeb();
extranetRecordsLibrary = extranetRecordsWeb.GetList(extranetRecordsLibraryURL);
}
item = WBFWebPartsUtils.GetRecord(extranetRecordsSite, extranetRecordsWeb, extranetRecordsLibrary, zone, recordID);
}
else
{
item = WBFWebPartsUtils.GetRecord(publicRecordsSite, publicRecordsWeb, publicRecordsLibrary, zone, recordID);
}
if (item == null)
{
if (InEditMode)
{
html += "<li><i>(Could not find document)</i></li>";
}
}
else
{
DocumentsToView = true;
string title = item.WBxGetAsString(WBColumn.Title);
if (String.IsNullOrEmpty(title))
{
title = Path.GetFileNameWithoutExtension(item.Name);
}
string extension = Path.GetExtension(item.Name).Replace(".", "").ToUpper();
string additionalText = "";
long fileLength = (item.File.Length / 1024);
additionalText = ", " + fileLength + "KB";
if (item.WBxHasValue(WBColumn.ReferenceDate))
{
DateTime referenceDate = (DateTime)item.WBxGet(WBColumn.ReferenceDate);
string referenceDateString = string.Format("{0}-{1}-{2}",
referenceDate.Year.ToString("D4"),
referenceDate.Month.ToString("D2"),
referenceDate.Day.ToString("D2"));
additionalText += ", " + referenceDateString;
}
html += String.Format("<li><img src=\"{0}\" alt=\"{1}\"/><a target=\"_blank\" href=\"{2}\">{1}</a> <span>({3})</span></li>",
WBUtils.DocumentIcon16(item.WBxGetAsString(WBColumn.Name)),
title,
item.WBxGetAsString(WBColumn.EncodedAbsoluteURL),
extension + additionalText);
}
}
html += "</ul>\n";
DocumentsList.Text = html;
}
}
catch (Exception exception)
{
if (InEditMode)
{
DocumentsList.Text = "An error occurred: " + exception.Message;
}
else
{
DocumentsToView = false;
}
}
finally
{
if (extranetRecordsWeb != null)
{
extranetRecordsWeb.Dispose();
}
if (extranetRecordsSite != null)
{
extranetRecordsSite.Dispose();
}
}
}
private void RefreshBoundData()
{
if (SelectedNodePath != "")
{
SelectedRecordsType.Text = SelectedNodePath.Replace("Records Types/", "").Replace("/", " / ");
WBRecordsType recordsType = null;
WBTerm functionalArea = null;
WBTerm subjectTag = null;
switch (SelectedView)
{
case VIEW_BY_RECORDS_TYPE:
{
recordsType = recordsTypesTaxonomy.GetSelectedRecordsType(SelectedNodePath);
SelectedRecordsTypeDescription.Text = recordsType.Description;
break;
}
case VIEW_BY_FUNCTION_THEN_TYPE:
{
string[] parts = SelectedNodePath.Split('/');
if (parts.Length < 3)
{
return;
}
string functionPath = parts[0];
List <String> partsList = new List <String>(parts);
partsList.RemoveAt(0);
string recordsTypePath = String.Join("/", partsList.ToArray());
Term functionalAreaTerm = functionalAreaTaxonomy.GetSelectedTermByPath(functionPath);
if (functionalAreaTerm != null)
{
functionalArea = new WBTerm(functionalAreaTaxonomy, functionalAreaTerm);
}
recordsType = recordsTypesTaxonomy.GetSelectedRecordsType(recordsTypePath);
SelectedRecordsTypeDescription.Text = recordsType.Description;
break;
}
case VIEW_BY_SUBJECT:
{
Term subjectTagsTerm = subjectTagsTaxonomy.GetSelectedTermByPath(SelectedNodePath);
if (subjectTagsTerm != null)
{
subjectTag = new WBTerm(subjectTagsTaxonomy, subjectTagsTerm);
SelectedRecordsTypeDescription.Text = subjectTag.Description;
}
if (subjectTag == null)
{
WBLogging.Debug("Did not find subject with path: " + SelectedNodePath);
return;
}
break;
}
default: return;
}
WBTeam team = WBTeam.GetFromTeamSite(teamsTaxonomy, SPContext.Current.Web);
String recordsLibraryURL = WBFWebPartsUtils.GetRecordsLibraryURL(SPContext.Current.Site);
if (Request.QueryString["Library"] == "Extranet")
{
recordsLibraryURL = WBFWebPartsUtils.GetExtranetLibraryURL(SPContext.Current.Site);
}
using (SPSite site = new SPSite(recordsLibraryURL))
{
using (SPWeb web = site.OpenWeb())
{
WBQuery query = new WBQuery();
if (recordsType != null)
{
WBQueryClause recordsTypeClause = new WBQueryClause(WBColumn.RecordsType, WBQueryClause.Comparators.Equals, recordsType);
recordsTypeClause.UseDescendants = true;
query.AddClause(recordsTypeClause);
}
if (functionalArea != null)
{
WBQueryClause functionalAreaClause = new WBQueryClause(WBColumn.FunctionalArea, WBQueryClause.Comparators.Equals, functionalArea);
functionalAreaClause.UseDescendants = true;
query.AddClause(functionalAreaClause);
}
if (subjectTag != null)
{
WBQueryClause subjectTagClause = new WBQueryClause(WBColumn.SubjectTags, WBQueryClause.Comparators.Equals, subjectTag);
subjectTagClause.UseDescendants = false;
query.AddClause(subjectTagClause);
}
if (team != null)
{
query.AddEqualsFilter(WBColumn.InvolvedTeams, team);
}
// string protectiveZoneFilter = "Public"; // Request.QueryString["ProtectiveZone"];
// if (protectiveZoneFilter != null && protectiveZoneFilter != "")
// {
// query.AddEqualsFilter(WBColumn.ProtectiveZone, protectiveZoneFilter);
// }
query.AddViewColumn(WBColumn.Name);
query.AddViewColumn(WBColumn.Title);
query.AddViewColumn(WBColumn.FileSize);
query.AddViewColumn(WBColumn.FileTypeIcon);
query.AddViewColumn(WBColumn.FileType);
query.AddViewColumn(WBColumn.TitleOrName);
query.AddViewColumn(WBColumn.DisplayFileSize);
query.AddViewColumn(WBColumn.RecordID);
query.AddViewColumn(WBColumn.EncodedAbsoluteURL);
query.AddViewColumn(WBColumn.ReferenceDate);
query.AddViewColumn(WBColumn.ReferenceID);
query.AddViewColumn(WBColumn.ProtectiveZone);
query.AddViewColumn(WBColumn.DeclaredRecord);
if (SelectedView != VIEW_BY_SUBJECT)
{
query.AddViewColumn(WBColumn.SubjectTags);
}
else
{
query.AddViewColumn(WBColumn.RecordsType);
}
if (sortColumn == null)
{
sortColumn = WBColumn.DeclaredRecord;
ascending = false;
}
if (sortColumn != null)
{
query.OrderBy(sortColumn, ascending);
}
SPList recordsLibrary = web.GetList(recordsLibraryURL); //"Documents"]; //farm.RecordsCenterRecordsLibraryName];
DataTable dataTable = recordsLibrary.WBxGetDataTable(site, query);
ShowResults.DataSource = dataTable;
ShowResults.Columns.Clear();
ButtonField buttonField = new ButtonField();
buttonField.Text = "Select";
buttonField.CommandName = "Select Document";
ShowResults.Columns.Add(buttonField);
ShowResults.Columns.Add(WBUtils.DynamicIconTemplateField(WBColumn.FileTypeIcon, WBColumn.EncodedAbsoluteURL));
ShowResults.Columns.Add(WBUtils.BoundField(WBColumn.Title, sortColumn, ascending));
ShowResults.Columns.Add(WBUtils.BoundField(WBColumn.Name, sortColumn, ascending));
ShowResults.Columns.Add(WBUtils.BoundField(WBColumn.DeclaredRecord, sortColumn, ascending));
ShowResults.Columns.Add(WBUtils.BoundField(WBColumn.ProtectiveZone, sortColumn, ascending));
ShowResults.Columns.Add(WBUtils.BoundField(WBColumn.RecordID, sortColumn, ascending));
// BoundField test = WBUtils.BoundField(WBColumn.ServerURL, sortColumn, ascending);
// test.Hid
// ShowResults.Columns.Add(WBUtils.BoundField(WBColumn.FunctionalArea, sortColumn, ascending));
//ShowResults.Columns.Add(WBUtils.BoundField(WBColumn.OwningTeam, sortColumn, ascending));
// ShowResults.Columns.Add(WBUtils.BoundField(WBColumn.ReferenceDate, sortColumn, ascending));
// ShowResults.Columns.Add(WBUtils.BoundField(WBColumn.ReferenceID, sortColumn, ascending));
//ShowResults.Columns.Add(WBUtils.BoundField(WBColumn.SeriesTag, sortColumn, ascending));
//if (SelectedView != VIEW_BY_SUBJECT)
// {
// ShowResults.Columns.Add(WBUtils.BoundField(WBColumn.SubjectTags, sortColumn, ascending));
// }
//else
// {
// ShowResults.Columns.Add(WBUtils.BoundField(WBColumn.RecordsType, sortColumn, ascending));
// }
ShowResults.DataBind();
}
}
}
else
{
WBUtils.logMessage("SelectedNodePath was empty");
}
}