To fetch the User name in Console application is as follows
using Microsoft.SharePoint;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
SPSite rootSite = new SPSite("http://jaganinfo-pc:1234/");
SPWeb rootWeb= rootSite.RootWeb;
SPUserCollection userList = rootWeb.AllUsers;
foreach (SPUser objUser in userList)
{
Console.WriteLine(objUser.Name);
}
Console.Read();
}
}
}
********************************************************************
Q) Write a Query SharePoint List by using LINQ
// Get DataContext from page context
DataContext data = new DataContext(SPContext.GetContext(this.Context).Web.Url);
// Get the SharePoint list
EntityList Customers = data.GetList("Customers");
// Query for customers from India
var indiaCustomers = from customer in Customers
where customer.City == "India"
select customer;
foreach (var indiaCust in indiaCustomers)
{
Console.Writeline("id = {0}, City = {1}", indiaCust.CustomerId, londonCust.City);
}
********************************************************************
Q) Write a program to Get All Alerts in the Site Collection
public void GetAlerts(Button btn)
{
SPSite rootSite = SPContext.Current.Site;
SPWeb rootWeb = rootSite.OpenWeb();
//Using RunWithElevatedPrivileges
SPSecurity.RunWithElevatedPrivileges(delegate()
{
// Get references to the site collection and site for the current context.
// The using statement makes sures these references are disposed properly.
SPList alertList = rootWeb.Lists[LIBName.Trim()];
DeleteAllExistingItems(alertList, btn); // Delete existing items
using (SPSite siteCollection = new SPSite(rootSite.ID))
{
foreach (SPWeb curretWeb in siteCollection.AllWebs)
//Get alerts for each web
{
using (SPWeb web = siteCollection.OpenWeb(curretWeb.ID))
{
web.AllowUnsafeUpdates = true;
try
{
SPAlertCollection allAlerts = web.Alerts;
foreach (SPAlert AlertItem in allAlerts)
{
AddAlertToTable(alertList, AlertItem);
}
}
catch (Exception ex)
{
Console.WriteLine("Delete failed: " + ex.Message);
throw;
}
web.AllowUnsafeUpdates = false;
}
}
}
});
}
********************************************************************
Q) Programmatically Upload Documents in a Document Library
public void DocumnetsUpload(SPWeb site)
{
if (FileUploadControl.HasFile)
{
SPFolder folder = site.GetFolder("Document_Library_Name");
SPFileCollection files = folder.Files;
//path of the file to upload
Stream fStream = FileUpload1.PostedFile.InputStream;
byte[] contents = new byte[fStream.Length];
fstream.position = 0;
fStream.Read(contents, 0, (int)fStream.Length);
fStream.Close();
string Filename = FileUpload1.FileName;
string URL = SPContext.Current.Site.Url + "/Document_Library_Name/" + Filename;
SPFile currentFile = files.Add(URL, contents);
}
}
********************************************************************
Q) Write a program to Delete all Items in a list
Note: Deleting all items in list will send all the items to recycle bin. To avoid fill-up recycle bin, we can just turn the recycle bin off while deleting the items.
public void DeleteAllItems(SPList CurrentList)
{
bool IsRecycleBinEnabled = SPContext.Current.Web.Site.WebApplication.RecycleBinEnabled;
if (IsRecycleBinEnabled)
{
//set the use off the recyclebin to false SPContext.Current.Web.site.Webapplication.RecycleBinEnabled = fasle;
}
StringBuilder sbDelete = new StringBuilder();
sbDelete.Append("");
foreach (SPListItem item in CurrentList.Items)
{
sbDelete.Append("
sbDelete.Append("
sbDelete.Append("
sbDelete.Append("
sbDelete.Append("
}
sbDelete.Append("");
try
{
SPContext.Current.Site.RootWeb.ProcessBatchData(sbDelete.ToString());
}
catch (Exception ex)
{
Console.WriteLine("Delete failed: " + ex.Message);
throw;
}
if (!IsRecycleBinEnabled)
{
//set the use off the recyclebin to false
//SPContext.Current.Web.site.Webapplication.RecycleBinEnabled = true;
}
********************************************************************
Q) SharePoint search using FullTextSqlQuery
//Here SharedServices2 refers to the Shared Service Provider servicing the site in Question
ServerContext context = ServerContext.GetContext("SharedServices2");
FullTextSqlQuery qrySearch = new FullTextSqlQuery(context);
//Specifies the results set containing the main search results from
//the content index matching the search query.
qrySearch.ResultTypes = ResultType.RelevantResults;
//Sremming : expansion of searches to include plural forms and
//other word variations :-)
qrySearch.EnableStemming = true;
qrySearch.TrimDuplicates = false;
qrySearch.QueryText = "SELECT URL, Title, Size, Write, HitHighlightedSummary FROM SCOPE() where \"scope\"='NTFS Archive' And FREETEXT(*,'" + TextBox1.Text.Trim() +
"')";
ResultTableCollection results = qrySearch.Execute();
ResultTable resultTable = results[ResultType.RelevantResults];
// Data Table to Store Search Results
DataTable dtResults = new DataTable();
dtResults.Load(resultTable, LoadOption.OverwriteChanges);
********************************************************************
