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());
}
