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