public static FilterParams GetDefaultFilter(IEnumerable <SearchPanelMetaItem> searchPanel, IObject initSource) { var filter = new FilterParams(); foreach (var item in searchPanel) { if (item.DefaultValue != null) { if (item.IsRange) { if (item.EditorType == EditorType.Date || item.EditorType == EditorType.Datetime) { filter.Add(item.Name, ">=", item.DefaultValue.Invoke(initSource)); filter.Add(item.Name, "<=", DateTime.Now.Date.AddDays(1).AddSeconds(-1)); } else { filter.Add(item.Name, "<=", item.DefaultValue.Invoke(initSource)); filter.Add(item.Name, ">=", item.DefaultValue.Invoke(initSource)); } } else { string operation = item.DefaultOper; if (String.IsNullOrWhiteSpace(operation)) { operation = item.EditorType == EditorType.Text ? "like" : "="; } filter.Add(item.Name, operation, item.DefaultValue.Invoke(initSource)); } } } return(filter); }
public ActionResult ThisWeekSearch() { var filter = new FilterParams(); filter.Add("datEnteredDate", ">=", DateTime.Today.AddDays(-7)); filter.Add("idfPerson", "=", false); Session["Filter"] = filter; return(RedirectToAction("ListForm")); }
public static FilterParams CetTestFilters() { var ret = new FilterParams(); ret.Add("par11", "like", "%Value%"); ret.Add("par21", ">=", 2); ret.Add("par22", "<=", 5); return(ret); }
public void CreateExcludeTemplateList() { Asset siteroot = Asset.GetSiteRoot(this.asset); Asset templatesRoot; if (string.IsNullOrEmpty(siteroot.Raw[""])) { templatesRoot = Asset.Load("/System/Templates"); } else { throw new NotImplementedException(); } FilterParams fp = new FilterParams(); fp.ExcludeProjectTypes = false; fp.Add(Comparison.Equals, AssetType.Folder); var templates = templatesRoot.GetFilterList(fp); var entries = new Dictionary <string, string>(templates.Count); foreach (var tpl in templates.OrderBy(_ => _.AssetPath.ToString())) { string title = string.Format("{0} ({1})", tpl.Label, tpl.AssetPath.GetParent()); entries.Add(title, tpl.Id.ToString()); } Input.ShowSelectList("Exclude Templates", "exclude_template_list", entries, size: 10); }
public new Task <UserPreferencesV1> GetOneByIdAsync(string correlationId, string userId) { var filterParams = new FilterParams(); filterParams.Add("user_id", userId); return(base.GetOneRandomAsync(correlationId, ComposeFilter(filterParams))); }
public ActionResult ExtendedSearchResult() { FilterParams filter = SearchPanelHelper.SearchPanelParseValues(Request.QueryString); filter.Add("idfPerson", "=", false); Session["Filter"] = filter; return(RedirectToAction("ListForm", new { isExtendedSearch = true })); }
public ActionResult MyCasesSearch() { var filter = new FilterParams(); filter.Add("idfPerson", "=", true); Session["Filter"] = filter; return(RedirectToAction("ListForm")); }
public async Task <SettingSectionV1> GetOneByIdAsync(string correlationId, string id) { FilterParams filter = new FilterParams(); filter.Add("id", id); return(await base.GetOneRandomAsync(correlationId, ComposeFilter(filter))); }
private static FilterParams GetFilterForPatientsList(Patient patientInfoForSearch) { var filter = new FilterParams(); if (patientInfoForSearch.CurrentResidenceAddress.Region != null) { filter.Add("idfsRegion", "=", patientInfoForSearch.CurrentResidenceAddress.Region.idfsRegion); } if (patientInfoForSearch.CurrentResidenceAddress.Rayon != null) { filter.Add("idfsRayon", "=", patientInfoForSearch.CurrentResidenceAddress.Rayon.idfsRayon); } if (!string.IsNullOrEmpty(patientInfoForSearch.strFirstName)) { filter.Add("strFirstName", "like", String.Format("%{0}%", patientInfoForSearch.strFirstName)); } if (!string.IsNullOrEmpty(patientInfoForSearch.strSecondName)) { filter.Add("strSecondName", "like", String.Format("%{0}%", patientInfoForSearch.strSecondName)); } if (!string.IsNullOrEmpty(patientInfoForSearch.strLastName)) { filter.Add("strLastName", "like", String.Format("%{0}%", patientInfoForSearch.strLastName)); } if (patientInfoForSearch.datDateofBirth.HasValue) { filter.Add("datDateofBirth", ">=", patientInfoForSearch.datDateofBirth.Value); filter.Add("datDateofBirth", "<", patientInfoForSearch.datDateofBirth.Value.AddDays(1)); } return(filter); }
static void AddExpression(FilterParams pars, string fieldName, object val) { if (val is string) { pars.Add(fieldName, "=", val); } else if (val is DateTime) { pars.Add(fieldName, ">=", ((DateTime)val).Date); pars.Add(fieldName, "<", ((DateTime)val).Date.AddDays(1)); } else if (val is BaseReferenceItem) { long?id = ((BaseReferenceItem)val).Id; if (id != null && id.Value != 0) { pars.Add(fieldName, "=", id); } } }
public async Task <LimitV1> GetOneByUserIdAsync(string correlationId, string userId) { var filter = new FilterParams(); var paging = new PagingParams(); filter.Add("user_id", userId); var result = await GetPageByFilterAsync(correlationId, ComposeFilter(filter), paging); var data = result.Data.ConvertAll <LimitV1>(x => ToPublic(x)); return(data[0]); }
public void OnPostPublish(Asset asset, PostPublishContext context) { context.RenderPublishLinks = true; using (var Logger = new CrownPeak.CMSAPI.CustomLibrary.UtilLogLogger("SitemapIndex.OnPostPublish", asset)) { foreach (var panel in asset.GetPanels("sitemap_roots")) { var sitemapAssetsList = new List <Asset>(); if (string.IsNullOrEmpty(panel["sitemap_asset"]) == false) { Asset sitemapAsset = Asset.Load(panel["sitemap_asset"]); if (sitemapAsset.IsLoaded == true) { sitemapAssetsList.Add(sitemapAsset); } } if (string.IsNullOrEmpty(panel["multi_sitemap_root_path"]) == false && string.IsNullOrEmpty(panel["multi_sitemap_template_id"]) == false) { try { FilterParams fp = new FilterParams(); fp.Add(AssetPropertyNames.TemplateId, Comparison.Equals, int.Parse(panel["multi_sitemap_template_id"])); Asset rootfolder = Asset.Load(panel["multi_sitemap_root_path"]); var foundAssets = rootfolder.GetFilterList(fp); sitemapAssetsList.AddRange(foundAssets); } catch (Exception) { } } Logger.Info("sitemapAssetsList count is '{0}'.", sitemapAssetsList.Count); foreach (var sitemapAsset in sitemapAssetsList) { if (sitemapAsset.IsLoaded) { sitemapAsset.Publish(publishDependencies: false); string sitemapUrl = sitemapAsset.GetLink(addDomain: true, protocolType: ProtocolType.Https); Logger.Info("Ping search engines for '{0}'.", sitemapUrl); var sitemapsPinger = new CPContrib.SiteMap.SitemapsPinger(Logger); sitemapsPinger.Ping(sitemapUrl); } } } } //Logger.Flush(); }
private List <OrganizationListItem> GetOrganizationsList(string textForSearch) { var accessor = OrganizationListItem.Accessor.Instance(null); var filter = new FilterParams(); string searchPattern = GetSearchPattern(textForSearch); filter.Add("name", "LIKE", searchPattern); using (var dbmanager = DbManagerFactory.Factory.Create(ModelUserContext.Instance)) { List <OrganizationListItem> organizations = accessor.SelectListT(dbmanager, filter); return(organizations); } }
public static FilterParams DuplicatesFilter(HttpRequestBase request) { var result = new FilterParams(); foreach (var key in request.QueryString.AllKeys) { if (String.IsNullOrWhiteSpace(request.QueryString[key])) { continue; } if (key == "idfsTentativeDiagnosis" && !String.IsNullOrWhiteSpace(request.QueryString["idfsFinalDiagnosis"])) { continue; } result.Add(key, "=", request.QueryString[key]); } return(result); }
public static void Add(this FilterParams filterParams, string param, string oper, object inputVal, EditorType editorType = EditorType.Text) { switch (editorType) { case EditorType.Numeric: { decimal preValue = 0; decimal.TryParse(inputVal.ToString(), out preValue); inputVal = preValue; } break; case EditorType.Date: case EditorType.Datetime: { DateTime preValue = new DateTime(); if (!DateTime.TryParse(inputVal.ToString(), out preValue)) { inputVal = null; } } break; case EditorType.Flag: { bool preValue = false; bool.TryParse(inputVal.ToString(), out preValue); inputVal = preValue; } break; default: { inputVal = inputVal.ToString(); } break; } filterParams.Add(param, oper, inputVal); }
public static Asset GetMasterPage(Asset asset, int masterTemplateId, string masterIdentifier = "_Master") { try { Asset result = null; Asset masterFolder = GetSiteRoot(asset, masterIdentifier); if (Log.IsDebugEnabled) { Log.Debug("GetSiteRoot returns {0}", masterFolder); } if (null != masterFolder) { FilterParams filter = new FilterParams(); filter.Limit = 1; filter.Add(AssetPropertyNames.TemplateId, Comparison.Equals, masterTemplateId); result = masterFolder.GetFilterList(filter).FirstOrDefault(x => x.WorkflowStatus.Name == asset.WorkflowStatus.Name); if (null == result) { filter.SetFilterStatus(new string[] { "", "Draft", "Stage", "Live" }); result = masterFolder.GetFilterList(filter).FirstOrDefault(); } } if (Log.IsTraceEnabled) { Log.Trace("getmasterpage result={0}", result); } return(result); } catch (Exception ex) { Log.Error("GetMasterPage", ex); throw; } }
static void AddExpression(FilterParams pars, string fieldName, object val, OperationType oper) { if (val is string) { pars.Add(fieldName, Oper(oper), val); } else if (val is long) { pars.Add(fieldName, Oper(oper), (long)val); } else if (val is DateTime) { pars.Add(fieldName, Oper(oper), ((DateTime)val).Date); } else if (val is Reference) { long id = ((Reference)val).RecordID; if (id != 0) { pars.Add(fieldName, Oper(oper), id); } } else if (val is GisReference) { long id = ((GisReference)val).RecordID; if (id != 0) { pars.Add(fieldName, Oper(oper), id); } } else if (val is Diagnosis) { long id = ((Diagnosis)val).RecordID; if (id != 0) { pars.Add(fieldName, Oper(oper), id); } } }
public static void RenderInput(Asset asset, InputContext context) { //------------------------------------ // Global //------------------------------------ Dictionary<string, string> dicSiteType = new Dictionary<string, string>(); dicSiteType.Add("Single Site", "single"); dicSiteType.Add("Site Collection", "collection"); dicSiteType.Add("Site Collection with TMF", "collection_tmf"); Dictionary<string, string> dicMobile = new Dictionary<string, string>(); dicMobile.Add("None", "no"); dicMobile.Add("Responsive", "responsive"); dicMobile.Add("Dual Output", "dual_output"); dicMobile.Add("Dedicated", "dedicated"); Dictionary<string, string> dicSelectOptions = new Dictionary<string, string>(); dicSelectOptions.Add("Dropdown", "dropdown"); dicSelectOptions.Add("Create New", "create_new"); ShowAcquireParams sapModel = new ShowAcquireParams(); sapModel.DefaultFolder = "/System/Models/"; sapModel.ShowUpload = false; //Country data FilterParams fpCountry = new FilterParams(); fpCountry.Add(AssetPropertyNames.TemplateLabel, Comparison.Equals, "Country Sites Config"); Asset aCountryFolder = Asset.Load("/System/Translation Model Framework/Global/Country Sites Config/"); Dictionary<string, string> dicCountries = new Dictionary<string, string>(); if (aCountryFolder.IsLoaded) { foreach (Asset aFile in aCountryFolder.GetFilterList(fpCountry)) { if (!dicCountries.Keys.Contains(aFile.Label)) { dicCountries.Add(aFile.Label, aFile.Label); } } } //Language Data FilterParams fpLanguage = new FilterParams(); fpLanguage.Add(AssetPropertyNames.TemplateLabel, Comparison.Equals, "Language"); Asset aLanguageFolder = Asset.Load("/System/Translation Model Framework/Global/Languages Config/"); Dictionary<string, string> dicLanguages = new Dictionary<string, string>(); if (aLanguageFolder.IsLoaded) { foreach (Asset aFile in aLanguageFolder.GetFilterList(fpLanguage)) { if (!dicLanguages.Keys.Contains(aFile.Label)) { dicLanguages.Add(aFile.Label, aFile.Label); } } } //CP public sites Dictionary<string, string> dicCPSites = new Dictionary<string, string>(); string szPublicSiteXML = GetPageSource("http://mtistage.cp-access.com/sitebuilder/cp-public/site-list.xml"); if (szPublicSiteXML.Contains("<sites>")) { List<XmlNode> lsXml = Util.LoadXml(szPublicSiteXML, "file"); foreach (XmlNode xNode in lsXml) { dicCPSites.Add(xNode.Attributes["name"], xNode.Value); } } //CP Training Dictionary<string, string> dicCPTraining = new Dictionary<string, string>(); string szTrainingXML = GetPageSource("http://mtistage.cp-access.com/sitebuilder/cp-training/site-list.xml"); if (szTrainingXML.Contains("<sites>")) { List<XmlNode> lsXml = Util.LoadXml(szTrainingXML, "file"); foreach (XmlNode xNode in lsXml) { dicCPTraining.Add(xNode.Attributes["name"], xNode.Value); } } //Partner Private sites Dictionary<string, string> dicPrivateSites = new Dictionary<string, string>(); if (!string.IsNullOrWhiteSpace(asset.Raw["private_key"])) { string szPrivateSiteXML = GetPageSource(asset.Raw["private_key"]); if (szPrivateSiteXML.Contains("<sites>")) { List<XmlNode> lsXml = Util.LoadXml(szPrivateSiteXML, "file"); foreach (XmlNode xNode in lsXml) { dicPrivateSites.Add(xNode.Attributes["name"], xNode.Value); } } } //------------------------------------ // Input Form //------------------------------------ Input.StartTabbedPanel("Import Setup", "Configuration"); string szLog = GetPageSource("http://mtistage.cp-access.com/SiteBuilder/Import-Log.xml"); if (!string.IsNullOrWhiteSpace(szLog)) { Input.StartControlPanel("Log"); Input.ShowTextBox("", "log_message", szLog, height: 20, readOnly: true); Input.EndControlPanel(); } Input.StartDropDownContainer("Site Builder Type", "sitebuilder_type", new Dictionary<string, string> { { "Build Site", "site_build" }, { "Add Extension", "site_extension" } }); Input.StartDropDownContainer("Technology List Options", "technology_list_option", new Dictionary<string, string>() { { "CP Public", "public" }, { "CP Training", "training" }, { "Private", "private" }, { "Local", "local" } }, "public"); //----------------------------------------- // CP Public Sites //----------------------------------------- Input.ShowDropDown("CrownPeak Technology Stacks", "cp_language_type", dicCPSites); Input.NextDropDownContainer(); //----------------------------- // CP Training Sites //----------------------------- Input.ShowDropDown("Training Technology Stacks", "training_language_type", dicCPTraining); Input.NextDropDownContainer(); //----------------------------- // Partner Private Folder //----------------------------- if (!string.IsNullOrWhiteSpace(asset.Raw["private_key"])) { Input.ShowDropDown("Private Technology Stacks", "private_language_type", dicPrivateSites); Input.AddHiddenField("private_language_exist", "true"); } else { Input.AddHiddenField("private_language_exist", "false"); Input.ShowMessage("Enter private key in Configuration tab, save and refesh the form"); Input.ShowMessage("Ask CrownPeak support how to set up a private key"); } //----------------------------- // Local File //----------------------------- Input.NextDropDownContainer(); Input.ShowAcquireDocument("Select a File", "local_file", helpMessage: "Select a local XML file"); Input.EndDropDownContainer(); //----------------------------- // Site Structure Setting //----------------------------- Input.ShowDropDown("Project Level", "project_level", new Dictionary<string, string> { { "Root", "root" }, { "Nested", "nested" }, { "System", "system" } }, Util.MakeList("root")); Input.StartDropDownContainer("Collection Folder", "collection_folder_type", new Dictionary<string, string> { { "New", "new" }, { "Select", "select" } }, "new"); Input.ShowTextBox("New Folder", "collection_new"); Input.NextDropDownContainer(); Input.ShowSelectFolder("Select", "collection_select"); Input.EndDropDownContainer(); Input.ShowTextBox("Site Root Name", "site_root_name"); Input.ShowTextBox("Project Name", "project_name"); //----------------------------- // Add Extension //----------------------------- Input.NextDropDownContainer(); Dictionary<string, string> dicExtensionTypes = new Dictionary<string, string>(); dicExtensionTypes.Add("TMF", "ext_tmf"); dicExtensionTypes.Add("Blog", "ext_blog"); dicExtensionTypes.Add("Release management", "ext_release_management"); dicExtensionTypes.Add("Metadata Management", "ext_metadata_management"); dicExtensionTypes.Add("Deep Clone Site", "ext_deep_clone"); dicExtensionTypes.Add("Clone and Convert", "ext_clone_convert"); Input.StartDropDownContainer("Extension Type", "extension_types", dicExtensionTypes); Input.ShowSelectFolder("Project Folder", "tmf_project_folder", "/", helpMessage: "Skip if the site doesn't use any Project folder"); Input.StartControlPanel("Master Site"); Input.StartHorizontalWrapContainer(); Input.StartDropDownContainer("Country Select", "tmf_master_country_option", dicSelectOptions, "dropdown"); Input.ShowDropDown("Country", "tmf_master_country_select", dicCountries); Input.NextDropDownContainer(); Input.ShowTextBox("Country Name", "new_master_country_name", width: 30, helpMessage: "United States, England, etc"); Input.EndDropDownContainer(); Input.StartDropDownContainer("Language Select", "tmf_master_language_option", dicSelectOptions, "dropdown"); Input.ShowDropDown("Language", "tmf_master_lang_select", dicLanguages); Input.NextDropDownContainer(); Input.ShowTextBox("Language Name", "new_master_language_name", width: 30, helpMessage: "English, Spanish, etc"); Input.EndDropDownContainer(); Input.EndHorizontalWrapContainer(); Input.ShowSelectFolder("Main Site", "tmf_master_main_site", "/"); Input.ShowTextBox("Rename Main Site", "tmf_master_main_site_rename"); Input.EndControlPanel(); while (Input.NextPanel("tmf_locale_panel", displayName: "Locale List")) { Input.StartHorizontalWrapContainer(); Input.StartDropDownContainer("Country Select", "tmf_country_option", dicSelectOptions, "dropdown"); Input.ShowDropDown("Country", "tmf_country_select", dicCountries); Input.NextDropDownContainer(); Input.ShowTextBox("Country Name", "new_country_name", width: 30, helpMessage: "United States, England, etc"); Input.EndDropDownContainer(); Input.StartDropDownContainer("Language Select", "tmf_language_option", dicSelectOptions, "dropdown"); Input.ShowDropDown("Language", "tmf_lang_select", dicLanguages); Input.NextDropDownContainer(); Input.ShowTextBox("Language Name", "new_language_name", width: 30, helpMessage: "English, Spanish, etc"); Input.EndDropDownContainer(); Input.EndHorizontalWrapContainer(); Input.ShowTextBox("Locale Name", "locale_name", helpMessage: "US-EN, AR-ES, etc"); } Input.NextDropDownContainer(); Input.NextDropDownContainer(); Input.NextDropDownContainer(); Input.NextDropDownContainer(); Input.NextDropDownContainer(); Input.EndDropDownContainer(); Input.EndDropDownContainer(); Input.StartControlPanel("Workflow"); Dictionary<string, string> dicWorkflow = new Dictionary<string, string>(); AssetParams apWorkflow = new AssetParams(); apWorkflow.ExcludeProjectTypes = false; foreach (Asset aWorkflow in Asset.Load("/System/Workflows/").GetFileList(apWorkflow)) { if (!dicWorkflow.Keys.Contains(aWorkflow.Label)) dicWorkflow.Add(aWorkflow.Label, aWorkflow.Label); } //Input.ShowTextBox("Workflow Name", "workflow_name", helpMessage: "Leaving blank will create assets without any workflow"); Input.ShowDropDown("Workflow", "workflow_name", dicWorkflow); Input.EndControlPanel(); Input.NextTabbedPanel(); Input.ShowMessage("Enter private key, save and refesh the form"); Input.ShowTextBox("Private Site Key", "private_key"); Input.EndTabbedPanel(); }
private static void CreateTMFRelationship(Asset masterLocale, Asset childLocale, IhSiteBuilderLog siteLog = null) { string szSiteName = IhSiteBuilderTMFHelper.GetSitePath(masterLocale).Parent.Label; Asset aSourceLanguageContent = masterLocale; Asset aDestinationLanguageContent = childLocale; Asset aFolderSource = Asset.Load(aSourceLanguageContent["folder_root"]); Asset aFolderDest = Asset.Load(aDestinationLanguageContent["folder_root"]); Asset aTemplConfig = Asset.Load(IhSiteBuilderTMFHelper.GetSitePath(masterLocale) + "/TMF Config/Templates configuration"); FilterParams fpFilter = new FilterParams(); fpFilter.Add(Comparison.Equals, AssetType.File); fpFilter.SortOrder = SortOrder.OrderBy(AssetPropertyNames.Label); fpFilter.Add(AssetPropertyNames.Label, Comparison.NotInSet, Util.MakeList(".jpeg", ".jpg", ".gif", ".png", ".js", ".css", ".pdf", ".doc", ".docx")); List<Asset> laPackageList = Asset.Load(aFolderSource.Id).GetFilterList(fpFilter); foreach (Asset aPackage in laPackageList) { int nSourceId = aPackage.Id; Asset aContentSource = Asset.Load(nSourceId); if (!string.Equals(aContentSource.TemplateId.ToString(), "0") && string.IsNullOrWhiteSpace(aTemplConfig["tmftemplate_" + aContentSource.TemplateId.ToString()])) { string szSourcePath = aContentSource.AssetPath.ToString(); string szDestinationPath = szSourcePath.Replace(aSourceLanguageContent["folder_root"], aDestinationLanguageContent["folder_root"]); int nDestinationId = Asset.Load(szDestinationPath).Id; int nRelationshipId = 0; string szDestStatus = ""; if (nDestinationId <= 0) { szDestStatus = "DESTINATION LABEL NOT FOUND, "; List<Asset> laConfigList = IhSiteBuilderTMFHelper.GetRelList(nSourceId, "source", szSiteName); nDestinationId = 0; foreach (Asset aConfigList in laConfigList) { if (Asset.Load(aConfigList["destination_id"]).AssetPath.ToString().ToLower().Contains(aDestinationLanguageContent["folder_root"].ToLower())) { nDestinationId = Convert.ToInt32(aConfigList["destination_id"]); nRelationshipId = aConfigList.Id; break; } } } else nRelationshipId = Asset.Load(IhSiteBuilderTMFHelper.GetSitePath(masterLocale) + "/Relationship config/" + nSourceId.ToString() + "-" + nDestinationId.ToString()).Id; string szStatus = ""; Asset aContentDest = Asset.Load(nDestinationId); if (nRelationshipId <= 0) { if (aContentSource.Id > 0 && aContentDest.Id > 0) { siteLog.Add("aContentSource: " + aContentSource.AssetPath); siteLog.Add("aContentDest: " + aContentDest.AssetPath); siteLog.Add("Master Locale: " + IhSiteBuilderTMFHelper.GetSitePath(masterLocale).AssetPath); IhSiteBuilderTMFHelper.AutoLinkLocales(aContentSource, aContentDest, IhSiteBuilderTMFHelper.GetSitePath(masterLocale).AssetPath.ToString()); IhSiteBuilderTMFHelper.FixRelativeLinks(aContentDest, masterLocale, childLocale, IhSiteBuilderTMFHelper.GetSitePath(masterLocale).AssetPath.ToString()); szStatus = "RELATIONSHIP CREATED, SourceID= " + nSourceId.ToString() + " DestID= " + nDestinationId.ToString(); } else szStatus = "SKIPPED, SourceID= " + nSourceId.ToString() + " DestID= " + nDestinationId.ToString(); } else szStatus = "RELATIONSHIP ALREADY EXISTS, SourceID= " + nSourceId.ToString() + " DestID= " + nDestinationId.ToString() + " Relationship ID= " + nRelationshipId.ToString(); szStatus = szDestStatus + szStatus; siteLog.Add(szStatus); } } }
/// <summary> /// Get FilterParams by linked content /// </summary> /// <param name="linkedContent"></param> /// <returns></returns> public static FilterParams GetFilterParams(IObject obj, LinkedContent linkedContent) { var filterParams = new FilterParams(); var notComboboxLinkedContext = linkedContent.m_LinkedItems.Where(s => s.MetaItem.Location != SearchPanelLocation.Combobox && s.MetaItem.Location != SearchPanelLocation.Toolbox); var comboboxLinkedContext = linkedContent.m_LinkedItems.Where(s => s.MetaItem.Location == SearchPanelLocation.Combobox || s.MetaItem.Location == SearchPanelLocation.Toolbox); foreach ( var control in notComboboxLinkedContext.Where(f => f.MetaItem.EditorType == EditorType.Text)) { string valText = control.Controls.First().Text == null ? null : control.Controls.First().Text.Trim(); if (!String.IsNullOrEmpty(valText)) { filterParams.Add(control.MetaItem.Name, Utils.IsEmpty(control.MetaItem.DefaultOper) ? "Like" : control.MetaItem.DefaultOper, valText); } else if (control.MetaItem.Mandatory(obj)) { throw new ValidationModelException("strSearchPanelMandatoryFields_msgId", control.MetaItem.Name, control.MetaItem.Name, null, typeof(RequiredValidator), ValidationEventType.Error, obj); } } foreach ( var control in notComboboxLinkedContext.Where(f => f.MetaItem.EditorType == EditorType.Numeric).Where( f => f.MetaItem.IsRange == false) /*.Where(d => !string.IsNullOrWhiteSpace(d.Controls.First().Text))*/) { if (!control.Controls.First().Visible) { object val = obj.GetValue(control.MetaItem.Name); if (val != null) { filterParams.Add(control.MetaItem.Name, Utils.IsEmpty(control.MetaItem.DefaultOper) ? "=" : control.MetaItem.DefaultOper, val, EditorType.Numeric); } } if (!Utils.IsEmpty(control.Controls.First().EditValue)) { filterParams.Add(control.MetaItem.Name, Utils.IsEmpty(control.MetaItem.DefaultOper) ? "=" : control.MetaItem.DefaultOper, control.Controls.First().Text, EditorType.Numeric); } } foreach ( var control in notComboboxLinkedContext.Where(f => f.MetaItem.EditorType == EditorType.Numeric).Where(f => f.MetaItem.IsRange)) { List <BaseEdit> contr = control.Controls.ToList(); if (!Utils.IsEmpty(contr[0].EditValue)) { filterParams.Add(control.MetaItem.Name, ">=", contr[0].Text, EditorType.Numeric); } if (!Utils.IsEmpty(contr[1].EditValue)) { filterParams.Add(control.MetaItem.Name, "<=", contr[1].Text, EditorType.Numeric); } } foreach ( var control in notComboboxLinkedContext.Where(f => f.MetaItem.EditorType == EditorType.Date).Where( f => f.MetaItem.IsRange == false).Where(d => !string.IsNullOrWhiteSpace(d.Controls.First().Text))) { if (!Utils.IsEmpty(control.Controls.First().EditValue)) { var start = control.Controls.First().EditValue as DateTime?; if (start.HasValue) { filterParams.Add(control.MetaItem.Name, string.IsNullOrEmpty(control.MetaItem.DefaultOper) ? "=" : control.MetaItem.DefaultOper, start.Value, EditorType.Date); } } } foreach ( var control in notComboboxLinkedContext.Where(f => f.MetaItem.EditorType == EditorType.Date).Where(f => f.MetaItem.IsRange)) { List <BaseEdit> contr = control.Controls.ToList(); bool bStart = false; var start = contr[0].EditValue as DateTime?; if (start.HasValue) { filterParams.Add(control.MetaItem.Name, ">=", start.Value, EditorType.Date); bStart = true; } bool bEnd = false; var end = contr[1].EditValue as DateTime?; if (end.HasValue) { filterParams.Add(control.MetaItem.Name, "<", end.Value.AddDays(1), EditorType.Date); bEnd = true; } if (control.MetaItem.Mandatory(obj) && (!bStart || !bEnd)) { throw new ValidationModelException("strSearchPanelMandatoryFields_msgId", control.MetaItem.Name, control.MetaItem.Name, null, typeof(RequiredValidator), ValidationEventType.Error, obj); } } foreach ( var control in notComboboxLinkedContext.Where(f => f.MetaItem.EditorType == EditorType.Lookup && !f.MetaItem.IsMultiple)) { var cntrl = (control.Controls.First() as LookUpEdit); var lookUpEditValue = cntrl.EditValue as IObject; //if (!Utils.IsEmpty(lookUpEditValue)) if (lookUpEditValue != null) { if ((long)lookUpEditValue.Key != 0) { filterParams.Add(control.MetaItem.Name, "=", lookUpEditValue.Key); } } else if (!Utils.IsEmpty(cntrl.EditValue)) //This is the case of Case_Status lookup, we use custom values for it { filterParams.Add(control.MetaItem.Name, "=", cntrl.EditValue); } } foreach ( var control in notComboboxLinkedContext.Where(f => f.MetaItem.EditorType == EditorType.Lookup && f.MetaItem.IsMultiple)) { var cntrl = (control.Controls.First() as PopupContainerEdit); var container = cntrl.Properties.PopupControl; var list = container.Controls[0] as CheckedListBoxControl; foreach (var i in list.CheckedItems) { var o = i as IObject; if (o == null) { continue; } if (0L.Equals(o.Key)) { continue; } if (control.MetaItem.IsBitMask) { filterParams.Add(control.MetaItem.Name, "&", o.Key, true); } else { filterParams.Add(control.MetaItem.Name, "=", o.Key, true); } } } foreach ( var control in comboboxLinkedContext.Where(f => f.MetaItem.IsMultiple)) { var cntrl = (control.Controls.ToArray()[2] as PopupContainerEdit); var container = cntrl.Properties.PopupControl; var list = container.Controls[0] as CheckedListBoxControl; foreach (var i in list.CheckedItems) { var o = i as IObject; if (o == null) { continue; } if (0L.Equals(o.Key)) { continue; } if (control.MetaItem.IsBitMask) { filterParams.Add(control.MetaItem.Name, "&", o.Key, true); } else { filterParams.Add(control.MetaItem.Name, "=", o.Key, true); } } } foreach ( var control in comboboxLinkedContext.Where(f => !f.MetaItem.IsMultiple)) { var controlWithValue = control.Controls.ToArray()[2] as BaseEdit; var condition = control.MetaItem.IsRange ? ">=" : control.Controls.ToArray()[1].EditValue.ToString(); object value = null; if (controlWithValue.Controls.Count == 4) // panel with range controls { var cnt1 = controlWithValue.Controls[1]; var cnt2 = controlWithValue.Controls[3]; if (cnt1 is DateEdit) { value = (cnt1 as DateEdit).EditValue; if (!Utils.IsEmpty(value)) { filterParams.Add(control.MetaItem.Name, ">=", value); } } if (cnt2 is DateEdit) { value = (cnt2 as DateEdit).EditValue; if (!Utils.IsEmpty(value)) { filterParams.Add(control.MetaItem.Name, "<=", value); } } } if (!Utils.IsEmpty(controlWithValue.EditValue) && !String.IsNullOrWhiteSpace(condition)) { if (controlWithValue is LookUpEdit) { //value = (controlWithValue as LookUpEdit).EditValue; var lookUpEditValue = (controlWithValue as LookUpEdit).EditValue as IObject; if (lookUpEditValue != null) { value = lookUpEditValue.Key; } } else if (controlWithValue is DateEdit) { value = (controlWithValue as DateEdit).EditValue; } else { if (control.Controls.ToArray()[1].Text != "Like") { value = controlWithValue.Text; } else { value = controlWithValue.Text; } } filterParams.Add(control.MetaItem.Name, condition, value); // as ListControl)); } } foreach ( var control in notComboboxLinkedContext.Where(f => f.MetaItem.EditorType == EditorType.Flag)) { //for null values if needed var flag = (control.Controls.First() as CheckEdit); filterParams.Add(control.MetaItem.Name, "=", flag.Checked?1:0); } return(filterParams); }
/*public class PersonsComparer : IEqualityComparer<Person> * { * public bool Equals(Person x, Person y) * { * return x.Pin.CompareTo(y.Pin) == 0; * } * * public int GetHashCode(Person obj) * { * return obj.Pin.GetHashCode(); * } * }*/ private Schema.Patient _getFromPersonIdentityServiceInternal(Schema.Patient p) { IdentityServiceClient client = null; //IIdentityService client = null; try { /*var b = new WSHttpBinding(SecurityMode.TransportWithMessageCredential); * b.Security.Transport.ClientCredentialType = HttpClientCredentialType.None; * b.Security.Message.ClientCredentialType = MessageCredentialType.UserName; * * var factory = new ChannelFactory<IIdentityService>(b); * factory.Credentials.UserName.UserName = "******"; * factory.Credentials.UserName.Password = "******"; * //factory.Credentials.Peer.PeerAuthentication.CertificateValidationMode = System.ServiceModel.Security.X509CertificateValidationMode.PeerTrust; * //factory.Credentials.ClientCertificate.SetCertificate(StoreLocation.LocalMachine, StoreName.TrustedPeople, X509FindType.FindBySubjectName, "localhost"); * * client = factory.CreateChannel(new EndpointAddress(new Uri("https://eservice.e-health.gov.az/EHealthWcf/IdentityService.svc"))); * ServicePointManager.ServerCertificateValidationCallback = * ((sender, certificate, chain, sslPolicyErrors) => * { * return true; * }); */ //client = new IdentityServiceClient("BasicHttpBinding_IIdentityService", "https://eservice.e-health.gov.az/EHealthWcf/IdentityService.svc"); client = new IdentityServiceClient(); var encryptedUser = Config.GetSetting("AzPinServiceUsr"); //"essiduser"; var enryptedPassword = Config.GetSetting("AzPinServicePwd");; //"ess1dUs3R"; var usr = Cryptor.Decrypt(encryptedUser); var pwd = Cryptor.Decrypt(enryptedPassword, usr); client.ClientCredentials.UserName.UserName = usr; client.ClientCredentials.UserName.Password = pwd; Person prs = null; if (p.idfsSearchMethod == 1) { var prsList = client.GetPersonByParams(p.strFirstName, p.strLastName, p.strSecondName, p.datDateofBirth /*.HasValue ? p.datDateofBirth.Value.ToString("yyyy-MM-ddT00:00:00") : null*/); if (prsList != null && prsList.Select(i => i.Pin).Distinct().Count() == 1) { prs = prsList[0]; if (prs != null) { try { prs = client.GetPersonByPin(prs.Pin); } catch (Exception) { } } } } else if (p.idfsSearchMethod == 2) { IdentityServiceDocumentType docType = IdentityServiceDocumentType.Passport; switch (p.idfsDocumentType) { case 1: docType = IdentityServiceDocumentType.Passport; break; case 2: docType = IdentityServiceDocumentType.IDCardForAdult; break; case 3: docType = IdentityServiceDocumentType.IDcardForChild; break; case 4: docType = IdentityServiceDocumentType.TemporaryResidencePermit; break; case 5: docType = IdentityServiceDocumentType.PermanentResidencePermit; break; case 6: docType = IdentityServiceDocumentType.BirthCertificate; break; } prs = client.GetPersonByDocumentNumber(p.strDocumentNumber, docType, docType == IdentityServiceDocumentType.BirthCertificate ? p.datDocumentDate : null); if (prs != null) { try { prs = client.GetPersonByPin(prs.Pin); } catch (Exception) { } } } else if (p.idfsSearchMethod == 3) { prs = client.GetPersonByPin(p.strPersonID); } else if (p.idfsSearchMethod == 4) { prs = new Person() { Pin = "0YR9DE3", Name = "Ä°SMAYILOV", SurName = "RAMÄ°L", FatherName = "TOFÄ°Q OÄžLU", DateOfBirth = new DateTime(1986, 1, 19), Sex = "M" }; } if (prs != null) { using (DbManagerProxy manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance)) { FilterParams filters = new FilterParams(); filters.Add("strPersonID", "=", prs.Pin); var items = Schema.PatientListItem.Accessor.Instance(null).SelectListT(manager, filters); if (items != null && items.Count == 1) { var proot = Schema.Patient.Accessor.Instance(null).SelectByKey(manager, items[0].idfHumanActual); p = proot; } } p.PersonIDType = p.PersonIDTypeLookup.FirstOrDefault(i => i.idfsBaseReference != 0 && i.idfsBaseReference != (long)PersonalIDType.Unknown); p.strPersonID = prs.Pin; p.strFirstName = prs.Name; p.strLastName = prs.SurName; p.strSecondName = prs.FatherName; p.datDateofBirth = prs.DateOfBirth; p.Gender = p.GenderLookup.FirstOrDefault(c => c.idfsBaseReference == (prs.Sex == "M" ? (long)GenderType.Male : (prs.Sex == "F" ? (long)GenderType.Female : 0))); return(p); } } catch (FaultException fex) { switch (fex.Code.Name) { case "2.1": case "2.2": case "2.3": return(null); case "0": case "1": default: LogError.Log("ErrorLog_PinService_", fex, stream => { stream.WriteLine(String.Format("SearchMethod = {0}, DocumentType = {1}, PersonID = '{2}', FirstName = '{3}', LastName = '{4}', SecondName = '{5}', DateofBirth = '{6}'", p.idfsSearchMethod, p.idfsDocumentType, p.strPersonID, p.strFirstName, p.strLastName, p.strSecondName, p.datDateofBirth.HasValue ? p.datDateofBirth.Value.ToString("yyyy-MM-ddT00:00:00") : "")); stream.WriteLine(String.Format("Code = {0}, Subcode = {1}, Reason = {2}", fex.Code.Name, fex.Code.SubCode == null ? "" : fex.Code.SubCode.Name, fex.Reason.ToString())); }); if (fex.InnerException != null) { LogError.Log("ErrorLog_PinService_", fex.InnerException); } throw; } } catch (Exception ex) { LogError.Log("ErrorLog_PinService_", ex, stream => { stream.WriteLine(String.Format("SearchMethod = {0}, DocumentType = {1}, PersonID = '{2}', FirstName = '{3}', LastName = '{4}', SecondName = '{5}', DateofBirth = '{6}'", p.idfsSearchMethod, p.idfsDocumentType, p.strPersonID, p.strFirstName, p.strLastName, p.strSecondName, p.datDateofBirth.HasValue ? p.datDateofBirth.Value.ToString("yyyy-MM-ddT00:00:00") : "")); }); if (ex.InnerException != null) { LogError.Log("ErrorLog_PinService_", ex.InnerException); } throw; } finally { if (client != null && client.State != System.ServiceModel.CommunicationState.Closed) { client.Close(); } } return(null); }
public static List<Asset> GetRelList(int nId, string szRelType, string szSitePath, bool bAddDestId = false, string szDestId = "", int nLimit = 500) { FilterParams fpFilter = new FilterParams(); if (szRelType.Equals("source", StringComparison.OrdinalIgnoreCase)) fpFilter.Add(AssetPropertyNames.Label, Comparison.StartsWith, nId.ToString() + "-"); else fpFilter.Add(AssetPropertyNames.Label, Comparison.EndsWith, "-" + nId.ToString()); if (bAddDestId) fpFilter.Add(AssetPropertyNames.Label, Comparison.EndsWith, "-" + szDestId); fpFilter.Limit = nLimit; Out.DebugWriteLine("Loaded=" + Asset.Load(szSitePath + "/Relationships Config/").IsLoaded.ToString()); return Asset.Load(szSitePath + "/Relationships Config/").GetFilterList(fpFilter); }
public string ComponentOutput(Asset asset, OutputContext context) { StringBuilder sb = new StringBuilder(); sb.AppendLine("<?xml version='1.0' encoding='UTF-8'?>"); sb.AppendLine(string.Format("<!-- generated {0} -->", DateTime.UtcNow.ToString("O"))); sb.AppendLine(@"<sitemapindex xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/siteindex.xsd' xmlns='http://www.sitemaps.org/schemas/sitemap/0.9'>" ); bool forceHttps = asset.Raw["sitemap_force_https"] == "true"; foreach (var panel in asset.GetPanels("sitemap_roots")) { var sitemapAssetsList = new List <Asset>(); if (string.IsNullOrEmpty(panel["sitemap_asset"]) == false) { Asset sitemapAsset = Asset.Load(panel["sitemap_asset"]); sitemapAssetsList.Add(sitemapAsset); } if (string.IsNullOrEmpty(panel["multi_sitemap_root_path"]) == false && string.IsNullOrEmpty(panel["multi_sitemap_template_id"]) == false) { try { FilterParams fp = new FilterParams(); fp.Add(AssetPropertyNames.TemplateId, Comparison.Equals, int.Parse(panel["multi_sitemap_template_id"])); Asset rootfolder = Asset.Load(panel["multi_sitemap_root_path"]); var foundAssets = rootfolder.GetFilterList(fp); sitemapAssetsList.AddRange(foundAssets); } catch (Exception) { } } Log.Info("sitemapAssetsList count is '{0}'.", sitemapAssetsList.Count); foreach (var sitemapAsset in sitemapAssetsList) { if (sitemapAsset.IsLoaded) { //create dependency to the sitemaproot asset specified asset.AddDependencyTo(sitemapAsset); sb.AppendLine("<sitemap>"); string loc = sitemapAsset.GetLink(addDomain: true); if (forceHttps) { loc = loc.Replace("http://", "https://"); } sb.AppendFormat(" <loc>{0}</loc>\n", loc); if (sitemapAsset.PublishDate != null) { //use W3C Datetime format, yyyy-MM-dd sb.AppendFormat(" <lastmod>{0}</lastmod>\n", sitemapAsset.PublishDate.Value.ToString("yyyy-MM-dd")); } sb.AppendLine("</sitemap>"); } } } sb.AppendLine("</sitemapindex>"); return(sb.ToString()); }
public static void ExcludeTemplates(FilterParams fp, IEnumerable <int> templateRefs) { fp.Add(AssetPropertyNames.TemplateId, Comparison.NotInSet, templateRefs.ToList()); }
private Tuple <Schema.Patient, string> _getFromPersonIdentityServiceInternal(Schema.Patient p) { var strPinVerificationSuffix = PinVerificationSuffix; string pin = p.strPersonID; string form = p.Parent is Schema.HumanCase ? "H02" : "H04"; string caseID = p.Parent is Schema.HumanCase ? (p.Parent as Schema.HumanCase).strCaseID : (p.Parent is Schema.ContactedCasePerson ? ((p.Parent as Schema.ContactedCasePerson).Parent as Schema.HumanCase).strCaseID : ""); DateTime?dtResponse = null; string resultCode = ""; Georgia.CommonDataWebSoapClient client = new Georgia.CommonDataWebSoapClient(); try { string codedUsername = Config.GetSetting("GgPinServiceUsr"); string codedPassword = Config.GetSetting("GgPinServicePwd"); string username = Cryptor.Decrypt(codedUsername); string password = Cryptor.Decrypt(codedPassword, username); var token = client.Login(username, password); if (token == null) { throw new Exception("PIN Service unreachable"); } var person = client.GetPersonInfoEx(token.Value, Guid.Empty, p.strPersonID, p.datDateofBirth.Value.Year); if (person == null) { resultCode = "NO_RECORDS_FOUND"; return(new Tuple <Schema.Patient, string>(null, string.Format("strPinNoRecordsFound{0}", strPinVerificationSuffix))); } dtResponse = DateTime.Now; resultCode = "OK"; using (DbManagerProxy manager = DbManagerFactory.Factory.Create(ModelUserContext.Instance)) { FilterParams filters = new FilterParams(); filters.Add("strPersonID", "=", p.strPersonID); var items = Schema.PatientListItem.Accessor.Instance(null).SelectListT(manager, filters); if (items != null && items.Count == 1) { var proot = Schema.Patient.Accessor.Instance(null).SelectByKey(manager, items[0].idfHumanActual); p = proot; } } p.PersonIDType = p.PersonIDTypeLookup.FirstOrDefault(i => i.idfsBaseReference == (long)PersonalIDType.PIN_GG); p.strPersonID = person.PrivateNumber; p.strFirstName = person.FirstName; p.strLastName = person.LastName; p.Gender = p.GenderLookup.FirstOrDefault(c => c.idfsBaseReference == (person.GenderID.Equals(PersonGendersEnum.Male) ? (long)GenderType.Male : (person.GenderID.Equals(PersonGendersEnum.Female) ? (long)GenderType.Female : 0))); p.bPINMode = true; DateTime xx; if ((person.BirthDate != null) && (DateTime.TryParseExact(person.BirthDate.ToString(), "yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture, DateTimeStyles.None, out xx))) { p.datDateofBirth = xx; //person.BirthDate; } return(new Tuple <Schema.Patient, string>(p, null)); } catch (Exception ex) { LogError.Log("ErrorLog_PinService_", ex, stream => { stream.WriteLine(String.Format("PIN = {0}, Form = {1}, CaseID = {2}, UserID = {3}, UserName = {4}, UserOrganization = {5}, EIDSSDateTime = {6}, PINServiceDateTime = {7}, Result = {8}", pin, form, caseID, EidssUserContext.Instance.CurrentUser.LoginName, EidssUserContext.Instance.CurrentUser.FullName, EidssUserContext.Instance.CurrentUser.OrganizationEng, DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss"), dtResponse.HasValue ? dtResponse.Value.ToString("yyyy-MM-ddTHH:mm:ss") : "", resultCode )); }); resultCode = "Exception:" + ex.Message; throw; } finally { if (client != null && client.State != System.ServiceModel.CommunicationState.Closed) { client.Close(); } LogError.Log("Log_PinService_", null, stream => { stream.WriteLine(String.Format("PIN = {0}, form = {1}, CaseID = {2}, UserID = {3}, UserName = {4}, UserOrganization = {5}, EIDSSDateTime = {6}, PINServiceDateTime = {7}, Result = {8}", pin, form, caseID, EidssUserContext.Instance.CurrentUser.LoginName, EidssUserContext.Instance.CurrentUser.FullName, EidssUserContext.Instance.CurrentUser.OrganizationEng, DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss"), dtResponse.HasValue ? dtResponse.Value.ToString("yyyy-MM-ddTHH:mm:ss") : "", resultCode )); }, "{0}{3}.txt"); } }
/// <summary> /// Filters everything even subfolders from the selected folder. Key = AssetID, Value = Asset. /// <para>If AssetType.Unspecified is selected, it will return all folders and files.</para> /// </summary> public static List<Asset> GetFilterList(Asset _assetFolder, AssetType _assetType = AssetType.Unspecified, string _path = "", bool excludeProjectTypes = false, List<string> excludeFolders = null, IhSiteBuilderLog siteLog = null) { FilterParams fpFilter = new FilterParams(); fpFilter.ExcludeProjectTypes = excludeProjectTypes; if (!_assetType.Equals(AssetType.Unspecified)) fpFilter.Add(Comparison.Equals, _assetType); Dictionary<string, Asset> dtAssets = new Dictionary<string, Asset>(); if (!string.IsNullOrWhiteSpace(_path)) { if (Asset.Load(_path).IsLoaded) _assetFolder = Asset.Load(_path); } List<Asset> laAssets = _assetFolder.GetFilterList(fpFilter); if (excludeFolders != null) { laAssets = ExcludeFolderList(laAssets, excludeFolders); } foreach (Asset asAsset in laAssets) { if (!dtAssets.Keys.Contains(asAsset.BranchId.ToString())) { if (asAsset.Type.Equals(AssetType.Folder)) { dtAssets.Add(asAsset.BranchId.ToString(), asAsset); } else if (asAsset.Type.Equals(AssetType.File)) { if (asAsset.WorkflowStatus.Name.Equals("Live") || asAsset.WorkflowStatus.Name.Equals("Stage") || asAsset.WorkflowStatus.Name.Equals("Draft") || asAsset.WorkflowStatus.Name.Equals("")) { dtAssets.Add(asAsset.BranchId.ToString(), asAsset); } } } else { if (asAsset.WorkflowStatus.Name.Equals("Live")) { dtAssets[asAsset.BranchId.ToString()] = asAsset; } else if (asAsset.WorkflowStatus.Name.Equals("Stage")) { if (!dtAssets[asAsset.BranchId.ToString()].WorkflowStatus.Name.Equals("Live") && !dtAssets[asAsset.BranchId.ToString()].WorkflowStatus.Name.Equals("Stage")) { dtAssets[asAsset.BranchId.ToString()] = asAsset; } } else if (asAsset.WorkflowStatus.Name.Equals("Draft")) { if (!dtAssets[asAsset.BranchId.ToString()].WorkflowStatus.Name.Equals("Live") && !dtAssets[asAsset.BranchId.ToString()].WorkflowStatus.Name.Equals("Stage") && !dtAssets[asAsset.BranchId.ToString()].WorkflowStatus.Name.Equals("Draft")) { dtAssets[asAsset.BranchId.ToString()] = asAsset; } } } } return dtAssets.Values.ToList<Asset>(); }
public static void RenderInput_bk(Asset asset, InputContext context) { //------------------------------------ // Global //------------------------------------ Dictionary<string, string> dicSiteType = new Dictionary<string, string>(); dicSiteType.Add("Single Site", "single"); dicSiteType.Add("Site Collection", "collection"); dicSiteType.Add("Site Collection with TMF", "collection_tmf"); Dictionary<string, string> dicMobile = new Dictionary<string, string>(); dicMobile.Add("None", "no"); dicMobile.Add("Responsive", "responsive"); dicMobile.Add("Dual Output", "dual_output"); dicMobile.Add("Dedicated", "dedicated"); Dictionary<string, string> dicSelectOptions = new Dictionary<string, string>(); dicSelectOptions.Add("Dropdown", "dropdown"); dicSelectOptions.Add("Create New", "create_new"); ShowAcquireParams sapModel = new ShowAcquireParams(); sapModel.DefaultFolder = "/System/Models/"; sapModel.ShowUpload = false; //Country data FilterParams fpCountry = new FilterParams(); fpCountry.Add(AssetPropertyNames.TemplateLabel, Comparison.Equals, "Country Sites Config"); Asset aCountryFolder = Asset.Load("/System/Translation Model Framework/Global/Country Sites Config/"); Dictionary<string, string> dicCountries = new Dictionary<string, string>(); if (aCountryFolder.IsLoaded) { foreach (Asset aFile in aCountryFolder.GetFilterList(fpCountry)) { if (!dicCountries.Keys.Contains(aFile.Label)) { dicCountries.Add(aFile.Label, aFile.Label); } } } //Language Data FilterParams fpLanguage = new FilterParams(); fpLanguage.Add(AssetPropertyNames.TemplateLabel, Comparison.Equals, "Language"); Asset aLanguageFolder = Asset.Load("/System/Translation Model Framework/Global/Languages Config/"); Dictionary<string, string> dicLanguages = new Dictionary<string, string>(); if (aLanguageFolder.IsLoaded) { foreach (Asset aFile in aLanguageFolder.GetFilterList(fpLanguage)) { if (!dicLanguages.Keys.Contains(aFile.Label)) { dicLanguages.Add(aFile.Label, aFile.Label); } } } //CP public sites Dictionary<string, string> dicCPSites = new Dictionary<string, string>(); string szPublicSiteXML = GetPageSource("http://mtistage.cp-access.com/sitebuilder/cp-public/site-list.xml"); if (szPublicSiteXML.Contains("<sites>")) { List<XmlNode> lsXml = Util.LoadXml(szPublicSiteXML, "file"); foreach (XmlNode xNode in lsXml) { dicCPSites.Add(xNode.Attributes["name"], xNode.Value); } } //CP Training Dictionary<string, string> dicCPTraining = new Dictionary<string, string>(); string szTrainingXML = GetPageSource("http://mtistage.cp-access.com/sitebuilder/cp-training/site-list.xml"); if (szTrainingXML.Contains("<sites>")) { List<XmlNode> lsXml = Util.LoadXml(szTrainingXML, "file"); foreach (XmlNode xNode in lsXml) { dicCPTraining.Add(xNode.Attributes["name"], xNode.Value); } } //Partner Private sites Dictionary<string, string> dicPrivateSites = new Dictionary<string, string>(); if (!string.IsNullOrWhiteSpace(asset.Raw["private_key"])) { string szPrivateSiteXML = GetPageSource("http://mtistage.cp-access.com/sitebuilder/partner/" + asset.Raw["private_key"] + "/site-list.xml"); if (szPrivateSiteXML.Contains("<sites>")) { List<XmlNode> lsXml = Util.LoadXml(szPrivateSiteXML, "file"); foreach (XmlNode xNode in lsXml) { dicPrivateSites.Add(xNode.Attributes["name"], xNode.Value); } } } //------------------------------------ // Input Form //------------------------------------ Input.StartTabbedPanel("Import Setup", "Configuration"); //Input.ShowRadioButton("Technology Stacks", "language_type", new Dictionary<string, string> { { "HTML", "html" }, { "NET", "net" }, { "PHP(Coming Soon)", "" }, { "Java(Coming Soon)", "" } }, "html"); Input.StartDropDownContainer("Technology List Options", "technology_list_option", new Dictionary<string, string>() { { "CP Public", "public" }, { "CP Training", "training" }, { "Private", "private" } }, "public"); //----------------------------------------- // CP Public Sites //----------------------------------------- Input.ShowDropDown("CrownPeak Technology Stacks", "cp_language_type", dicCPSites); Input.ShowDropDown("Create in a separate project", "new_project", new Dictionary<string, string>() { { "Yes", "yes" }, { "No", "no" } }, Util.MakeList("yes")); //TMF Input.StartDropDownContainer("Site Type", "site_type_option", dicSiteType, "single"); //Single Site Input.ShowMessage("Creates a single site"); Input.ShowTextBox("Site Name", "single_site_name"); Input.ShowHeader("Mobile"); Input.ShowCheckBox("", "single_site_mobile", "true", "Dual Output", "Creates output_mobile.aspx within the template", "", false); Input.ShowHeader("Extension"); Input.StartHorizontalWrapContainer(); Input.ShowCheckBox("", "single_site_module_blog", "true", "Blog(Coming Soon)", unCheckedValue: "", defaultChecked: false); Input.ShowCheckBox("", "single_site_module_release", "true", "Release Management(Coming Soon)", unCheckedValue: "", defaultChecked: false); Input.ShowCheckBox("", "single_site_module_metadata", "true", "Metadata Management(Coming Soon)", unCheckedValue: "", defaultChecked: false); Input.EndHorizontalWrapContainer(); Input.NextDropDownContainer(); //Site Collection Input.ShowMessage("Creates collection of sites with their own templates and models"); Input.ShowTextBox("Collection Name", "collection_name"); while (Input.NextPanel("collection_panel", displayName: "Site List")) { Input.ShowTextBox("Site Name", "collection_site_name"); Input.ShowHeader("Mobile"); Input.ShowCheckBox("", "collection_site_mobile", "true", "Dual Output", "Creates output_mobile.aspx within the template", "", false); Input.ShowHeader("Extension"); Input.StartHorizontalWrapContainer(); Input.ShowCheckBox("", "collection_site_module_blog", "true", "Blog(Coming Soon)", unCheckedValue: "", defaultChecked: false); Input.ShowCheckBox("", "collection_site_module_release", "true", "Release Management(Coming Soon)", unCheckedValue: "", defaultChecked: false); Input.ShowCheckBox("", "collection_site_module_metadata", "true", "Metadata Management(Coming Soon)", unCheckedValue: "", defaultChecked: false); Input.EndHorizontalWrapContainer(); } Input.NextDropDownContainer(); //Site Collection with TMF Input.ShowMessage("Creates collection of sites with TMF. Templates are shared"); Input.ShowTextBox("Site Name", "collection_tmf_name"); Input.ShowHeader("Mobile"); Input.ShowCheckBox("", "collection_tmf_mobile", "true", "Dual Output", "Creates output_mobile.aspx within the template", "", false); Input.ShowHeader("Extension"); Input.StartHorizontalWrapContainer(); Input.ShowCheckBox("", "collection_tmf_module_blog", "true", "Blog(Coming Soon)", unCheckedValue: "", defaultChecked: false); Input.ShowCheckBox("", "collection_tmf_module_release", "true", "Release Management(Coming Soon)", unCheckedValue: "", defaultChecked: false); Input.ShowCheckBox("", "collection_tmf_module_metadata", "true", "Metadata Management(Coming Soon)", unCheckedValue: "", defaultChecked: false); Input.EndHorizontalWrapContainer(); while (Input.NextPanel("tmf_panel", displayName: "TMF List")) { Input.ShowCheckBox("", "master_site", "true", "Master Site", unCheckedValue: "false", defaultChecked: false); Input.StartHorizontalWrapContainer(); Input.StartDropDownContainer("Country Select", "tmf_country_option", dicSelectOptions, "dropdown"); Input.ShowDropDown("Country", "tmf_country_select", dicCountries); Input.NextDropDownContainer(); Input.ShowTextBox("Country Name", "new_country_name", width: 30, helpMessage: "United States, England, etc"); Input.EndDropDownContainer(); Input.StartDropDownContainer("Language Select", "tmf_language_option", dicSelectOptions, "dropdown"); Input.ShowDropDown("Language", "tmf_lang_select", dicLanguages); Input.NextDropDownContainer(); Input.ShowTextBox("Language Name", "new_language_name", width: 30, helpMessage: "English, Spanish, etc"); Input.EndDropDownContainer(); Input.EndHorizontalWrapContainer(); Input.ShowTextBox("Locale Name", "locale_name", helpMessage: "US-EN, AR-ES, etc"); } Input.EndDropDownContainer(); Input.NextDropDownContainer(); //----------------------------- // CP Training Sites //----------------------------- Input.ShowDropDown("Training Technology Stacks", "training_language_type", dicCPTraining); Input.ShowDropDown("Project Level", "project_level", new Dictionary<string, string> { { "Root", "root" }, { "Nested", "nested" }, { "System", "system" } }, Util.MakeList("root")); Input.StartDropDownContainer("Collection Folder", "collection_folder_type", new Dictionary<string, string> { { "New", "new" }, { "Select", "select" } }, "new"); Input.ShowTextBox("New Folder", "collection_new"); Input.NextDropDownContainer(); Input.ShowSelectFolder("Select", "collection_select"); Input.EndDropDownContainer(); Input.ShowTextBox("Site Root Name", "site_root_name"); Input.ShowTextBox("Project Name", "project_name"); Input.NextDropDownContainer(); //----------------------------- // Partner Private Folder //----------------------------- if (!string.IsNullOrWhiteSpace(asset.Raw["private_key"])) { Input.ShowDropDown("Private Technology Stacks", "private_language_type", dicPrivateSites); Input.AddHiddenField("private_language_exist", "true"); } else { Input.AddHiddenField("private_language_exist", "false"); Input.ShowMessage("Enter private key in Configuration tab, save and refesh the form"); Input.ShowMessage("Ask CrownPeak support how to set up a private key"); } Input.EndDropDownContainer(); Input.StartControlPanel("Workflow"); Dictionary<string, string> dicWorkflow = new Dictionary<string, string>(); AssetParams apWorkflow = new AssetParams(); apWorkflow.ExcludeProjectTypes = false; foreach (Asset aWorkflow in Asset.Load("/System/Workflows/").GetFileList(apWorkflow)) { dicWorkflow.Add(aWorkflow.Label, aWorkflow.Label); } //Input.ShowTextBox("Workflow Name", "workflow_name", helpMessage: "Leaving blank will create assets without any workflow"); Input.ShowDropDown("Workflow", "workflow_name", dicWorkflow); Input.EndControlPanel(); /* //Mobile Input.StartDropDownContainer("Mobile", "include_mobile", dicMobile, "no"); Input.NextDropDownContainer(); //Responsive Input.ShowMessage("Responsive Mobile"); Input.NextDropDownContainer(); //Dual output Input.ShowMessage("Dual output shares one input template"); Input.NextDropDownContainer(); //Dedicated Input.ShowMessage("Dedicated mobile has separate templates and models"); Input.EndDropDownContainer(); */ //Input.NextTabbedPanel(); // Input.ShowAcquireDocument("Developer Model", "model_developer", sapModel); // Input.ShowAcquireDocument("File Model", "model_file", sapModel); // Input.ShowAcquireDocument("Folder Model", "model_folder", sapModel); // Input.ShowTextBox("Workflow Name", "workflow_name"); Input.NextTabbedPanel(); Input.ShowMessage("Enter private key, save and refesh the form"); Input.ShowTextBox("Private Site Key", "private_key"); Input.EndTabbedPanel(); }
private static FilterParams GetFilterForFarmsList(FarmPanel farmInfoForSearch) { var filter = new FilterParams(); if (!string.IsNullOrEmpty(farmInfoForSearch.strContactPhone)) { filter.Add("strContactPhone", "like", String.Format("%{0}%", farmInfoForSearch.strContactPhone)); } if (farmInfoForSearch.idfsOwnershipStructure.HasValue) { filter.Add("idfsOwnershipStructure", "=", farmInfoForSearch.idfsOwnershipStructure); } if (farmInfoForSearch.idfsLivestockProductionType.HasValue) { filter.Add("idfsLivestockProductionType", "=", farmInfoForSearch.idfsLivestockProductionType); } if (farmInfoForSearch.Address.idfsCountry.HasValue) { filter.Add("idfsCountry", "=", farmInfoForSearch.Address.idfsCountry); } if (farmInfoForSearch.Address.idfsRegion.HasValue) { filter.Add("idfsRegion", "=", farmInfoForSearch.Address.idfsRegion); } if (farmInfoForSearch.Address.idfsRayon.HasValue) { filter.Add("idfsRayon", "=", farmInfoForSearch.Address.idfsRayon); } if (farmInfoForSearch.Address.idfsSettlement.HasValue) { filter.Add("idfsSettlement", "=", farmInfoForSearch.Address.idfsSettlement); } if (farmInfoForSearch.Address.idfsSettlement.HasValue) { filter.Add("idfsSettlement", "=", farmInfoForSearch.Address.idfsSettlement); } if (!string.IsNullOrEmpty(farmInfoForSearch.strOwnerFirstName)) { filter.Add("strFirstName", "like", String.Format("%{0}%", farmInfoForSearch.strOwnerFirstName)); } if (!string.IsNullOrEmpty(farmInfoForSearch.strOwnerMiddleName)) { filter.Add("strSecondName", "like", String.Format("%{0}%", farmInfoForSearch.strOwnerMiddleName)); } if (!string.IsNullOrEmpty(farmInfoForSearch.strOwnerLastName)) { filter.Add("strLastName", "like", String.Format("%{0}%", farmInfoForSearch.strOwnerLastName)); } if (!string.IsNullOrEmpty(farmInfoForSearch.strNationalName)) { filter.Add("strNationalName", "like", String.Format("%{0}%", farmInfoForSearch.strNationalName)); } return(filter); }
public static FilterParams SearchPanelParseValues(NameValueCollection collection) { var result = new FilterParams(); string[] helpers; string[] ignoredKeys = new string[collection.AllKeys.Length]; int counter = 0; foreach (string key in collection.AllKeys) { if (String.IsNullOrWhiteSpace(collection[key]) || ignoredKeys.Contains(key) || key.ToLowerInvariant().EndsWith("input") || key.ToLowerInvariant().EndsWith("-text")) { continue; } helpers = key.Split('.'); if (helpers.Length <= 1) { continue; } if (helpers[0].ToLowerInvariant() == "lookup" && collection[key] == "0") { continue; } if (helpers[1].ToLowerInvariant() == "operand") { continue; } //helpers is an array of strings helping to define param if (helpers.Length >= 3) //it means the item is interval or from combobox { if (helpers[0].Equals("CBox", StringComparison.InvariantCultureIgnoreCase)) //value from combobox { // find all parts, include all to ignored keys result.Add( collection[String.Format(CBOX_PARAMETER_PATTERN, "Item", helpers[2])], collection[String.Format(CBOX_PARAMETER_PATTERN, "Operand", helpers[2])], collection[String.Format(CBOX_PARAMETER_PATTERN, "Value", helpers[2])] ); ignoredKeys[counter++] = String.Format(CBOX_PARAMETER_PATTERN, "Item", helpers[2]); ignoredKeys[counter++] = String.Format(CBOX_PARAMETER_PATTERN, "Operand", helpers[2]); ignoredKeys[counter++] = String.Format(CBOX_PARAMETER_PATTERN, "Value", helpers[2]); } else //interval values { if (helpers[2].Contains("_Day")) { DateTime?date = DateTimeHelper.GetDateForFilterByKey(collection, key.Replace("_Day", "")); if (date.HasValue) { result.Add(helpers[2].Replace("_Day", ""), (helpers[1].ToLowerInvariant() == "from") ? ">=" : "<=", date); } } else if (!helpers[2].Contains("_Month") && !helpers[2].Contains("_Year")) { result.Add( helpers[2], (helpers[1].ToLowerInvariant() == "from") ? ">=" : "<=", GetTypedValue(helpers[0], collection[key]) ); } ignoredKeys[counter++] = key; } } else { if (helpers[0].ToLowerInvariant() == "string") { result.Add(helpers[1], "LIKE", String.Format("%{0}%", collection[key])); } else { if (helpers[0].ToLowerInvariant() == "flag") { if (Convert.ToBoolean(collection[key].Split(',')[0])) { result.Add(helpers[1], null, null); } } else { result.Add(helpers[1], "=", GetTypedValue(helpers[0], collection[key])); } ignoredKeys[counter++] = key; } } } return(result); }