private void showMovies() { dcUTWDataContext dc = new dcUTWDataContext(); if (string.IsNullOrEmpty(hfCatgory.Value)) { var mv = dc.Movies.Where(p => p.State == true).OrderByDescending(p => p.AddTime).OrderByDescending(p => p.ID).AsQueryable(); gvMovies.DataSource = mv; gvMovies.DataBind(); } else { if (Convert.ToInt32(hfCatgory.Value) > 0) { int nCatID = Convert.ToInt32(hfCatgory.Value); var mv = dc.Movies.Where(p => p.State == true && p.Type == nCatID).OrderByDescending(p => p.AddTime).AsQueryable(); gvMovies.DataSource = mv; gvMovies.DataBind(); } else { var mv = dc.Movies.Where(p => p.State == true).OrderByDescending(p => p.AddTime).OrderByDescending(p => p.ID).AsQueryable(); gvMovies.DataSource = mv; gvMovies.DataBind(); } } }
private void showTopNew() { dcUTWDataContext dc = new dcUTWDataContext(); var topNew = dc.Movies.Where(p => p.State == true).OrderBy(p => p.AddTime).OrderBy(p => p.ID).Take(Convert.ToInt32(hfCount.Value)); dlTopNew.DataSource = topNew; dlTopNew.DataBind(); }
protected void lbDown_Click(object sender, EventArgs e) { dcUTWDataContext dc = new dcUTWDataContext(); var Downs = dc.Downloads.Where(p => p.ID == Convert.ToInt64((sender as LinkButton).CommandArgument.Trim())).Single(); Downs.DownCount++; dc.SubmitChanges(); Response.Redirect(Downs.Url.Trim()); }
private void CreateMainMenu(System.Web.UI.WebControls.Menu objMenu) { dcUTWDataContext dc = new dcUTWDataContext(); var mnus = dc.Menus.Where(p => p.State == true && p.Parent == 0).Take(10); foreach (var mnuItem in mnus) { objMenu.Items.Add(createMenuItem(mnuItem.Title, mnuItem.ID.ToString(), mnuItem.Url)); } }
protected void lbDown_Click(object sender, EventArgs e) { dcUTWDataContext dc = new dcUTWDataContext(); var dwnUrl = dc.MovieAddrs.Where(p => p.ID == Convert.ToInt64((sender as LinkButton).CommandArgument.Trim())).Single(); dwnUrl.DownCount++; dc.Movies.Where(p => p.ID == dwnUrl.MovieID).Single().DownCount++; dc.SubmitChanges(); Response.Redirect(dwnUrl.Url.Trim()); }
protected void dvOrder_DataBound(object sender, EventArgs e) { if (Request.QueryString["id"] != null) { //(dvOrder.Rows[1].Cells[1].Controls[0] as TextBox).Text = "1";// Session["userID"].ToString();//UserID dcUTWDataContext dc = new dcUTWDataContext(); string MovieName = dc.Movies.Where(m => m.ID == Convert.ToInt32(Request.QueryString["id"].Trim())).Single().Name; (dvOrder.Rows[2].Cells[1].Controls[0] as TextBox).Text = MovieName;//MovieTitle //(dvOrder.Rows[3].Cells[1].Controls[0] as TextBox).Text = Request.QueryString["id"].Trim();//movieID } }
protected void Page_Load(object sender, EventArgs e) { if (!String.IsNullOrEmpty(Request.QueryString["id"])) { dcUTWDataContext dc = new dcUTWDataContext(); var oneMovie = dc.Movies.Where(p => p.ID == Convert.ToInt32(Request.QueryString["id"])).Single(); mpWatch.MediaSource = oneMovie.WhatUrl.Trim(); mpWatch.PlaceholderSource = oneMovie.Cover.Trim(); oneMovie.WatchCount++; dc.SubmitChanges(); } }
protected void dvUser_ItemInserting(object sender, DetailsViewInsertEventArgs e) { dcUTWDataContext dc = new dcUTWDataContext(); int nCount = dc.Managers.Where(p => p.Name == e.Values["Name"].ToString()).Count(); if (nCount != 0) { lblMSG.Text = "بۇ ئىسىم تىزىملىتىلىپ بولغان! باشقا ئىسىم كىرگۈزۈڭ."; lblMSG.Visible = true; e.Cancel = true; } e.Values["Password"] = UDev.net.Scurity.CreateHashText(e.Values["Password"].ToString()); e.Values["AddTime"] = DateTime.Now; }
private void CreateChildMenu(System.Web.UI.WebControls.Menu mnuMain) { dcUTWDataContext dc = new dcUTWDataContext(); var mnus = dc.Menus.Where(p => p.State == true && p.Parent != 0); foreach (var mnu in mnus) { int nMenuID = getMenuID(mnu.Parent.ToString(), mnuMain); if (nMenuID > -1) { mnuMain.Items[nMenuID].ChildItems.Add(createMenuItem(mnu.Title, mnu.ID.ToString(), mnu.Url)); } } }
private void fillMovieType() { dcUTWDataContext dc = new dcUTWDataContext(); var mc = from c in dc.MovieCatgories where c.State == true select new { c.ID, c.Name }; ddlType.Items.Clear(); ddlType.Items.Add(new ListItem("بارلىق", "0")); foreach (var t in mc) { ddlType.Items.Add(new ListItem(t.Name, t.ID.ToString())); } }
protected void Page_Load(object sender, EventArgs e) { if (Request["CatID"] != null) { try { int nCatID = int.Parse(Request.QueryString["CatID"]); dcUTWDataContext dc = new dcUTWDataContext(); var ArticleCat = dc.ArticleCatogries.Where(p => p.ID == nCatID).SingleOrDefault(); lblTitle.Text = ArticleCat.Name; } catch { } } }
protected void Page_Load(object sender, EventArgs e) { if (!String.IsNullOrEmpty(Request.QueryString["id"])) { dcUTWDataContext dc = new dcUTWDataContext(); var oneMovie = dc.Movies.Where(p => p.ID == Convert.ToInt32(Request.QueryString["id"])).Single(); ltrlDescraption.Text = oneMovie.Descraption; lblMovieTitle.Text = oneMovie.Name.Trim(); imgCover.ImageUrl = oneMovie.Cover; hlWatch.NavigateUrl = "~/Web/Watch.aspx?id=" + oneMovie.ID; ltrlImages.Text = getImages(oneMovie.ID); ShowIMDBRating(oneMovie.IMDBID.Trim()); } }
/// <summary> /// get images for lightbox /// </summary> /// <param name="nMID"></param> /// <returns></returns> private string getImages(Int64 nMID) { dcUTWDataContext dc = new dcUTWDataContext(); var Images = dc.Pictures.Where(p => p.MovieID == nMID); StringBuilder sbImages = new StringBuilder(); sbImages.Append("<ul>"); foreach (var pic in Images) { sbImages.Append("<li>"); sbImages.Append("<a href=\"" + pic.Url + "\" title=\"" + pic.Descraption + "\">"); sbImages.Append("<img src=\"" + pic.Url + "\" width=\"72\" height=\"72\" alt=\"\" />"); sbImages.Append("</a>"); sbImages.Append("<li>"); sbImages.Append("<li>"); } sbImages.Append("</ul>"); return(sbImages.ToString()); }
protected void btnLogin_Click(object sender, EventArgs e) { if (Session["Manager"] != null) { Response.Redirect("~/Web/Mange/MMain.aspx"); } dcUTWDataContext dc = new dcUTWDataContext(); var objManager = dc.Managers.Where(p => p.Name == txtName.Text.Trim() && p.Password == UDev.net.Scurity.CreateHashText(txtPass.Text.Trim())).SingleOrDefault(); if (objManager == null) { lblMSG.Text = "ئىسىم ياكى پارول خفتا!"; } else { Session["Manager"] = objManager; Response.Redirect("~/Web/Manage/MMain.aspx"); } }
//private void MovieData() //{ // //dcUTWDataContext dc = new dcUTWDataContext(); // //var Movies = dc.Movies.Where(p => p.State == true).Select(p => new { p.ID, p.Name,isThere= dc.Recommends.Select(r=>r.MovieID).Contains(p.ID)}); //} //private Boolean isRecommend(int nID) //{ // dcUTWDataContext dc = new dcUTWDataContext(); // Boolean bln = dc.Recommends.Where(p => p.MovieID == nID).Select(p=>p.MovieID).Contains(nID); // return bln; //} protected void btnAdd_Click(object sender, EventArgs e) { dcUTWDataContext dc = new dcUTWDataContext(); if (dc.Recommends.Select(p => p.MovieID).Contains(Convert.ToInt64(ddlMovies.SelectedValue)) == false) { Recommend rcm = new Recommend(); rcm.MovieID = Convert.ToInt64(ddlMovies.SelectedValue); rcm.State = true; rcm.AddTime = DateTime.Now; dc.Recommends.InsertOnSubmit(rcm); dc.SubmitChanges(); } else { lblMSG.Visible = true; } gvRecommends.DataBind(); }
private void Search() { dcUTWDataContext dc = new dcUTWDataContext(); string strKey = txtKeyWord.Text.Trim(); IQueryable <Movie> iqMv = dc.Movies; iqMv = iqMv.Where(m => m.Name == strKey || m.Name.Contains(strKey) || m.Descraption.Contains(strKey) || m.OtherName.Contains(strKey)); if (Convert.ToInt16(ddlType.SelectedValue) != 0) { iqMv = iqMv.Where(m => m.Type == Convert.ToInt32(ddlType.SelectedValue)); } //var sr=from m in dc.Movies // where (m.Name == strKey || m.Name.Contains(strKey) || m.Descraption.Contains(strKey) || m.OtherName.Contains(strKey)) // && m.Type==Convert.ToInt32(ddlType.SelectedValue) // select m; //StringBuilder sbQuery = new StringBuilder(); //sbQuery.AppendLine("from m in dc.Movies"); //sbQuery.AppendLine(" where (m.Name == \"" + strKey // + "\" || m.Name.Contains(\"" + strKey // + "\") || m.Descraption.Contains(\"" + strKey // + "\") || m.OtherName.Contains(\"" + strKey + "\"))"); //if (Convert.ToInt16(ddlType.SelectedValue) != 0) //{ // sbQuery.AppendLine("&& m.Type=="+ddlType.SelectedValue); //} //sbQuery.AppendLine(" select m;"); //var SearchResult = dc.ExecuteQuery<Movie>(sbQuery.ToString());//dc.Movies.Where(p => p.Name.Contains("پالۋان") || p.Name == "يېشىل ئادەم" || p.Descraption.Contains("ئۇرۇش")).Take(10); //GridView1.DataSource = iqMv;//SearchResult; //GridView1.DataBind(); gvMovies.DataSource = iqMv; gvMovies.DataBind(); }
private void getImages() { dcUTWDataContext dc = new dcUTWDataContext(); var advs = dc.Advertizements.Where(p => p.State == true); StringBuilder sbImages = new StringBuilder(); bool blnFrist = true; foreach (var adv in advs) { if (blnFrist) { sbImages.AppendLine("<div class=\"active\">"); blnFrist = false; } else { sbImages.AppendLine("<div>"); } sbImages.AppendLine("<a href=\"" + adv.NavUrl + "\"><img src=\"" + adv.Url + "\" alt=\"" + adv.Title + "\" /></a>"); sbImages.AppendLine("</div>"); } ltrlImages.Text = sbImages.ToString(); }