public Media_Types GetDetails(int idx)
{
using (MediaEntities dbContext = new MediaEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
Media_Types type_obj = dbContext.Media_Types.Where(x => x.TypeId == idx).FirstOrDefault();
return(type_obj);
}
}
public int Delte(int TypeId)
{
using (MediaEntities dbContext = new MediaEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
//Media_Types type_obj = (from x in dbContext.Media_Types where x.TypeId == TypeId select x).First();
Media_Types type_obj = dbContext.Media_Types.Single(x => x.TypeId == TypeId);
dbContext.DeleteObject(type_obj);
int i = dbContext.SaveChanges();
return(i);
}
}
private void DeleteMediaFile(string file_name, int topicid)
{
int TypeId = Convert.ToInt32(ddlMediaTypeList.SelectedValue);
MediaTypes media_type_obj = new MediaTypes();
Media_Types type_obj = media_type_obj.GetDetails(TypeId);
string TypePath = type_obj.TypePath;
string dir_path = Server.MapPath("~" + TypePath + "/" + topicid);
if (Directory.Exists(dir_path))
{
FileHandleClass file_handle_obj = new FileHandleClass();
file_handle_obj.deleteFile(file_name, dir_path);
}
}
public int UpdateStatus(string UserId, int TypeId, string Status)
{
using (MediaEntities dbContext = new MediaEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
Media_Types type_obj = dbContext.Media_Types.Single(x => x.TypeId == TypeId);
type_obj.TypeId = TypeId;
type_obj.Status = Status;
type_obj.LastModifiedByUserId = new Guid(UserId);
type_obj.ModifiedDate = System.DateTime.Now;
int i = dbContext.SaveChanges();
return(i);
}
}
private void LoadData()
{
MediaTypes media_type_obj = new MediaTypes();
Media_Types type_obj = media_type_obj.GetDetails(_idx);
EditingMediaTypes = type_obj;
txtTypeName.Text = type_obj.TypeName;
txtTypeExt.Text = type_obj.TypeExt;
txtTypePath.Text = type_obj.TypePath;
txtDescription.Text = type_obj.Description;
string Status = type_obj.Status;
PopulateStatus2DDL(Status);
}
public int Update(int TypeId, string UserId, string TypeName, string TypeExt, string TypePath, string Description, string Status)
{
using (MediaEntities dbContext = new MediaEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
//Media_Types type_obj = (from x in dbContext.Media_Types where x.TypeId == TypeId select x).First();
Media_Types type_obj = dbContext.Media_Types.Single(x => x.TypeId == TypeId);
type_obj.TypeName = TypeName;
type_obj.TypeExt = TypeExt;
type_obj.TypePath = TypePath;
type_obj.Description = Description;
type_obj.IPModifiedLog = IP;
type_obj.ModifiedDate = System.DateTime.Now;
type_obj.LastModifiedByUserId = new Guid(UserId);
type_obj.Status = Status;
int i = dbContext.SaveChanges();
return(i);
}
}
//INSERT- UPDATE - DELETE
public int Insert(string UserId, string TypeName, string TypeExt, string TypePath, string Description, string Status)
{
using (MediaEntities dbContext = new MediaEntities())
{
dbContext.CommandTimeout = Settings.CommandTimeout;
System.Nullable <Int32> ListOrder = (from u in dbContext.Media_Types select u.TypeId).DefaultIfEmpty(0).Max() + 1;
Media_Types type_obj = new Media_Types();
type_obj.TypeName = TypeName;
type_obj.TypeExt = TypeExt;
type_obj.TypePath = TypePath;
type_obj.Description = Description;
type_obj.CreatedByUserId = new Guid(UserId);
type_obj.CreatedOnDate = System.DateTime.Now;
type_obj.IPLog = IP;
type_obj.ListOrder = (ListOrder == null ? 1 : ListOrder);
type_obj.Status = Status;
dbContext.AddToMedia_Types(type_obj);
int i = dbContext.SaveChanges();
return(i);
}
}
private int UpdateData()
{
string userid = Session["UserId"].ToString();
int typeid = Convert.ToInt32(ddlMediaTypeList.SelectedValue);
int topicid = Convert.ToInt32(ddlMediaTopicList.SelectedValue);
int albumid = Convert.ToInt32(ddlAlbumList.SelectedValue);
int artistid = Convert.ToInt32(ddlArtistList.SelectedValue);
int composerid = Convert.ToInt32(ddlComposerList.SelectedValue);
int playlistid = Convert.ToInt32(ddlPlayList.SelectedValue);
string title = txtFileTitle.Text;
string description = txtDescription.Value;
string dimension = string.Empty;
string source = txtSource.Text;
string status = "0";
int autostart = 0;
int medialoop = 0;
if (chkAutoStart.Checked == true)
{
autostart = 1;
}
if (chkMedialoop.Checked == true)
{
medialoop = 1;
}
if (chkIsFilePublished.Checked == true)
{
status = "1";
}
/*** UPLOAD ************************************************************************************************************/
string[] FileImg = new String[2];
string front_image = string.Empty; string main_image = string.Empty;
string front_path = Server.MapPath(upload_front_image_dir);
string main_path = Server.MapPath(upload_main_image_dir);
string Orginal_front_image = ViewState["Thumbnail"].ToString();
string Orginal_main_image = ViewState["Photo"].ToString();
//if (FileUpload1.HasFile)
if (Session["FileUpload1"] != null && Session["FileUpload1"].ToString() != string.Empty)
{
FileHandleClass file_bj = new FileHandleClass();
FileImg = file_bj.upload_front_main_image(FileUpload1, front_path, main_path, 120, 120);
main_image = FileImg[0];
front_image = FileImg[1];
//System.Drawing.Image img1 = System.Drawing.Image.FromFile(front_path+ "/" + front_image);
imgPhoto.ImageUrl = upload_front_image_dir + "/" + front_image;
DeleteFrontImage(Orginal_front_image);
DeleteMainImage(Orginal_main_image);
}
else
{
front_image = Orginal_front_image;
main_image = Orginal_main_image;
}
////========================================================================================================================
/*** UPLOAD FILE*************************************************************************************************************/
string filename = string.Empty; string fileurl = string.Empty, file_ext = string.Empty;
string Orginal_File = ViewState["FileName"].ToString();
int TypeId = Convert.ToInt32(ddlMediaTypeList.SelectedValue);
MediaTypes media_type_obj = new MediaTypes();
Media_Types type_obj = media_type_obj.GetDetails(TypeId);
string TypeExt = type_obj.TypeExt.Trim();
string TypePath = type_obj.TypePath;
string dir_path = Server.MapPath("~/" + TypePath + "/" + topicid);
string[] arr_list = GetArray(TypeExt);
if (rdlFileUpload.SelectedValue == "0")
{
HttpPostedFile posted_file = File1.PostedFile;
if (posted_file.ContentLength > 0)
{
file_ext = System.IO.Path.GetExtension(posted_file.FileName).ToLower().Trim();
if (!Directory.Exists(dir_path))
{
Directory.CreateDirectory(dir_path);
}
for (int i = 0; i < arr_list.Length; i++)
{
if (file_ext == arr_list[i].ToString())
{
FileHandleClass file_obj = new FileHandleClass();
filename = file_obj.uploadInputFile(posted_file, dir_path);
fileurl = string.Empty;
DeleteMediaFile(Orginal_File);
}
}
}
else
{
filename = ViewState["FileName"].ToString();
}
}
else if (rdlFileUpload.SelectedValue == "1")
{
file_ext = System.IO.Path.GetExtension(txtFileUrl.Text).ToLower().Trim();
filename = System.IO.Path.GetFileName(txtFileUrl.Text);
for (int i = 0; i < arr_list.Length; i++)
{
if (file_ext == arr_list[i].ToString())
{
fileurl = txtFileUrl.Text;
filename = string.Empty;
}
}
if (fileurl.Length <= 0)
{
fileurl = ViewState["FileUrl"].ToString();
}
}
if (filename == string.Empty && fileurl == string.Empty)
{
filename = ViewState["FileName"].ToString();
fileurl = ViewState["FileUrl"].ToString();
}
/************************************************************************************************************************/
MediaFiles media_obj = new MediaFiles();
int relust = media_obj.Update(_idx, userid, typeid, topicid, playlistid, albumid, artistid, composerid, filename, fileurl, title, description,
autostart, medialoop, dimension, source, main_image, front_image, status);
return(relust);
}
private int UpdateData()
{
string userid = Session["UserId"].ToString();
int typeid = Convert.ToInt32(ddlMediaTypeList.SelectedValue);
int topicid = Convert.ToInt32(ddlMediaTopicList.SelectedValue);
int albumid = Convert.ToInt32(ddlAlbumList.SelectedValue);
int artistid = Convert.ToInt32(ddlArtistList.SelectedValue);
int composerid = Convert.ToInt32(ddlComposerList.SelectedValue);
int playlistid = Convert.ToInt32(ddlPlayList.SelectedValue);
string title = txtFileTitle.Text;
string description = txtDescription.Value;
string dimension = txtDimension.Text;
string source = txtSource.Text;
string status = "0";
int autostart = 0;
int medialoop = 0;
if (chkAutoStart.Checked == true)
{
autostart = 1;
}
if (chkMedialoop.Checked == true)
{
medialoop = 1;
}
if (chkIsFilePublished.Checked == true)
{
status = "1";
}
/*** UPLOAD IMAGE************************************************************************************************************/
string Orginal_Photo = ViewState["Photo"].ToString();
string Orginal_Thumbnail = ViewState["Thumbnail"].ToString();
string[] FileImg = new String[2];
string photo = string.Empty; string thumbnail = string.Empty;
string front_path = Server.MapPath(front_image_dir);
string main_path = Server.MapPath(main_image_dir);
HttpPostedFile myfile = File2.PostedFile;
if (chkAutoCreateThumbnail.Checked == true)
{
if (myfile.ContentLength > 0)
{
if (System.IO.Directory.Exists(front_path) && System.IO.Directory.Exists(main_path))
{
FileHandleClass file_obj = new FileHandleClass();
FileImg = file_obj.uploadFrontMainInputFile(myfile, front_path, main_path, 120, 120);
photo = FileImg[0];
thumbnail = FileImg[1];
DeleteFrontImage(Orginal_Photo);
DeleteMainImage(Orginal_Thumbnail);
}
else
{
string scriptCode = "<script>alert('Đường dẫn không tồn tại.');</script>";
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "scriptName", scriptCode);
}
}
else
{
photo = ViewState["Photo"].ToString();
thumbnail = ViewState["Thumbnail"].ToString();
}
}
else
{
if (myfile.ContentLength > 0)
{
FileHandleClass file_handle_obj = new FileHandleClass();
photo = file_handle_obj.uploadFixedInputFile(myfile, front_path, 120, 120);
DeleteFrontImage(Orginal_Photo);
}
else
{
photo = ViewState["Photo"].ToString();
thumbnail = ViewState["Thumbnail"].ToString();
}
}
////========================================================================================================================
/*** UPLOAD FILE*************************************************************************************************************/
string filename = string.Empty; string fileurl = string.Empty, file_ext = string.Empty;
int TypeId = Convert.ToInt32(ddlMediaTypeList.SelectedValue);
MediaTypes media_type_obj = new MediaTypes();
Media_Types type_obj = media_type_obj.GetDetails(TypeId);
string TypeExt = type_obj.TypeExt.Trim();
string TypePath = type_obj.TypePath;
string dir_path = Server.MapPath("~/" + TypePath);
string[] arr_list = GetArray(TypeExt);
if (rdlFileUpload.SelectedValue == "0")
{
HttpPostedFile posted_file = File1.PostedFile;
if (posted_file.ContentLength > 0)
{
file_ext = System.IO.Path.GetExtension(myfile.FileName).ToLower().Trim();
if (Directory.Exists(dir_path))
{
for (int i = 0; i < arr_list.Length; i++)
{
if (file_ext == arr_list[i].ToString())
{
FileHandleClass file_obj = new FileHandleClass();
filename = file_obj.uploadInputFile(posted_file, dir_path);
}
}
}
}
}
else
{
file_ext = System.IO.Path.GetExtension(txtFileUrl.Text).ToLower().Trim();
filename = System.IO.Path.GetFileName(txtFileUrl.Text);
for (int i = 0; i < arr_list.Length; i++)
{
if (file_ext == arr_list[i].ToString())
{
fileurl = txtFileUrl.Text;
}
}
}
/************************************************************************************************************************/
MediaFiles media_obj = new MediaFiles();
int relust = media_obj.Update(_idx, userid, typeid, topicid, playlistid, albumid, artistid, composerid, filename, fileurl, title, description,
autostart, medialoop, dimension, source, photo, thumbnail, status);
return(relust);
}
public string[] GetSelectedVideo()
{
Uri requestUri = Context.Request.Url;
string baseUrl = requestUri.Scheme + Uri.SchemeDelimiter + requestUri.Host + (requestUri.IsDefaultPort ? "" : ":" + requestUri.Port);
int typeid = 2;
//====MediaType=================================================================
MediaTypes media_type_obj = new MediaTypes();
Media_Types type_obj = media_type_obj.GetDetails(typeid);
string TypePath = type_obj.TypePath;
//==============================================================================
int FileId = 0;
string Title = string.Empty;
string FileName = string.Empty;
string FileUrl = string.Empty;
string Photo = string.Empty;
string Thumbnail = string.Empty;
string file_path = string.Empty;
string _path = baseUrl + "/" + TypePath + "/";
string dir_image_path = System.Configuration.ConfigurationManager.AppSettings["upload_media_image_dir"];
string image = "";
string[] array_list = new string[3];
MediaFiles media_obj = new MediaFiles();
DataTable dtMedia = media_obj.GetSelectedItem(typeid);
for (int i = 0; i < dtMedia.Rows.Count; i++)
{
FileId = Convert.ToInt32(dtMedia.Rows[i]["FileId"].ToString());
Title = dtMedia.Rows[i]["Title"].ToString();
FileName = dtMedia.Rows[i]["FileName"].ToString();
FileUrl = dtMedia.Rows[i]["FileUrl"].ToString();
Photo = dtMedia.Rows[i]["Photo"].ToString();
Thumbnail = dtMedia.Rows[i]["Photo"].ToString();
file_path = _path + FileName;
if (Photo != string.Empty)
{
image = baseUrl + "/" + dir_image_path + "/photo/" + Photo;
}
if (Photo == string.Empty)
{
image = baseUrl + "/" + dir_image_path + "/thumbnails/" + Thumbnail;
}
if (Photo == string.Empty && Thumbnail == string.Empty)
{
image = baseUrl + "/images/no_image.jpg";
}
array_list[0] = array_list[0] + "," + Title;
if (FileName != string.Empty && FileUrl == string.Empty)
{
array_list[1] = array_list[1] + "," + file_path;
}
else
{
array_list[1] = array_list[1] + "," + FileUrl;
}
array_list[2] = array_list[2] + "," + image;
}
return(array_list);
}
