public static IDataReader GetQuickSnapshotReport(DateTime StartDate, DateTime EndDate, int CreatorId) { return(DbHelper2.RunSpDataReader("ReportQuickSnapshot", DbHelper2.mp("@StartDate", SqlDbType.DateTime, StartDate), DbHelper2.mp("@EndDate", SqlDbType.DateTime, EndDate), DbHelper2.mp("@CreatorId", SqlDbType.Int, CreatorId))); }
public static IDataReader SearchHistory( DateTime fromDate, DateTime toDate, int userID, int contUserID, int msgType, string keyword, bool displayLastEventsFirst, int DefaultBias) { //if userId=contUserId=0 -> all with all int origUserId = 0; int origContUserId = 0; if (userID != 0) { origUserId = DbHelper2.RunSpInteger("UserGetOriginalId", DbHelper2.mp("@UserId", SqlDbType.Int, userID)); } if (contUserID != 0) { origContUserId = DbHelper2.RunSpInteger("UserGetOriginalId", DbHelper2.mp("@UserId", SqlDbType.Int, contUserID)); } return(DbHelper2.RunSpDataReader("ASP_SEARCH_HISTORY", DbHelper2.mp("@User_id", SqlDbType.Int, origUserId), DbHelper2.mp("@Cont_user_id", SqlDbType.Int, origContUserId), DbHelper2.mp("@DT_Begin", SqlDbType.DateTime, fromDate), DbHelper2.mp("@DT_End", SqlDbType.DateTime, toDate), DbHelper2.mp("@Mess_Type", SqlDbType.Int, msgType), DbHelper2.mp("@Keyword", SqlDbType.NVarChar, 50, keyword), DbHelper2.mp("@Order", SqlDbType.Int, displayLastEventsFirst ? 1 : 0), DbHelper2.mp("@TimeOffset", SqlDbType.Int, DefaultBias * 60))); }
/// <summary> /// Reader returns fields: /// PartnerId, GroupId, GroupName, Level (=1) /// </summary> public static IDataReader GetListGroupsByPartner(int PartnerId, bool IncludeCurrent, bool IncludeEveryone) { return(DbHelper2.RunSpDataReader("PartnerGroupGetListByPartner", DbHelper2.mp("@PartnerId", SqlDbType.Int, PartnerId), DbHelper2.mp("@IncludeCurrent", SqlDbType.Bit, IncludeCurrent), DbHelper2.mp("@IncludeEveryone", SqlDbType.Bit, IncludeEveryone))); }
public static IDataReader GetTop10Users(DateTime StartDate, DateTime EndDate, int DefaultBias) { return(DbHelper2.RunSpDataReader("ASP_REP_GET_TOP10_WRITERS", DbHelper2.mp("@startdate", SqlDbType.DateTime, StartDate), DbHelper2.mp("@enddate", SqlDbType.DateTime, EndDate), DbHelper2.mp("@TimeOffset", SqlDbType.Int, DefaultBias * 60))); }
public static IDataReader Message_GetByUserIdAndTimeFilter(int userId, DateTime startDate, DateTime endDate, int timeZoneId) { return(DbHelper2.RunSpDataReader(timeZoneId, new string[] { "Sent" }, "Message_GetByUserIdAndTimeFilter", DbHelper2.mp("@UserId", SqlDbType.Int, userId), DbHelper2.mp("@StartDate", SqlDbType.DateTime, startDate), DbHelper2.mp("@EndDate", SqlDbType.DateTime, endDate))); }
public static int GetAuthenticatedUsers(DateTime StartDate, DateTime EndDate, int DefaultBias) { return(DbHelper2.RunSpInteger("ASP_REP_GET_AUTH_USERS", DbHelper2.mp("@startdate", SqlDbType.DateTime, StartDate), DbHelper2.mp("@enddate", SqlDbType.DateTime, EndDate), DbHelper2.mp("@TimeOffset", SqlDbType.Int, DefaultBias * 60))); }
/// <summary> /// Gets the clients. /// </summary> /// <param name="fromDate">From date.</param> /// <param name="toDate">To date.</param> /// <param name="managers">The managers.</param> /// <returns>ClientId, ClientName</returns> public static IDataReader GetClients(DateTime fromDate, DateTime toDate, string managers) { return(DbHelper2.RunSpDataReader("custom_ClioSoft_ClientsGet", DbHelper2.mp("@FromDate", SqlDbType.DateTime, fromDate), DbHelper2.mp("@ToDate", SqlDbType.DateTime, toDate), DbHelper2.mp("@Managers", SqlDbType.VarChar, 8000, managers))); }
/// <summary> /// Gets the sec group stats. /// </summary> /// <param name="GroupID">The group ID.</param> /// <param name="fromDate">From date.</param> /// <param name="toDate">To date.</param> /// <param name="ShowAll">if set to <c>true</c> [show all].</param> /// <returns>ActiveAccounts, InactiveAccounts, NewProjectsCount, NewEventsCount, NewIncidentsCount, NewToDosCount, NewTasksCount, PortalLogins, ReOpenIncidentsCount</returns> public static IDataReader GetSecGroupStats(int GroupID, DateTime fromDate, DateTime toDate, bool ShowAll) { return(DbHelper2.RunSpDataReader("ReportGroupStatistics", DbHelper2.mp("@StartDate", SqlDbType.DateTime, fromDate), DbHelper2.mp("@EndDate", SqlDbType.DateTime, toDate), DbHelper2.mp("@GroupId", SqlDbType.Int, GroupID), DbHelper2.mp("@ShowAll", SqlDbType.Bit, ShowAll))); }
public static IDataReader GetListIMSessionsByUserAndDate(int UserId, DateTime StartDate, DateTime EndDate, int Bias) { return(DbHelper2.RunSpDataReader("ASP_REP_GET_USER_IM_SESSIONS", DbHelper2.mp("@user_id", SqlDbType.Int, UserId), DbHelper2.mp("@fromdate", SqlDbType.DateTime, StartDate), DbHelper2.mp("@todate", SqlDbType.DateTime, EndDate), DbHelper2.mp("@TimeOffset", SqlDbType.Int, Bias * 60))); }
public static int GetFilesTransferred(DateTime StartDate, DateTime EndDate, int DefaultBias) { return(DbHelper2.RunSpInteger("ASP_REP_GET_FILES_TRANSFERRED", DbHelper2.mp("@startdate", SqlDbType.DateTime, StartDate), DbHelper2.mp("@enddate", SqlDbType.DateTime, EndDate), DbHelper2.mp("@total", SqlDbType.Int, 0), DbHelper2.mp("@TimeOffset", SqlDbType.Int, DefaultBias * 60))); }
public static int GetCountChatMessages(DateTime StartDate, DateTime EndDate, int DefaultBias) { return(DbHelper2.RunSpInteger("ASP_REP_GET_CHAT_MESSAGES", DbHelper2.mp("@startdate", SqlDbType.DateTime, StartDate), DbHelper2.mp("@enddate", SqlDbType.DateTime, EndDate), DbHelper2.mp("@total", SqlDbType.Int, 0), DbHelper2.mp("@TimeOffset", SqlDbType.Int, DefaultBias * 60))); }
/// <summary> /// Gets the tasks. /// </summary> /// <param name="projectId">The project id.</param> /// <param name="completion">The completion.</param> /// <param name="completionFromDate">The completion from date.</param> /// <param name="completionToDate">The completion to date.</param> /// <returns></returns> public static IDataReader GetTasks(int projectId, int completion, DateTime completionFromDate, DateTime completionToDate) { return(DbHelper2.RunSpDataReader("custom_ClioSoft_TasksGet", DbHelper2.mp("@ProjectId", SqlDbType.Int, projectId), DbHelper2.mp("@Completion", SqlDbType.Int, completion), DbHelper2.mp("@CompletionFromDate", SqlDbType.DateTime, completionFromDate), DbHelper2.mp("@CompletionToDate", SqlDbType.DateTime, completionToDate))); }
/// <summary> /// Gets the project groups by user. /// </summary> /// <param name="fromDate">From date.</param> /// <param name="toDate">To date.</param> /// <param name="users">The users.</param> /// <param name="clients">The clients.</param> /// <returns>ProjectGroupId, ProjectGroupName</returns> public static IDataReader GetProjectGroupsByUser(DateTime fromDate, DateTime toDate, string users, string clients) { return(DbHelper2.RunSpDataReader("custom_ClioSoft_ProjectGroupsGetByUser", DbHelper2.mp("@FromDate", SqlDbType.DateTime, fromDate), DbHelper2.mp("@ToDate", SqlDbType.DateTime, toDate), DbHelper2.mp("@Users", SqlDbType.VarChar, 8000, users), DbHelper2.mp("@Clients", SqlDbType.VarChar, 8000, clients))); }
/// <summary> /// Gets the user report info. /// </summary> /// <param name="fromDate">From date.</param> /// <param name="toDate">To date.</param> /// <param name="ownerId">The owner id.</param> /// <param name="projectId">The project id.</param> /// <param name="completion">The completion.</param> /// <param name="completionFromDate">The completion from date.</param> /// <param name="completionToDate">The completion to date.</param> /// <returns></returns> public static IDataReader GetUserReportInfo(DateTime fromDate, DateTime toDate, int ownerId, int projectId, int completion, DateTime completionFromDate, DateTime completionToDate) { return(DbHelper2.RunSpDataReader("custom_ClioSoft_UserReportGetInfo", DbHelper2.mp("@FromDate", SqlDbType.DateTime, fromDate), DbHelper2.mp("@ToDate", SqlDbType.DateTime, toDate), DbHelper2.mp("@ProjectId", SqlDbType.Int, projectId), DbHelper2.mp("@UserId", SqlDbType.Int, ownerId), DbHelper2.mp("@Completion", SqlDbType.Int, completion), DbHelper2.mp("@CompletionFromDate", SqlDbType.DateTime, completionFromDate), DbHelper2.mp("@CompletionToDate", SqlDbType.DateTime, completionToDate))); }
/// <summary> /// Gets the projects. /// </summary> /// <param name="fromDate">From date.</param> /// <param name="toDate">To date.</param> /// <param name="managers">The managers.</param> /// <param name="clients">The clients.</param> /// <param name="projectGroups">The project groups.</param> /// <param name="completion">The completion.</param> /// <param name="completionFromDate">The completion from date.</param> /// <param name="completionToDate">The completion to date.</param> /// <returns></returns> public static IDataReader GetProjects(DateTime fromDate, DateTime toDate, string managers, string clients, string projectGroups, int completion, DateTime completionFromDate, DateTime completionToDate) { return(DbHelper2.RunSpDataReader("custom_ClioSoft_ProjectsGet", DbHelper2.mp("@FromDate", SqlDbType.DateTime, fromDate), DbHelper2.mp("@ToDate", SqlDbType.DateTime, toDate), DbHelper2.mp("@Managers", SqlDbType.VarChar, 8000, managers), DbHelper2.mp("@Clients", SqlDbType.VarChar, 8000, clients), DbHelper2.mp("@ProjectGroups", SqlDbType.VarChar, 8000, projectGroups), DbHelper2.mp("@Completion", SqlDbType.Int, completion), DbHelper2.mp("@CompletionFromDate", SqlDbType.DateTime, completionFromDate), DbHelper2.mp("@CompletionToDate", SqlDbType.DateTime, completionToDate))); }
public static IDataReader GetChats(int iUserId) { int origUserId = 0; if (iUserId != 0) { origUserId = DbHelper2.RunSpInteger("UserGetOriginalId", DbHelper2.mp("@UserId", SqlDbType.Int, iUserId)); if (origUserId == -1) { origUserId = 0; } } return(DbHelper2.RunSpDataReader("ASP_GET_CHATS", DbHelper2.mp("@USER_ID", SqlDbType.Int, origUserId))); }
public static int GetCountIMMessages(DateTime StartDate, DateTime EndDate, bool getInternal, int DefaultBias) { int ret = 0; using (IDataReader reader = DbHelper2.RunSpDataReader("ASP_REP_GET_IM_MESSAGES", DbHelper2.mp("@startdate", SqlDbType.DateTime, StartDate), DbHelper2.mp("@enddate", SqlDbType.DateTime, EndDate), DbHelper2.mp("@use_dates", SqlDbType.Bit, 1), DbHelper2.mp("@internal", SqlDbType.Bit, getInternal ? 1 : 0), DbHelper2.mp("@TimeOffset", SqlDbType.Int, DefaultBias * 60))) { if (reader.Read()) { ret = (int)reader["MessagesSent"]; } } return(ret); }
/// <summary> /// LoginsClient, MsgSent, MsgReceived, ConfCreated, /// ConfMsgSent, FilesSent, FSBytes, FilesReceived, FRBytes, /// FilesPublished, FPBytes, CalEntries, Projects, CreateDate. /// </summary> public static IDataReader GetUserStats(int UserID, DateTime fromDate, DateTime toDate, int DefaultBias) { int origUserId = 0; if (UserID != 0) { origUserId = DbHelper2.RunSpInteger("UserGetOriginalId", DbHelper2.mp("@UserId", SqlDbType.Int, UserID)); if (origUserId == -1) { origUserId = 0; } } return(DbHelper2.RunSpDataReader("ASP_REP_GET_USER_STATS", DbHelper2.mp("@user_id", SqlDbType.Int, origUserId), DbHelper2.mp("@fromdate", SqlDbType.DateTime, fromDate), DbHelper2.mp("@todate", SqlDbType.DateTime, toDate), DbHelper2.mp("@TimeOffset", SqlDbType.Int, DefaultBias * 60))); }
public static IDataReader SearchChat(int iUserId, int iChatId, DateTime dtFrom, DateTime dtTo, string sKeyWord, int iOrder, int DefaultBias) { int origUserId = 0; if (iUserId != 0) { origUserId = DbHelper2.RunSpInteger("UserGetOriginalId", DbHelper2.mp("@UserId", SqlDbType.Int, iUserId)); if (origUserId == -1) { origUserId = 0; } } return(DbHelper2.RunSpDataReader("ASP_SEARCH_CHAT", DbHelper2.mp("@User_id", SqlDbType.Int, origUserId), DbHelper2.mp("@Chat_id", SqlDbType.Int, iChatId), DbHelper2.mp("@DT_Begin", SqlDbType.DateTime, dtFrom), DbHelper2.mp("@DT_End", SqlDbType.DateTime, dtTo), DbHelper2.mp("@Keyword", SqlDbType.NVarChar, 50, sKeyWord), DbHelper2.mp("@Order", SqlDbType.Int, iOrder), DbHelper2.mp("@TimeOffset", SqlDbType.Int, DefaultBias * 60))); }
/// <summary> /// DisplayName, Count /// </summary> /// <returns></returns> public static IDataReader GetMostActiveGroupsByIncidentReport(DateTime FromDate, DateTime ToDate) { return(DbHelper2.RunSpDataReader("ReportMostActiveGroupsByIncident", DbHelper2.mp("@FromDate", SqlDbType.DateTime, FromDate), DbHelper2.mp("@ToDate", SqlDbType.DateTime, ToDate))); }
public static bool GetMenuInAlerts(int UserId) { return((bool)DbHelper2.RunSpScalar("UserPreferenceMenuInAlertsGet", DbHelper2.mp("@UserId", SqlDbType.Int, UserId))); }
/// <summary> /// Reader returns fields: /// UserId, Login, FirstName, LastName, Email, Activity, IMGroupId /// </summary> public static IDataReader GetUserInfoByOriginalId(int OriginalId) { return(DbHelper2.RunSpDataReader("UserGetByOriginalId", DbHelper2.mp("@OriginalId", SqlDbType.Int, OriginalId))); }
/// <summary> /// Reader returns fields: /// GroupId, GroupName /// </summary> public static IDataReader GetListAvailableGroupsForPartner(int UserId) { return(DbHelper2.RunSpDataReader("GroupsGetAvailableForPartner", DbHelper2.mp("@PrincipalId", SqlDbType.Int, UserId))); }
/// <summary> /// Reader returns fields: /// GroupId, GroupName /// </summary> public static IDataReader GetListAvailableGroups() { return(DbHelper2.RunSpDataReader("GroupsGetAvailable")); }
/// <summary> /// Reader returns fields: /// GroupId, GroupName /// </summary> public static IDataReader GetListGroups() { return(DbHelper2.RunSpDataReader("GroupGet", DbHelper2.mp("@PrincipalId", SqlDbType.Int, 0))); }
public static IDataReader GetUsersByCompany() { return(DbHelper2.RunSpDataReader("ASP_GET_USERS_BY_COMPANY")); }
public static int GetGroupForPartnerUser(int UserId) { return(DbHelper2.RunSpInteger("GroupGetForPartnerUser", DbHelper2.mp("@PrincipalId", SqlDbType.Int, UserId))); }
/// <summary> /// Reader returns fields: /// GroupId, GroupName, Level /// </summary> public static IDataReader GetListGroupsAsTree() { return(DbHelper2.RunSpDataReader("GroupsGetAsTree2")); }
/// <summary> /// Reader returns fields: /// UserId, Login, FirstName, LastName, Email, IsActive, IMGroupId, CreatedBy, Comments, IsExternal, IsPending, OriginalId /// </summary> public static IDataReader GetUserInfo(int UserId) { return(DbHelper2.RunSpDataReader("UserGet", DbHelper2.mp("@PrincipalId", SqlDbType.Int, UserId))); }
/// <summary> /// Reader returns fields: /// UserId, Login, FirstName, LastName, Email, IMGroupId, CreatedBy, Activity, IsExternal /// </summary> public static IDataReader GetListAllUsersInGroup(int GroupId) { return(DbHelper2.RunSpDataReader("UsersGetByGroupAll", DbHelper2.mp("@GroupId", SqlDbType.Int, GroupId))); }