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