public static void GetItemParams(string ItemId, string TemplateName, string Thr) { int ParamVal = 0; Database dbObj = new Database(HyperCatalog.Business.ApplicationSettings.Components["PublicationManager_DB"].ConnectionString); DataSet ds = dbObj.RunSQLReturnDataSet(String.Format("SELECT ParamSetValueId FROM HOT_ItemParams WHERE ItemId = '{0}' and TemplateName = '{1}'", ItemId, TemplateName)); if (ds != null) { ParamVal = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString()); } //Console.WriteLine("Inside from " + Thr); Publication pubWS = HyperCatalog.WebServices.WSInterface.Publication; HyperCatalog.WebServices.PublicationManagerWS.ParamSet[] colorParams = pubWS.GetParamSet("HP Colors"); HyperCatalog.WebServices.PublicationManagerWS.ParamSet chosenColor = null; foreach (HyperCatalog.WebServices.PublicationManagerWS.ParamSet color in colorParams) { if (color.Id == ParamVal) { chosenColor = color; break; } } }
protected void UpdateDataView() { try { dlTemplates.Items.Clear(); if (template != null || template.Count >= 0) { foreach (string t in template) { dlTemplates.Items.Add(new ListItem(t, t)); } } CultureList culs = SessionState.User.Cultures; CollectionView vCuls = new CollectionView(culs); if (SessionState.Culture.Code != HyperCatalog.Shared.SessionState.MasterCulture.Code) { vCuls.ApplyFilter("FallbackCode", SessionState.Culture.Code, CollectionView.FilterOperand.StartsWith); dlLocalizations.Items.Add(new ListItem(SessionState.Culture.Name, SessionState.Culture.Code)); } foreach (Culture cul in vCuls) { string prefix = ""; for (int i = 0; i < (int)cul.Type; i++) { prefix += "_"; } dlLocalizations.Items.Add(new ListItem(prefix + cul.Name, cul.Code)); } if (SessionState.Culture != null) { dlLocalizations.SelectedValue = SessionState.Culture.Code; } else { dlLocalizations.SelectedValue = HyperCatalog.Shared.SessionState.MasterCulture.Code; } Publication pubWS = HyperCatalog.WebServices.WSInterface.Publication; colorParams = pubWS.GetParamSet("HP Colors"); dlColors.Items.Add(new ListItem("Default", "default")); dlColors.Items.Add(new ListItem("Auto", "auto")); foreach (ParamSet param in colorParams) { dlColors.Items.Add(new ListItem(param.Name, param.Id.ToString())); } try { //FIX FOR 70901 int paramVal = 0; //paramVal = pubWS.GetHotItemParam(item.Id.ToString(), dlTemplates.Text.ToString()); paramVal = GetHotItemParam(item.Id.ToString(), dlTemplates.Text.ToString()); //FIX FOR 70901 if (paramVal > 0) { if (paramVal < dlColors.Items.Count) { dlColors.SelectedValue = dlColors.Items[paramVal + 1].Value; } } } catch (Exception ex) { } } catch (Exception e) { Response.Write(e.Message); } }