Exemplo n.º 1
0
    public DataSet MostView()
    {
        try
        {
            MyConnction.Open();
            Mycommand             = new OleDbCommand("MostView", MyConnction);
            Mycommand.CommandType = CommandType.StoredProcedure;
            ds      = new DataSet();
            adapter = new OleDbDataAdapter(Mycommand);
            adapter.Fill(ds, "UserHistory");
            ImDb.WebService Db          = new ImDb.WebService();
            DataTable       TableMovies = Db.GetMoviesName();
            ds.Tables[0].Columns.Add(new DataColumn(("MovieName"), typeof(string)));
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                DataRow dr = TableMovies.Rows.Find(ds.Tables[0].Rows[i]["MovieID"]);

                ds.Tables[0].Rows[i]["MovieName"] = dr["MovieName"];
            }
            return(ds);
        }
        catch (Exception err)
        {
            throw err;
        }
        finally { MyConnction.Close(); }
    }
Exemplo n.º 2
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (Request.QueryString["G"] == null || Session["User"] == null)
     {
         if (Request.QueryString["m"] != null)
         {
             ImDb.WebService ImDb = new ImDb.WebService();
             MovieUrl = ImDb.GetURLAddress(int.Parse(Request.QueryString["m"]));
         }
         else
         {
             Response.Redirect("HomePage.aspx");
         }
     }
     else
     {
         GroupId = int.Parse(Request.QueryString["G"]);
         //if (((GroupsDetails) Page.Application["Rooms"]).Rooms.Count != 0)
         GroupsDetails groupsDetails = (GroupsDetails)Cache.Get("Rooms");
         if (groupsDetails.Rooms.Count != 0)
         {
             //Gr = ((GroupsDetails)Page.Application["Rooms"]).GetTheSerchGroup(GroupId);
             Gr = groupsDetails.GetTheSerchGroup(GroupId);
             this.LabelCurrent.Text = Gr.CurrentTime.ToString();
             Gr.EndMovie            = int.Parse(this.LabelEend.Text);
             //startTimer(Gr.MenngerGroup, ((UserDetail)Session["User"]).UserId);
             if (Gr.Active)
             {
                 Page.ClientScript.RegisterStartupScript(this.ButtonStop.GetType(), "startVideo", "playVideo()", true);
             }
             else
             {
                 Page.ClientScript.RegisterStartupScript(this.ButtonStop.GetType(), "pauseVideo", "pauseVideo()", true);
             }
         }
         else
         {
             this.LabelCurrent.Text = "0";
         }
         ImDb.WebService ImDb = new ImDb.WebService();
         MovieUrl = ImDb.GetURLAddress(Gr.MovieID);
     }
     if (Gr != null)
     {
         PopChat();
     }
     else
     {
         this.TextBoxChat.Visible   = false;
         this.TextBoxMessge.Visible = false;
     }
 }
Exemplo n.º 3
0
 public void PopMoiveDetails()
 {
     ImDb.WebService   Wb    = new ImDb.WebService();
     ImDb.MovieDetails Movie = Wb.GetMoviesDetails(int.Parse(MovieId));
     this.LabelMovieName.Text        = Movie.MoivesName;
     this.LabelDescription.Text      = Movie.description;
     this.ImageMoviePhoto.ImageUrl   = Movie.UrlPicture;
     this.LabelYearRate.Text        += Movie.YearRate;
     this.LabelDate.Text            += Movie.Date.ToShortDateString();
     this.Labelcategory.Text         = Movie.Category;
     this.DataListPlayers.DataSource = Movie.PlayersNRevive.Tables["PlayersTBbl"];
     this.DataListPlayers.DataBind();
     this.DataListReview.DataSource = Movie.PlayersNRevive.Tables["ReviewsTBbl"];
     this.DataListReview.DataBind();
 }
Exemplo n.º 4
0
    private void AddMoviesNames(DataSet ds)    //הוספת שמות הסרטים מ IMDB לטבלת הסטוריית סרטים למשתמש
    {
        ds.Tables["UserHistory"].Columns.Add(new DataColumn(("MovieName"), typeof(string)));
        ds.Tables["GroupHistory"].Columns.Add(new DataColumn(("MovieName"), typeof(string)));
        ImDb.WebService Db          = new ImDb.WebService();
        DataTable       TableMovies = Db.GetMoviesName();

        for (int i = 0; i < ds.Tables["UserHistory"].Rows.Count; i++)
        {
            DataRow dr = TableMovies.Rows.Find(ds.Tables["UserHistory"].Rows[i][1]);

            ds.Tables["UserHistory"].Rows[i]["MovieName"] = dr["MovieName"];
        }
        for (int i = 0; i < ds.Tables["GroupHistory"].Rows.Count; i++)
        {
            DataRow dr = TableMovies.Rows.Find(ds.Tables["GroupHistory"].Rows[i]["MovieID"]);

            ds.Tables["GroupHistory"].Rows[i]["MovieName"] = dr["MovieName"];
        }
    }
Exemplo n.º 5
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (Request.QueryString["G"] == null || Session["User"] == null)
     {
         if (Request.QueryString["m"] != null)
         {
             ImDb.WebService ImDb = new ImDb.WebService();
             MovieUrl = ImDb.GetURLAddress(int.Parse(Request.QueryString["m"]));
         }
         else
         {
             Response.Redirect("HomePage.aspx");
         }
     }
     else
     {
         GroupId = int.Parse(Request.QueryString["G"]);
         //if (((GroupsDetails) Page.Application["Rooms"]).Rooms.Count != 0)
         GroupsDetails groupsDetails = (GroupsDetails)Cache.Get("Rooms");
         if (groupsDetails.Rooms.Count != 0)
         {
             //Gr = ((GroupsDetails)Page.Application["Rooms"]).GetTheSerchGroup(GroupId);
             Gr = groupsDetails.GetTheSerchGroup(GroupId);
             this.LabelCurrent.Text = Gr.CurrentTime.ToString();
             Gr.EndMovie            = int.Parse(this.LabelEend.Text);
             //startTimer(Gr.MenngerGroup, ((UserDetail)Session["User"]).UserId);
             UserName = ((UserDetail)Session["User"]).UserName;
         }
         else
         {
             GroupId = 0;
             this.LabelCurrent.Text = "0";
         }
         ImDb.WebService ImDb = new ImDb.WebService();
         MovieUrl = ImDb.GetURLAddress(Gr.MovieID);
     }
 }
Exemplo n.º 6
0
 protected void ButtonTrailler_Click(object sender, EventArgs e)
 {
     ImDb.WebService   Wb    = new ImDb.WebService();
     ImDb.MovieDetails Movie = Wb.GetMoviesDetails(int.Parse(MovieId));
     Response.Redirect(Movie.TrailerAdd);
 }