public static bool DoesWorkspaceExist(Guid siteId, Guid webId, Guid listId, int itemId)
{
bool exists = false;
SPSecurity.RunWithElevatedPrivileges(() =>
{
using (var eSite = new SPSite(siteId))
{
using (var con = new SqlConnection(
CoreFunctions.getReportingConnectionString(eSite.WebApplication.Id, eSite.ID)))
{
con.Open();
using (var cmd = new SqlCommand(WorkspaceQueries.GetDoesWorkSpaceExistQuery(siteId, webId, listId, itemId)))
using (var rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
bool.TryParse(rdr[0].ToString(), out exists);
}
}
}
}
});
return(exists);
}
public static void SendCompletedSignalsToDB(
Guid siteId,
SPWeb itemWeb,
SPWeb parentWeb,
Guid listId,
int itemId,
Guid createdWebId,
string createdWebServerRelativeUrl,
string createdWebTitle,
string creatorId,
string createdWebDescription)
{
Guard.ArgumentIsNotNull(itemWeb, nameof(itemWeb));
SPSecurity.RunWithElevatedPrivileges(() =>
{
using (var eSite = new SPSite(siteId))
{
var eRootWeb = eSite.RootWeb;
using (var con = new SqlConnection(
CoreFunctions.getReportingConnectionString(eSite.WebApplication.Id, eSite.ID)))
{
con.Open();
using (var cmd = new SqlCommand(WorkspaceQueries.GetSendCompletedSignalsQuery(
siteId,
itemWeb.ID,
parentWeb,
listId,
itemId,
createdWebId,
createdWebServerRelativeUrl,
createdWebTitle,
creatorId,
createdWebDescription,
eSite,
eRootWeb)))
{
cmd.Connection = con;
cmd.ExecuteNonQuery();
}
}
}
});
}
public static void AddToFRF(
Guid siteId,
Guid createdWebId,
string siteTitle,
string createdWebUrl,
int userId,
int type,
Guid listId,
int itemId)
{
// type legend
// 1 = favorites
// 2 = recent
// 3 = frequent apps
// 4 = workspace
SPSecurity.RunWithElevatedPrivileges(() =>
{
using (var spSite = new SPSite(siteId))
{
using (var con = new SqlConnection(CoreFunctions.getConnectionString(spSite.WebApplication.Id)))
{
con.Open();
using (var cmd = new SqlCommand
{
CommandText = WorkspaceQueries.GetAddToFRFQuery(
siteId,
createdWebId,
siteTitle,
createdWebUrl,
userId,
listId,
itemId),
Connection = con
})
{
cmd.ExecuteNonQuery();
}
}
}
});
}
public static bool IsFirstAttempt(SPSite site, SPWeb web, string listId, string itemId)
{
var iRecs = 0;
SPSecurity.RunWithElevatedPrivileges(() =>
{
Guard.ArgumentIsNotNull(site, nameof(site));
var siteId = site.ID;
using (var eSite = new SPSite(site.ID))
{
using (var con = new SqlConnection(CoreFunctions.getConnectionString(site.WebApplication.Id)))
{
con.Open();
using (var cmd = new SqlCommand(WorkspaceQueries.GetFirstAttemptQuery(siteId, web, listId, itemId)))
{
cmd.Connection = con;
iRecs = int.Parse(cmd.ExecuteScalar().ToString());
}
}
}
});
return(iRecs == 0);
}