/// <summary>
/// Reader returns fields:
/// DirectoryId, Name, Path, CreatorId, Created, ModifierId, Modified, ParentDirectoryId
/// </summary>
public static IDataReader GetRoot(int TimeZoneId, string ContainerKey)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "Created", "Modified" },
"fsc_DirectoryGetRoot",
DbHelper2.mp("@ContainerKey", SqlDbType.NVarChar, 255, ContainerKey)));
}
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)));
}
/// <summary>
/// Reader returns fields:
/// EventId, Title, PrincipalId, IsConfirmed, LastSavedDate, StateId
/// </summary>
/// <returns></returns>
public static IDataReader GetListEventResourcesNotPending(int UserId, int TimeZoneId)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "LastSavedDate", "StartDate", "FinishDate" },
"EventResourcesGetNotPending",
DbHelper2.mp("@UserId", SqlDbType.Int, UserId)));
}
/// <summary>
/// Reader returns fields:
/// @INFO_TYPE=1: U.[user_id], U.login, U.first_name, U.last_name, U.eMail, @STATUS AS [status],
/// U.imgroup_id, R.imgroup_name, U.status_time as [time]
/// </summary>
public static IDataReader GetUserInfo(int iUserId, int iInfoType)
{
return(DbHelper2.RunSpDataReader("OM_GET_USER_INFO",
DbHelper2.mp("@USER_ID", SqlDbType.Int, iUserId),
DbHelper2.mp("@INFO_TYPE", SqlDbType.Int, iInfoType),
DbHelper2.mp("@TIME", SqlDbType.Int, 0)));
}
/// <summary>
/// ObjectRoleId
/// </summary>
/// <returns></returns>
public static IDataReader GetPersonalSubscriptionDetailsForObject(int EventTypeId, int UserId, int ObjectId)
{
return(DbHelper2.RunSpDataReader("SubscriptionDetailsGetPersonalForObject",
DbHelper2.mp("@EventTypeId", SqlDbType.Int, EventTypeId),
DbHelper2.mp("@UserId", SqlDbType.Int, UserId),
DbHelper2.mp("@ObjectId", SqlDbType.Int, ObjectId)));
}
/// <summary>
/// Reader returns fields:
/// FileId, Name, DirectoryId, FileBinaryId, CreatorId, Created, ModifierId, Modified, Length, AllowHistory, Description
/// </summary>
public static IDataReader GetById(int TimeZoneId, int FileId)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "Created", "Modified" },
"fsc_FileGetById",
DbHelper2.mp("@FileId", SqlDbType.Int, FileId)));
}
/// <summary>
/// OldState, NewState
/// </summary>
/// <returns></returns>
public static IDataReader RecalculateState(int EventId, DateTime DT)
{
return(DbHelper2.RunSpDataReader("EventRecalculateState",
DbHelper2.mp("@EventId", SqlDbType.Int, EventId),
DbHelper2.mp("@DateNow", SqlDbType.DateTime, DT)
));
}
/// <summary>
/// Reader returns fields:
/// EventId, StartDate, FinishDate
/// </summary>
/// <returns></returns>
public static IDataReader GetEventDates(int EventId, int TimeZoneId)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "StartDate", "FinishDate" },
"EventGetDates",
DbHelper2.mp("@EventId", SqlDbType.Int, EventId)));
}
/*
* ProjectGroupsGet
* [ProjectGroupId], [Title], [Description], [CreationDate], [CreatorId]
*/
public static IDataReader GetProjectGroup(int ProjectGroupId, int TimeZoneId)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "CreationDate" },
"ProjectGroupGet",
DbHelper2.mp("@ProjectGroupId", SqlDbType.Int, ProjectGroupId)));
}
/// <summary>
/// Reader returns fields:
/// SubscriptionId, DateTypeId, UserId, ObjectId, Lag, IsActive, HookId, SubscriptionType
/// </summary>
/// <returns></returns>
public static IDataReader GetReminderSubscriptionPersonalForObject(int DateTypeId, int UserId, int ObjectId)
{
return(DbHelper2.RunSpDataReader("ReminderSubscribtionGetPersonalForObject",
DbHelper2.mp("@DateTypeId", SqlDbType.Int, DateTypeId),
DbHelper2.mp("@UserId", SqlDbType.Int, UserId),
DbHelper2.mp("@ObjectId", SqlDbType.Int, ObjectId)));
}
public static IDataReader GetOverlapedUserExceptions(int ExceptionId, DateTime FromDate, DateTime ToDate)
{
return(DbHelper2.RunSpDataReader("UserCalendarExceptionsGetOverlaped",
DbHelper2.mp("@ExceptionId", SqlDbType.Int, ExceptionId),
DbHelper2.mp("@FromDate", SqlDbType.DateTime, FromDate),
DbHelper2.mp("@ToDate", SqlDbType.DateTime, ToDate)));
}
/// <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)));
}
/// <summary></summary>
/// <returns>
/// TemplateId, TemplateName, CreatorId, LastEditorId, CreationDate, LastSavedDate, TemplateData
/// </returns>
public static IDataReader GetProjectTemplate(int TemplateId, int TimeZoneId)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "CreationDate", "LastSavedDate" },
"ProjectTemplateGet",
DbHelper2.mp("@TemplateId", SqlDbType.Int, TemplateId)));
}
/// <summary>
/// TimeTrackingEntryId, UserId, ObjectTypeId, ObjectId, Title,
/// Day1, Day2, Day3, Day4, Day5, Day6, Day7, Total, TotalApproved, Rate, Cost, TaskTime
/// </summary>
/// <returns></returns>
public static IDataReader GetListTimeTrackingItemsForFinances(int blockTypeInstanceId, DateTime startDate, int userId)
{
return(DbHelper2.RunSpDataReader("TimeTrackingItemsGetForFinances",
DbHelper2.mp("@BlockTypeInstanceId", SqlDbType.Int, blockTypeInstanceId),
DbHelper2.mp("@StartDate", SqlDbType.DateTime, startDate),
DbHelper2.mp("@UserId", SqlDbType.Int, userId)));
}
public static IDataReader GetSessions(DateTime StartDate, DateTime EndDate, int DefaultBias)
{
return(DbHelper2.RunSpDataReader("ASP_REP_GET_SESSIONS",
DbHelper2.mp("@StartDate", SqlDbType.DateTime, StartDate),
DbHelper2.mp("@EndDate", SqlDbType.DateTime, EndDate),
DbHelper2.mp("@TimeOffset", SqlDbType.Int, DefaultBias * 60)));
}
/// <summary>
/// Reader returns fields:
/// DirectoryId, Name, Path, CreatorId, Created, ModifierId, Modified, ParentDirectoryId
/// </summary>
public static IDataReader GetParentById(int TimeZoneId, int DirectoryId)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "Created", "Modified" },
"fsc_DirectoryGetParentById",
DbHelper2.mp("@DirectoryId", SqlDbType.Int, DirectoryId)));
}
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)));
}
/// <summary>
/// Reader returns fields:
/// EventId, Title, Location, TypeId, StartDate, FinishDate,
/// Description, StateId
/// </summary>
/// <returns></returns>
public static IDataReader GetListEventsForUser(int UserId, int TimeZoneId)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "StartDate", "FinishDate" },
"EventsGetForUser",
DbHelper2.mp("@UserId", SqlDbType.Int, UserId)));
}
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)));
}
public static IDataReader Message_GetByUserIdAndTimeFilter(int userId, DateTime startDate, DateTime endDate)
{
return(DbHelper2.RunSpDataReader("Message_GetByUserIdAndTimeFilter",
DbHelper2.mp("@UserId", SqlDbType.Int, userId),
DbHelper2.mp("@StartDate", SqlDbType.DateTime, startDate),
DbHelper2.mp("@EndDate", SqlDbType.DateTime, endDate)));
}
/// <summary>
/// Reader returns fields:
/// ResourceId, EventId, PrincipalId, IsGroup, MustBeConfirmed, ResponsePending,
/// IsConfirmed, IsExternal
/// </summary>
/// <returns></returns>
public static IDataReader GetListResources(int EventId, int TimeZoneId)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "LastSavedDate" },
"EventResourcesGet",
DbHelper2.mp("@EventId", SqlDbType.Int, EventId)));
}
/// <summary></summary>
/// <returns>
/// DataReader contains fields:
/// TemplateId, Name, TemplateCreated, TemplateModified, TemplateCreatorId, TemplateModifierId, TemplateXML
/// </returns>
public static IDataReader GetReportTemplate(int ReportTemplateId, int TimeZoneId)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "TemplateCreated", "TemplateModified" },
"ReportTemplateGet",
DbHelper2.mp("@ReportTemplateId", SqlDbType.Int, ReportTemplateId)));
}
/// Reader returns fields:
/// FileId, Name, DirectoryId, FileBinaryId, CreatorId, Created, ModifierId, Modified, Length, AllowHistory, Description
public static IDataReader AllowHistory(int TimeZoneId, int FileId, bool AllowHistory)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "Created", "Modified" },
"fsc_FileAllowHistory",
DbHelper2.mp("@FileId", SqlDbType.Int, FileId),
DbHelper2.mp("@AllowHistory", SqlDbType.Bit, AllowHistory)));
}
/// <summary>
/// MessageId, CreationDate, ExpirationDate, Text, CreatorId
/// </summary>
/// <param name="userId"></param>
/// <param name="onlyActive"></param>
/// <param name="TimeZoneId"></param>
/// <returns></returns>
public static IDataReader GetBroadCastMessages(int userId, bool onlyActive, int TimeZoneId)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "CreationDate", "ExpirationDate" },
"BroadCastMessagesGet",
DbHelper2.mp("@UserId", SqlDbType.Int, userId),
DbHelper2.mp("@OnlyActive", SqlDbType.Bit, onlyActive)));
}
/// Reader returns fields:
/// FileId, Name, DirectoryId, FileBinaryId, CreatorId, Created, ModifierId, Modified, Length, AllowHistory, Description
public static IDataReader Move(int TimeZoneId, int FileId, int DestDirectoryId)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "Created", "Modified" },
"fsc_FileMove",
DbHelper2.mp("@FileId", SqlDbType.Int, FileId),
DbHelper2.mp("@DestDirectoryId", SqlDbType.Int, DestDirectoryId)));
}
/// <summary>
/// SystemEventId, EventTypeId, ObjectId, ObjectTitle, RelObjectTitle, UserId, Dt,
/// ObjectTypeId, SystemEventTitle, RelObjectTypeId, RelObjectId
/// </summary>
/// <returns></returns>
public static IDataReader GetListSystemEventsByObject(int ObjectId, int ObjectTypeId, int TimeZoneId)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "Dt" },
"SystemEventsGetByObject",
DbHelper2.mp("@ObjectId", SqlDbType.Int, ObjectId),
DbHelper2.mp("@ObjectTypeId", SqlDbType.Int, ObjectTypeId)));
}
/// <summary>
/// Reader returns fields:
/// EventId, ProjectId, ProjectTitle, CreatorId, ManagerId,
/// Title, Description, Location, CreationDate, StartDate,
/// FinishDate, PriorityId, PriorityName, TypeId, TypeName, ReminderInterval,
/// StateId, HasRecurrence, ContactUid, OrgUid, ClientName
/// </summary>
/// <returns></returns>
public static IDataReader GetEvent(int EventId, int TimeZoneId, int LanguageId)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "CreationDate", "StartDate", "FinishDate" },
"EventGet",
DbHelper2.mp("@EventId", SqlDbType.Int, EventId),
DbHelper2.mp("@LanguageId", SqlDbType.Int, LanguageId)));
}
/// <summary>
/// Returns fields: AccActive, AccInactive, MsgIM, MsgConf,
/// TransfFiles, TransfBytes, Confs, Projects, FilesPub, CalEntries.
/// </summary>
public static IDataReader GetGroupStats(int IMGroupId, DateTime fromDate, DateTime toDate, int DefaultBias)
{
return(DbHelper2.RunSpDataReader("ASP_REP_GET_GROUP_STATS",
DbHelper2.mp("@imgroup_id", SqlDbType.Int, IMGroupId),
DbHelper2.mp("@TimeOffset", SqlDbType.Int, DefaultBias * 60),
DbHelper2.mp("@fromdate", SqlDbType.DateTime, fromDate),
DbHelper2.mp("@todate", SqlDbType.DateTime, toDate)));
}
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)));
}
/// <summary>
/// Reader returns fields:
/// FileId, Name, DirectoryId, FileBinaryId, CreatorId, Created, ModifierId, Modified, Length
/// </summary>
public static IDataReader GetChildFilesByDirectoryId(int TimeZoneId, int DirectoryId, string ContainerKey)
{
return(DbHelper2.RunSpDataReader(
TimeZoneId, new string[] { "Created", "Modified" },
"fsc_FilesGetByDirectoryId",
DbHelper2.mp("@DirectoryId", SqlDbType.Int, DirectoryId),
DbHelper2.mp("@ContainerKey", SqlDbType.NVarChar, 255, ContainerKey)));
}
