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'}";
}
