1

using System;
using System.Configuration;
using System.Data.SqlClient;
using System.Web;
using System.Web.UI.WebControls;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        HttpCookie objckusername = Request.Cookies["ckusername"];
        if (objckusername == null)
        {
            AdminBox.Visible = false;
            Login1.Visible = true;
            Login1.VisibleWhenLoggedIn = true;
        }
        if (objckusername != null) if (objckusername.Value.ToString().CompareTo("SurvuM") == 0)
            {
                AdminBox.Visible = true;
                Login1.Visible = false;
                Login1.VisibleWhenLoggedIn = false;
                //Setup_DeleteEntry();
            }
    }
    protected void LoginButton_Click(object sender, EventArgs e)
    {
        if (Login1.UserName.CompareTo("SurvuM") == 0 && Login1.Password.CompareTo("hello12") == 0)
        {
            Response.Cookies["ckusername"].Value = Login1.UserName.ToString();
            Response.Cookies["ckusername"].Expires = DateTime.Now.AddDays(1);
            Response.Redirect("admincack.aspx");
        }
    }
    protected void UserName_TextChanged(object sender, EventArgs e)
    {

    }
    protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
    {

    }
    protected void Video_CheckedChanged(object sender, EventArgs e)
    {

    }
    protected void Image_CheckedChanged(object sender, EventArgs e)
    {

    }
    protected void LogOffButton_Click(object sender, EventArgs e)
    {
        HttpCookie objckusername = Request.Cookies["ckusername"];
        if (objckusername == null)
        {
            /* if cookie does not exist user is not logged in
            and shouldn't be accessing this page anyhow - send user away */
            Response.Redirect(Request.ServerVariables["HTTP_REFERER"]);
        }
        else
        /*if cookie exists, user is logged in, wants to logout, so kill cookie */
        {
            objckusername.Expires = DateTime.Now.AddDays(-1);
            Response.Cookies.Add(objckusername);
            Response.Redirect(Request.ServerVariables["HTTP_REFERER"]);
        }
    }
    protected void TitleBox_TextChanged(object sender, EventArgs e)
    {

    }
    protected void Pathbox_TextChanged(object sender, EventArgs e)
    {

    }
    protected void ImageBox_TextChanged(object sender, EventArgs e)
    {

    }
    protected void RefBox_TextChanged(object sender, EventArgs e)
    {

    }
    protected void ResetButton_Click(object sender, EventArgs e)
    {
        //VideoRadio.Checked = false;
        //ImageRadio.Checked = false;
       // MonthList.SelectedIndex = 0;
       // DayList.SelectedIndex = 0;
        TitleBox.Text = "";
        Pathbox.Text = "";
        //ImageBox.Text = "";
        //RefBox.Text = "";
        successLabel.Text = "";
        
    }

    public string MonthName(int monthid)
        //Marius' handy little month thingy
    {
        if (monthid == 1) { 
            return "Jan.";
        }
         if (monthid == 2) { 
            return "Feb.";
        }
        if (monthid == 3) { 
            return "Mar.";
        }
        if (monthid == 4) { 
            return "Apr.";
        }
        if (monthid == 5) { 
            return "May";
        }
        if (monthid == 6) { 
            return "Jun.";
        }
        if (monthid == 7) { 
            return "Jul.";
        }
        if (monthid == 8) { 
            return "Aug.";
        }
        if (monthid == 9) { 
            return "Sep.";
        }
        if (monthid == 10) { 
            return "Oct.";
        }
        if (monthid == 11) { 
            return "Nov.";
        }
        if (monthid == 12) {
            return "Dec.";
        }
        else {
            return "invalid Month... wtf";
        }
    }

    protected void OKButton_Click(object sender, EventArgs e)
    {
        try
        {
            DatabaseAction.Execute(delegate(SqlConnection con)
            {
                // XXX using a stored procedure would be better -- Terry Poulin, 2010-10-29.
                //Datetime today = System.Datetime.Today;

                SqlCommand db = new SqlCommand(@"INSERT INTO videos 
                                          (path, title, month, day, isVideo)
                                          VALUES( @path , @title , @month, @day, @isVideo)", con);
                db.Parameters.AddWithValue("@title", TitleBox.Text.Trim());
                //db.Parameters.AddWithValue("@month", MonthName(today.Month));
                //db.Parameters.AddWithValue("@day", today.Day);

                string path = Pathbox.Text.Trim();
                //string image = ImageBox.Text.Trim();
                int isVideo = 1;

                db.Parameters.AddWithValue("@isVideo", isVideo);
                db.Parameters.AddWithValue("@path", path);
                //db.Parameters.AddWithValue("@image", image);
                
                if (db.ExecuteNonQuery() != 1)
                {
                    // this should only happen if the query code breaks.
                    throw new Exception("Error in SQL");
                }
                // reset form for another entry.
                ResetButton_Click(this, null);
            });
        }
        catch (Exception err)
        {
            Response.Write(err.Message + "<br>");
            Response.Write(err.InnerException);
            Response.Write(err.Source);
            Response.Write(err.Data);
        }
	}
    
        protected void DeleteEntry_SelectedIndexChanged(object sender, EventArgs e)
    {
        
    }

    protected void DeleteButton_Click(object sender, EventArgs e)
    {
        DeleteTag.Text = "Deleted!";
        string toBeDeleted = DeleteEntry.SelectedValue;
    }

    //protected void Button1_Click(object sender, EventArgs e)
    //{
    //    try
    //    {
    //        FileUpload1.SaveAs(AppDomain.CurrentDomain.BaseDirectory + @"files\" + FileUpload1.FileName);
    //        Pathbox.Text = FileUpload1.FileName;
    //    }
    //    catch (Exception)
    //    {
    //        Response.Write("<p style=\"color:red;\">Error uploading file, contact web master.</p>");
    //    }
    //}

    protected void Setup_DeleteEntry()
    {

        // populate the drop down list with all the video entries. Oi' what a design.
        try
        {
            DatabaseAction.Execute(delegate(SqlConnection con)
            {
                SqlCommand db = new SqlCommand(@"SELECT * FROM videos", con);
                SqlDataReader data = db.ExecuteReader();
                while (data.Read())
                {
                    DeleteEntry.Items.Add(data["title"].ToString());
                }
            });
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }
    }
}