public Media getMediaByName(MediaType.MediaTypes type, string name) { Media media = new Media(); try { if (connect()) { DataSet selectedData = new DataSet(); SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT NAME,TYPE,YEAR,DESCRIPTION FROM " + getMediaTypeTable(type) + " WHERE Name ='" + name.Replace("'", "''") + "' ORDER BY NAME", connection); dataAdapter.Fill(selectedData); media = createMedia(selectedData, false); disconnect(); return(media); } else { return(media); } } catch (SqlException ex) { return(new Media()); } }
public Object[] getVideoData(MediaType.MediaTypes type, string name) { Object[] videoInformation = new Object[2]; try { if (connect()) { DataSet selectedData = new DataSet(); SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT VIDEO,VIDEOEXTENTION FROM " + getMediaTypeTable(type) + " WHERE Name ='" + name.Replace("'", "''") + "' ORDER BY NAME", connection); dataAdapter.Fill(selectedData); byte[] data = (selectedData.Tables[0].Rows[0]["VIDEO"] == DBNull.Value) ? null : (byte[])selectedData.Tables[0].Rows[0]["VIDEO"]; string extention = (selectedData.Tables[0].Rows[0]["VIDEOEXTENTION"] == DBNull.Value) ? String.Empty : selectedData.Tables[0].Rows[0]["VIDEOEXTENTION"].ToString(); videoInformation[0] = data; videoInformation[1] = extention; disconnect(); return(videoInformation); } else { return new Object[] { } }; } catch (SqlException ex) { return(new Object[] { }); } }
public Media getMediaPresentationList(MediaType.MediaTypes type, string name) { Media media = new Media(); try { if (connect()) { DataSet selectedData = new DataSet(); SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT NAME,TYPE,YEAR,DESCRIPTION,IMAGE1 FROM " + getMediaTypeTable(type) + " ORDER BY NAME", connection); dataAdapter.Fill(selectedData); media = createMedia(selectedData, true); disconnect(); return(media); } else { return(new Media()); } } catch (SqlException ex) { return(new Media()); } }
private string getMediaTypeTable(MediaType.MediaTypes type) { switch (type) { case MediaType.MediaTypes.MOVIES: { return(ConfigurationManager.AppSettings.Get("MovieTable")); } case MediaType.MediaTypes.TVSERIES: { return(ConfigurationManager.AppSettings.Get("TVSeriesTable")); } case MediaType.MediaTypes.ANIMESERIES: { return(ConfigurationManager.AppSettings.Get("AnimeTable")); } case MediaType.MediaTypes.GAMES: { return(ConfigurationManager.AppSettings.Get("GamesTable")); } default: { return(String.Empty); } } }
public byte[] getImageData(MediaType.MediaTypes type, int image, string name) { try { if (connect()) { DataSet selectedData = new DataSet(); SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT IMAGE" + image + " FROM " + getMediaTypeTable(type) + " WHERE Name ='" + name.Replace("'", "''") + "' ORDER BY NAME", connection); dataAdapter.Fill(selectedData); if (selectedData.Tables.Count > 0 && selectedData.Tables[0].Rows.Count > 0) { byte[] data = (selectedData.Tables[0].Rows[0]["IMAGE" + image] == DBNull.Value) ? null : (byte[])selectedData.Tables[0].Rows[0]["IMAGE" + image]; disconnect(); return(data); } else { return(new byte[] { }); } } return(new byte[] { }); } catch (SqlException ex) { return(new byte[] { }); } }
public List <Media> getPresentationMediaListByValue(MediaType.MediaTypes type, string value) { List <Media> mediaList = new List <Media>(); try { if (connect()) { DataSet selectedData = new DataSet(); string queryString = "select NAME,TYPE,YEAR,DESCRIPTION from " + getMediaTypeTable(type) + " where NAME like '%" + value.Replace("'", "''") + "%' ORDER BY NAME"; SqlDataAdapter dataAdapter = new SqlDataAdapter(queryString, connection); dataAdapter.Fill(selectedData); mediaList = createPresentationMediaList(selectedData); disconnect(); return(mediaList); } else { return(mediaList); } } catch (SqlException ex) { return(new List <Media>()); } }
public List <string> getMediaListByValue(MediaType.MediaTypes type, string value) { List <string> mediaList = new List <string>(); try { if (connect()) { DataSet selectedData = new DataSet(); SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT NAME FROM " + getMediaTypeTable(type) + " WHERE NAME like '%" + value.Replace("'", "''") + "%' ORDER BY NAME", connection); dataAdapter.Fill(selectedData); mediaList = createMediaList(selectedData); disconnect(); return(mediaList); } else { return(mediaList); } } catch (SqlException ex) { return(new List <string>()); } }
public List <Media> getPresentationMediaListByLetter(MediaType.MediaTypes type, string letter) { List <Media> mediaList = new List <Media>(); try { if (connect()) { DataSet selectedData = new DataSet(); string queryString = "select NAME,TYPE,YEAR,DESCRIPTION from " + getMediaTypeTable(type) + " where NAME like '[0-9]%' OR NAME NOT like '[a-Z]%' ORDER BY NAME"; if (letter != "#") { queryString = "SELECT NAME,TYPE,YEAR,DESCRIPTION FROM " + getMediaTypeTable(type) + " WHERE NAME like '" + letter + "%' ORDER BY NAME"; } SqlDataAdapter dataAdapter = new SqlDataAdapter(queryString, connection); dataAdapter.Fill(selectedData); mediaList = createPresentationMediaList(selectedData); disconnect(); return(mediaList); } else { return(mediaList); } } catch (SqlException ex) { return(new List <Media>()); } }
public List <string> getMediaNameList(MediaType.MediaTypes type) { List <string> mediaList = new List <string>(); try { if (connect()) { DataSet selectedData = new DataSet(); SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT NAME FROM " + getMediaTypeTable(type), connection); dataAdapter.Fill(selectedData); mediaList = createMediaList(selectedData); disconnect(); return(mediaList); } else { return(mediaList); } } catch (SqlException ex) { return(new List <string>()); } }
public byte[] getPresentationImage(MediaType.MediaTypes type) { int mediaType = (type == MediaType.MediaTypes.MOVIES) ? 1 : (type == MediaType.MediaTypes.TVSERIES ? 2 : (type == MediaType.MediaTypes.ANIMESERIES ? 3 : 4)); try { if (connect()) { SqlCommand command = new SqlCommand("getPresentationImage", connection); command.CommandType = CommandType.StoredProcedure; SqlParameter parameter = new SqlParameter("MEDIATYPE", mediaType); command.Parameters.Add(parameter); SqlDataReader reader = command.ExecuteReader(); byte[] imageData = null; if (reader.Read()) { imageData = (byte[])reader["IMAGE1"]; } reader.Close(); disconnect(); return(imageData); } else { return(null); } } catch (SqlException ex) { return(null); } catch (Exception ex) { return(null); } }
protected void Page_Load(object sender, EventArgs e) { try { string id = Request.QueryString["id"]; if (id != String.Empty && id != null) { DataSet data = (DataSet)Session["MediaData"]; DataTable dt = data.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["NAME"].ToString().Equals(id)) { byte[] imgData = (byte[])dt.Rows[i]["IMAGE1"]; Response.BinaryWrite(imgData); } } } else { string type = Request.QueryString["type"]; if (type != String.Empty && type != null) { clsSQLServerMediaConnection access = new clsSQLServerMediaConnection(); MediaType.MediaTypes typeValue = type == "1" ? MediaType.MediaTypes.MOVIES : type == "2" ? MediaType.MediaTypes.TVSERIES : type == "3" ? MediaType.MediaTypes.ANIMESERIES : MediaType.MediaTypes.GAMES; byte[] img = access.getPresentationImage(typeValue); Response.ContentType = "image/jpeg"; Response.BinaryWrite(img); } } } catch (Exception ex) { } }
public void ProcessRequest(HttpContext context) { context.Response.Cache.SetCacheability(HttpCacheability.NoCache); context.Response.Headers.Add("Cache-Control", "no-cache, no-store"); context.Response.Cache.SetExpires(DateTime.UtcNow.AddYears(-1)); context.Response.Expires = 0; string operation = context.Request.QueryString["op"]; if (operation != null && operation != String.Empty) { if (operation == "GetPicRan") { string type = context.Request.QueryString["type"]; if (type != null && type != String.Empty) { clsSQLServerMediaConnection access = new clsSQLServerMediaConnection(); MediaType.MediaTypes typeValue = type == "1" ? MediaType.MediaTypes.MOVIES : type == "2" ? MediaType.MediaTypes.TVSERIES : type == "3" ? MediaType.MediaTypes.ANIMESERIES : MediaType.MediaTypes.GAMES; byte[] img = access.getPresentationImage(typeValue); context.Response.ContentType = "image/jpeg"; context.Response.BinaryWrite(img); } } else { if (operation == "GetPicByName") { string type = context.Request.QueryString["type"]; string name = context.Request.QueryString["name"]; if (type != null && type != String.Empty && name != null && name != String.Empty) { name = Server.UrlDecode(name); clsSQLServerMediaConnection access = new clsSQLServerMediaConnection(); MediaType.MediaTypes typeValue = type == "1" ? MediaType.MediaTypes.MOVIES : type == "2" ? MediaType.MediaTypes.TVSERIES : type == "3" ? MediaType.MediaTypes.ANIMESERIES : MediaType.MediaTypes.GAMES; byte[] img = access.getImageByName(typeValue, name); if (img != null) { context.Response.ContentType = "image/jpeg"; context.Response.BinaryWrite(img); } else { string imageFileName = "image-not-available.jpg"; string path = HttpContext.Current.Server.MapPath("~/images/" + imageFileName); try { FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(fs); byte[] image = br.ReadBytes((int)fs.Length); br.Close(); fs.Close(); context.Response.ContentType = "image/jpeg"; context.Response.BinaryWrite(image); } catch { } } } } } } }
public byte[] getImageByName(MediaType.MediaTypes type, string name) { return(getImageData(type, 1, name)); }
protected void searchLoadData() { string media = mediaSelection.SelectedValue; string displayViewMode = displayMode.SelectedValue; string letter = ddlLetter.SelectedValue; string searchText = txt_SearchValue.Text; clsSQLServerMediaConnection getData = new clsSQLServerMediaConnection(); MediaType.MediaTypes typeSelected = getMediaTypeValueSelected(media); int typeValueSelected = getMediaNumericValueSelected(media); List <Media> mediaList = new List <Media>(); if (searchText == String.Empty) { // search by letter mediaList = getData.getPresentationMediaListByLetter(typeSelected, letter); } else { // search by value mediaList = getData.getPresentationMediaListByValue(typeSelected, searchText); } lbl_ContentTitle.Text = "Showing " + mediaSelection.SelectedValue + " - " + mediaList.Count + " results were found!"; if (displayViewMode == "Image Grid") { if (mediaList.Count > 0) { foreach (Media m in mediaList) { m.ImageURL = "~/ImageHandlerRequest.ashx?op=GetPicByName&type=" + typeValueSelected + "&name=" + Server.UrlEncode(m.Name); } imageDataList.DataSource = mediaList; imageDataList.DataBind(); } else { // no elements found } } else { imageDataList.DataSource = null; imageDataList.DataBind(); if (displayViewMode == "Details") { if (mediaList.Count > 0) { foreach (Media m in mediaList) { m.ImageURL = "~/ImageHandlerRequest.ashx?op=GetPicByName&type=" + typeValueSelected + "&name=" + Server.UrlEncode(m.Name); } gridMediaList.DataSource = mediaList; gridMediaList.DataBind(); } else { // no elements } } } }
public static Media returnInformation(string name, string type) { clsSQLServerMediaConnection getData = new clsSQLServerMediaConnection(); MediaType.MediaTypes typeM = MediaType.MediaTypes.MOVIES; switch (type) { case "Movies": { typeM = MediaType.MediaTypes.MOVIES; } break; case "TV Series": { typeM = MediaType.MediaTypes.TVSERIES; } break; case "Anime Series": { typeM = MediaType.MediaTypes.ANIMESERIES; } break; case "Games": { typeM = MediaType.MediaTypes.GAMES; } break; default: { typeM = MediaType.MediaTypes.MOVIES; } break; } Media mediaData = getData.getMediaByName(typeM, name); object[] videoData = getData.getVideoData(typeM, name); if (videoData != null && videoData.Length > 0 && videoData[0] != null) { try { string fileName = name + "." + Convert.ToString(videoData[1]); string fileNameCompletePath = HttpContext.Current.Server.MapPath("~/videos/" + fileName); byte[] videoBytes = (byte[])videoData[0]; // Open file for reading System.IO.FileStream _FileStream = new System.IO.FileStream(fileNameCompletePath, System.IO.FileMode.Create, System.IO.FileAccess.Write); // Writes a block of bytes to this stream using data from // a byte array. _FileStream.Write(videoBytes, 0, videoBytes.Length); // close file stream _FileStream.Close(); mediaData.VideoURL = "videos/" + fileName; } catch (Exception ex) { mediaData.VideoURL = ""; } } else { mediaData.VideoURL = ""; } return(mediaData); //Media m = new Media(); //m.Name = "Movie Test 999"; //m.Description = "Description 999"; //m.Year = 2016; //m.Type = "Comedy"; //m.VideoURL = "videos/TWICE - CHEER UP Dance video 3 HD.mp4"; //return m; //return "{ 'name':'Movie Name','year':'2016','type':'Comedy','Description':'Lucys movie description', 'videoURL':'videos/TWICE - CHEER UP M V.mp4'}"; }