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(); } }