public DeckPropertiesDialog(eFlash.Data.Deck newDeck, bool changeType) { InitializeComponent(); deck = newDeck; txtTitle.Text = deck.title; txtCategory.Text = deck.category; txtSubcategory.Text = deck.subcategory; grpType.Enabled = changeType; switch (deck.type) { case Constant.textDeck: rdText.Checked = true; break; case Constant.imageDeck: rdImage.Checked = true; break; case Constant.soundDeck: rdAudio.Checked = true; break; case Constant.noQuizDeck: rdNoQuiz.Checked = true; break; } saved = false; }
public DeckPropertiesDialog(eFlash.Data.Deck newDeck, bool changeType) { InitializeComponent(); deck = newDeck; txtTitle.Text = deck.title; txtCategory.Text = deck.category; txtSubcategory.Text = deck.subcategory; grpType.Enabled = changeType; switch (deck.type) { case Constant.textDeck: rdText.Checked = true; break; case Constant.imageDeck: rdImage.Checked = true; break; case Constant.soundDeck: rdAudio.Checked = true; break; case Constant.noQuizDeck: rdNoQuiz.Checked = true; break; } saved = false; }
private void LayoutEditor_Shown(object sender, EventArgs e) { if (deck == null) { deck = new eFlash.Data.Deck(); deck.uid = ProfileManager.getCurrentUserID(); if (!showDeckPropertiesDialog(true)) { changed = false; templateChanged = false; this.Close(); return; } if (deck.cardList.Count == 0) { promptAtTemplateChange = false; } } changed = false; if (deck.cardList.Count == 0) { promptAtTemplateChange = false; } if (deck.type == Constant.noQuizDeck) { deleteSideToolStripMenuItem1.Enabled = true; addNewSideToolStripMenuItem.Enabled = true; } else if (deck.type == Constant.textDeck || deck.type == Constant.imageDeck || deck.type == Constant.soundDeck) { tsObjects.Visible = false; templateSelector = new TemplateSelector(this, deck.type); templateSelector.Location = tsObjects.Location; this.Controls.Add(templateSelector); deleteSideToolStripMenuItem1.Enabled = false; addNewSideToolStripMenuItem.Enabled = false; } else { throw new Exception("Invalid deck type"); } }
public LayoutEditor(main newPrevWindow, eFlash.Data.Deck newDeck, bool makeCopy) { InitializeComponent(); prevWindow = newPrevWindow; if (makeCopy) { deck = deepCopy(newDeck); } else { deck = newDeck; } initialize(); }
/// <summary> /// Makes a deep copy of deck, duplicating all its cards, /// objects, and files, and sets it to be the current deck. /// </summary> /// <param name="otherDeck">Deck to copy</param> /// <returns>Deck object of copy of deck</returns> private eFlash.Data.Deck deepCopy(eFlash.Data.Deck otherDeck) { otherDeck.load(); _deck = new eFlash.Data.Deck(-1, otherDeck.type, otherDeck.category, otherDeck.subcategory, otherDeck.title, ProfileManager.getCurrentUserID(), ProfileManager.getCurrentNetID()); // Put deck entry into DB saveDeck(); Card newCard; eObject newObj; CreatorObject newCreatorObj; foreach (Card curCard in otherDeck.cardList) { newCard = new Card(curCard.tag, ProfileManager.getCurrentUserID()); // Add each card to the DB newCard.cardID = dbAccess.insertLocalDB.insertToCards(newCard); dbAccess.insertLocalDB.insertToCDRelations(deck.id, newCard.cardID); foreach (eObject curObj in curCard.eObjectList) { newObj = new eObject(newCard.cardID, curObj.side, curObj.type, curObj.x1, curObj.x2, curObj.y1, curObj.y2, curObj.data); // Make a CreatorObject to let it load up the data file newCreatorObj = CreatorObject.newFromEObject(this, newObj, 0); newCreatorObj.initialize(); newObj.actualFilename = newObj.generateFileName(); // Save each object to DB and file saveObject(newCreatorObj); } } return(deck); }
public static int insertToDecks(eFlash.Data.Deck d) { return(insertToDecks(d.category, d.subcategory, d.title, d.type, d.uid, d.netID)); }
/** * A function to retrieve all unranked decks belonging to a user in the local database * Pre: local network user id * Post: List of corresponding Decks */ public static List<Deck> getUnrankedDecks(int netID) { List<Deck> deckList = new List<Deck>(); string SQL; MySqlCommand cmd = new MySqlCommand(); MySqlDataReader myData; connect(); try { SQL = "SELECT decks.did, decks.cat, decks.subcat, decks.title FROM unranked, decks WHERE unranked.lnuid = " + Convert.ToString(netID) + " AND unranked.ldid = decks.did ORDER BY cat, title"; cmd.Connection = conn; cmd.CommandText = SQL; myData = cmd.ExecuteReader(); while (myData.Read()) { Deck deck = new Deck(myData.GetInt32(myData.GetOrdinal("did")), myData.GetString(myData.GetOrdinal("cat")), myData.GetString(myData.GetOrdinal("subcat")), myData.GetString(myData.GetOrdinal("title"))); deckList.Add(deck); } myData.Close(); conn.Close(); return deckList; } catch (MySql.Data.MySqlClient.MySqlException ex) { MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); conn.Close(); throw new Exception(); } }
/** * A function to retrieve all the decks in the local database, ordered by input specification * Pre: order (0 = cat, 1 = alphabetical, 2 = time) * Post: List of corresponding Decks */ public static List<Deck> getDecksOrdered(int order) { List<Deck> deckList = new List<Deck>(); deckList.Clear(); string SQL; MySqlCommand cmd = new MySqlCommand(); MySqlDataReader myData; connect(); try { //the if statement spliced in by Daniel for main menu selecting all decks switch (order) { case 0: SQL = "SELECT did,type,cat,subcat,title,uid,nuid FROM decks ORDER BY cat, title"; break; case 1: SQL = "SELECT did,type,cat,subcat,title,uid,nuid FROM decks ORDER BY title"; break; case 2: SQL = "SELECT did,type,cat,subcat,title,uid,nuid FROM decks ORDER BY cat, title"; break;//change this case when timestamp implemented default: MessageBox.Show("Error: corrupted order input to getDecksOrdered"); SQL = "SELECT did,type,cat,subcat,title,uid,nuid FROM decks ORDER BY cat, title"; break; } cmd.Connection = conn; cmd.CommandText = SQL; myData = cmd.ExecuteReader(); while (myData.Read()) { Deck deck = new Deck(myData.GetInt32(myData.GetOrdinal("did")), myData.GetString(myData.GetOrdinal("type")), myData.GetString(myData.GetOrdinal("cat")), myData.GetString(myData.GetOrdinal("subcat")), myData.GetString(myData.GetOrdinal("title")), myData.GetInt32(myData.GetOrdinal("uid")), myData.GetInt32(myData.GetOrdinal("nuid"))); deckList.Add(deck); } myData.Close(); conn.Close(); return deckList; } catch (MySql.Data.MySqlClient.MySqlException ex) { MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); conn.Close(); throw new Exception(); } }
public LayoutEditor(main newPrevWindow, eFlash.Data.Deck newDeck) : this(newPrevWindow, newDeck, false) { }
public static void updateDeck(eFlash.Data.Deck d) { updateDecks(d.id, d.type, d.category, d.subcategory, d.title, d.uid, d.netID); }
public static byte[] buildNetBLOB(Deck deck, int uploaderID) { Card curCard; eObject curObj; IEnumerator objEnum; IEnumerator cardEnum; MemoryStream stream = new MemoryStream(); XmlTextWriter writer = new XmlTextWriter(stream, System.Text.Encoding.UTF8); //Use automatic indentation for readability. writer.Formatting = Formatting.Indented; //Write the root element writer.WriteStartElement("eFlash-Network"); //Start an element writer.WriteStartElement("Deck"); //Add attribute to Deck writer.WriteAttributeString("cat", deck.category); writer.WriteAttributeString("subcat", deck.subcategory); writer.WriteAttributeString("title", deck.title); writer.WriteAttributeString("type", deck.type); writer.WriteAttributeString("nuid", Convert.ToString(uploaderID)); cardEnum = deck.cardList.GetEnumerator(); while (cardEnum.MoveNext()) { //Load the cards belonging to this deck curCard = (Card)cardEnum.Current; writer.WriteStartElement("Card"); writer.WriteAttributeString("tag",curCard.tag); objEnum = curCard.eObjectList.GetEnumerator(); while (objEnum.MoveNext()) { curObj = (eObject)objEnum.Current; writer.WriteStartElement("Object"); writer.WriteAttributeString("size", Convert.ToString(curObj.efile.size)); writer.WriteAttributeString("side", Convert.ToString(curObj.side)); writer.WriteAttributeString("type", Convert.ToString(curObj.type)); writer.WriteAttributeString("quizType", Convert.ToString(curObj.quizType)); writer.WriteAttributeString("x1", Convert.ToString(curObj.x1)); writer.WriteAttributeString("x2", Convert.ToString(curObj.x2)); writer.WriteAttributeString("y1", Convert.ToString(curObj.y1)); writer.WriteAttributeString("y2", Convert.ToString(curObj.y2)); writer.WriteBase64(curObj.efile.rawData, 0, curObj.efile.size); // end the Object element writer.WriteEndElement(); } // end the Card element writer.WriteEndElement(); } // end the Deck element writer.WriteEndElement(); // end the root element writer.WriteFullEndElement(); //writer.WriteEndDocument(); //Close the writer and stream writer.Close(); stream.Close(); return stream.ToArray(); }
public static int parseBLOB(byte[] blob, int uid) { int size = 0; int curDid = -1; int curCid = -1; byte[] data = null; Deck deck = null; eObject curObj = null; Card curCard = null; MemoryStream stream = new MemoryStream(blob); XmlTextReader reader = new XmlTextReader(stream); while (reader.Read()) { switch (reader.NodeType) { case XmlNodeType.Element: if (reader.Name == "Deck") { deck = new Deck(reader.GetAttribute("cat"), reader.GetAttribute("subcat"), reader.GetAttribute("title"), reader.GetAttribute("type"),Convert.ToInt32(reader.GetAttribute("nuid")), uid); try { //Insert to Decks table in local database curDid = deck.saveToDB(); } catch { throw new Exception("Error Writting Deck!!!"); } } else if (reader.Name == "Card") { curCard = new Card(reader.GetAttribute("tag"), uid); try { //Insert to Cards table in local database curCid = curCard.saveToDB(curDid); } catch { throw new Exception("Error Writting Card!!!"); } } else if (reader.Name == "Object") { //First create the array of bytes for the blob size = Convert.ToInt32(reader.GetAttribute("size")); data = new byte[size]; curObj = new eObject( curCid, Convert.ToInt32(reader.GetAttribute("side")), reader.GetAttribute("type"), Convert.ToInt32(reader.GetAttribute("x1")), Convert.ToInt32(reader.GetAttribute("x2")), Convert.ToInt32(reader.GetAttribute("y1")), Convert.ToInt32(reader.GetAttribute("y2")) ); try { string qType = reader.GetAttribute("quizType"); if (qType == Constant.nonePrefix || qType == Constant.answerPrefix || qType == Constant.questionPrefix) { curObj.quizType = qType; } } catch {} try { reader.ReadElementContentAsBase64(data, 0, size); curObj.efile = new eFile(data); //save to file and update DB curObj.save(); } catch { throw new Exception("Error Saving Object !!!"); } } break; } } return curDid; }
private void LayoutEditor_Shown(object sender, EventArgs e) { if (deck == null) { deck = new eFlash.Data.Deck(); deck.uid = ProfileManager.getCurrentUserID(); if (!showDeckPropertiesDialog(true)) { changed = false; templateChanged = false; this.Close(); return; } if (deck.cardList.Count == 0) { promptAtTemplateChange = false; } } changed = false; if (deck.cardList.Count == 0) { promptAtTemplateChange = false; } if (deck.type == Constant.noQuizDeck) { deleteSideToolStripMenuItem1.Enabled = true; addNewSideToolStripMenuItem.Enabled = true; } else if (deck.type == Constant.textDeck || deck.type == Constant.imageDeck || deck.type == Constant.soundDeck) { tsObjects.Visible = false; templateSelector = new TemplateSelector(this, deck.type); templateSelector.Location = tsObjects.Location; this.Controls.Add(templateSelector); deleteSideToolStripMenuItem1.Enabled = false; addNewSideToolStripMenuItem.Enabled = false; } else { throw new Exception("Invalid deck type"); } }
/// <summary> /// Makes a deep copy of deck, duplicating all its cards, /// objects, and files, and sets it to be the current deck. /// </summary> /// <param name="otherDeck">Deck to copy</param> /// <returns>Deck object of copy of deck</returns> private eFlash.Data.Deck deepCopy(eFlash.Data.Deck otherDeck) { otherDeck.load(); _deck = new eFlash.Data.Deck(-1, otherDeck.type, otherDeck.category, otherDeck.subcategory, otherDeck.title, ProfileManager.getCurrentUserID(), ProfileManager.getCurrentNetID()); // Put deck entry into DB saveDeck(); Card newCard; eObject newObj; CreatorObject newCreatorObj; foreach (Card curCard in otherDeck.cardList) { newCard = new Card(curCard.tag, ProfileManager.getCurrentUserID()); // Add each card to the DB newCard.cardID = dbAccess.insertLocalDB.insertToCards(newCard); dbAccess.insertLocalDB.insertToCDRelations(deck.id, newCard.cardID); foreach (eObject curObj in curCard.eObjectList) { newObj = new eObject(newCard.cardID, curObj.side, curObj.type, curObj.x1, curObj.x2, curObj.y1, curObj.y2, curObj.data); // Make a CreatorObject to let it load up the data file newCreatorObj = CreatorObject.newFromEObject(this, newObj, 0); newCreatorObj.initialize(); newObj.actualFilename = newObj.generateFileName(); // Save each object to DB and file saveObject(newCreatorObj); } } return deck; }