public void GenerateID(Tag[] tagsArray) { if (tagsArray.Count<Tag>() == 0) { Id = 0; return; } int max_id = tagsArray[0].Id; foreach (Tag tag in tagsArray) { if (max_id < tag.Id) { max_id = tag.Id; } } Id = max_id + 1; }
/// <summary> /// Saves TAGs list into database /// </summary> /// <param name="tagsArray">List of TAGs</param> /// <returns>True if success</returns> public bool SaveTags(Tag[] tagsArray) { string strSQL; ADODB.Connection con = new ADODB.Connection(); object obj = new object(); try { con.Open(GenerateConnectionString(), "", "", 0); } catch (Exception) { //TODO: Error logging return false; } for (int i = 0; i < tagsArray.Length; i++) { strSQL = string.Format(NEW_TAG, tagsArray[i].Id, tagsArray[i].Name); try { con.Execute(strSQL, out obj, 0); } catch (Exception) { //TODO: Error logging con.Close(); return false; } } con.Close(); return true; }
public Tag[] LoadTagsArray() { string strAccessConn = GenerateConnectionString(); string strAccessSelect = string.Format(GET_ALL, "TAGS"); // Create the dataset and add the Categories table to it: DataSet myDataSet = new DataSet(); OleDbConnection myAccessConn = null; try { myAccessConn = new OleDbConnection(strAccessConn); } catch (Exception) { return null; } try { OleDbCommand myAccessCommand = new OleDbCommand(strAccessSelect, myAccessConn); OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myAccessCommand); myAccessConn.Open(); myDataAdapter.Fill(myDataSet, "TAGS"); } catch (Exception) { return null; } finally { myAccessConn.Close(); } DataRowCollection dra = myDataSet.Tables["TAGS"].Rows; Tag[] array = new Tag[dra.Count]; for (int i = 0; i < dra.Count; i++) { DataRow dr = dra[i]; array[i] = new Tag(); array[i].Id = (int)(dr.ItemArray[0]); array[i].Name = ((string)(dr.ItemArray[1])).Trim(); } return array; }
public void SaveTags(DataBase dataBase) { Tag[] tagsArray = new Tag[tagList.Values.Count]; tagList.Values.CopyTo(tagsArray, 0); dataBase.SaveTags(tagsArray); }
private int GetSelectedTagIndex(string value) { Tag[] tagsArray = new Tag[tagList.Values.Count]; tagList.Values.CopyTo(tagsArray, 0); foreach (Tag tag in tagsArray) { if (tag.Name == value) { return tag.Id; } } return -1; }
private void buttonDeleteAvailTag_Click(object sender, EventArgs e) { if( listBoxAvailTags.SelectedItem == null ) { return; } Tag[] tagsArray = new Tag[tagList.Values.Count]; tagList.Values.CopyTo(tagsArray, 0); foreach (Tag tag in tagsArray) { if (tag.Name == (string)(listBoxAvailTags.SelectedItem)) { tagList.Remove(tag.Id); break; } } listBoxAvailTags.Items.Remove(listBoxAvailTags.SelectedItem); }
private void buttonAddTag_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(textBoxDefineTag.Text)) { return; } if (listBoxAvailTags.Items.Contains(textBoxDefineTag.Text)) { return; } listBoxAvailTags.Items.Add(textBoxDefineTag.Text); Tag tag = new Tag(); Tag[] tagsArray = new Tag[tagList.Values.Count]; tagList.Values.CopyTo(tagsArray, 0); tag.GenerateID(tagsArray); tag.Name = textBoxDefineTag.Text; tagList.Add(tag.Id, tag); textBoxDefineTag.Text = ""; ((Form1)(this.ParentForm)).UpdateComboBoxTags(); }
public void TagList_AddItem(Tag item) { tagList.Add(item.Id, item); listBoxAvailTags.Items.Add(item.Name); }