/// <summary> /// DisplayName, Count /// </summary> /// <returns></returns> public static IDataReader GetMostActiveGroupsByToDoReport(DateTime FromDate, DateTime ToDate) { return(DbHelper2.RunSpDataReader("ReportMostActiveGroupsByToDo", DbHelper2.mp("@FromDate", SqlDbType.DateTime, FromDate), DbHelper2.mp("@ToDate", SqlDbType.DateTime, ToDate))); }
public static int CheckChildren(int GroupId) { return(DbHelper2.RunSpInteger("GroupCheckChildren", DbHelper2.mp("@GroupId", SqlDbType.Int, GroupId))); }
/// <summary> /// Reader returns fields: /// GroupId, GroupName, Level /// </summary> public static IDataReader GetListGroupsAsTreeForIBN() { return(DbHelper2.RunSpDataReader("GroupsGetAsTree2")); }
/// <summary> /// Reader returns fields: /// GroupId, GroupName, HasChildren /// </summary> public static IDataReader GetListChildGroups(int GroupId) { return(DbHelper2.RunSpDataReader("GroupsGetByParent", DbHelper2.mp("@GroupId", SqlDbType.Int, GroupId))); }
/// <summary> /// Reader returns fields: /// GroupId, GroupName /// </summary> public static IDataReader GetListAvailableGroups() { return(DbHelper2.RunSpDataReader("GroupsGetAvailable")); }
public BasePlanSlotRow(int BasePlanSlotId) { using (IDataReader reader = DbHelper2.RunSpDataReader("mc_BasePlanSlotSelect", DbHelper2.mp("@BasePlanSlotId", SqlDbType.Int, BasePlanSlotId))) { if (reader.Read()) { Load(reader); } else { throw new Exception(String.Format("Record with {0}.{1}={2} not found", "BasePlanSlot", "BasePlanSlotId", BasePlanSlotId)); } } }
/// <summary> /// Reader returns fields: /// UserId, Login, FirstName, LastName, Email, IMGroupId, CreatedBy, Activity, IsExternal /// </summary> public static IDataReader GetListAllUsersIn2Group(int Group1Id, int Group2Id) { return(DbHelper2.RunSpDataReader("UsersGetBy2GroupAll", DbHelper2.mp("@Group1Id", SqlDbType.Int, Group1Id), DbHelper2.mp("@Group2Id", SqlDbType.Int, Group2Id))); }
public static void ReplaceUnchangeableUser(int FromUserId, int ToUserId) { DbHelper2.RunSp("ReportsReplaceUnchangeableUser", DbHelper2.mp("@FromUserId", SqlDbType.Int, FromUserId), DbHelper2.mp("@ToUserId", SqlDbType.Int, ToUserId)); }
public static IDataReader GetQDictionary(string query) { return(DbHelper2.RunTextDataReader(query)); }
public static IDataReader GetUsersByCompany() { return(DbHelper2.RunSpDataReader("ASP_GET_USERS_BY_COMPANY")); }
public static int CheckForUnchangeableRoles(int UserId) { return(DbHelper2.RunSpInteger("ReportsCheckForUnchangeableRoles", DbHelper2.mp("@UserId", SqlDbType.Int, UserId))); }
public static IDataReader GetReportBinaryData(int ReportItemId) { return(DbHelper2.RunSpDataReaderBlob("ReportGetBinaryData", DbHelper2.mp("@ReportItemId", SqlDbType.Int, ReportItemId))); }
/// <summary> /// Reader contains fields: /// UserId, FirstName, LastName, FullName, FullName2 /// </summary> /// <returns></returns> public static IDataReader GetListReportsModifiers() { return(DbHelper2.RunSpDataReader("ReportGetModifiers")); }
/// <summary> /// Reader contains fields: /// UserId, FirstName, LastName, FullName, FullName2 /// </summary> /// <returns></returns> public static IDataReader GetListReportsCreators() { return(DbHelper2.RunSpDataReader("ReportGetAuthors")); }
/// <summary> /// Initializes a new instance of the <see cref="PendingEMailMessageRow"/> class. /// </summary> /// <param name="PendingEMailMessageId">The pending E mail message id.</param> public PendingEMailMessageRow(int PendingEMailMessageId) { using (IDataReader reader = DbHelper2.RunSpDataReader("mc_PendingEMailMessageSelect", DbHelper2.mp("@PendingEMailMessageId", SqlDbType.Int, PendingEMailMessageId))) { if (reader.Read()) { Load(reader); } else { throw new Exception(String.Format("Record with {0}.{1}={2} not found", "PendingEMailMessage", "PendingEMailMessageId", PendingEMailMessageId)); } } }
/// <summary> /// </summary> /// <returns></returns> public static void DeleteReportTemplate(int TemplateId) { DbHelper2.RunSp("ReportTemplateDelete", DbHelper2.mp("@TemplateId", SqlDbType.Int, TemplateId)); }
public static void Delete(int BasePlanSlotId) { DbHelper2.RunSp("mc_BasePlanSlotDelete", DbHelper2.mp("@BasePlanSlotId", SqlDbType.Int, BasePlanSlotId)); }
/// <summary> /// </summary> /// <returns></returns> public static void DeleteReportItem(int ReportItemId) { DbHelper2.RunSp("ReportHistoryDelete", DbHelper2.mp("@ReportItemId", SqlDbType.Int, ReportItemId)); }
/// <summary> /// Reader returns fields: /// UserId, Login, FirstName, LastName, Email, IMGroupId, CreatedBy /// </summary> public static DataTable GetListActiveUsersInGroupDataTable(int GroupId) { return(DbHelper2.RunSpDataTable("UsersGetActiveByGroup", DbHelper2.mp("@GroupId", SqlDbType.Int, GroupId))); }
/// <summary> /// </summary> /// <returns></returns> public static void DeleteTemporaryTemplates() { DbHelper2.RunSp("ReportTemplateDeleteTemporary"); }
/// <summary> /// Reader returns fields: /// UserId, Login, FirstName, LastName, Email, IMGroupId, CreatedBy, Activity, IsExternal /// </summary> public static IDataReader GetListAllActiveUsersInGroup(int GroupId) { return(DbHelper2.RunSpDataReader("UsersGetActiveByGroupAll", DbHelper2.mp("@GroupId", SqlDbType.Int, GroupId))); }
public static int GetOnlineUsersCount() { return(DbHelper2.RunSpInteger("ASP_REP_GET_ONLINE_USERS_COUNT")); }
/// <summary> /// Reader returns fields: /// GroupId, GroupName, IMGroupId, ContactUid, OrgUid /// </summary> public static IDataReader GetListGroups() { return(DbHelper2.RunSpDataReader("GroupGet", DbHelper2.mp("@PrincipalId", SqlDbType.Int, 0))); }
public static int GetGroupsCount() { return(DbHelper2.RunSpInteger("ASP_REP_GET_TOTAL_GROUPS")); }
/// <summary> /// Reader returns fields: /// GroupId, GroupName /// </summary> public static IDataReader GetListGroupsForMove(int GroupId) { return(DbHelper2.RunSpDataReader("GroupsGetForMove", DbHelper2.mp("@GroupId", SqlDbType.Int, GroupId))); }
public static int GetUsersCount() { return(DbHelper2.RunSpInteger("ASP_REP_GET_TOTAL_USERS")); }
public static void Delete(int GroupId) { DbHelper2.RunSp("GroupDelete", DbHelper2.mp("@GroupId", SqlDbType.Int, GroupId)); }
/// <summary> /// Deletes the by E mail message id. /// </summary> /// <param name="EMailMessageId">The E mail message id.</param> public static void DeleteByEMailMessageId(int EMailMessageId) { DbHelper2.RunSp("mc_PendingEMailMessageDeleteByEMailMessageId", DbHelper2.mp("@EMailMessageId", SqlDbType.Int, EMailMessageId)); }
public static void DeletePartnerGroup(int PartnerId, int GroupId) { DbHelper2.RunSp("PartnerGroupDelete", DbHelper2.mp("@PartnerId", SqlDbType.Int, PartnerId), DbHelper2.mp("@GroupId", SqlDbType.Int, GroupId)); }
/// <summary> /// IMLogins, MessSent, MessReceived, IMGroups /// </summary> /// <returns></returns> public static IDataReader GetUsageStats() { return(DbHelper2.RunSpDataReader("ASP_REP_GET_USAGE_STATS")); }