private static void CacheSetupData()
{
if (Item_Setup.Count != 0)
{
return;
}
Assembly _assembly;
StreamReader _textStreamReader = null;
try
{
_assembly = Assembly.GetExecutingAssembly();
_textStreamReader = new StreamReader(_assembly.GetManifestResourceStream("MSEAHackUtility." + Program.gateway + ".Ins.img.xml"));
}
catch (Exception e)
{
// Debug.WriteLine(LogLevel.Error, "Error accessing Map.xml resourrce file {0}", e.StackTrace);
return;
}
XmlDocument mapxml = new XmlDocument();
mapxml.Load(_textStreamReader);
foreach (XmlNode map in mapxml.DocumentElement.SelectNodes("/imgdir/imgdir"))
{
int id = int.Parse(map.Attributes["name"].InnerText);
XmlNode node = map.SelectSingleNode("string[@name='name']");
XmlNode nodedesc = map.SelectSingleNode("string[@name='desc']");
Item_Setup.Add(id, new KeyValuePair <string, String>(
node == null ? "NULL" : node.Attributes["value"].InnerText.ToLower(),
nodedesc == null ? "NULL" : nodedesc.Attributes["value"].InnerText));
}
}
public int Insert(Item_Setup item_Setup)
{
int isExecuted = 0;
try
{
commandString = @"INSERT INTO Item_Setup (Name) VALUES('" + item_Setup.Name + "')";
sqlCommand = new SqlCommand();
sqlCommand.CommandText = commandString;
sqlCommand.Connection = sqlConnection;
sqlConnection.Open();
isExecuted = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
return(isExecuted);
}
public int Insert(Item_Setup item_Setup)
{
return(itemSetUpRepository.Insert(item_Setup));
}
