public void PlayVideo()
{
string ID = Request.QueryString["VideoID"].ToString();
RegisterVideo rv = new RegisterVideo();
rv.PKVideoID = Convert.ToInt32(ID);
rv.GetVideoFromID();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", ("inline;filename=" + rv.VideoName));
Response.ContentType = rv.Extension.ToString();
Response.BinaryWrite(rv.Image);
Response.Flush();
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
string ID = Request.QueryString["VideoID"].ToString();
RegisterVideo rv = new RegisterVideo();
rv.PKVideoID = Convert.ToInt32(ID);
rv.GetVideoFromID();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", ("inline;filename=" + rv.VideoName));
Response.ContentType = rv.Extension.ToString();
Response.BinaryWrite(rv.Image);
Response.Flush();
Response.End();
}
protected void gvVideos_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
int id = Int32.Parse(gvVideos.DataKeys[e.RowIndex].Value.ToString());
RegisterVideo rv = new RegisterVideo();
rv.PKVideoID = id;
rv.DeleteVideo();
BindGrid();
}
catch (System.Exception ex)
{
lblError.Text = ex.Message;
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["VideoConnectionString"].ToString());
try
{
System.Web.HttpPostedFile InputFile = fuVideo.PostedFile;
int FileLength = InputFile.ContentLength;
System.IO.Stream StreamObject = InputFile.InputStream;
byte[] FileByteArray = new byte[FileLength];
StreamObject.Read(FileByteArray, 0, FileLength);
string VideoName = fuVideo.FileName.ToString();
string ext;
ext = VideoName.Substring((VideoName.Length - (VideoName.Length - (VideoName.LastIndexOf(".") + 1))));
ext = ext.Trim();
ext = ext.ToUpper();
if (ext == "XLS" || ext == "MOV" || ext == "MP4" || ext == "WMV" || ext == "M2V" || ext == "M4V" || ext == "OGG" || ext == "WEBM" || ext == "AVI" || ext == "MPG" || ext == "MPEG")
{
RegisterVideo rv = new RegisterVideo();
rv.VideoName = fuVideo.FileName.ToString();
rv.Image = FileByteArray;
rv.DateUploaded = Convert.ToDateTime(DateTime.Now.ToShortDateString());
rv.UserName = Session["UserName"].ToString();
// rv.InsertIntoVideos();
string FileSize = GetFileSize(FileLength);
rv.FileSize = FileSize;
int cnt = rv.CheckVideo();
if (cnt == 0)
{
SqlCommand com = new SqlCommand();
com.CommandText = "spInsertIntoVideos";
com.CommandType = CommandType.StoredProcedure;
com.Connection = con;
con.Open();
com.Parameters.Add(new SqlParameter("@VideoName", rv.VideoName));
com.Parameters.Add(new SqlParameter("@Image", rv.Image));
com.Parameters.Add(new SqlParameter("@DateUploaded", rv.DateUploaded));
com.Parameters.Add(new SqlParameter("@UserName", rv.UserName));
com.Parameters.Add(new SqlParameter("@FileSize", FileSize));
com.ExecuteNonQuery();
lblError.Text = "Video Uploaded Successfully";
}
else
{
lblError.Text = "File already exists";
}
BindGrid();
}
else
{
lblError.Text = "File format not supported";
}
}
catch (System.Exception ex)
{
lblError.Text = ex.Message;
}
finally
{
con.Close();
}
}
protected void gvVideos_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
int id = Int32.Parse(gvVideos.DataKeys[e.RowIndex].Value.ToString());
RegisterVideo rv = new RegisterVideo();
rv.PKVideoID = id;
rv.DeleteVideo();
BindGrid();
}
catch (System.Exception ex)
{
lblError.Text = ex.Message;
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["VideoConnectionString"].ToString());
try
{
System.Web.HttpPostedFile InputFile = fuVideo.PostedFile;
int FileLength = InputFile.ContentLength;
System.IO.Stream StreamObject = InputFile.InputStream;
byte[] FileByteArray = new byte[FileLength];
StreamObject.Read(FileByteArray, 0, FileLength);
string VideoName = fuVideo.FileName.ToString();
string ext;
ext = VideoName.Substring((VideoName.Length - (VideoName.Length - (VideoName.LastIndexOf(".") + 1))));
ext = ext.Trim();
ext = ext.ToUpper();
if (ext == "XLS" || ext == "MOV" || ext == "MP4" || ext == "WMV" || ext == "M2V" || ext == "M4V" || ext == "OGG" || ext == "WEBM" || ext == "AVI" || ext == "MPG" || ext == "MPEG")
{
RegisterVideo rv = new RegisterVideo();
rv.VideoName = fuVideo.FileName.ToString();
rv.Image = FileByteArray;
rv.DateUploaded = Convert.ToDateTime(DateTime.Now.ToShortDateString());
rv.UserName = Session["UserName"].ToString();
// rv.InsertIntoVideos();
string FileSize = GetFileSize(FileLength);
rv.FileSize = FileSize;
int cnt = rv.CheckVideo();
if (cnt == 0)
{
SqlCommand com = new SqlCommand();
com.CommandText = "spInsertIntoVideos";
com.CommandType = CommandType.StoredProcedure;
com.Connection = con;
con.Open();
com.Parameters.Add(new SqlParameter("@VideoName", rv.VideoName));
com.Parameters.Add(new SqlParameter("@Image", rv.Image));
com.Parameters.Add(new SqlParameter("@DateUploaded", rv.DateUploaded));
com.Parameters.Add(new SqlParameter("@UserName", rv.UserName));
com.Parameters.Add(new SqlParameter("@FileSize", FileSize));
com.ExecuteNonQuery();
lblError.Text = "Video Uploaded Successfully";
}
else
{
lblError.Text = "File already exists";
}
BindGrid();
}
else
{
lblError.Text = "File format not supported";
}
}
catch (System.Exception ex)
{
lblError.Text = ex.Message;
}
finally
{
con.Close();
}
}
