public int UpdateList(Int32 op_id, string op_title)
{
SPDataSource ds = new SPDataSource();
ds.DataSourceMode = SPDataSourceMode.List;
ds.UseInternalName = true;
string queryString;
queryString = "<View></View>";
ds.UpdateCommand = queryString;
Parameter dbParam_ListId = new Parameter("ListID");
dbParam_ListId.DefaultValue = "DF806E7E-0073-4202-99E3-C4A269E2FA5D";
ds.UpdateParameters.Add(dbParam_ListId);
Dictionary <string, object> keys = new Dictionary <string, object>();
keys.Add("ID", op_id);
Dictionary <string, object> values = new Dictionary <string, object>();
values.Add("Title", op_title);
SPDataSourceView dsw = ds.GetView();
dsw.Update(keys, values, null, null);
return(1);
}
private void ModifyCAMLFilter(SPDataSource dataSource)
{
var xml = new XmlDocument();
xml.LoadXml(dataSource.SelectCommand);
if (xml.DocumentElement == null)
{
return;
}
var query = xml.DocumentElement.SelectSingleNode(CAML.Query);
if (query != null)
{
var where = query.SelectSingleNode(CAML.Where);
if (where == null)
{
where = xml.CreateNode(XmlNodeType.Element, CAML.Where, string.Empty);
query.AppendChild(where);
var w = CAMLGenerator.JoinFilters(CAMLPredicates, CAML.And);
where.InnerXml = w;
}
else
{
var whereParts = new List <string> {
where.InnerXml
};
whereParts.AddRange(CAMLPredicates);
where.InnerXml = CAMLGenerator.JoinFilters(whereParts, CAML.And);
}
}
dataSource.SelectCommand = xml.OuterXml;
Debug.WriteLine(xml.OuterXml);
}
protected SPDataSource entityds()
{
using (SPSite site = new SPSite(MyConfiguration.GetSiteURL(SPContext.Current)))
{
SPWeb hrWeb = site.AllWebs["HRMV02"];
SPDataSource entityds = new SPDataSource();
entityds.List = hrWeb.Lists["Entity"];
return(entityds);
}
}
protected SPDataSource entityds()
{
using (SPSite site = new SPSite(MyConfiguration.GetSiteURL(SPContext.Current)))
{
SPWeb hrWeb = site.AllWebs["HRMV02"];
SPDataSource entityds = new SPDataSource();
entityds.List = hrWeb.Lists["Entity"];
return entityds;
}
}
protected SPDataSource resdetailds(int resfilterid)
{
using (SPSite site = new SPSite(MyConfiguration.GetSiteURL(SPContext.Current)))
{
SPWeb hrWeb = site.AllWebs["HRMV02"];
SPDataSource resdetds = new SPDataSource();
resdetds.SelectCommand = @"<Query>
<Where>
<Eq>
<FieldRef Name='Department' LookupId='True' />
<Value Type='Lookup'>" + resfilterid + @"</Value>
</Eq>
</Where>
</Query>";
resdetds.List = hrWeb.Lists["Resource Details"];
return(resdetds);
}
}
protected SPDataSource deptds(int deptid)
{
using (SPSite site = new SPSite(MyConfiguration.GetSiteURL(SPContext.Current)))
{
SPWeb hrWeb = site.AllWebs["HRMV02"];
SPDataSource deptds = new SPDataSource();
deptds.SelectCommand = @"<Query>
<Where>
<Eq>
<FieldRef Name='Entity' LookupId='True'/>
<Value Type='Lookup'>" + deptid + @"</Value>
</Eq>
</Where>
</Query>";
deptds.List = hrWeb.Lists["Department"];
return(deptds);
}
}
protected SPDataSource deptds(int deptid)
{
using (SPSite site = new SPSite(MyConfiguration.GetSiteURL(SPContext.Current)))
{
SPWeb hrWeb = site.AllWebs["HRMV02"];
SPDataSource deptds = new SPDataSource();
deptds.SelectCommand = @"<Query>
<Where>
<Eq>
<FieldRef Name='Entity' LookupId='True'/>
<Value Type='Lookup'>" + deptid + @"</Value>
</Eq>
</Where>
</Query>";
deptds.List = hrWeb.Lists["Department"];
return deptds;
}
}
public List <ProductCatalogData> 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 <ProductCatalogData> dt = new List <ProductCatalogData>();
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}")];
ProductCatalogData r = new ProductCatalogData();
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);
}
protected override void BindDataSource()
{
var ds = new SPDataSource(List) {SelectCommand = BuildSelectCommand(false)};
ds.SelectParameters.Add("nextpagedata", Page.Request.QueryString.ToString());
ds.SelectParameters.Add("maximumrows", RowLimit.ToString());
ds.SelectParameters.Add("rootfolder", Page.Request.QueryString["RootFolder"]);
ds.SelectParameters.Add("prevpagedata", "");
var view = ds.GetView();
var args = new DataSourceSelectArguments();
try
{
view.Select(args, DataSourceViewSelectCallback);
NextPagePosition = ds.SelectParameters["nextpagedata"].DefaultValue;
PrevPagePosition = ds.SelectParameters["prevpagedata"].DefaultValue;
}
catch (SPQueryThrottledException)
{
ThresholdException = true;
ds = new SPDataSource(List) { SelectCommand = BuildSelectCommand(true) };
ds.SelectParameters.Add("nextpagedata", Page.Request.QueryString.ToString());
ds.SelectParameters.Add("maximumrows", RowLimit.ToString());
ds.SelectParameters.Add("rootfolder", Page.Request.QueryString["RootFolder"]);
ds.SelectParameters.Add("prevpagedata", "");
view = ds.GetView();
args = new DataSourceSelectArguments();
try
{
view.Select(args, DataSourceViewSelectCallback);
NextPagePosition = ds.SelectParameters["nextpagedata"].DefaultValue;
PrevPagePosition = ds.SelectParameters["prevpagedata"].DefaultValue;
}
catch (SPQueryThrottledException)
{
// Empty data source
DataSource = new DataTable();
}
}
if (RequiredAggregations)
{
BindAllDataSource();
}
}
protected SPDataSource resdetailds(int resfilterid)
{
using (SPSite site = new SPSite(MyConfiguration.GetSiteURL(SPContext.Current)))
{
SPWeb hrWeb = site.AllWebs["HRMV02"];
SPDataSource resdetds = new SPDataSource();
resdetds.SelectCommand = @"<Query>
<Where>
<Eq>
<FieldRef Name='Department' LookupId='True' />
<Value Type='Lookup'>" + resfilterid + @"</Value>
</Eq>
</Where>
</Query>";
resdetds.List = hrWeb.Lists["Resource Details"];
return resdetds;
}
}
