public void AgregarMarcaPrograma(DTOProgramFlag flag) { string sSel; string sSelCount; bool exist; sSelCount = "SELECT COUNT(*) FROM \"tbl_ProgramFlag\" WHERE \"idProgramFlag\" = " + flag.IdProgramFlag; NpgsqlDataAdapter daCount; DataSet dtCount = new DataSet(); try { daCount = new NpgsqlDataAdapter(sSelCount, sConexion); daCount.Fill(dtCount); if (dtCount.Tables[0].Rows[0][0].ToString() == "0") exist = false; else exist = true; } catch (Exception) { exist = false; } if (!exist) { sSel = "INSERT INTO \"tbl_ProgramFlag\" VALUES(" + flag.IdProgramFlag + ",'" + flag.Name + "','" + flag.Pname + "','" + flag.Description + "')"; NpgsqlDataAdapter da; DataSet dt = new DataSet(); try { da = new NpgsqlDataAdapter(sSel, sConexion); da.Fill(dt); } catch (Exception) { } } }
static void InsertProgramFlags(XmlDocument doc) { try { Console.WriteLine("Marca de Programas"); DTOProgramFlag marca = new DTOProgramFlag(); XmlNodeList programFlags = doc.GetElementsByTagName("glf")[0].ChildNodes[0].ChildNodes[3].ChildNodes; foreach (XmlNode flag in programFlags) { marca.IdProgramFlag = Int64.Parse(flag.Attributes["id"].Value); marca.Name = flag.Attributes["name"].Value; marca.Pname = flag.Attributes["pname"].Value; marca.Description = flag.Attributes["desc"].Value; conexion.AgregarMarcaPrograma(marca); } } catch (Exception ex) { Console.WriteLine(ex.Message); } }