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 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 GetSystemVersion()
{
try
{
return(ProviderUtil.succeed_string(
ProviderUtil.execute_reader(GetFullyQualifiedName("GetSystemVersion"))));
}
catch (Exception ex) { string strEx = ex.ToString(); return(string.Empty); }
}
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 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 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 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 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 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 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 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 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 <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 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 <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 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>()); }
}
