public ComboBoxItem newComboItem(String label, SlotCanvasType tag){
ComboBoxItem c = new ComboBoxItem();
c.Content = label;
c.Tag = tag;
ctypeItems.Add(tag, c);
return c;
}
public SlotCanvas(int id, int canvasid, int clockPosition, SlotCanvasType type, String param1, String param2, String param3, String label)
{
this.id = id;
this.canvasid = canvasid;
this.sliceposition = clockPosition;
this.type = type;
this.param1 = param1;
this.param2 = param2;
this.param3 = param3;
this.label = label;
}
internal void setModifValues(int sliceId, int selectedId, int position, SlotCanvasType type, string param1, string param2, string param3)
{
this.canvasId = sliceId;
this.itemId = selectedId;
this.canvasPos = position;
this.DISPLAYTYPE = type;
this.comboType.SelectedItem = ctypeItems[type];
if (DISPLAYTYPE == SlotCanvasType.SPECIFICITEM)
{
this.param1Value.Text = param1;
param1Value_TextChanged(null,null);
}
else if (DISPLAYTYPE == SlotCanvasType.CATEGORYITEM)
{
param1CategCombo.SelectedItem = this.ccategItems[param1];
}
else if (DISPLAYTYPE == SlotCanvasType.SYNC)
{
param1SyncCombo.SelectedItem = param1;
param2Clock.Value = param2;
}
else if (DISPLAYTYPE == SlotCanvasType.SLIDESLOAD)
{
String[] s = param1.Split(',');
Queue<String> q = new Queue<string>(s);
param1Value.Text = q.Dequeue();
param2Value.Text = q.Dequeue();
param3Value.Text = String.Join(",", q.ToArray());
}
}
private void comboTypeChanged(object sender, SelectionChangedEventArgs e)
{
this.DISPLAYTYPE = ((SlotCanvasType)((ComboBoxItem)((ComboBox)sender).SelectedItem).Tag);
refreshLayout();
}
public void modifyCanvasItem(int canvasId, int slicePosition, int itemId, SlotCanvasType slotCanvasType, string param1, string param2, string param3, string label)
{
isConnected();
String q = "UPDATE `canvasitem` SET type='" + slotCanvasType.ToString() + "', param1='" + param1 + "', param2='" + param2 + "', param3='" + param3 + "', label='" + label + "' WHERE idcanvasitem='"+itemId+"';";
Console.WriteLine(q);
MySqlCommand cmd = new MySqlCommand(q, connection);
cmd.ExecuteNonQuery();
}
public void addNewCanvasItem(int canvasId, int slicePosition, SlotCanvasType slotCanvasType, string param1, string param2, string param3, string label)
{
isConnected();
String q = "INSERT INTO `canvasitem` VALUES(NULL, '" + canvasId + "', '" + slicePosition + "','" + slotCanvasType.ToString() + "','" + param1 + "','" + param2 + "','" + param3 + "','" + label + "');";
Console.WriteLine(q);
MySqlCommand cmd = new MySqlCommand(q, connection);
cmd.ExecuteNonQuery();
}
