public static void UploadListItem() { using (SPSite spSite = new SPSite("http://leumtstspapp1/sites/staff/HR/")) { SPWeb spWeb = spSite.OpenWeb(); SPList spList = spWeb.Lists["testWf"]; SPListItem spItm = spList.Items[0]; string[] arrApp = new string[] { "*****@*****.**" }; SPView listView = spList.Views["MAT_ADOBE_SIGN_VIEW"]; if (listView == null) { throw new ApplicationException("The list does not contain the view by name MAT_ADOBE_SIGN_VIEW"); } SPViewFieldCollection viewfieldCollection = listView.ViewFields; StringBuilder buff = new StringBuilder(16); buff.Append("Column Name : Column Value"); foreach (string viewFieldName in viewfieldCollection) { var val = spItm[viewFieldName]; buff.Append(string.Format("{0}:{1}", viewFieldName, val)); buff.Append(Environment.NewLine); buff.Append(Environment.NewLine); } string miscInfo = "WEbUrl=" + spWeb.Url + "&listTitle=" + spList.Title + "&ItemId=" + spItm.ID; // now send it to signature AdobeOperations.SendDocumentByBytesForSigninig(Encoding.ASCII.GetBytes(buff.ToString()), null, spItm["ID"].ToString(), arrApp, null, miscInfo); } }
private void CreateItemforForm() { FormWebPart wp = (FormWebPart)this.WebPart; List <BaseFieldControl> fields = new List <BaseFieldControl>(); List <DesignDataSource> sources = new List <DesignDataSource>(); if (!string.IsNullOrEmpty(wp.DataSourcesData)) { sources = Utilities.DeserializeObject <List <DesignDataSource> >(wp.DataSourcesData); } SPSecurity.RunWithElevatedPrivileges(delegate() { SPSite site = SPContext.Current.Site; site.AllowUnsafeUpdates = true; foreach (DesignDataSource source in sources) { fields = new List <BaseFieldControl>(); SPWeb web = site.OpenWeb(new Guid(source.WebId)); web.AllowUnsafeUpdates = true; SPList list = web.Lists[new Guid(source.ListId)]; SPView view = list.GetView(new Guid(source.ViewId)); SPViewFieldCollection viewfields = view.ViewFields; foreach (var viewfield in viewfields) { BaseFieldControl formField = (BaseFieldControl)FindControl(viewfield.ToString()); if (formField == null) { continue; } fields.Add(formField); } SPListItem item = list.Items.Add(); foreach (BaseFieldControl Fld in fields) { try { item[Fld.FieldName] = Fld.Value; } catch { }; } UpdateUserInfo(item); item.Update(); web.AllowUnsafeUpdates = false; } site.AllowUnsafeUpdates = false; }); }
protected override void Render(HtmlTextWriter writer) { base.Render(writer); try { if (this.ListToDisplay != null) { SPList selectedList = SPContext.Current.Web.Lists[new Guid(this._listToDisplay)]; SPView defaultView = selectedList.DefaultView; if (this.IsExternalList) { SPViewFieldCollection fields = defaultView.ViewFields; System.Collections.Specialized.StringCollection stringCol = fields.ToStringCollection(); // Nik20121105 - Write the table headers; System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.AppendLine("<table class=\"wet-boew-zebra\">"); sb.Append("<tr>"); foreach (string field in stringCol) { sb.Append("<th>" + field + "</th>"); } sb.Append("</tr>"); foreach (SPListItem item in selectedList.Items) { sb.AppendLine("<tr>"); bool firstCol = true; foreach (string field in stringCol) { if (firstCol) { firstCol = false; sb.AppendLine("<td><a href=\"" + SPContext.Current.Web.Url + "/_layouts/listform.aspx?PageType=4&ListId={" + this._listToDisplay + "}&ID=" + item["BdcIdentity"].ToString() + "\">" + item[field].ToString() + "</a></td>"); } else { sb.AppendLine("<td>" + item[field].ToString() + "</td>"); } } sb.AppendLine("</tr>"); } sb.AppendLine("</table>"); writer.Write(sb.ToString()); } else { writer.Write(defaultView.RenderAsHtml()); } } } catch (Exception ex) { writer.Write(ex.ToString()); } }
private void loadTemplate() { StringBuilder sb = new StringBuilder(Properties.Resources.TextFile1.Replace("\r\n", "\\r\\n").Replace("\"", "`").Replace("#nonworkingdays#", "65")); StringBuilder images = new StringBuilder(); images.Append("HTMLPicture(`red.gif`) = `gBHJJGHA5MIQAEIcx0ACSFQfehzOr3TSbVBVJbTORvcxkMi5LhVXBSJb+fj8fCeUDRLJWeC/Xr0NJsaJMJTiRCEeyhUTTJZJdSORz0NxwayBPz4UakeRoNa3IxAdxxONTOT7d7vcpcLq2Hg1dSVSr0aDPbhvNbxYbBb5zN7zPR8fLlcj8ej0eRtNztWaxapqNDsNBoebMZT1aLQejOZjhQR+d6FQriPp6bRWKTwMZkeSNRzNMJbebHYzvW61ahoMz2TadbhgLjzOx4eKcTbgPJ2ezabLeOhweRfMTsVCme7cbbgOhxcB2ObcLZXbxyNr5czlahkMT1Uajbx1OLvLxgeJ0OrpUahejPZr3UqmauVeCKRTgNxrcByNz0T6feZHEeb4/Dyd6hHGQxBm8NY0GmMQwHmMozm4MownoSBJKwdxzEiRxvDiNpzEmR53l0XBvjgNp5keSBvvAexrmsb8PnqSRKRONhvLcfh5nmkx9noRhHNeLp1E+Tp5mWZJ2joOhzk2S5ujWM5bDkNRZDUMRPiKHR/y7LwATBMMxTHMkyzGEJ8gIAMwIYFkxIQhAAAOZZADoQRBDgOQADkOBBkUQQ4gMJgOAeCICAOOJFjoAYJhwKAKASAQshYGgBkUOIJikNwHCmAQYByLYfisSpBAMIoHBEHQViaMwPi0Lo2gsQgYiWIwSjQDoqBmOYlCAJAFESOQOAoGoPCSDIhjOBYvguAICjkhgHk6MA3h8OYRhaDAAgkCoADoOQIgEKIuC8BAxAyNgyhOBgNG4OACDIHYFjmKBGCyQYQEKSYLgaCRohySATCYA4KhAGBUHSEJxmSSIGkGcRMGAERSCUGwJCCNhcEAAAlmgAARBCNxQDGOBCgOAgokWcQsCgKBQEEQwDA2JQtBUOgkFCUpPh+Ac1h2gIA=`\\r\\n"); images.Append("HTMLPicture(`green.gif`) = `gBHJJGHA5MIQAEIcxsAB6ZCPJy2NZ9ZKSFBhD53YyMN7EQxKWpoObFRJHWZlNjBQSAZSUKaAJZCQxFGJ/G5kVBvfD7fBFVJdNi4PhsYSDLChMZ5YyNMKlNRxXSCHaWJY6S5LJKJJbyfDzKqdLxNWpqKaBJj1fL2TbEUDleDmbzsb6sZ6wKCZLKvaCyNyUM5fTRhKCWKxSUJfLq8O5kXx8IiaKZeRZYKS3NxeUBkcDtcTzfD0ZziaOYMadYqhN64PzfdjgKSyNTJcDMKS1NpSTZaKydL6vZ6yL6hlC3PhUThdQi2RKaYaeMaoNhYWpwMq4PA5QQ+LagMRiTZkbLpbZiURoYjcY5cT5iJiqMa5ay8JqzNJ4V59LaRLLK2ZrYBBFqahcrWT44FWOw3luPosE4MA1lQOJDlwRg0FsPApFALztjIdJ5HUSxgk3EBNDaVY6iaTwtjeYZCnsfR7DOUrblkNYyFuO5IF8Sw5FaPI4EsNQ0kgMQhjoHR/yRJIASXJkmydJ8oSjKUpyWEJ8gIAMloYFkmoQhAAAOX5ADYQRBDQNQBjUNBBkUQQ0gyCoLAoCIJgYNJFjYBYHAUAQAAIA4CgkLQOkUNJMk2TpPiGMYjBYQYMk0ThPASJQfiSG4nkICpTFiFwvC4NYjhMEo2DUCwABoHowgSGQPg8B4pDOE41DYAYKCqKYgB4MosA0GAui2GwOAGYYIiCEIHh2KgYjEMwfBwAIIGkNAJiyGYajWF4NBIDYWgCAwLkSNgMCIIJxAIZQNAgL5kHoIZoDAKANAoFRWC4MIRBEY4hAYSoDBaABJiERBHBEEYGBAYBYGAKQNBEFZLBoQI4FCIIjCWNgFA6AQEFmcxRCAAAdoCA`\\r\\n"); images.Append("HTMLPicture(`checkmark.gif`) = `gBHJJGHA5MIPAAMADmIwAcbpcqKYxAdDrdKUZI9Si9JRkVhkRizRzJarNZbTZjveLwSy2SK7Zi+KK0JChWqfYbVY50WJXQauSCDYhBNq+IiSWUSazJVzCV73fL4bLhba2agzXTKXbPcLXQC2Ja1Zq5OK3IiUY5VWbDWrteDtbTpWS8baQV7FV6UXZLVbKWysaZwcjqcyMXJ3Ki5I5oXpFYLSYaUWx8TC5QyIYpAYrcPCmZ5FVDCSJsWZTX7PYDodjpYbTVRgVxLSbIHqLWSEOa0Kj83iNY4+fD6fKsYo5Vi6VC4aalVbBVKxYqOcTnciMWKOUy1TiMXo/f/fAHh8Xj8nl83n9Hp9Xr9nt93v+HxEL5AgB8MNFnjhEKAAHMRACMQRBkGHgRgaHwgAWQhGAUEQQh+FYLEYQYKg8EwUA0ShBgAB4AhkA5GA+BBBiGCQGBKRgABqIIBCMC4bBSCBGBAGIXhgFgdAMFQCgSRgThaIoXAigoOgoTYjA4DYBh2G4JmSQQHAIDASCEaJBBmHoiGwQYMhoZJAgAHaAg==`\\r\\n"); images.Append("HTMLPicture(`yellow.gif`) = `gBHJJGHA5MIQAEIcxbADzZqKcCPHDxYJvbJzA7yYp4erVTj4cC1eC+Mz5c7FezZUr0aKTdqyJrvXReeTJQL6dbMfDkXr3bqtdy2KrtV5FciZITqVJDd7FR7gRAadi4OTsWBScSQFruYKHcqiKjmTQufToZboUZEdSsLDuWpUdayMjlTAqdisITtWxZejWU7qU46ejXVTvXpody5McyMjxYBtu5FebMST0aCSeLCO7qUo1zkTYR1dapH7uWhTdivJk1QV9T7tWpZebOSLrVRBdq0Kz8eThfz8fOAHL+fLzdy4ME4aMgXOwLDsVZGdSmG+2H71bCldqxJbwXhmerTTj0aSZf7+frtWZT3JReTIQL3cS6dKjGLww/THEsTr8eZxpYShukIExyE6KKvi0f8FwYAEHQfCEIwlCcKQrC0LwxDMNQeEJ8gIAMHIYFkIIQhAAAOYRAC2QRBCyK4BiuLJBkUQQsA2DQShuFoLgmLBFi2AIKgcI4ZhSGoZAKEIAkULBMgQFAhC0HgWAUAAPkqQQNgcBAHh0H4tB6GIAAaAgMkIDRZgMHYOi0KojF2AQPESK4TgeAwICeF4tCUIYCAEA4MCuLYBigZwEisIgmCAKRrAYEABi2K4qAgBIChcGAcCKFYDgYCIKGyLILnYBQbCaKITCcegLDgJBaDKIQAisEhLDQBIZBKYQBASCwDDCBJQhWRJFAcHIjB4Ch4iUKBAAeao0HwDBAiIQQECiRZYDIeBAACAgCgcCwdC0FQ6EQUBSk2G4BxAHaAg`\\r\\n"); sb = sb.Replace("#Images#", images.ToString()); SPViewFieldCollection vfc = view.ViewFields; StringBuilder columns = new StringBuilder(); foreach (string field in vfc) { SPField spfield = list.Fields.GetFieldByInternalName(field); switch (spfield.Type) { case SPFieldType.Number: case SPFieldType.Currency: case SPFieldType.DateTime: case SPFieldType.Counter: columns.Append("Columns(`" + spfield.Title + "`).Alignment = 2\\r\\n"); break; case SPFieldType.Calculated: if (spfield.Description == "Indicator") { columns.Append("Columns(`" + spfield.Title + "`).Alignment = 1\\r\\n"); } else { columns.Append("Columns(`" + spfield.Title + "`).Alignment = 2\\r\\n"); } break; default: columns.Append("Columns(`" + spfield.Title + "`).Alignment = 0\\r\\n"); break; } if (spfield.InternalName == "StartDate") { columns.Append("Columns(`" + spfield.Title + "`).Def(18) = 1\\r\\n"); } if (spfield.InternalName == "DueDate") { columns.Append("Columns(`" + spfield.Title + "`).Def(18) = 2\\r\\n"); } } sb = sb.Replace("#Columns#", columns.ToString()); strTemplate = sb.ToString(); }
protected override ActivityExecutionStatus Execute(ActivityExecutionContext executionContext) { ActivityActivationReference.IsAllowed(this, __Context.Web); // Get the workflow context for the workflow activity. NWWorkflowContext ctx = NWWorkflowContext.GetContext(__Context, new Guid(__ListId), __ListItem.Id, WorkflowInstanceId, this); base.LogProgressStart(ctx); string approverNames = ctx.AddContextDataToString(this.Approvers); string qryUrl = ctx.AddContextDataToString(this.UrlMiscInfo); string[] approvers = Akki.AdobeSign.Common.Utilities.GetUserEmails(approverNames, ctx.Web.Url).ToArray(); try { SPList spList = this.__Context.Web.Lists[new Guid(this.__ListId)]; SPListItem spItm = spList.GetItemById(this.__ListItem.Id); var agreeementName = string.Format(Constants.MsgListItemAgreementName, spItm.ID, spList.Title); SPView listView = spList.Views[Constants.AkkiItemViewTypeAdobe]; if (listView == null) { throw new ApplicationException(Constants.ErrNoViewFound); } SPViewFieldCollection viewfieldCollection = listView.ViewFields; StringBuilder buff = new StringBuilder(16); buff.Append(Constants.HeaderTextInfo); foreach (string viewFieldName in viewfieldCollection) { buff.Append(Environment.NewLine); buff.Append(Environment.NewLine); var val = spItm[viewFieldName]; buff.Append(string.Format("{0}:{1}", viewFieldName, val)); buff.Append(Environment.NewLine); buff.Append(Environment.NewLine); } var agreementId = AdobeOperations.SendDocumentByBytesForSigninig(Encoding.ASCII.GetBytes(buff.ToString()), null, agreeementName, approvers, null, qryUrl).agreementId; this.OutAdobeAgreementID = agreementId; // if no problem try { Utilities.SetDefaultColValues(spItm, agreementId, AgreementStatus.OUT_FOR_SIGNATURE); } catch { } } catch (Exception ex) { //log.Error("[Execute]", ex); throw; } base.LogProgressEnd(ctx, executionContext); return(ActivityExecutionStatus.Closed); }
/// <summary> /// Ensure the field in the view /// </summary> /// <param name="fieldCollection">the collection of fields</param> /// <param name="fieldInternalName">the current field internal name</param> public void EnsureFieldInView(SPViewFieldCollection fieldCollection, string fieldInternalName) { if (!string.IsNullOrEmpty(fieldInternalName)) { if (!fieldCollection.Exists(fieldInternalName)) { fieldCollection.Add(fieldInternalName); } } }
private List <string> GetVisibleColumns(SPViewFieldCollection sfc) { List <string> visFields = new List <string>(); foreach (string field in sfc) { visFields.Add(field); } visFields.Add("Today's Date"); return(visFields); }
private SPList ConfigureStyleDocumentLibrary(SPFeatureReceiverProperties properties) { SPSite site = properties.Feature.Parent as SPSite; SPWeb rootWeb = site.RootWeb; SPList list = null; try { SPListCollection lists = rootWeb.Lists; bool updateRequired = false; bool newListCreated = false; list = AddList(lists, "Style Library", "Style Library", "$Resources:cmscore,ListDescriptionRootStyles;", new Guid("00BFEA71-E717-4E80-AA17-D0C71B360101"), null, SPListTemplateType.DocumentLibrary, out newListCreated); //list = lists["Style Library"]; if (list != null) { EnableFolderCreationOnList(list, ref updateRequired); if (list.AllowDeletion) { list.AllowDeletion = false; updateRequired = true; } if (updateRequired) { list.Update(); } //EnableStandardVersioningOnList(list, ref updateRequired); EnableAllowEveryoneViewItems(list); DisableCrawlOnList(list); list.Update(); SPView defaultView = list.DefaultView; if (defaultView != null) { SPViewFieldCollection viewFields = defaultView.ViewFields; AddFieldToView(list, SPBuiltInFieldId.CheckoutUser, viewFields); defaultView.Update(); } //AddFolder(list.RootFolder, "XSL Style Sheets"); } } catch (Exception ex) { SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory(ex.Source, TraceSeverity.High, EventSeverity.Error), TraceSeverity.High, ex.Message, ex.Data); } return(list); }
private static SPList GetOASList(SPWeb web) { SPListTemplateType genericList = new SPListTemplateType(); genericList = SPListTemplateType.GenericList; //Check if the list exist SPList oaslist = web.Lists.TryGetList(OAS_LIST); if (oaslist == null) { //Create a custom list web.AllowUnsafeUpdates = true; Guid listGuid = web.Lists.Add(OAS_LIST, "", genericList); oaslist = web.Lists[listGuid]; oaslist.Hidden = true; //Add columns SPFieldCollection collFields = oaslist.Fields; string field1 = collFields.Add("FileId", SPFieldType.Text, false); SPField column1 = collFields.GetFieldByInternalName(field1); string field4 = collFields.Add("JobId", SPFieldType.Text, false); SPField column4 = collFields.GetFieldByInternalName(field4); string field2 = collFields.Add("Started", SPFieldType.DateTime, false); SPField column2 = collFields.GetFieldByInternalName(field2); string field3 = collFields.Add("Finished", SPFieldType.DateTime, false); SPField column3 = collFields.GetFieldByInternalName(field3); string field5 = collFields.Add("Type", SPFieldType.Integer, false); SPField column5 = collFields.GetFieldByInternalName(field5); SPView view = oaslist.DefaultView; SPViewFieldCollection collViewFields = view.ViewFields; collViewFields.Add(column1); collViewFields.Add(column2); collViewFields.Add(column3); collViewFields.Add(column4); collViewFields.Add(column5); view.Update(); } return(oaslist); }
internal static bool AddFieldToView(SPList list, Guid fieldId, SPViewFieldCollection viewfields) { bool flag = false; try { SPField field = list.Fields[fieldId]; if ((field != null) && !viewfields.Exists(field.InternalName)) { viewfields.Add(field); flag = true; } } catch (Exception ex) { SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory(ex.Source, TraceSeverity.High, EventSeverity.Error), TraceSeverity.High, ex.Message, ex.Data); } return(flag); }
internal List <BaseFieldControl> FieldList(WebPart webpart) { FormWebPart wp = (FormWebPart)webpart; List <BaseFieldControl> fields = new List <BaseFieldControl>(); List <DesignDataSource> sources = new List <DesignDataSource>(); if (!string.IsNullOrEmpty(wp.DataSourcesData)) { sources = Utilities.DeserializeObject <List <DesignDataSource> >(wp.DataSourcesData); } SPSecurity.RunWithElevatedPrivileges(delegate() { SPSite site = SPContext.Current.Site; foreach (DesignDataSource source in sources) { SPWeb web = site.OpenWeb(new Guid(source.WebId)); SPList list = web.Lists[new Guid(source.ListId)]; SPView view = list.GetView(new Guid(source.ViewId)); SPViewFieldCollection viewfields = view.ViewFields; foreach (var viewfield in viewfields) { BaseFieldControl formField = (BaseFieldControl)FindControl(viewfield.ToString()); //formField.ControlMode = Microsoft.SharePoint.WebControls.SPControlMode.Display; if (formField == null) { continue; } fields.Add(formField); } } }); return(fields); }
private void PopulateAndSync() { SPSite site = SPContext.Current.Site; SPWeb web = site.RootWeb; SPWebCollection webs = site.AllWebs; SPList list = null; //SPListCollection lists = null; List <SPList> lists = new List <SPList>(); SPView view = null; SPViewCollection views = null; //SPFieldCollection fields = null; SPViewFieldCollection viewfields = null; if (!string.IsNullOrEmpty(source.Title)) { tbx_name.Text = source.Title; } #region Webs ddl_webs.DataSource = webs; ddl_webs.DataTextField = "Title"; ddl_webs.DataValueField = "ID"; if (!string.IsNullOrEmpty(source.WebId)) { try { Guid WebId = new Guid(source.WebId); web = site.OpenWeb(WebId); ddl_webs.SelectedValue = web.ID.ToString(); } catch (Exception) { web = site.RootWeb; } } //lists = web.Lists; foreach (SPList _list in web.Lists) { if (!_list.Hidden) { if (_list.BaseType == SPBaseType.DocumentLibrary) { if (!((SPDocumentLibrary)_list).IsCatalog) { lists.Add(_list); } } else { lists.Add(_list); } } } ddl_webs.DataBind(); #endregion #region Lists ddl_lists.DataSource = lists; ddl_lists.DataTextField = "Title"; ddl_lists.DataValueField = "ID"; if (!string.IsNullOrEmpty(source.ListId)) { try { Guid ListId = new Guid(source.ListId); list = web.Lists.GetList(ListId, true); views = list.Views; ddl_lists.SelectedValue = list.ID.ToString(); } catch (Exception) { list = lists[0]; ddl_lists.SelectedValue = list.ID.ToString(); views = lists[0].Views; } } if (list == null) { list = lists[0]; } if (views == null) { views = list.Views; } ddl_lists.DataBind(); ddl_lists.SelectedValue = list.ID.ToString(); #endregion #region Views ddl_views.DataSource = views; ddl_views.DataTextField = "Title"; ddl_views.DataValueField = "ID"; if (!string.IsNullOrEmpty(source.ViewId) && list != null) { try { Guid ViewId = new Guid(source.ViewId); view = list.Views[ViewId]; viewfields = view.ViewFields; ddl_views.SelectedValue = view.ID.ToString(); } catch (Exception) { view = list.Views[0]; } } if (view == null) { view = list.Views[0]; } if (viewfields == null) { viewfields = view.ViewFields; } ddl_views.DataBind(); ddl_views.SelectedValue = view.ID.ToString(); #endregion #region Fields cbl_fields.DataSource = viewfields; if (!string.IsNullOrEmpty(source.ViewFields) && view != null) { string[] _fields = source.ViewFields.Split(new char[1] { ';' }); } cbl_fields.DataBind(); #endregion #region CAML if (!string.IsNullOrEmpty(source.Query) && view != null) { tbx_caml.Text = view.Query; } else { if (view != null) { tbx_caml.Text = view.Query; } } #endregion }
private List<string> GetVisibleColumns(SPViewFieldCollection sfc) { List<string> visFields = new List<string>(); foreach (string field in sfc) { visFields.Add(field); } visFields.Add("Today's Date"); return visFields; }
private void GetListItems(out string xml) { xml = string.Empty; SPSite site = SPContext.Current.Site; XmlDocument doc = new XmlDocument(); List <DesignDataSource> sources = new List <DesignDataSource>(); if (!string.IsNullOrEmpty(DataSourcesData)) { sources = Utilities.DeserializeObject <List <DesignDataSource> >(DataSourcesData); } SPSecurity.RunWithElevatedPrivileges(delegate() { //bool first = true; foreach (DesignDataSource source in sources) { SPWeb web = site.OpenWeb(new Guid(source.WebId)); SPList list = web.Lists[new Guid(source.ListId)]; SPView view = list.GetView(new Guid(source.ViewId)); //view.RowLimit = 0; //SPQuery query = new SPQuery(view); //query.ViewFieldsOnly = true; //string sxml = list.GetItems(query).Xml; SPViewFieldCollection viewfields = view.ViewFields; List <string> used = new List <string>(); foreach (var viewfield in viewfields) { used.Add(viewfield.ToString()); } string dataschema = list.SchemaXml; //Cleanup document doc.LoadXml(dataschema); XmlNode listnode = doc.SelectSingleNode("//List", NameSpaceManager(doc.NameTable)); XmlNode targetfields = listnode.SelectSingleNode("//Fields", NameSpaceManager(doc.NameTable)); targetfields.RemoveAll(); XmlNode RegionalSettings = doc.SelectSingleNode("//RegionalSettings", NameSpaceManager(doc.NameTable)); listnode.RemoveChild(RegionalSettings); XmlNode ServerSettings = doc.SelectSingleNode("//ServerSettings", NameSpaceManager(doc.NameTable)); listnode.RemoveChild(ServerSettings); //Get All Node again XmlDocument schemadoc = new XmlDocument(); schemadoc.LoadXml(dataschema); listnode = schemadoc.SelectSingleNode("//List", NameSpaceManager(schemadoc.NameTable)); XmlNode fields = listnode.SelectSingleNode("//Fields", NameSpaceManager(schemadoc.NameTable)); XmlNodeList fieldnodes = fields.SelectNodes("//Field", NameSpaceManager(schemadoc.NameTable)); foreach (XmlNode field in fieldnodes) { XmlNode namenode = field.Attributes["Name"]; XmlNode displaynamenode = field.Attributes["DisplayName"]; XmlNode staticnamenode = field.Attributes["StaticName"]; XmlNode hiddennode = field.Attributes["Hidden"]; string name = string.Empty; if (namenode != null) { name = namenode.Value; } string staticname = string.Empty; if (staticnamenode != null) { staticname = staticnamenode.Value; } string displayname = string.Empty; if (displaynamenode != null) { displayname = displaynamenode.Value; } bool hidden = false; if (hiddennode != null) { hidden = Boolean.Parse(hiddennode.Value); } if (used.Contains(name) || used.Contains(displayname) || used.Contains(staticname)) { try { if (field.ParentNode == fields) { XmlNode importNode = doc.ImportNode(field, true); targetfields.AppendChild(importNode); if (importNode.ParentNode == targetfields) { if (hiddennode == null) { XmlAttribute hiddenAttribute = importNode.OwnerDocument.CreateAttribute("Hidden"); hiddenAttribute.Value = Boolean.FalseString; importNode.Attributes.Append(hiddenAttribute); } XmlNode requirednode = importNode.Attributes["Required"]; if (requirednode == null && importNode.ParentNode == targetfields) { XmlAttribute requiredAttribute = importNode.OwnerDocument.CreateAttribute("Required"); requiredAttribute.Value = Boolean.FalseString; importNode.Attributes.Append(requiredAttribute); } XmlNode groupnode = importNode.Attributes["Group"]; if (groupnode == null && importNode.ParentNode == targetfields) { XmlAttribute groupAttribute = importNode.OwnerDocument.CreateAttribute("Group"); groupAttribute.Value = string.Empty; importNode.Attributes.Append(groupAttribute); } } } } catch (Exception ex) { ex.ToString(); } } } } }); xml = doc.InnerXml; }
private void SetListFormFields(Control canvas) { List <DesignDataSource> sources = new List <DesignDataSource>(); if (!string.IsNullOrEmpty(DataSourcesData)) { sources = Utilities.DeserializeObject <List <DesignDataSource> >(DataSourcesData); } if (inEditMode) { } SPSecurity.RunWithElevatedPrivileges(delegate() { SPSite site = SPContext.Current.Site; foreach (DesignDataSource source in sources) { SPWeb web = site.OpenWeb(new Guid(source.WebId)); SPList list = web.Lists[new Guid(source.ListId)]; SPView view = list.GetView(new Guid(source.ViewId)); SPViewFieldCollection viewfields = view.ViewFields; foreach (var viewfield in viewfields) { if (list.Fields.ContainsField(viewfield.ToString())) { try { string fieldname = viewfield.ToString().Replace("_x0020_", " "); SPField field = list.Fields.GetField(fieldname); FormField fld = new FormField(); if (inEditMode && Page.IsPostBack) //if (DesignMode)// && Page.IsPostBack) { fld.ControlMode = SPControlMode.Display; } else { fld.ControlMode = SPControlMode.New; } //fld.ControlMode = SPControlMode.New; fld.ListId = list.ID; fld.FieldName = field.InternalName; fld.ID = field.InternalName; fld.DisableInputFieldLabel = true; fld.InDesign = inEditMode; fld.IsValid = inEditMode; try { if (!string.IsNullOrEmpty(field.DefaultValue)) { if (field.FieldValueType == typeof(Boolean)) { bool isbool = false; fld.Value = (Boolean.TryParse(field.DefaultValue, out isbool)); fld.InputFieldLabel = string.Empty; } else { fld.Value = field.DefaultValue; } } } catch (Exception) { } canvas.Controls.Add(fld); if (field.Required) { InputFormRequiredFieldValidator required = new InputFormRequiredFieldValidator(); required.ID = "required_" + fld.ClientID; required.ControlToValidate = fld.ClientID; required.ValidationGroup = fld.ClientID; required.ErrorMessage = field.ValidationMessage; //required.EnableClientScript = true; required.BreakAfter = true; required.BreakBefore = false; required.Display = System.Web.UI.WebControls.ValidatorDisplay.Dynamic; canvas.Controls.Add(required); } if (field.Type == SPFieldType.Number) { SPFieldNumber Number = (SPFieldNumber)field; if (Number.MinimumValue != Double.MinValue && Number.MaximumValue != Double.MaxValue) { InputFormRangeValidator range = new InputFormRangeValidator(); range.ID = "range_" + fld.ClientID; range.ControlToValidate = fld.ClientID; range.ValidationGroup = fld.ClientID; range.ErrorMessage = field.ValidationMessage; //range.EnableClientScript = true; range.BreakAfter = true; range.BreakBefore = false; range.Display = System.Web.UI.WebControls.ValidatorDisplay.Dynamic; range.MaximumValue = Number.MaximumValue.ToString(); range.MinimumValue = Number.MinimumValue.ToString(); range.Type = System.Web.UI.WebControls.ValidationDataType.Double; canvas.Controls.Add(range); } } if (field.Type == SPFieldType.Currency) { SPFieldCurrency Currency = (SPFieldCurrency)field; if (Currency.MaximumValue != Double.MaxValue && Currency.MinimumValue != Double.MinValue) { InputFormRangeValidator range = new InputFormRangeValidator(); range.ID = "range_" + fld.ClientID; range.ControlToValidate = fld.ClientID; range.ValidationGroup = fld.ClientID; range.ErrorMessage = field.ValidationMessage; //range.EnableClientScript = true; range.BreakAfter = true; range.BreakBefore = false; range.Display = System.Web.UI.WebControls.ValidatorDisplay.Dynamic; range.MaximumValue = Currency.MaximumValue.ToString(); range.MinimumValue = Currency.MinimumValue.ToString(); range.Type = System.Web.UI.WebControls.ValidationDataType.Currency; canvas.Controls.Add(range); } } if (!string.IsNullOrEmpty(field.ValidationFormula)) { InputFormRegularExpressionValidator regex = new InputFormRegularExpressionValidator(); regex.ControlToValidate = fld.ClientID; regex.ValidationGroup = fld.ClientID; regex.ErrorMessage = fld.ErrorMessage; regex.ErrorMessage = field.ValidationMessage; //regex.EnableClientScript = true; regex.BreakAfter = true; regex.BreakBefore = false; regex.Display = System.Web.UI.WebControls.ValidatorDisplay.Dynamic; regex.ValidationExpression = field.ValidationFormula; canvas.Controls.Add(regex); } /* * if (field.Type == SPFieldType.MultiChoice) * { * InputFormCheckBoxListValidator checkboxes = new InputFormCheckBoxListValidator(); * //SPFieldMultiChoice choice = (SPFieldMultiChoice)field; * checkboxes.ControlToValidate = fld.ClientID; * checkboxes.ValidationGroup = fld.ClientID; * checkboxes.ErrorMessage = fld.ErrorMessage; * checkboxes.EnableClientScript = true; * //checkboxes.BreakAfter = true; * checkboxes.Display = System.Web.UI.WebControls.ValidatorDisplay.Dynamic; * canvas.Controls.Add(checkboxes); * * } */ } catch (Exception ex) { ex.Message.ToString(); } } } } }); }
protected new void BtnSaveAdvancedSettings_Click(object sender, EventArgs e) { bool flag = false; if (base.List.AllowContentTypes) { base.List.ContentTypesEnabled = RadEnableContentTypesYes.Checked; } if (ItemLevelSecurityPanel.Visible) { int num = 1; if (RadReadSecurityOwn.Checked) { num = 2; } if (num == 2 && CheckIfListHasUniqueFields(base.List)) { throw new SPException(base.GetResourceString("advsetng_CannotSetItemLevelPermissionsOnListWithUniqueColumns")); } int writeSecurity = 1; if (RadWriteSecurityOwn.Checked) { writeSecurity = 2; } else if (RadWriteSecurityNone.Checked) { writeSecurity = 4; } base.List.ReadSecurity = num; base.List.WriteSecurity = writeSecurity; } //SendToSection.UseFieldset = true; if (SendToSection.Visible) { base.List.SendToLocationName = TxtSendToLocationName.Text; base.List.SendToLocationUrl = TxtSendToLocationUrl.Text; } if (TasksIssuesEmailSettingsSection.Visible) { base.List.EnableAssignToEmail = RadEnableAssigntoEmailYes.Checked; } if (RadDefaultItemOpenPreferClient.Checked) { base.List.DefaultItemOpen = DefaultItemOpen.PreferClient; } else if (RadDefaultItemOpenBrowser.Checked) { base.List.DefaultItemOpen = DefaultItemOpen.Browser; } else if (RadDefaultItemOpenServerSetting.Checked) { base.List.DefaultItemOpen = DefaultItemOpen.PreferClient; base.List.DefaultItemOpenUseListSetting = false; } if (FolderCreationSection.Visible) { base.List.EnableFolderCreation = RadEnableFoldersYes.Checked; } if (AllowCrawlSection.Visible) { base.List.NoCrawl = !RadAllowCrawlYes.Checked; } if (SPUtility.IsCompatibilityLevel15Up && AllowNonDefaultCrawlViewSection.Visible) { base.List.CrawlNonDefaultViews = RadAllowNonDefaultCrawlViewYes.Checked; } //if (AllowSyncSection.Visible && !base.Web.SiteSubscriptionSettingsCache.ExcludeOfflineClient && RadAllowSyncYes.Enabled) //{ // base.List.ExcludeFromOfflineClient = !RadAllowSyncYes.Checked; //} if (AllowGridEditingSection.Visible) { base.List.DisableGridEditing = !RadAllowGridYes.Checked; } if (DocumentTemplateSection.Visible) { SPDocumentLibrary sPDocumentLibrary = (SPDocumentLibrary)base.List; sPDocumentLibrary.DocumentTemplateUrl = TxtListDocumentTemplate.Text; } if (PanelAttachments.Visible) { bool enableAttachments = base.List.EnableAttachments; base.List.EnableAttachments = RadAttachmentsEnabled.Checked; if (!enableAttachments && RadAttachmentsEnabled.Checked) { flag = ChkAttachmentsAddToDefaultView.Checked; } } if (PanelGlobalMettingsDataList.Visible) { base.List.MultipleDataList = !RadGlobalMtgDataListYes.Checked; } if (AttachmentLibrarySection.Visible) { base.List.IsSiteAssetsLibrary = RadAttachmentLibraryYes.Checked; } if (DialogForFormsPagesSection.Visible) { base.List.NavigateForFormsPages = RadDialogForFormsPagesNo.Checked; } if (SPUtility.IsCompatibilityLevel15Up && ManagedIndexesSection.Visible) { base.List.EnableManagedIndexes = RadManagedIndexesYes.Checked; } if (EventHandlerSection.Visible && base.Web.EventHandlersEnabled) { base.List.EventSinkAssembly = TxtEventHandlerAssemblyName.Text.Trim(); base.List.EventSinkClass = TxtEventHandlerClassName.Text.Trim(); base.List.EventSinkData = TxtEventHandlerProperties.Text.Trim(); } base.List.Update(); if (flag) { SPView defaultView = base.List.DefaultView; SPViewFieldCollection viewFields = defaultView.ViewFields; if (!viewFields.Exists("Attachments")) { viewFields.Add("Attachments"); defaultView.Update(); } } SPUtility.Redirect(base.List.DefaultViewUrl, SPRedirectFlags.UseSource | SPRedirectFlags.Trusted, HttpContext.Current); }
public string Write(Guid listGuid) { string csv = string.Empty; UseWeb(spWeb => { SPList list = spWeb.Lists.GetList(listGuid, true); SPView view = list.DefaultView; SPViewFieldCollection fields = view.ViewFields; SPField geomField = list.GetGeoField(); //create header for (int i = 0; i < view.ViewFields.Count; i++) { string field = view.ViewFields[i]; if (geomField.InternalName != field) { csv += view.ViewFields[i]; } else { csv += "Longitude, Latitude"; } if ((i + 1) < view.ViewFields.Count) { csv += ","; } else { csv += "\r\n"; } } //create CSV rows foreach (SPListItem listItem in list.Items) { for (int i = 0; i < view.ViewFields.Count; i++) { string field = view.ViewFields[i]; if (geomField.InternalName != field) { csv += listItem[view.ViewFields[i]].ToString(); } else { OpenSMIL.Server.SimpleFeature.GeomtryTypes.Point point = GetPoint(listItem[field] as string); csv += point.Lon + ","; csv += point.Lat; } if ((i + 1) < view.ViewFields.Count) { csv += ","; } else { csv += "\r\n"; } } } }); return(csv); }
protected override void Render(HtmlTextWriter writer) { base.Render(writer); System.Text.StringBuilder sb = new System.Text.StringBuilder(); string CAMLQuery = null; try { if (this._listId != null && this._viewName != null) { using (SPSite site = new SPSite(SPContext.Current.Site.Url)) { using (SPWeb web = site.OpenWeb(this.ListWebId)) { SPList selectedList = web.Lists[this._listId]; SPListItemCollection items = selectedList.Items; SPView defaultView = selectedList.Views[this._viewName]; uint itemsPerPage = defaultView.RowLimit; SPViewFieldCollection fields = defaultView.ViewFields; System.Collections.Specialized.StringCollection stringCol = fields.ToStringCollection(); if (Page.Request.QueryString != null && Page.Request.QueryString.Count > 0) { FilterEngine filterEngine = new FilterEngine(Page.Request.QueryString, selectedList); CAMLQuery = filterEngine.CAMLQuery; } // Nik20121105 - Write the table headers; sb.AppendLine("<table class=\"wet-boew-zebra\">"); sb.Append("<tr>"); foreach (string field in stringCol) { sb.Append("<th>" + selectedList.Fields.GetFieldByInternalName(field).Title + "</th>"); } sb.Append("</tr>"); if (CAMLQuery == null) { CAMLQuery = ""; } SPQuery query = new SPQuery(); query.Query = CAMLQuery; query.RowLimit = itemsPerPage; items = selectedList.GetItems(query); if (Page.Request.QueryString["p_ID"] != null) { string prev = ""; if (Page.Request.QueryString["PagedPrev"] == "TRUE") { prev = "&PagedPrev=TRUE"; } SPListItemCollectionPosition position = new SPListItemCollectionPosition("Paged=TRUE&p_ID=" + Page.Request.QueryString["p_ID"] + prev); query.ListItemCollectionPosition = position; } string lastId = ""; foreach (SPListItem item in items) { sb.AppendLine("<tr>"); bool firstCol = true; foreach (string field in stringCol) { if (firstCol) { firstCol = false; string itemUrl = string.Empty; SPField test = item.Fields.TryGetFieldByStaticName("BdcIdentity"); if (test != null) { itemUrl = HttpUtility.UrlEncode(this._listWeb + "/_layouts/listform.aspx?PageType=4&ListId={" + this._listId.ToString() + "}&ID=" + item["BdcIdentity"].ToString()); } else { itemUrl = HttpUtility.UrlEncode(this._listWeb + "/_layouts/listform.aspx?PageType=4&ListId={" + this._listId.ToString() + "}&ID=" + item.ID.ToString()); } string renderedField = string.Empty; if (item[field] != null) { renderedField = item[field].ToString(); } sb.AppendLine("<td><a href=\"" + this.ItemViewerUrl + "?ItemUrl=" + itemUrl + "\">" + renderedField.Replace("string;#", "").Replace("datetime;#", "").Replace("number;#", "") + "</a></td>"); } else { string renderedField = string.Empty; if (item[field] != null) { renderedField = FieldRenderer.RenderField(item[field].ToString(), item.Fields.GetFieldByInternalName(field)); } sb.AppendLine("<td>" + renderedField + "</td>"); } } sb.AppendLine("</tr>"); lastId = item.ID.ToString(); } sb.AppendLine("</table>"); string curUrl = Page.Request.Url.OriginalString; string forwardUrl = curUrl.Replace("p_ID=" + Page.Request.QueryString["p_ID"], "p_ID=" + lastId).Replace("&PagedPrev=TRUE", ""); string prevUrl = curUrl.Replace("p_ID=" + Page.Request.QueryString["p_ID"], "p_ID=" + items[0].ID.ToString()); if (forwardUrl.IndexOf("p_ID") < 0) { if (!forwardUrl.Contains("?")) { forwardUrl += "?p_ID=" + lastId; } else { forwardUrl += "&p_ID=" + lastId; } } if (prevUrl.IndexOf("p_ID") < 0) { if (!prevUrl.Contains("?")) { prevUrl += "?p_ID=" + items[0].ID.ToString(); } else { prevUrl += "&p_ID=" + items[0].ID.ToString(); } } if (!prevUrl.Contains("PagedPrev")) { prevUrl += "&PagedPrev=TRUE"; } if (CAMLQuery != null) { SPQuery newQuery = new SPQuery(); newQuery.Query = CAMLQuery; if (items[0].ID != selectedList.GetItems(newQuery)[0].ID) { sb.AppendLine("<a href=\"" + prevUrl + "\">< Previous</a> "); } } else if (items[0].ID != selectedList.Items[0].ID) { sb.AppendLine("<a href=\"" + prevUrl + "\">< Previous</a> "); } if ((int.Parse(lastId) + itemsPerPage) < selectedList.Items.Count) { sb.AppendLine("<a href=\"" + forwardUrl + "\">Next ></a>"); } writer.Write(sb.ToString()); } } } } catch (Exception ex) { LogEngine.Log(ex, "Accessible Lists"); } }
public void BindDropDownLists(string objSelectedList) { ArrayList objColumnCollection = new ArrayList(); ArrayList objLookupColumnCollection = new ArrayList(); try { using (SPSite objSPsite = new SPSite(SPContext.Current.Site.Url)) { using (SPWeb objWeb = objSPsite.OpenWeb()) { objSelectedList = ddlListName.SelectedItem.Value; SPList objList = objWeb.Lists[objSelectedList]; SPViewFieldCollection objSPViewFieldCollection = objList.DefaultView.ViewFields; string strTest = objList.Views.SchemaXml; SPFieldCollection objFieldCollection = objList.Fields; DataTable dt = objList.Items.GetDataTable(); foreach (SPField objField in objFieldCollection) { if (IsValidField(objField)) { if (objField.Type == SPFieldType.Lookup) { SPFieldLookup lookUpColumn = (SPFieldLookup)objField; if (!lookUpColumn.AllowMultipleValues) { objLookupColumnCollection.Add(objField); } } else { objColumnCollection.Add(objField); } } } } } ddlDisplayName.DataSource = objColumnCollection; ddlDisplayName.DataBind(); ddlParent.DataSource = objLookupColumnCollection; ddlParent.DataBind(); if (!string.IsNullOrEmpty(_ParentLookup)) { ddlParent.SelectedIndex = ddlParent.Items.IndexOf(((ListItem)ddlParent.Items.FindByText(_ParentLookup))); } if (!string.IsNullOrEmpty(_ValueColumn)) { ddlDisplayName.SelectedIndex = ddlDisplayName.Items.IndexOf(((ListItem)ddlDisplayName.Items.FindByText(_ValueColumn))); } } catch (Exception ex) { throw ex; } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { curWeb = SPContext.Current.Web; curWeb.Site.CatchAccessDeniedException = false; //HttpContext.Current.Session["ListGUID"] = Request["List"]; list = curWeb.Lists[new Guid(Request["List"])]; //HttpContext.Current.Session["ViewGUID"] = Request["View"]; view = list.Views[new Guid(Request["View"])]; string[] tLists = Request["Lists"].Split(';'); lists = new string[tLists.Length]; for (int i = 0; i < lists.Length; i++) { lists[i] = tLists[i].Split(',')[0]; } SPQuery query = new SPQuery(); query.Query = view.Query; query.ViewFields = view.ViewFields.SchemaXml; dtRollup = new DataTable(); SPViewFieldCollection vfc = view.ViewFields; foreach (string strField in vfc) { SPField f = getRealField(list.Fields.GetFieldByInternalName(strField)); dtRollup.Columns.Add(f.InternalName); arrFields.Add(f.InternalName); } XmlDocument xmlQuery = new XmlDocument(); xmlQuery.LoadXml("<Query>" + view.Query + "</Query>"); XmlNode ndGroupBy = xmlQuery.SelectSingleNode("//GroupBy"); if (ndGroupBy != null) { foreach (XmlNode nd in ndGroupBy.ChildNodes) { SPField f = getRealField(list.Fields.GetFieldByInternalName(nd.Attributes["Name"].Value)); if (!dtRollup.Columns.Contains(f.InternalName)) { dtRollup.Columns.Add(f.InternalName); arrFields.Add(f.InternalName); } } xmlQuery.ChildNodes[0].RemoveChild(ndGroupBy); } string squery = xmlQuery.ChildNodes[0].InnerXml; processSite(curWeb, squery); foreach (string strField in arrFields) { try { SPField f = getRealField(list.Fields.GetFieldByInternalName(strField)); dtRollup.Columns[f.InternalName].ColumnName = f.Title; } catch { } } //foreach (XmlNode nd in ndGroupBy.ChildNodes) //{ // SPField f = getRealField(list.Fields.GetFieldByInternalName(nd.InnerText)); // dtRollup.Columns.Add(f.InternalName); // arrFields.Add(nd.InnerText); //} listGrid.DataSource = dtRollup; listGrid.DataBind(); } }