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