public void Prefetch()
{
using (PXConnectionScope s = new PXConnectionScope())
{
using (PXDataRecord record = PXDatabase.SelectSingle<Contract>(
new PXDataField<Contract.contractID>(),
new PXDataFieldValue<Contract.nonProject>(1)))
{
ID = record.GetInt32(0) ?? 0;
}
}
}
protected int?getDefaultSiteID()
{
using (PXDataRecord record = PXDatabase.SelectSingle <INSite>(
new PXDataField <INSite.siteID>(),
new PXDataFieldOrder <INSite.siteID>()))
{
if (record != null)
{
return(record.GetInt32(0));
}
}
return(null);
}
public void Prefetch()
{
using (new PXConnectionScope())
{
using (PXDataRecord prefGeneral = PXDatabase.SelectSingle <EPSetup>(
new PXDataField(typeof(EPSetup.firstDayOfWeek).Name)))
{
if (prefGeneral != null)
{
var firstDayValue = prefGeneral.GetInt32(0);
_firstDayOfWeek = firstDayValue == null ? DayOfWeek.Sunday : (DayOfWeek)firstDayValue;
}
}
}
}
private TimeZoneInfo.AdjustmentRule Initialize(DefinitionParameters parameter)
{
DaylightShift row = null;
var id = parameter.Id;
var year = parameter.Year;
using (new PXConnectionScope())
using (PXDataRecord rec = PXDatabase.SelectSingle <DaylightShift>
(
new PXDataField(typeof(DaylightShift.fromDate).Name),
new PXDataField(typeof(DaylightShift.toDate).Name),
new PXDataField(typeof(DaylightShift.shift).Name),
new PXDataFieldValue(typeof(DaylightShift.isActive).Name, PXDbType.Bit, 1),
new PXDataFieldValue(typeof(DaylightShift.year).Name, PXDbType.Int, year),
new PXDataFieldValue(typeof(DaylightShift.timeZone).Name, PXDbType.VarChar, id)
))
{
if (rec != null)
{
row = new DaylightShift();
row.IsActive = true;
row.Year = year;
row.TimeZone = id;
row.FromDate = rec.GetDateTime(0);
row.ToDate = rec.GetDateTime(1);
row.Shift = rec.GetInt32(2);
}
}
if (row == null || string.IsNullOrEmpty(row.TimeZone))
{
return(_systemProvider.FindTimeRegionByTimeZone(id).With(_ => _.GetAdjustmentRule(year)));
}
var start = new DateTime(year, 1, 1);
var end = new DateTime(year, 12, 31);
var delta = TimeSpan.FromMinutes(row.Shift ?? 0);
var tranStart = GetTransitionTime((DateTime)row.FromDate);
var tranEnd = GetTransitionTime((DateTime)row.ToDate);
return(TimeZoneInfo.AdjustmentRule.CreateAdjustmentRule(start, end, delta, tranStart, tranEnd));
}
/// <summary>
/// Append node with specified tutle to favorites.
/// </summary>
private void AddFavorite(string title, Guid?siteId)
{
if (String.IsNullOrEmpty(title) && siteId == null)
{
return;
}
Guid folderID = PXSiteMap.RootNode.NodeID;
string neutralTitle;
using (PXDataRecord record = PXDatabase.SelectSingle <PX.SM.SiteMap>(new PXDataField("Title"),
new PXDataFieldValue("NodeID", siteId)))
{
neutralTitle = record.GetString(0);
}
if (!string.IsNullOrEmpty(neutralTitle))
{
using (PXDataRecord rec_id = PXDatabase.SelectSingle <Favorite>(
new PXDataField("Max(Position)+1"),
new PXDataFieldValue("UserID", PXAccess.GetUserID())))
{
int pos = 1;
if (rec_id != null)
{
pos = rec_id.GetInt32(0) ?? 1;
}
PXDatabase.Insert <Favorite>(
new PXDataFieldAssign("UserID", PXAccess.GetUserID()),
new PXDataFieldAssign("NodeID", Guid.NewGuid()),
new PXDataFieldAssign("Title", neutralTitle),
new PXDataFieldAssign("ParentID", folderID),
new PXDataFieldAssign("Position", pos),
new PXDataFieldAssign("SiteMapID", siteId));
}
}
}
