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_Blog : System.Web.UI.Page
{
  public int SummaryMaxLength = 400;

  clsBlog blog = new clsBlog();

  /****************************************************************************************************/
  /// <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)
    {
      blog.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)
    {
      blog.Load(id);
      tbTitle.Text = blog.bl_title;
      tbDate.Text = Utils.ProperDate(blog.bl_date);
      edSnippet.Content = blog.bl_snippet;
      edCopy.Content = blog.bl_post;
      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)
  {
    blog.Clear();
    blog.bl_id = int.Parse(ddRecord.SelectedValue);
    blog.bl_snippet = edSnippet.Content;
    blog.bl_post = edCopy.Content;
    blog.bl_title = tbTitle.Text;
    blog.bl_date = Utils.ToSystemDate(tbDate.Text);
    int id = blog.Save();

    blog.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);
    blog.Delete(id);
    blog.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("Blog_ListLatest", db.DBase);
    cmd.CommandType = CommandType.StoredProcedure;
    rdr = cmd.ExecuteReader();
    while (rdr.Read())
    {
      FeedItem item = new FeedItem();
      item.Title = rdr["bl_title"].ToString();
      item.Description = Utils.StripHTML(rdr["bl_snippet"].ToString());
      item.PubDate = Convert.ToDateTime(rdr["bl_date"]);
      item.Link = "http://www.bluwave.co.za/Blog-View.aspx?id=" + db.ProcessField(rdr["bl_id"], "");
      rss.AddFeedItem(item);
    }

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


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