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