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();
}
