using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CodeCafe.Web;
using System.Data.SqlClient;
using System.Data;

public partial class Admin_News : System.Web.UI.Page
{
  public int SummaryMaxLength = 400;

  clsNews news = new clsNews();

  /****************************************************************************************************/
  /// <summary>
  /// Handles the Load event of the Page control.
  /// </summary>
  /// <param name="sender">The source of the event.</param>
  /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
  protected void Page_Load(object sender, EventArgs e)
  {
    if (!IsPostBack)
    {
      news.List(ddRecord, 0, ListTypes.AllowNew);
      Clear();
    }
  }

  /****************************************************************************************************/
  /// <summary>
  /// Clears the form.
  /// </summary>
  protected void Clear()
  {
    tbTitle.Text = "";
    edSnippet.Content = "";
    edCopy.Content = "";
    tbDate.Text = "";
    btnDelete.Visible = false;
  }

  /****************************************************************************************************/
  /// <summary>
  /// Loads the article.
  /// </summary>
  /// <param name="sender">The sender.</param>
  /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
  protected void LoadArticle(object sender, EventArgs e)
  {
    int id = int.Parse(ddRecord.SelectedValue);
    Clear();
    if (id > 0)
    {
      news.Load(id);
      tbTitle.Text = news.ni_title;
      tbDate.Text = Utils.ProperDate(news.ni_date);
      edSnippet.Content = news.ni_snippet;
      edCopy.Content = news.ni_copy;
      btnDelete.Visible = true;
    }
  }

  /****************************************************************************************************/
  /// <summary>
  /// Saves the report.
  /// </summary>
  /// <param name="sender">The sender.</param>
  /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
  protected void Save(object sender, EventArgs e)
  {
    news.Clear();
    news.ni_id = int.Parse(ddRecord.SelectedValue);
    news.ni_snippet = edSnippet.Content;
    news.ni_copy = edCopy.Content;
    news.ni_author = "BluWave Software";
    news.ni_title = tbTitle.Text;
    news.ni_date = Utils.ToSystemDate(tbDate.Text);
    int id = news.Save();

    news.List(ddRecord, id, ListTypes.AllowNew);
    btnDelete.Visible = true;
    GenerateRss();
  }


  /****************************************************************************************************/
  /// <summary>
  /// Deletes the specified article.
  /// </summary>
  /// <param name="sender">The sender.</param>
  /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
  protected void Delete(object sender, EventArgs e)
  {
    int id = int.Parse(ddRecord.SelectedValue);
    news.Delete(id);
    news.List(ddRecord, 0, ListTypes.AllowNew);
    Clear();
  }

  /****************************************************************************************************/
  /// <summary>
  /// Generates the RSS.
  /// </summary>
  private void GenerateRss()
  {
    RSSGenerator rss = new RSSGenerator("~/Feeds/bluwave.xml");
    
    MSSqlTools db = new MSSqlTools();
    SqlDataReader rdr = null;
    SqlCommand cmd;

    db.DBase.Open();
    cmd = new SqlCommand("News_ListAll", db.DBase);
    cmd.CommandType = CommandType.StoredProcedure;
    rdr = cmd.ExecuteReader();
    while (rdr.Read())
    {
      FeedItem item = new FeedItem();
      item.Title = rdr["ni_title"].ToString();
      item.Description = Utils.StripHTML(rdr["ni_snippet"].ToString());
      item.PubDate = Convert.ToDateTime(rdr["ni_date"]);
      item.Link = "http://www.bluwave.co.za/News-View.aspx?id=" + db.ProcessField(rdr["ni_id"], "");
      rss.AddFeedItem(item);
    }

    rdr.Close();
    rss.ExportRSS();
  }


  /****************************************************************************************************/
}