/// <summary>
/// Saves relations between TAGs and XML rows
/// </summary>
/// <param name="relationsArray">List with TAG IDs and XML FIELD IDs</param>
/// <returns>True if success</returns>
public bool SaveRelations(XmlTagRelation[] relationsArray)
{
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 < relationsArray.Length; i++)
{
strSQL = string.Format(NEW_XML_TAG_RELATION,
relationsArray[i].TagID,
relationsArray[i].XmlFileID);
try
{
con.Execute(strSQL, out obj, 0);
}
catch (Exception)
{
//TODO: Error logging
con.Close();
return false;
}
}
con.Close();
return true;
}
public List<XmlTagRelation> LoadRelationArray()
{
string strAccessConn = GenerateConnectionString();
string strAccessSelect = "SELECT * FROM XML_TAG_RELATION";
// 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, "XML_TAG_RELATION");
}
catch (Exception)
{
return null;
}
finally
{
myAccessConn.Close();
}
DataRowCollection dra = myDataSet.Tables["XML_TAG_RELATION"].Rows;
List<XmlTagRelation> array = new List<XmlTagRelation>();
for (int i = 0; i < dra.Count; i++)
{
DataRow dr = dra[i];
XmlTagRelation item = new XmlTagRelation();
item.TagID = (int)(dr.ItemArray[0]);
item.XmlFileID = (int)(dr.ItemArray[1]);
array.Add(item);
}
return array;
}
