public static bool RecycleApplication(Guid applicationId)
{
try
{
return(ProviderUtil.succeed(ProviderUtil.execute_reader(GetFullyQualifiedName("RecycleApplication"), applicationId)));
}
catch (Exception ex) { string strEx = ex.ToString(); return(false); }
}
public static bool RemoveOwnerVariable(Guid applicationId, long id, Guid currentUserId)
{
try
{
return(ProviderUtil.succeed(ProviderUtil.execute_reader(GetFullyQualifiedName("RemoveOwnerVariable"),
applicationId, id, currentUserId, DateTime.Now)));
}
catch (Exception ex) { string strEx = ex.ToString(); return(false); }
}
public static bool SetVariable(Guid?applicationId, string name, string value, Guid currentUserId)
{
try
{
return(ProviderUtil.succeed(ProviderUtil.execute_reader(GetFullyQualifiedName("SetVariable"), applicationId,
name, value, currentUserId, DateTime.Now)));
}
catch (Exception ex) { string strEx = ex.ToString(); return(false); }
}
public static bool AddOrModifyApplication(Guid applicationId, string name, string title, string description, Guid?currentUserId)
{
try
{
return(ProviderUtil.succeed(ProviderUtil.execute_reader(GetFullyQualifiedName("AddOrModifyApplication"),
applicationId, name, title, description, currentUserId)));
}
catch (Exception ex) { string strEx = ex.ToString(); return(false); }
}
public static bool IsSystemAdmin(Guid?applicationId, Guid userId)
{
string spName = GetFullyQualifiedName("IsSystemAdmin");
try
{
return(ProviderUtil.succeed((IDataReader)ProviderUtil.execute_reader(spName, applicationId, userId)));
}
catch (Exception ex) { return(false); }
}
public static bool FollowUnFollow(Guid applicationId, Guid userId, Guid followedId, bool?follow)
{
string spName = GetFullyQualifiedName("FollowUnfollow");
try
{
return(ProviderUtil.succeed((IDataReader)ProviderUtil.execute_reader(spName, applicationId,
userId, followedId, follow, DateTime.Now)));
}
catch (Exception ex) { return(false); }
}
public static bool LikeDislikeUnlike(Guid applicationId, Guid userId, Guid likedId, bool?like)
{
string spName = GetFullyQualifiedName("LikeDislikeUnlike");
try
{
return(ProviderUtil.succeed((IDataReader)ProviderUtil.execute_reader(spName, applicationId,
userId, likedId, like, DateTime.Now)));
}
catch (Exception ex) { return(false); }
}
public static bool SaveTaggedItems(Guid applicationId, ref List <TaggedItem> items,
bool?removeOldTags, Guid currentUserId)
{
if (items == null || items.Count == 0 || currentUserId == Guid.Empty)
{
return(false);
}
SqlConnection con = new SqlConnection(ProviderUtil.ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
//Add Items
DataTable taggedTable = new DataTable();
taggedTable.Columns.Add("ContextID", typeof(Guid));
taggedTable.Columns.Add("TaggedID", typeof(Guid));
taggedTable.Columns.Add("ContextType", typeof(string));
taggedTable.Columns.Add("TaggedType", typeof(string));
foreach (TaggedItem itm in items)
{
taggedTable.Rows.Add(itm.ContextID, itm.TaggedID, itm.ContextType, itm.TaggedType);
}
SqlParameter taggedParam = new SqlParameter("@TaggedItems", SqlDbType.Structured);
taggedParam.TypeName = "[dbo].[TaggedItemTableType]";
taggedParam.Value = taggedTable;
//end of Add Items
cmd.Parameters.AddWithValue("@ApplicationID", applicationId);
cmd.Parameters.Add(taggedParam);
cmd.Parameters.AddWithValue("@RemoveOldTags", removeOldTags.HasValue && removeOldTags.Value);
cmd.Parameters.AddWithValue("@CurrentUserID", currentUserId);
string sep = ", ";
string arguments = "@ApplicationID" + sep + "@TaggedItems" + sep + "@RemoveOldTags" + sep + "@CurrentUserID";
cmd.CommandText = ("EXEC" + " " + GetFullyQualifiedName("SaveTaggedItems") + " " + arguments);
con.Open();
try { return(ProviderUtil.succeed((IDataReader)cmd.ExecuteReader())); }
catch (Exception ex) { string strEx = ex.ToString(); return(false); }
finally { con.Close(); }
}
public static bool AddEmailsToQueue(Guid applicationId, ref List <EmailQueueItem> items)
{
SqlConnection con = new SqlConnection(ProviderUtil.ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
//Add Items
DataTable queueTable = new DataTable();
queueTable.Columns.Add("ID", typeof(long));
queueTable.Columns.Add("SenderUserID", typeof(Guid));
queueTable.Columns.Add("Action", typeof(string));
queueTable.Columns.Add("Email", typeof(string));
queueTable.Columns.Add("Title", typeof(string));
queueTable.Columns.Add("EmailBody", typeof(string));
foreach (EmailQueueItem itm in items)
{
queueTable.Rows.Add(itm.ID, itm.SenderUserID, itm.Action, itm.Email, itm.Title, itm.EmailBody);
}
SqlParameter queueParam = new SqlParameter("@EmailQueueItems", SqlDbType.Structured);
queueParam.TypeName = "[dbo].[EmailQueueItemTableType]";
queueParam.Value = queueTable;
//end of Add Items
cmd.Parameters.AddWithValue("@ApplicationID", applicationId);
cmd.Parameters.Add(queueParam);
string sep = ", ";
string arguments = "@ApplicationID" + sep + "@EmailQueueItems";
cmd.CommandText = ("EXEC" + " " + GetFullyQualifiedName("AddEmailsToQueue") + " " + arguments);
con.Open();
try { return(ProviderUtil.succeed((IDataReader)cmd.ExecuteReader())); }
catch (Exception ex) { string strEx = ex.ToString(); return(false); }
finally { con.Close(); }
}
public static bool SetSystemSettings(Guid applicationId, Dictionary <RVSettingsItem, string> items, Guid currentUserId)
{
SqlConnection con = new SqlConnection(ProviderUtil.ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
//Add Items
DataTable appsTable = new DataTable();
appsTable.Columns.Add("FirstValue", typeof(string));
appsTable.Columns.Add("SecondValue", typeof(string));
foreach (RVSettingsItem name in items.Keys)
{
appsTable.Rows.Add(name.ToString(), items[name]);
}
SqlParameter appParam = new SqlParameter("@Items", SqlDbType.Structured);
appParam.TypeName = "[dbo].[StringPairTableType]";
appParam.Value = appsTable;
//end of Add Items
cmd.Parameters.AddWithValue("@ApplicationID", applicationId);
cmd.Parameters.Add(appParam);
cmd.Parameters.AddWithValue("@CurrentUserID", currentUserId);
cmd.Parameters.AddWithValue("@Now", DateTime.Now);
string sep = ", ";
string arguments = "@ApplicationID" + sep + "@Items" + sep + "@CurrentUserID" + sep + "@Now";
cmd.CommandText = ("EXEC" + " " + GetFullyQualifiedName("SetSystemSettings") + " " + arguments);
con.Open();
try { return(ProviderUtil.succeed((IDataReader)cmd.ExecuteReader())); }
catch (Exception ex) { string strEx = ex.ToString(); return(false); }
finally { con.Close(); }
}
public static bool ArchiveEmailQueueItems(Guid applicationId, ref List <long> itemIds)
{
SqlConnection con = new SqlConnection(ProviderUtil.ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
//Add IDs
DataTable idsTable = new DataTable();
idsTable.Columns.Add("Value", typeof(long));
foreach (long id in itemIds)
{
idsTable.Rows.Add(id);
}
SqlParameter idsParam = new SqlParameter("@ItemIDs", SqlDbType.Structured);
idsParam.TypeName = "[dbo].[BigIntTableType]";
idsParam.Value = idsTable;
//end of Add IDs
cmd.Parameters.AddWithValue("@ApplicationID", applicationId);
cmd.Parameters.Add(idsParam);
cmd.Parameters.AddWithValue("@Now", DateTime.Now);
string sep = ", ";
string arguments = "@ApplicationID" + sep + "@ItemIDs" + sep + "@Now";
cmd.CommandText = ("EXEC" + " " + GetFullyQualifiedName("ArchiveEmailQueueItems") + " " + arguments);
con.Open();
try { return(ProviderUtil.succeed((IDataReader)cmd.ExecuteReader())); }
catch (Exception ex) { string strEx = ex.ToString(); return(false); }
finally { con.Close(); }
}
public static bool SetApplications(List <KeyValuePair <Guid, string> > applications)
{
SqlConnection con = new SqlConnection(ProviderUtil.ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
//Add Items
DataTable appsTable = new DataTable();
appsTable.Columns.Add("FirstValue", typeof(Guid));
appsTable.Columns.Add("SecondValue", typeof(string));
foreach (KeyValuePair <Guid, string> app in applications)
{
appsTable.Rows.Add(app.Key, app.Value);
}
SqlParameter appParam = new SqlParameter("@Applications", SqlDbType.Structured);
appParam.TypeName = "[dbo].[GuidStringTableType]";
appParam.Value = appsTable;
//end of Add Items
cmd.Parameters.Add(appParam);
string arguments = "@Applications";
cmd.CommandText = ("EXEC" + " " + GetFullyQualifiedName("SetApplications") + " " + arguments);
con.Open();
try { return(ProviderUtil.succeed((IDataReader)cmd.ExecuteReader())); }
catch (Exception ex) { string strEx = ex.ToString(); return(false); }
finally { con.Close(); }
}
