add advertisements

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Text;
using System.Xml;



public partial class Reporter_addAdvertisements : System.Web.UI.Page
{
    DBUpdate advertise = new DBUpdate();
    SqlDataReader dr;
    SqlCommand cmd;
    SqlDataReader drdr;
    protected void Page_Load(object sender, EventArgs e)
    {
        int idUser = Convert.ToInt32(Session["idUser"]);
        string name = "";
        advertise.cmd.Parameters.Clear();
        SqlParameter p = new SqlParameter("@ret", SqlDbType.Int);
        p.Direction = ParameterDirection.ReturnValue;
        advertise.cmd.Parameters.Add(p);
        advertise.cmd.Parameters.AddWithValue("@userid", idUser);

        string fetchrow = "select * from tblReporterRegistration,tblUser where tblReporterRegistration.regnId = tblUser.registrationid and  tblUser.userid= " + idUser;

        drdr = advertise.datareader(fetchrow);
        while (advertise.dr.Read())
        {

            name = drdr["firstname"].ToString();
        }
        lbllogin.Text = "Welcome " + name;

    }
    protected void btnSubmit_Click(object sender, ImageClickEventArgs e)
    {
        advertise.cmd.Parameters.Clear();
        SqlParameter p = new SqlParameter("@ret", SqlDbType.Int);
        p.Direction = ParameterDirection.ReturnValue;
        advertise.cmd.Parameters.Add(p);
        advertise.cmd.Parameters.AddWithValue("@title", txtTitle.Text);
        advertise.cmd.Parameters.AddWithValue("@description", txtDescription.Text);
        advertise.cmd.Parameters.AddWithValue("@contents", "http://www." + txtUrl.Text);
        advertise.cmd.Parameters.AddWithValue("@fromDate", txtFromDate.Text);
        advertise.cmd.Parameters.AddWithValue("@toDate", txtTodate.Text);
        string filename = UploadImage.FileName.ToString();
        advertise.cmd.Parameters.AddWithValue("@adimage", filename);
        ////advertise.cmd.Parameters.AddWithValue("@advideo", "");

        UploadImage.SaveAs(Server.MapPath("..\\images\\") + UploadImage.FileName.ToString());
        StatusLabel.Text = "Upload status: File uploaded!";
        string s = advertise.excproc("AddAdvertisement");
        if (s == "1")
        {

            lblinsert.Visible = true;
            lblinsert.Text = "Advertisement Inserted Sucessfully..";

        }

        String strFilePath = "D:\\Lis2008\\RssFeeds\\advertisexml.xml";


        XmlTextWriter writer = new XmlTextWriter(strFilePath, Encoding.UTF8);

        writer.WriteStartDocument();

        writer.WriteStartElement("Advertisements");

        writer.WriteString("\n");

        writer.WriteString("\n");
      
        //writer.WriteString("\n");
        //writer.WriteEndElement();

        //writer.Flush();

        //writer.Close();
        advertise.getcon();

        cmd = new SqlCommand("select * from tblAdvertisements", advertise.con);
        cmd.Connection = advertise.con;
        dr = cmd.ExecuteReader();
      //  int cnt = 1;
        while (dr.Read())
        {
            writer.WriteStartElement("Ad");
            writer.WriteString("\n");
            writer.WriteElementString("ImageUrl","..\\RssFeeds\\images\\"+ dr["adimage"].ToString());
            writer.WriteString("\n");
            //writer.WriteElementString("Width", "170");
            //writer.WriteString("\n");
            //writer.WriteElementString("Height", "113");
            //writer.WriteString("\n");
            writer.WriteElementString("NavigateUrl", dr["contents"].ToString());
            writer.WriteString("\n");
            writer.WriteElementString("AlternateText", dr["description"].ToString());
            writer.WriteString("\n");
            writer.WriteElementString("Impressions", "40");
            writer.WriteString("\n");
            writer.WriteElementString("Keyword", "small");
            writer.WriteString("\n");
            writer.WriteEndElement();
              writer.WriteString("\n");
        }


        advertise.con.Close();


        
        writer.WriteEndElement();
      
        writer.Flush();

        writer.Close();
        Response.Redirect("..\\DisplayAds.aspx"); 
        //Response.Redirect("..//testAdvertise.aspx"); 
    }
}