public static void parse_guids(ref IDataReader reader, ref List <Guid> lstGuids,
ref long totalCount, ref string errorMessage)
{
while (reader.Read())
{
try { if (!string.IsNullOrEmpty(reader["ID"].ToString()))
{
lstGuids.Add((Guid)reader["ID"]);
}
}
catch { }
if (totalCount <= 0)
{
try { if (!string.IsNullOrEmpty(reader["TotalCount"].ToString()))
{
totalCount = long.Parse(reader["TotalCount"].ToString());
}
}
catch { }
}
}
if (reader.NextResult())
{
totalCount = ProviderUtil.succeed_long(reader, ref errorMessage);
}
else if (!reader.IsClosed)
{
reader.Close();
}
}
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 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 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 string GetVariable(Guid?applicationId, string name)
{
try
{
return(ProviderUtil.succeed_string(
ProviderUtil.execute_reader(GetFullyQualifiedName("GetVariable"), applicationId, name)));
}
catch (Exception ex) { string strEx = ex.ToString(); return(string.Empty); }
}
public static string GetSystemVersion()
{
try
{
return(ProviderUtil.succeed_string(
ProviderUtil.execute_reader(GetFullyQualifiedName("GetSystemVersion"))));
}
catch (Exception ex) { string strEx = ex.ToString(); return(string.Empty); }
}
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 string GetFileExtension(Guid applicationId, Guid fileId)
{
string spName = GetFullyQualifiedName("GetFileExtension");
try
{
return(ProviderUtil.succeed_string((IDataReader)ProviderUtil.execute_reader(spName, applicationId, fileId)));
}
catch (Exception ex) { return(string.Empty); }
}
public static void GetEmailQueueItems(Guid applicationId, ref List <EmailQueueItem> retItems, int?count)
{
try
{
IDataReader reader = ProviderUtil.execute_reader(
GetFullyQualifiedName("GetEmailQueueItems"), applicationId, count);
_parse_email_queue_items(ref reader, ref retItems);
}
catch (Exception ex) { string strEx = ex.ToString(); }
}
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 void GetFanIDs(Guid applicationId, ref List <Guid> retList, Guid likedId)
{
string spName = GetFullyQualifiedName("GetFanIDs");
try
{
IDataReader reader = (IDataReader)ProviderUtil.execute_reader(spName, applicationId, likedId);
ProviderUtil.parse_guids(ref reader, ref retList);
}
catch (Exception ex) { }
}
public static void GetLastContentCreators(Guid applicationId, ref ArrayList retList, int?count)
{
string spName = GetFullyQualifiedName("GetLastContentCreators");
try
{
IDataReader reader = (IDataReader)ProviderUtil.execute_reader(spName, applicationId, count);
_parse_last_active_users(ref reader, ref retList);
}
catch (Exception ex) { }
}
public static List <Application> GetApplications(int?count, int?lowerBoundary, ref int totalCount)
{
try
{
List <Application> ret = new List <Application>();
IDataReader reader = ProviderUtil.execute_reader(GetFullyQualifiedName("GetApplications"), count, lowerBoundary);
_parse_applications(ref reader, ref ret, ref totalCount);
return(ret);
}
catch (Exception ex) { return(new List <Application>()); }
}
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 void RaaiVanStatistics(Guid applicationId, ref Dictionary <string, object> dic, DateTime?dateFrom, DateTime?dateTo)
{
string spName = GetFullyQualifiedName("RaaiVanStatistics");
try
{
IDataReader reader = (IDataReader)ProviderUtil.execute_reader(spName, applicationId, dateFrom, dateTo);
_parse_raaivan_statistics(ref reader, ref dic);
}
catch (Exception ex) { }
}
public static List <Application> GetUserApplications(Guid userId, bool isCreator, bool?archive)
{
try
{
List <Application> ret = new List <Application>();
IDataReader reader = ProviderUtil.execute_reader(GetFullyQualifiedName("GetUserApplications"), userId, isCreator, archive);
int totalCount = 0;
_parse_applications(ref reader, ref ret, ref totalCount);
return(ret);
}
catch (Exception ex) { return(new List <Application>()); }
}
public static List <DeletedState> GetDeletedStates(Guid applicationId, int?count, long?lowerBoundary)
{
string spName = GetFullyQualifiedName("GetDeletedStates");
try
{
IDataReader reader = ProviderUtil.execute_reader(spName, applicationId, count, lowerBoundary);
List <DeletedState> retItems = new List <DeletedState>();
_parse_deleted_states(ref reader, ref retItems);
return(retItems);
}
catch (Exception ex) { return(new List <DeletedState>()); }
}
public static List <SchemaInfo> GetSchemaInfo()
{
string spName = GetFullyQualifiedName("SchemaInfo");
try
{
IDataReader reader = (IDataReader)ProviderUtil.execute_reader(spName);
List <SchemaInfo> items = new List <SchemaInfo>();
_parse_schema_info(ref reader, ref items);
return(items);
}
catch (Exception ex) { return(new List <SchemaInfo>()); }
}
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 List <Application> GetApplications(List <Guid> applicationIds)
{
try
{
if (applicationIds == null || applicationIds.Count == 0)
{
return(new List <Application>());
}
int totalCount = 0;
List <Application> ret = new List <Application>();
IDataReader reader = ProviderUtil.execute_reader(GetFullyQualifiedName("GetApplicationsByIDs"),
string.Join(",", applicationIds.Select(id => id.ToString())), ',');
_parse_applications(ref reader, ref ret, ref totalCount);
return(ret);
}
catch (Exception ex) { return(new List <Application>()); }
}
public static long?SetOwnerVariable(Guid applicationId, long?id, Guid?ownerId,
string name, string value, Guid currentUserId)
{
try
{
long result = ProviderUtil.succeed_long(ProviderUtil.execute_reader(GetFullyQualifiedName("SetOwnerVariable"),
applicationId, id, ownerId, name, value, currentUserId, DateTime.Now));
if (result <= 0)
{
return(null);
}
else
{
return(result);
}
}
catch (Exception ex) { string strEx = ex.ToString(); return(null); }
}
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 void GetOwnerVariables(ref List <Variable> ret, Guid applicationId,
long?id, Guid?ownerId, string name, Guid?creatorUserId)
{
try
{
if (ownerId == Guid.Empty)
{
ownerId = null;
}
if (creatorUserId == Guid.Empty)
{
creatorUserId = null;
}
IDataReader reader = ProviderUtil.execute_reader(GetFullyQualifiedName("GetOwnerVariables"), applicationId,
id, ownerId, name, creatorUserId);
_parse_variables(ref reader, ref ret);
}
catch (Exception ex) { }
}
public static Dictionary <RVSettingsItem, string> GetSystemSettings(Guid applicationId, List <RVSettingsItem> names)
{
names = names.Where(n => n != RVSettingsItem.UseLocalVariables).ToList();
if (applicationId == Guid.Empty && names.Count == 0)
{
return(new Dictionary <RVSettingsItem, string>());
}
string spName = GetFullyQualifiedName("GetSystemSettings");
try
{
IDataReader reader = (IDataReader)ProviderUtil.execute_reader(spName, applicationId,
ProviderUtil.list_to_string <RVSettingsItem>(names), ',');
Dictionary <RVSettingsItem, string> items = new Dictionary <RVSettingsItem, string>();
_parse_setting_items(ref reader, ref items);
return(items);
}
catch (Exception ex) { return(new Dictionary <RVSettingsItem, string>()); }
}
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(); }
}
