Esempio n. 1
0
 protected void SetManualUpload(object sender, EventArgs e)
 {
     if (UploadPosterButton.Enabled == false)
     {
         UploadPosterButton.Enabled = true;
     }
     else
     {
         UploadPosterButton.Enabled = false;
     }
     UploadPosterButton.DataBind();
 }
Esempio n. 2
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        string savePath, poster;

        // Add new movie title or event to [movies] table
        try
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ValidationConnectionString"].ConnectionString);
            conn.Open();
            string     addTitle = "IF NOT EXISTS (SELECT * FROM movies WHERE title = @title) INSERT INTO movies (Title, Runtime, Format, Poster, Credits) values (@title, @runtime, @format, @poster, @credits)";
            SqlCommand sqlCmd   = new SqlCommand(addTitle, conn);
            sqlCmd.Parameters.AddWithValue("@title", MovieTitle.Text);
            sqlCmd.Parameters.AddWithValue("@format", MovieFormat.Text);

            // Event only (uses event poster)
            if (MovieFormat.Text == "אירוע")
            {
                savePath = Server.MapPath("/assets/") + "event.png";
                sqlCmd.Parameters.AddWithValue("@poster", savePath.Substring(Server.MapPath("~").Length));
                sqlCmd.Parameters.AddWithValue("@runtime", MovieRuntime.Text);
                sqlCmd.Parameters.AddWithValue("@credits", "0");
            }
            // Regular or 3D Movie
            else
            {
                sqlCmd.Parameters.AddWithValue("@credits", CreditsBox.Text);
                // Option to add local poster, if impossible to get from api
                if (UploadPosterButton.HasFile)
                {
                    try
                    {
                        string filename = Path.GetFileName(UploadPosterButton.FileName);
                        savePath = Server.MapPath("/assets/poster/") + filename;
                        UploadPosterButton.SaveAs(savePath);
                        sqlCmd.Parameters.AddWithValue("@poster", savePath.Substring(Server.MapPath("~").Length));
                    }
                    catch (Exception x)
                    {
                        Logger l = new Logger(Server.MapPath("/log/"));
                        l.w("[AddMovie : Poster Upload] " + x.Message.ToString(), "Error");
                    }
                }
                // Get poster file from OMDB API
                else
                {
                    poster   = "http://img.omdbapi.com/?i=" + getMovieID() + "&apikey=a6d6bc5";
                    savePath = Server.MapPath("/assets/poster/") + getMovieID() + ".png";

                    // Save poster image locally
                    WebClient client = new WebClient();
                    client.DownloadFile(poster, savePath);
                    sqlCmd.Parameters.AddWithValue("@poster", savePath.Substring(Server.MapPath("~").Length));
                }
            }

            if (MovieRuntime.Text.Equals(""))
            {
                //Cut the 'min' from runtime string (OMDB API).
                runtime = runtime.Substring(0, 3);
                runtime = TimeSpan.FromMinutes(Double.Parse(runtime)).ToString("hh\\:mm\\:ss");
                sqlCmd.Parameters.AddWithValue("@runtime", runtime);
                sqlCmd.Parameters.AddWithValue("@credits", "0");
            }

            sqlCmd.ExecuteNonQuery();
            conn.Close();
            Response.Redirect("Index.aspx");
        }
        catch (System.Net.WebException) // 404 error code
        {
            Response.Write("<script>alert('הסרט לא נמצא, הכנס פוסטר באופן ידני');</script>");
        }
        catch (Exception) { }
    }