public Guid?ContactsCache(string email) { if (String.IsNullOrEmpty(email)) { return(null); } lock (_locker) { if (_ContactsCache == null) { _ContactsCache = new Dictionary <string, Guid>(); } Guid result; if (_ContactsCache.TryGetValue(email, out result)) { return(result); } using (PXDataRecord record = PXDatabase.SelectSingle <Contact>(new PXDataField <Contact.noteID>(), new PXDataFieldValue <Contact.eMail>(email), new PXDataFieldValue <Contact.contactType>(ContactTypesAttribute.Person))) { if (record != null && record.GetGuid(0) != null) { _ContactsCache[email] = record.GetGuid(0).Value; return(record.GetGuid(0)); } } } return(null); }
protected virtual void ValidateINUnit(InventoryItem item) { if (item == null) { return; } using (PXDataRecord record = PXDatabase.SelectSingle <INUnit>(new PXDataField <INUnit.toUnit>(), new PXDataFieldValue <INUnit.unitType>(INUnitType.InventoryItem), new PXDataFieldValue <INUnit.inventoryID>(item.InventoryID), new PXDataFieldValue <INUnit.toUnit>(PXDbType.NVarChar, 6, item.BaseUnit, PXComp.NE))) { if (record != null) { throw new PXException(Messages.WrongInventoryItemToUnitValue, record.GetString(0), item.InventoryCD, item.BaseUnit); } } IEnumerable <PXDataRecord> baseConversions = PXDatabase.SelectMulti <INUnit>(new PXDataField <INUnit.toUnit>(), new PXDataFieldValue <INUnit.unitType>(INUnitType.InventoryItem), new PXDataFieldValue <INUnit.inventoryID>(item.InventoryID), new PXDataFieldValue <INUnit.fromUnit>(PXDbType.NVarChar, item.BaseUnit), new PXDataFieldValue <INUnit.toUnit>(PXDbType.NVarChar, item.BaseUnit)); if (baseConversions.Count() != 1) { throw new PXException(Messages.BaseConversionNotFound, item.BaseUnit, item.BaseUnit, item.InventoryCD); } }
/// <summary> /// The tlbPath callback event handler. /// </summary> protected void tlbPath_CallBack(object sender, PXCallBackEventArgs e) { if (e.Command.Name == "AddFav" && PXSiteMap.CurrentNode != null) { Guid nodeID = PXSiteMap.CurrentNode.NodeID; if (!IsInFavorites(nodeID)) { AddFavorite(screenTitle, nodeID); } else { PXDatabase.Delete <Favorite>( new PXDataFieldRestrict("UserID", PXAccess.GetUserID()), new PXDataFieldRestrict("SiteMapID", nodeID) ); } PXContext.Session.FavoritesExists["FavoritesExists"] = null; PXSiteMap.FavoritesProvider.Clear(); // check if favorites exists using (PXDataRecord exist = PXDatabase.SelectSingle <Favorite>( new PXDataField("UserID"), new PXDataFieldValue("UserID", PXAccess.GetUserID()))) { e.Result = (exist == null) ? "0" : "1"; } } }
/// <summary> /// The tlbPath callback event handler. /// </summary> protected void tlbPath_CallBack(object sender, PXCallBackEventArgs e) { if (e.Command.Name == "AddFav" && PXSiteMap.CurrentNode != null) { var currentNode = PXSiteMap.CurrentNode; var entryScreenId = GetEntryNodeId(currentNode.ScreenID); if (!IsInFavoritesLegacy(entryScreenId)) { screenRepository.SetFavoriteForScreen(entryScreenId, true); } else { screenRepository.SetFavoriteForScreen(entryScreenId, false); } PXContext.Session.FavoritesExists["FavoritesExists"] = null; PXSiteMap.FavoritesProvider.Clear(); // check if favorites exists using (PXDataRecord exist = PXDatabase.SelectSingle <Favorite>( new PXDataField("UserID"), new PXDataFieldValue("UserID", PXAccess.GetUserID()))) { e.Result = (exist == null) ? "0" : "1"; } } }
protected void Page_Init(object sender, EventArgs e) { this.usrCaption.CustomizationAvailable = false; this.ds.ReportCode = this.Request.QueryString["ID"]; if (!String.IsNullOrEmpty(this.ds.ReportCode) && this.ds.ReportCode.Contains(".rpx")) { this.ds.ReportCode = this.ds.ReportCode.Replace(".rpx", ""); } string screenID = null; object date = PX.Common.PXContext.GetBusinessDate(); PX.Common.PXContext.SetBusinessDate((DateTime?)date); if (PXSiteMap.CurrentNode != null) { this.Title = PXSiteMap.CurrentNode.Title; screenID = PXSiteMap.CurrentNode.ScreenID; } else { string url = (Request.ApplicationPath != "/" ? Request.Path.Replace(Request.ApplicationPath, "~") : "~" + Request.Path) + "?id=" + this.ds.ReportCode + ".rpx"; PXSiteMapNode node = SiteMap.Provider.FindSiteMapNode(url) as PXSiteMapNode; if (node != null) { this.Title = node.Title; this.usrCaption.ScreenTitle = node.Title; this.usrCaption.ScreenID = PX.Common.Mask.Format("CC.CC.CC.CC", node.ScreenID); screenID = node.ScreenID; } else { using (PXDataRecord record = PXDatabase.SelectSingle <PX.SM.SiteMap>( new PXDataField("ScreenID"), new PXDataFieldValue("Url", PXDbType.VarChar, 512, url) )) { if (record != null) { screenID = record.GetString(0); if (!String.IsNullOrEmpty(screenID) && !PXAccess.VerifyRights(screenID)) { throw new PXSetPropertyException(ErrorMessages.NotEnoughRights, this.ds.ReportCode); } } } } } if (String.IsNullOrEmpty(PX.Common.PXContext.GetScreenID()) && !String.IsNullOrEmpty(screenID)) { PX.Common.PXContext.SetScreenID(PX.Common.Mask.Format(">CC.CC.CC.CC", screenID)); } if (_canSendEmail) { viewer.EmailSend += new PXReportViewer.EmailSendHandler(viewer_EmailSend); } else { viewer.AllowSendEmails = false; } }
/// <summary> /// Check if current node in Favorites. /// </summary> private bool IsInFavoritesLegacy(Guid nodeId) { using (PXDataRecord exist = PXDatabase.SelectSingle <Favorite>( new PXDataField("SiteMapID"), new PXDataFieldValue("SiteMapID", nodeId), new PXDataFieldValue("UserID", PXAccess.GetUserID()))) { return(exist != null); } }
/// <summary> /// Check if current node in Favorites. /// </summary> private bool IsInFavorites(Guid nodeId) { using (PXDataRecord exist = PXDatabase.SelectSingle <MUIFavoriteScreen>( new PXDataField("NodeID"), new PXDataFieldValue("NodeID", nodeId), new PXDataFieldValue("IsPortal", PXSiteMap.IsPortal), new PXDataFieldValue("Username", PXAccess.GetUserLogin()))) { return(exist != null); } }
public void Prefetch() { using (PXDataRecord rec = PXDatabase.SelectSingle <PreferencesSecurity>(new PXDataField <PreferencesSecurityExt.usrApplyWorkgroupRestrictions>())) { if (rec != null) { Enabled = rec.GetBoolean(0) ?? false; } } }
private static bool HasPaymentMethod(int?pMInstanceID) { if (pMInstanceID == null) { return(false); } return(PXDatabase.SelectSingle <CustomerPaymentMethod>( new PXDataField <CustomerPaymentMethod.cCProcessingCenterID>(), new PXDataFieldRestrict <CustomerPaymentMethod.pMInstanceID>(pMInstanceID)) != null); }
/// <summary> /// Check if current node in Favorites. /// </summary> private bool IsInFavorites(Guid?siteId) { Guid nodeID = siteId.HasValue ? siteId.Value : PXSiteMap.CurrentNode.NodeID; using (PXDataRecord exist = PXDatabase.SelectSingle <Favorite>( new PXDataField("SiteMapID"), new PXDataFieldValue("SiteMapID", nodeID), new PXDataFieldValue("UserID", PXAccess.GetUserID()))) { return(exist != null); } }
public void Prefetch() { using (PXDataRecord arSetup = PXDatabase.SelectSingle <ARSetup>( new PXDataField <ARSetup.migrationMode>())) { if (arSetup != null) { isMigrationModeEnabled = (bool)arSetup.GetBoolean(0); } } }
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 static void OnPublished(USCustomizationPlugin plugin, ref List <Tuple <string, object[]> > errors) { string companyName = PXAccess.GetCompanyName(); plugin.WriteLog(PXLocalizer.LocalizeFormatWithKey(USMessages.SomePluginRunning, typeof(USMessages).FullName, companyName)); //Select an Account that is Active PXDataRecord record = PXDatabase.SelectSingle <Account>(new PXDataFieldValue <Account.active>(PXDbType.Bit, true)); if (record == null) { errors.Add(new Tuple <string, object[]>(USMessages.NoActiveAccounts, new object[] { companyName })); } }
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; } } } }
protected virtual void ARInvoice_RowSelecting(PXCache sender, PXRowSelectingEventArgs e) { ARInvoice row = (ARInvoice)e.Row; if (row != null && !String.IsNullOrEmpty(row.DocType) && !String.IsNullOrEmpty(row.RefNbr)) { row.IsCCPayment = false; if (PXDatabase.SelectSingle <CustomerPaymentMethod>( new PXDataField <CustomerPaymentMethod.cCProcessingCenterID>(), new PXDataFieldRestrict <CustomerPaymentMethod.pMInstanceID>(row.pMInstanceID)) != null) { row.IsCCPayment = true; } } }
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)); }
public void Prefetch(PXDatabaseUSProvider provider) { PXDataRecord record = PXDatabase.SelectSingle <USSetup>(new PXDataField <USSetup.enableInAP>(), new PXDataField <USSetup.simpleNumberingID>()); if (record == null) { _featureActive = false; } else { if (record.GetBoolean(0) ?? false) { _featureActive = true; } else { _featureActive = false; } } }
/// <summary> /// The tlbPath callback event handler. /// </summary> protected void tlbPath_CallBack(object sender, PXCallBackEventArgs e) { if (e.Command.Name == "AddFav" && PXSiteMap.CurrentNode != null) { Guid nodeID = PXSiteMap.CurrentNode.NodeID; if (!IsInFavorites(nodeID)) { AddFavorite(screenTitle, nodeID); } else { PXDatabase.Delete <Favorite>( new PXDataFieldRestrict("UserID", PXAccess.GetUserID()), new PXDataFieldRestrict("SiteMapID", nodeID) ); } PXContext.Session.FavoritesExists["FavoritesExists"] = null; PXSiteMap.FavoritesProvider.Clear(); // check if favorites exists using (PXDataRecord exist = PXDatabase.SelectSingle <Favorite>( new PXDataField("UserID"), new PXDataFieldValue("UserID", PXAccess.GetUserID()))) { e.Result = (exist == null) ? "0" : "1"; } } else if (e.Command.Name == "ClearFilter") { var ds = PXPage.GetDefaultDataSource(this.Page); if (ds != null) { var action = ds.DataGraph.Actions[clearFilterCommand]; if (action != null) { action.Press(); } } PXCallbackManager.RegisterJavaScript( "if (window['__px_alls'] && __px_alls(this) && __px_alls(this)['tlbPath'])__px_alls(this)['tlbPath'].items['clearFilter'].setVisible(false);"); } }
public static bool IsEntityInUse <Table>(params object[] keys) where Table : IBqlTable { if (Attribute.IsDefined(typeof(Table), typeof(EntityInUseDBSlotOnAttribute))) { var slot = PXDatabase.GetSlot <EntityInUseDefinition <Table> >(typeof(EntityInUseDefinition <Table>).FullName, typeof(Table)); return(keys.Length != 0 ? slot.EntitiesInUse.Contains(GetHash <Table>(keys)) : slot.EntitiesInUse.Any()); } else { KeysCollection cacheKeys = GetCacheKeys <Table>(); if (keys.Length != 0 && cacheKeys.Count() != keys.Length) { throw new PXArgumentException(nameof(keys)); } var fields = new PXDataField[cacheKeys.Count * (keys.Length != 0 ? 2 : 1)]; for (int i = 0; i < cacheKeys.Count; i++) { string cacheKey = cacheKeys[i]; fields[i] = new PXDataField(cacheKey); if (keys.Length != 0) { fields[cacheKeys.Count + i] = new PXDataFieldValue(cacheKey, keys[i]); } } using (PXDataRecord record = PXDatabase.SelectSingle <Table>(fields)) { return(record != null); } } }
/// <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)); } } }
protected void Page_Init(object sender, EventArgs e) { // remove unum parameter PropertyInfo isreadonly = typeof(System.Collections.Specialized.NameValueCollection).GetProperty("IsReadOnly", BindingFlags.Instance | BindingFlags.NonPublic); // make collection editable isreadonly.SetValue(this.Request.QueryString, false, null); this.Request.QueryString.Remove(PXUrl.UNum); isreadonly.SetValue(this.Request.QueryString, true, null); this.usrCaption.CustomizationAvailable = false; var date = PXContext.GetBusinessDate(); PX.Common.PXContext.SetBusinessDate((DateTime?)date); if ((this.viewer.SchemaUrl = this.Request.QueryString["ID"]) == null) { this.viewer.SchemaUrl = ReportID; } if (SiteMap.CurrentNode != null) { this.Title = PXSiteMap.CurrentNode.Title; _screenID = PXSiteMap.CurrentNode.ScreenID; } else { string url; if (Request.ApplicationPath != "/") { url = Request.Path.Replace(Request.ApplicationPath, "~") + "?ID=" + this.viewer.SchemaUrl; } else if (Request.Path.StartsWith("/")) { url = "~" + Request.Path; } else { url = Request.Path; } PXSiteMapNode node = SiteMap.Provider.FindSiteMapNode(url) as PXSiteMapNode; if (node != null) { this.Title = node.Title; this.usrCaption.ScreenTitle = node.Title; this.usrCaption.ScreenID = PX.Common.Mask.Format(">CC.CC.CC.CC", node.ScreenID); _screenID = node.ScreenID; } else { using (PXDataRecord record = PXDatabase.SelectSingle <PX.SM.SiteMap>( new PXDataField("ScreenID"), new PXDataFieldValue("Url", PXDbType.VarChar, 512, url) )) { if (record != null) { _screenID = record.GetString(0); if (!String.IsNullOrEmpty(_screenID) && !PXAccess.VerifyRights(_screenID)) { throw new PXSetPropertyException(ErrorMessages.NotEnoughRights, this.viewer.SchemaUrl); } } } } } if (String.IsNullOrEmpty(PX.Common.PXContext.GetScreenID())) { if (String.IsNullOrEmpty(_screenID) && !String.IsNullOrEmpty(this.viewer.SchemaUrl)) { string schema = this.viewer.SchemaUrl; if (schema.EndsWith(".rpx", StringComparison.OrdinalIgnoreCase)) { schema = schema.Substring(0, schema.Length - 4); } if (schema.Length == 8) { _screenID = schema; } } if (!String.IsNullOrEmpty(_screenID)) { PX.Common.PXContext.SetScreenID(PX.Common.Mask.Format(">CC.CC.CC.CC", _screenID)); } } if (_canSendEmail) { viewer.EmailSend += new PXReportViewer.EmailSendHandler(viewer_EmailSend); } else { viewer.AllowSendEmails = false; } }