/// <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"));
}
