public void AgregarCanal(DTOChannel channel, String type)
{
string sSel;
string sSelCount;
bool exist;
sSelCount = "SELECT COUNT(*) FROM \"tbl_Channel\" WHERE \"idChannel\"=" + channel.IdChannel;
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)
{
string sSelIdTipo = "SELECT \"tbl_ChannelType\".\"idType\" FROM \"tbl_ChannelType\" WHERE \"tbl_ChannelType\".\"channelType\" = '" + type + "'";
NpgsqlDataAdapter daIdTipo;
DataSet dtIdTipo = new DataSet();
string idTipo="";
try
{
daIdTipo = new NpgsqlDataAdapter(sSelIdTipo, sConexion);
daIdTipo.Fill(dtIdTipo);
idTipo = dtIdTipo.Tables[0].Rows[0][0].ToString();
}
catch (Exception)
{
}
sSel = "INSERT INTO \"tbl_Channel\" VALUES(" + channel.IdChannel + ",'" + channel.CallLetter + "','" + channel.ChannelName.Replace("'","") + "'," + idTipo + ");";
NpgsqlDataAdapter da;
DataSet dt = new DataSet();
try
{
da = new NpgsqlDataAdapter(sSel, sConexion);
da.Fill(dt);
}
catch (Exception)
{
}
}
}
static void InsertChannel(XmlDocument xmlDoc)
{
try
{
Console.WriteLine("Canales");
DTOChannel canal = new DTOChannel();
XmlNodeList channels = xmlDoc.GetElementsByTagName("glf")[0].ChildNodes[2].ChildNodes;
foreach (XmlNode channel in channels)
{
canal.IdChannel = Int64.Parse(channel.Attributes["id"].Value);
canal.CallLetter = channel.Attributes["c"].Value;
canal.ChannelName = channel.Attributes["l"].Value;
conexion.AgregarCanal(canal, channel.Attributes["t"].Value);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
