Field values

30/04/2008 Reply	Field values
Victor Bastos 24 posts	Is it possible to swap values of two fields? I've been wrongly using fields "Classification" and "Category", so I wonder if there's a way to transfer the values from one field to another without having to re-type all over again. Also, is it possible to delete all values from one field at once without having to navigate through all wine cards one by one? Merci!

07/05/2008
Reply

Re : Field values

Administrateur View your blog

3099 posts

Hello Victor,

if(App.ActiveCellar == null)
{
   return;
}

App.Animate(AnimationType.Work, true);
App.SetCursor(true);

ObjectCollection categories = App.ActiveCellar.GetCollection((ushort)ObjectType.Category);
ObjectCollection classifications = App.ActiveCellar.GetCollection((ushort)ObjectType.Classification);

Hashtable newCategories = new Hashtable();
Hashtable newClass = new Hashtable();

ArrayList oldCategories = new ArrayList();
ArrayList oldClass = new ArrayList();

for (int i = 0; i < categories.Count; i++)
{
   oldCategories.Add(categories[i]);
}

for (int i = 0; i < classifications.Count; i++)
{
   oldClass.Add(classifications[i]); 
}

for (int i = 0; i < oldCategories.Count; i++)
{
   BaseItem oItem = (BaseItem)oldCategories[i];
   BaseItem item = (BaseItem)App.ActiveCellar.CreateItem(ObjectType.Classification);
   item.Name = oItem.Name.Trim();
   item.Save();
   if(!newClass.ContainsKey(item.Name)) {
      newClass.Add(item.Name, item);
   }
}

for (int i = 0; i < oldClass.Count; i++)
{
   BaseItem oItem = (BaseItem)oldClass[i];
   BaseItem item = (BaseItem)App.ActiveCellar.CreateItem(ObjectType.Category);
   item.Name = oItem.Name.Trim();
   item.Save();
   if(!newCategories.ContainsKey(item.Name)) {
      newCategories.Add(item.Name, item);
   }
}

// switch
ObjectCollection wines = App.ActiveCellar.GetCollection((ushort)ObjectType.Wine);

for (int i = 0; i < wines.Count; i++) {
  Wine w = (Wine)wines[i];
  string categoryName = w.Category.Name.Trim();
  string className = w.Classification.Name.Trim();

if((categoryName != String.Empty)
	&& (newClass.ContainsKey(categoryName))) {
	w.Classification = (Classification)newClass[categoryName];
  }

if((className != String.Empty)
	&& (newCategories.ContainsKey(className))) {
	w.Category = (Category)newCategories[className];
  }

w.Save();
}

// delete items
for (int i = 0; i < oldCategories.Count; i++)
{
  ((BaseItem)oldCategories[i]).Delete();
}

for (int i = 0; i < oldClass.Count; i++)
{
  ((BaseItem)oldClass[i]).Delete();
}

// OK
MessageBox.Show("Done !");

App.SetCursor(false);
App.StopAnimate();

Dont forget to backup cellar before execute script.

Matthieu

08/05/2008 Reply	Re : Field values
Victor Bastos 24 posts	Thanks a lot!!