/// <summary>
/// ResourceId, EventId, PrincipalId, IsGroup, MustBeConfirmed, ResponsePending,
/// IsConfirmed, IsExternal
/// </summary>
/// <returns></returns>
public static DataTable GetListEventResourcesDataTable(int EventId, int TimeZoneId)
{
return(DbHelper2.RunSpDataTable(
TimeZoneId, new string[] { "LastSavedDate" },
"EventResourcesGet",
DbHelper2.mp("@EventId", SqlDbType.Int, EventId)));
}
/// <summary>
/// ActualId, AccountId, Title, OutlineLevel, ActualDate, Description, AValue,
/// LastEditorId, LastSavedDate, ObjectTypeId, ObjectId, ObjectTitle
/// </summary>
public static DataTable GetListActualFinancesByProject(int ProjectId, int TimeZoneId)
{
return(DbHelper2.RunSpDataTable(
TimeZoneId, new string[] { "ActualDate", "LastSavedDate" },
"ActualFinancesGetListByProject",
DbHelper2.mp("@ProjectId", SqlDbType.Int, ProjectId)));
}
/// <summary>
/// Reader returns fields:
/// PartnerId, GroupId, GroupName, Level (=1)
/// </summary>
public static DataTable GetListGroupsByPartnerDataTable(int PartnerId, bool IncludeCurrent, bool IncludeEveryone)
{
return(DbHelper2.RunSpDataTable("PartnerGroupGetListByPartner",
DbHelper2.mp("@PartnerId", SqlDbType.Int, PartnerId),
DbHelper2.mp("@IncludeCurrent", SqlDbType.Bit, IncludeCurrent),
DbHelper2.mp("@IncludeEveryone", SqlDbType.Bit, IncludeEveryone)));
}
/// <summary>
/// ItemId, Title, PriorityId, PriorityName, ItemType, CreationDate, StartDate, FinishDate,
/// PercentCompleted, IsCompleted, ManagerId, ReasonId, ProjectId, ProjectTitle,
/// StateId, CompletionTypeId,
/// TaskTime, TotalMinutes, TotalApproved, HasRecurrence, ContactUid, OrgUid, ClientName,
/// CategoryId, CategoryName
/// </summary>
/// <returns></returns>
public static DataTable GetListEventsForManagerViewWithCategories(int PrincipalId,
int TimeZoneId, int LanguageId, int ManagerId, int ProjectId, int categoryId,
bool ShowActive,
DateTime dtCompleted1, DateTime dtCompleted2,
DateTime dtUpcoming1, DateTime dtUpcoming2,
DateTime dtCreated1, DateTime dtCreated2,
PrimaryKeyId orgUid, PrimaryKeyId contactUid)
{
object obj_dtCompleted1 = (dtCompleted1 <= DateTime.MinValue.AddDays(1)) ? null : (object)dtCompleted1;
object obj_dtCompleted2 = (dtCompleted2 <= DateTime.MinValue.AddDays(1)) ? null : (object)dtCompleted2;
object obj_dtUpcoming1 = (dtUpcoming1 >= DateTime.MaxValue.AddDays(-1)) ? null : (object)dtUpcoming1;
object obj_dtUpcoming2 = (dtUpcoming2 >= DateTime.MaxValue.AddDays(-1)) ? null : (object)dtUpcoming2;
object obj_dtCreated1 = (dtCreated1 <= DateTime.MinValue.AddDays(1)) ? null : (object)dtCreated1;
object obj_dtCreated2 = (dtCreated2 <= DateTime.MinValue.AddDays(1)) ? null : (object)dtCreated2;
return(DbHelper2.RunSpDataTable(
TimeZoneId, new string[] { "CreationDate", "StartDate", "FinishDate" },
"EventsGetForManagerViewWithCategories",
DbHelper2.mp("@PrincipalId", SqlDbType.Int, PrincipalId),
DbHelper2.mp("@LanguageId", SqlDbType.Int, LanguageId),
DbHelper2.mp("@ManagerId", SqlDbType.Int, ManagerId),
DbHelper2.mp("@ProjectId", SqlDbType.Int, ProjectId),
DbHelper2.mp("@CategoryId", SqlDbType.Int, categoryId),
DbHelper2.mp("@ShowActive", SqlDbType.Bit, ShowActive),
DbHelper2.mp("@CompletedDate1", SqlDbType.DateTime, obj_dtCompleted1),
DbHelper2.mp("@CompletedDate2", SqlDbType.DateTime, obj_dtCompleted2),
DbHelper2.mp("@StartDate1", SqlDbType.DateTime, obj_dtUpcoming1),
DbHelper2.mp("@StartDate2", SqlDbType.DateTime, obj_dtUpcoming2),
DbHelper2.mp("@CreationDate1", SqlDbType.DateTime, obj_dtCreated1),
DbHelper2.mp("@CreationDate2", SqlDbType.DateTime, obj_dtCreated2),
DbHelper2.mp("@OrgUid", SqlDbType.UniqueIdentifier, orgUid),
DbHelper2.mp("@ContactUid", SqlDbType.UniqueIdentifier, contactUid)));
}
/// <summary></summary>
/// <returns>
/// DataReader contains fields:
/// ReportItemId, ReportId, CreationDate, CreatorId
/// </returns>
public static DataTable GetReportsByTemplateId(int TemplateId, int TimeZoneId)
{
return(DbHelper2.RunSpDataTable(
TimeZoneId, new string[] { "CreationDate" },
"ReportsGetByTemplateId",
DbHelper2.mp("@TemplateId", SqlDbType.Int, TemplateId)));
}
public static DataTable GetListTimeTrackingItemsForFinances_DataTable(int blockTypeInstanceId, DateTime startDate, int userId)
{
return(DbHelper2.RunSpDataTable("TimeTrackingItemsGetForFinances",
DbHelper2.mp("@BlockTypeInstanceId", SqlDbType.Int, blockTypeInstanceId),
DbHelper2.mp("@StartDate", SqlDbType.DateTime, startDate),
DbHelper2.mp("@UserId", SqlDbType.Int, userId)));
}
public static DataTable GetPersonalSubscriptionsForObjectDT(int ObjectTypeId, int UserId, int ObjectId)
{
return(DbHelper2.RunSpDataTable("SubscriptionsGetPersonalForObject",
DbHelper2.mp("@ObjectTypeId", SqlDbType.Int, ObjectTypeId),
DbHelper2.mp("@UserId", SqlDbType.Int, UserId),
DbHelper2.mp("@ObjectId", SqlDbType.Int, ObjectId)));
}
/// <summary>
/// Reader returns fields:
/// EventId, ProjectId, CreatorId, ManagerId, LastEditorId,
/// Title, Description, Location, CreationDate, LastSavedDate, StartDate,
/// FinishDate, PriorityId, PriorityName, TypeId, TypeName, StateId
/// </summary>
/// <returns></returns>
public static DataTable GetListEventsByProjectDataTable(int ProjectId, int TimeZoneId, int LanguageId)
{
return(DbHelper2.RunSpDataTable(
TimeZoneId, new string[] { "CreationDate", "StartDate", "FinishDate" },
"EventsGetByProject",
DbHelper2.mp("@ProjectId", SqlDbType.Int, ProjectId),
DbHelper2.mp("@LanguageId", SqlDbType.Int, LanguageId)));
}
public static DataTable GetListIMSessionsByUserAndDate(int UserId, DateTime StartDate, DateTime EndDate, int Bias)
{
return(DbHelper2.RunSpDataTable("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 DataTable GetListSystemEventsByObjectDT(int ObjectId, int ObjectTypeId, int TimeZoneId)
{
return(DbHelper2.RunSpDataTable(
TimeZoneId, new string[] { "Dt" },
"SystemEventsGetByObject",
DbHelper2.mp("@ObjectId", SqlDbType.Int, ObjectId),
DbHelper2.mp("@ObjectTypeId", SqlDbType.Int, ObjectTypeId)));
}
/// <summary>
/// Pop3MailRequestId, Sender, SenderIbnUserId, FirstName, LastName, Subject, InnerText,
/// Priority, PriorityName, Pop3BoxId, Received, MhtFileId, SenderType, Pop3BoxName
/// </summary>
/// <returns></returns>
public static DataTable GetDataTable(int issueRequestId, int pop3BoxId, int timeZoneId, int languageId)
{
return(DbHelper2.RunSpDataTable(
timeZoneId, new string[] { "Received" },
"Pop3MailRequestsGet",
DbHelper2.mp("@Pop3MailRequestId", SqlDbType.Int, issueRequestId),
DbHelper2.mp("@Pop3BoxId", SqlDbType.Int, pop3BoxId),
DbHelper2.mp("@LanguageId", SqlDbType.Int, languageId)));
}
/// <summary>
/// EventId, Title, Location, PriorityId, PriorityName, TypeId, ManagerId, StartDate, FinishDate
/// </summary>
/// <returns></returns>
public static DataTable GetListPendingEventsDataTable(int ProjectId, int UserId, int TimeZoneId, int LanguageId)
{
return(DbHelper2.RunSpDataTable(
TimeZoneId, new string[] { "StartDate", "FinishDate" },
"EventsGetPending",
DbHelper2.mp("@ProjectId", SqlDbType.Int, ProjectId),
DbHelper2.mp("@UserId", SqlDbType.Int, UserId),
DbHelper2.mp("@LanguageId", SqlDbType.Int, LanguageId)));
}
public static DataTable GetListPop3MailRequestsDataTable(int Pop3MailRequestId, int Pop3BoxId, int TimeZoneId, int LanguageId)
{
return(DbHelper2.RunSpDataTable(
TimeZoneId, new string[] { "Received" },
"Pop3MailRequestsGet",
DbHelper2.mp("@Pop3MailRequestId", SqlDbType.Int, Pop3MailRequestId),
DbHelper2.mp("@Pop3BoxId", SqlDbType.Int, Pop3BoxId),
DbHelper2.mp("@LanguageId", SqlDbType.Int, LanguageId)));
}
public static DataTable GetSystemEventsDT(int UserId, DateTime StartDate,
DateTime EndDate, int TimeZoneId)
{
return(DbHelper2.RunSpDataTable(
TimeZoneId, new string[] { "Dt" },
"SystemEventsGet",
DbHelper2.mp("@UserId", SqlDbType.Int, UserId),
DbHelper2.mp("@StartDate", SqlDbType.DateTime, StartDate),
DbHelper2.mp("@EndDate", SqlDbType.DateTime, EndDate)));
}
/// <summary>
/// EventId, Title, Location, TypeId, StartDate, FinishDate,
/// LastEditorId, LastSavedDate, ProjectId, ProjectName
/// </summary>
/// <returns></returns>
public static DataTable GetListEventsUpdatedForUserDataTable(int ProjectId, int UserId, int TimeZoneId, int Days)
{
return(DbHelper2.RunSpDataTable(
TimeZoneId, new string[] { "StartDate", "FinishDate", "LastSavedDate" },
"EventsGetUpdatedForUser",
DbHelper2.mp("@ProjectId", SqlDbType.Int, ProjectId),
DbHelper2.mp("@UserId", SqlDbType.Int, UserId),
DbHelper2.mp("@TimeZoneId", SqlDbType.Int, TimeZoneId),
DbHelper2.mp("@Days", SqlDbType.Int, Days)));
}
public static DataTable GetListStickedObjectsUtc(int userId,
bool getTasks, bool getTodo, bool getIncidents, bool getDocuments)
{
return(DbHelper2.RunSpDataTable("StickedObjectsGet",
DbHelper2.mp("@UserId", SqlDbType.Int, userId),
DbHelper2.mp("@GetTasks", SqlDbType.Bit, getTasks),
DbHelper2.mp("@GetTodo", SqlDbType.Bit, getTodo),
DbHelper2.mp("@GetIncidents", SqlDbType.Bit, getIncidents),
DbHelper2.mp("@getDocuments", SqlDbType.Bit, getDocuments)));
}
/// <summary>
/// Gets the list objects in priority order in UTC time.
/// </summary>
/// <param name="userId">The user id.</param>
/// <param name="fromDate">From date.</param>
/// <param name="toDate">To date.</param>
/// <param name="getTasks">if set to <c>true</c> [get tasks].</param>
/// <param name="getTodo">if set to <c>true</c> [get todo].</param>
/// <param name="getIncidents">if set to <c>true</c> [get incidents].</param>
/// <returns>
/// ObjectId, ObjectTypeId, ObjectName, PriorityId, StateId,
/// StartDate (UTC), FinishDate (UTC), CreationDate (UTC),
/// TaskTime, PercentCompleted, TaskTimeLeft, FinishDateLeft (UTC),
/// IsOverdue, IsNewMessage, AssignmentId, AssignmentName, ProjectId, ProjectTitle
/// </returns>
public static DataTable GetListObjectsInPriorityOrderUtc(int userId, DateTime fromDate,
DateTime toDate, bool getTasks, bool getTodo, bool getIncidents, bool getDocuments)
{
return(DbHelper2.RunSpDataTable("ObjectsGetInPriorityOrder",
DbHelper2.mp("@UserId", SqlDbType.Int, userId),
DbHelper2.mp("@FromDate", SqlDbType.DateTime, fromDate),
DbHelper2.mp("@ToDate", SqlDbType.DateTime, toDate),
DbHelper2.mp("@GetTasks", SqlDbType.Bit, getTasks),
DbHelper2.mp("@GetTodo", SqlDbType.Bit, getTodo),
DbHelper2.mp("@GetIncidents", SqlDbType.Bit, getIncidents),
DbHelper2.mp("@GetDocuments", SqlDbType.Bit, getDocuments)));
}
/// <summary>
/// Gets the list objects in priority order.
/// </summary>
/// <param name="userId">The user id.</param>
/// <param name="fromDate">From date.</param>
/// <param name="toDate">To date.</param>
/// <param name="getTasks">if set to <c>true</c> [get tasks].</param>
/// <param name="getTodo">if set to <c>true</c> [get todo].</param>
/// <param name="getIncidents">if set to <c>true</c> [get incidents].</param>
/// <param name="timeZoneId">The time zone id.</param>
/// <returns>ObjectId, ObjectTypeId, ObjectName, PriorityId, StateId, StartDate (local), FinishDate (local), CreationDate (local), TaskTime, PercentCompleted, TaskTimeLeft, FinishDateLeft (local)</returns>
public static DataTable GetListObjectsInPriorityOrder(int userId, DateTime fromDate,
DateTime toDate, bool getTasks, bool getTodo, bool getIncidents, int timeZoneId)
{
return(DbHelper2.RunSpDataTable(timeZoneId,
new string[] { "StartDate", "FinishDate", "CreationDate", "FinishDateLeft" },
"ObjectsGetInPriorityOrder",
DbHelper2.mp("@UserId", SqlDbType.Int, userId),
DbHelper2.mp("@FromDate", SqlDbType.DateTime, fromDate),
DbHelper2.mp("@ToDate", SqlDbType.DateTime, toDate),
DbHelper2.mp("@GetTasks", SqlDbType.Bit, getTasks),
DbHelper2.mp("@GetTodo", SqlDbType.Bit, getTodo),
DbHelper2.mp("@GetIncidents", SqlDbType.Bit, getIncidents)));
}
/// <summary>
/// DataReader contains fields:
/// TemplateId, TemplateName, TemplateCreated, TemplateModified, TemplateCreatorId, TemplateModifierId, TemplateXML
/// </summary>
/// <returns></returns>
public static DataTable GetReportTemplatesByFilterDataTable(int CreatorId,
int TimeZoneId, DateTime StartDate, DateTime FinishDate, int LastEditorId,
int UserId)
{
object oStartDate = (StartDate == DateTime.MinValue) ? (object)DBNull.Value : StartDate;
object oFinishDate = (FinishDate == DateTime.MaxValue) ? (object)DBNull.Value : FinishDate;
return(DbHelper2.RunSpDataTable(
TimeZoneId, new string[] { "TemplateCreated", "TemplateModified" },
"ReportTemplatesGetByFilter",
DbHelper2.mp("@CreatorId", SqlDbType.Int, CreatorId),
DbHelper2.mp("@LastEditorId", SqlDbType.Int, LastEditorId),
DbHelper2.mp("@UserId", SqlDbType.Int, UserId),
DbHelper2.mp("@StartDate", SqlDbType.DateTime, oStartDate),
DbHelper2.mp("@FinishDate", SqlDbType.DateTime, oFinishDate)));
}
/// <summary>
/// ItemId, Title, PriorityId, PriorityName, ItemType, CreationDate, StartDate, FinishDate,
/// TaskTime, TotalMinutes, TotalApproved,
/// PercentCompleted, IsCompleted, ManagerId, ReasonId, ProjectId, StateId, CompletionTypeId,
/// HasRecurrence, ContactUid, OrgUid, ClientName, CategoryId, CategoryName
/// </summary>
/// <returns></returns>
public static DataTable GetListEventsForResourceViewWithCategories(int userId,
int timeZoneId, int languageId, int managerId, int projectId, int categoryId,
bool showActive, DateTime dtCompleted, DateTime dtUpcoming,
PrimaryKeyId orgUid, PrimaryKeyId contactUid)
{
object obj_dtCompleted = (dtCompleted <= DateTime.MinValue.AddDays(1)) ? null : (object)dtCompleted;
object obj_dtUpcoming = (dtUpcoming >= DateTime.MaxValue.AddDays(-1)) ? null : (object)dtUpcoming;
return(DbHelper2.RunSpDataTable(
timeZoneId, new string[] { "CreationDate", "StartDate", "FinishDate" },
"EventsGetForResourceViewWithCategories",
DbHelper2.mp("@UserId", SqlDbType.Int, userId),
DbHelper2.mp("@LanguageId", SqlDbType.Int, languageId),
DbHelper2.mp("@ManagerId", SqlDbType.Int, managerId),
DbHelper2.mp("@ProjectId", SqlDbType.Int, projectId),
DbHelper2.mp("@CategoryId", SqlDbType.Int, categoryId),
DbHelper2.mp("@ShowActive", SqlDbType.Bit, showActive),
DbHelper2.mp("@CompletedDate", SqlDbType.DateTime, obj_dtCompleted),
DbHelper2.mp("@StartDate", SqlDbType.DateTime, obj_dtUpcoming),
DbHelper2.mp("@OrgUid", SqlDbType.UniqueIdentifier, orgUid),
DbHelper2.mp("@ContactUid", SqlDbType.UniqueIdentifier, contactUid)));
}
/// <summary>
/// Returns fields: LogId, LdapId, Dt, UserCount, Title.
/// </summary>
public static DataTable SyncLogGetList(int LogId, int TimeZoneId)
{
return(DbHelper2.RunSpDataTable(TimeZoneId, new string[] { "Dt" }, "LdapSyncLogGetList"
, DbHelper2.mp("@LogId", SqlDbType.Int, LogId)
));
}
/// <summary>
/// UserId, FirstName, LastName, FullName, FullName2
/// </summary>
/// <returns></returns>
public static DataTable GetListEventCreatorsDataTable()
{
return(DbHelper2.RunSpDataTable("EventGetCreators"));
}
/// <summary>
/// UserId, FirstName, LastName, FullName, FullName2
/// </summary>
/// <returns></returns>
public static DataTable GetListEventManagersDataTable()
{
return(DbHelper2.RunSpDataTable("EventGetManagers"));
}
/// <summary>
/// AccountId, ProjectId, Title, OutlineLevel, OutlineNumber, IsSummary, IsCollapsed,
/// TTotal, TCur, TSub,
/// ETotal, ECur, ESub,
/// ATotal, ACur, ASub,
/// TParent, EParent
/// </summary>
/// <returns></returns>
public static DataTable GetListAccountsByProjectCollapsed(int ProjectId, int UserId)
{
return(DbHelper2.RunSpDataTable("AccountsGetByProjectCollapsed",
DbHelper2.mp("@ProjectId", SqlDbType.Int, ProjectId),
DbHelper2.mp("@UserId", SqlDbType.Int, UserId)));
}
/// <summary>
/// UserId, FirstName, LastName, Email, Login
/// </summary>
/// <returns></returns>
public static DataTable GetListUsersForEventDataTable(int EventId)
{
return(DbHelper2.RunSpDataTable("EventSecurityGetByEvent",
DbHelper2.mp("@EventId", SqlDbType.Int, EventId)));
}
public static DataTable GetListAccountsForMoveDataTable(int AccountId)
{
return(DbHelper2.RunSpDataTable("AccountGetListForMove",
DbHelper2.mp("@AccountId", SqlDbType.Int, AccountId)));
}
public static DataTable GetListAccountsDataTable(int ProjectId)
{
return(DbHelper2.RunSpDataTable("AccountGetList",
DbHelper2.mp("@ProjectId", SqlDbType.Int, ProjectId)));
}
/// <summary>
/// ContentTypeId, Extension, ContentTypeString, FriendlyName, IconFileId, BigIconFileId,
/// AllowWebDav, AllowNewWindow, AllowForceDownload
/// </summary>
/// <returns></returns>
public static DataTable GetListContentTypesDataTable()
{
return(DbHelper2.RunSpDataTable("ContentTypesGet"));
}
/*
* ProjectGroupsGet
* [ProjectGroupId], [Title], [Description], [CreationDate], [CreatorId]
*/
public static DataTable GetProjectGroupsDT(int TimeZoneId)
{
return(DbHelper2.RunSpDataTable(
TimeZoneId, new string[] { "CreationDate" },
"ProjectGroupsGet"));
}
/// <summary>
/// Reader returns fields:
/// CalendarId, ProjectId, ProjectName, CalendarName, TimeZoneId, CanDelete
/// </summary>
public static DataTable GetListCalendarsDataTable()
{
return(DbHelper2.RunSpDataTable("CalendarsGet",
DbHelper2.mp("@CalendarId", SqlDbType.Int, 0)));
}
