public ClubCloud_Setting_View GetSettingsByQuery(string bondsnummer, Guid verenigingId, System.Web.UI.DataSourceSelectArguments selectArgs = null, List <System.Web.UI.WebControls.Parameter> parameters = null, ClubCloud_Setting settings = null) { if (settings != null) { ValidateSettings(ref settings); } ClubCloud_Setting_View view = new ClubCloud_Setting_View(); using (new SPMonitoredScope("Settings GetSettingsByQuery")) { StringBuilder querybuilder = new StringBuilder("SELECT * FROM dbo.ClubCloud_Setting"); List <SqlParameter> sqlparams = new List <SqlParameter>(); List <SqlParameter> sqlparamscount = new List <SqlParameter>(); string and = " AND "; if (parameters != null && parameters.Count > 0) { querybuilder.Append(" WHERE "); foreach (System.Web.UI.WebControls.Parameter parameter in parameters) { object value = null; Type type = TypeConvertor.ToNetType(parameter.DbType); if (type == typeof(DateTime)) { IFormatProvider culture = new System.Globalization.CultureInfo("nl-NL", true); value = DateTime.Parse(parameter.DefaultValue, culture, System.Globalization.DateTimeStyles.AssumeLocal); querybuilder.Append(parameter.Name + " >= @" + parameter.Name + and); } else { value = TypeDescriptor.GetConverter(type).ConvertFrom(parameter.DefaultValue); querybuilder.Append(parameter.Name + " = @" + parameter.Name + and); } if (value != null) { sqlparams.Add(new SqlParameter { Value = value, ParameterName = "@" + parameter.Name, DbType = parameter.DbType, Direction = parameter.Direction }); sqlparamscount.Add(new SqlParameter { Value = value, ParameterName = "@" + parameter.Name, DbType = parameter.DbType, Direction = parameter.Direction }); } } if (querybuilder.Length > and.Length) { querybuilder.Remove(querybuilder.Length - and.Length, and.Length); } } if (!string.IsNullOrWhiteSpace(selectArgs.SortExpression)) { querybuilder.Append(" ORDER BY " + selectArgs.SortExpression); } view.ClubCloud_Setting = beheerModel.Database.SqlQuery <ClubCloud_Setting>(querybuilder.ToString(), sqlparams.ToArray()).Skip(selectArgs.StartRowIndex).Take(selectArgs.MaximumRows).ToList <ClubCloud_Setting>(); if (selectArgs.RetrieveTotalRowCount) { view.TotalRowCount = beheerModel.Database.SqlQuery <ClubCloud_Setting>(querybuilder.ToString(), sqlparamscount.ToArray()).Count(); } } return(view); }
protected internal override System.Collections.IEnumerable ExecuteSelect(System.Web.UI.DataSourceSelectArguments arguments) { return(default(System.Collections.IEnumerable)); }
public System.Collections.IEnumerable Select(System.Web.UI.DataSourceSelectArguments arguments) { return(default(System.Collections.IEnumerable)); }
public List <clsData> GetListsOld() { SPDataSource ds = new SPDataSource(); ds.DataSourceMode = SPDataSourceMode.List; ds.UseInternalName = true; ds.Scope = SPViewScope.Recursive; ds.IncludeHidden = true; string queryString; //queryString = "<View><ViewFields><FieldRef Name='ID'/><FieldRef Name='Title'/><FieldRef Name='PermMask'/></ViewFields><Query><Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>5</Value></Eq></Where></Query></View>"; //queryString = "<View><ViewFields><FieldRef Name='ID'/><FieldRef Name='Title'/><FieldRef Name='PermMask'/></View>"; queryString = "<View></View>"; ds.SelectCommand = queryString; Parameter dbParam_ListId = new Parameter("ListID"); dbParam_ListId.DefaultValue = "DF806E7E-0073-4202-99E3-C4A269E2FA5D"; ds.SelectParameters.Add(dbParam_ListId); SPDataSourceView dsw; List <clsData> dt = new List <clsData>(); dsw = ds.GetView(); SPList xlist = dsw.List; SPViewCollection colViews = xlist.Views; foreach (SPView vView in colViews) { } /* * SPListItem newFolder = xlist.Items.Add(xlist.RootFolder.ServerRelativeUrl, SPFileSystemObjectType.Folder, null); * if (newFolder != null) * { * newFolder["Title"] = "Min Nye Folder"; * newFolder.Update(); * } */ System.Web.UI.DataSourceSelectArguments args = new System.Web.UI.DataSourceSelectArguments(); SPDataSourceViewResultItem[] arrResult = (SPDataSourceViewResultItem[])dsw.Select(args); foreach (SPDataSourceViewResultItem Result in arrResult) { SPListItem oListItem = (SPListItem)Result.ResultItem; //SPField myField = xitem.Fields[new Guid("{FE7E79DD-DD68-438e-A960-E3686025D44B}")]; clsData r = new clsData(); foreach (SPField ofield in oListItem.Fields) { string tekst; try { tekst = ">" + ofield.Title + "< >" + ofield.InternalName + "<>" + oListItem[ofield.Id] + "<"; } catch { //OK } switch (ofield.InternalName) { case "ID": r.ID = (int)oListItem[ofield.Id]; break; case "Title": r.Title = (string)oListItem[ofield.Id]; break; } } dt.Add(r); } return(dt); }
// Constructors public SqlDataSourceSelectingEventArgs(System.Data.Common.DbCommand command, System.Web.UI.DataSourceSelectArguments arguments) { }
public ObjectDataSourceSelectingEventArgs(System.Collections.Specialized.IOrderedDictionary inputParameters, System.Web.UI.DataSourceSelectArguments arguments, bool executingSelectCount) : base(default(System.Collections.Specialized.IOrderedDictionary)) { }
public virtual void Select(System.Web.UI.DataSourceSelectArguments arguments, System.Web.UI.DataSourceViewSelectCallback callback) { }
public System.Collections.IEnumerable Select(System.Web.UI.DataSourceSelectArguments arguments) { }
protected override System.Collections.IEnumerable ExecuteSelect(System.Web.UI.DataSourceSelectArguments arguments) { return(SchemaInfo.FilterByCategory("Users")); }
protected override System.Collections.IEnumerable ExecuteSelect(System.Web.UI.DataSourceSelectArguments arguments) { return((new SchemaInfoCollection(ObjectSchemaSettings.GetConfig().Schemas)).FilterByNotRelation()); }