public void GetCurrFiles()
{
using (MultimediaEntities db = new MultimediaEntities())
{
curr_files = db.AllFiles.Where(x => x.FileIsOnDrive == true).ToList();
}
}
void GetVideoExtensions()
{
using (MultimediaEntities db = new MultimediaEntities())
{
video_extensions = db.FileExtensions.Where(x => x.FileTypeID == 3).Select(x => x.FileExtensionID).ToArray <int>();
}
}
void GetSoundExtensions()
{
using (MultimediaEntities db = new MultimediaEntities())
{
sound_extensions = db.FileExtensions.Where(x => x.FileTypeID == 2).Select(x => x.FileExtensionID).ToArray <int>();
}
}
void GetImageExtensions()
{
using (MultimediaEntities db = new MultimediaEntities())
{
image_extensions = db.FileExtensions.Where(x => x.FileTypeID == 1).Select(x => x.FileExtensionID).ToArray <int>();
}
}
public void SavePrevFiles()
{
using (MultimediaEntities db = new MultimediaEntities())
{
//prev_files = db.AllFiles.Where(x => x.FileIsOnDrive == true).ToList<AllFile>();
}
}
public int GetVideosDBTotalCount()
{
int count;
using (MultimediaEntities db = new MultimediaEntities())
{
count = db.Videos.Count();
}
return(count);
}
//*************************************UsageReport
public int GetFilesDBTotalCount()
{
int count;
using (MultimediaEntities db = new MultimediaEntities())
{
count = db.AllFiles.Count();
}
return(count);
}
public void AddView(int image_id)
{
using (MultimediaEntities db = new MultimediaEntities())
{
Models.Image f_image = db.Images.Where(x => x.FileID == image_id).First();
f_image.ImageViews++;
db.Entry(f_image).State = EntityState.Modified;
db.SaveChanges();
}
}
public List <AllFile> GetTopSizedFiles()
{
List <AllFile> top_size = new List <AllFile>(10);
using (MultimediaEntities db = new MultimediaEntities())
{
top_size = db.AllFiles.OrderByDescending(x => x.FileSize).Take(10).ToList();
}
return(top_size);
}
public void AddView(int sound_id)
{
using (MultimediaEntities db = new MultimediaEntities())
{
Sound f_sound = db.Sounds.Where(x => x.FileID == sound_id).First();
f_sound.SoundViews++;
db.Entry(f_sound).State = EntityState.Modified;
db.SaveChanges();
}
}
//Getting extension element from database due to string extension
FileExtension GetExtention(string extension)
{
FileExtension fe;
using (MultimediaEntities db = new MultimediaEntities())
{
fe = db.FileExtensions.Where(x => x.FileExtensionName.ToUpper() == extension.ToUpper()).First();
}
return(fe);
}
//Getting extensions from database
void GetExtentions()
{
MultimediaEntities db = new MultimediaEntities();
extensions = db.FileExtensions.Select(x => x.FileExtensionName).ToArray <string>();
for (int i = 0; i < extensions.Count(); i++)
{
extensions[i] = extensions[i].ToUpper();
}
}
public void AddView(int video_id)
{
using (MultimediaEntities db = new MultimediaEntities())
{
Video f_video = db.Videos.Where(x => x.FileID == video_id).First();
f_video.VideoViews++;
db.Entry(f_video).State = EntityState.Modified;
db.SaveChanges();
}
}
public void AddFinding(int sound_id, int finding_type)
{
using (MultimediaEntities db = new MultimediaEntities())
{
Finding finding = new Finding {
FileID = sound_id, FindingTypeID = finding_type
};
db.Findings.Add(finding);
db.SaveChanges();
}
}
public int GetVideoInProcessCount()
{
int count = 0;
using (MultimediaEntities db = new MultimediaEntities())
{
TimeSpan ts = new TimeSpan(0, 0, 0);
count = db.Videos.Where(x => x.VideoCurrentPosition > ts).Count();
}
return(count);
}
//Reseting file existion in database
public void ResetFilesDB()
{
using (MultimediaEntities db = new MultimediaEntities())
{
foreach (AllFile file in db.AllFiles)
{
file.FileIsOnDrive = false;
db.Entry(file).State = EntityState.Modified;
}
db.SaveChanges();
}
}
//Adding new image from file
void AddToImages(FileTreeNode file, AllFile db_file)
{
Models.Image image_db = new Models.Image();
System.Drawing.Image image_info = System.Drawing.Image.FromFile(file.href);
image_db.FileID = db_file.FileID;
image_db.ImageSize = image_info.Size.Width.ToString() + "x" + image_info.Size.Height.ToString();
image_db.ImageViews = 0;
using (MultimediaEntities db = new MultimediaEntities())
{
db.Images.Add(image_db);
db.SaveChanges();
}
}
public int GetTotalImagesViews()
{
int views = 0;
using (MultimediaEntities db = new MultimediaEntities())
{
foreach (Image file in db.Images.ToList())
{
views += file.ImageViews;
}
}
return(views);
}
public int GetTotalSoundsViews()
{
int views = 0;
using (MultimediaEntities db = new MultimediaEntities())
{
foreach (Sound file in db.Sounds.ToList())
{
views += file.SoundViews;
}
}
return(views);
}
public int GetTotalVideosViews()
{
int views = 0;
using (MultimediaEntities db = new MultimediaEntities())
{
foreach (Video file in db.Videos.ToList())
{
views += file.VideoViews;
}
}
return(views);
}
public List <AllFile> GetTopViewedImages()
{
List <AllFile> top_images = new List <AllFile>(10);
using (MultimediaEntities db = new MultimediaEntities())
{
List <Image> topimages = db.Images.OrderBy(x => x.ImageViews).Take(10).ToList();
foreach (Image image in topimages)
{
top_images.Add(db.AllFiles.Find(image.FileID));
}
}
return(top_images);
}
public List <AllFile> GetTopViewedVideos()
{
List <AllFile> top_videos = new List <AllFile>(10);
using (MultimediaEntities db = new MultimediaEntities())
{
List <Video> topvideos = db.Videos.OrderBy(x => x.VideoViews).Take(10).ToList();
foreach (Video image in topvideos)
{
top_videos.Add(db.AllFiles.Find(image.FileID));
}
}
return(top_videos);
}
public List <AllFile> GetTopViewedSounds()
{
List <AllFile> top_sounds = new List <AllFile>(10);
using (MultimediaEntities db = new MultimediaEntities())
{
List <Sound> topsounds = db.Sounds.OrderBy(x => x.SoundViews).Take(10).ToList();
foreach (Sound sound in topsounds)
{
top_sounds.Add(db.AllFiles.Find(sound.FileID));
}
}
return(top_sounds);
}
public List <AllFile> GetDeletedFiles()
{
int[] all_deleted_files;
using (MultimediaEntities db = new MultimediaEntities())
{
all_deleted_files = db.AllFiles.Where(x => x.FileIsOnDrive == false).Select(x => x.FileID).ToArray <int>();
}
foreach (AllFile file in prev_files)
{
if (all_deleted_files.Contains(file.FileID))
{
deleted_files.Add(file);
}
}
return(deleted_files);
}
//Adding new sound from file
void AddToSounds(FileTreeNode file, AllFile db_file)
{
Sound sound_db = new Sound();
sound_db.FileID = db_file.FileID;
TagLib.File sound_tags = TagLib.File.Create(file.href);
try
{
sound_db.SoundAlbum = sound_tags.Tag.Album;
}
catch
{
sound_db.SoundAlbum = "Unknown";
}
try
{
sound_db.SoundArtist = sound_tags.Tag.AlbumArtists[0];
}
catch
{
sound_db.SoundArtist = "Unknown";
}
try
{
sound_db.SoundDuration = sound_tags.Properties.Duration.Duration();
}
catch
{
sound_db.SoundDuration = new TimeSpan(0, 3, 0);
}
try
{
sound_db.SoundName = sound_tags.Tag.Title;
}
catch
{
sound_db.SoundName = "Unknown";
}
sound_db.SoundCurrentPosition = new TimeSpan(0, 0, 0);
sound_db.SoundViews = 0;
using (MultimediaEntities db = new MultimediaEntities())
{
db.Sounds.Add(sound_db);
db.SaveChanges();
}
}
public string GetTotalVideoProcessed()
{
TimeSpan ts = new TimeSpan(0, 0, 0);
using (MultimediaEntities db = new MultimediaEntities())
{
foreach (Video video in db.Videos.ToList())
{
for (int i = 0; i < video.VideoViews; i++)
{
ts.Add(video.VideoDuration);
}
ts.Add(video.VideoCurrentPosition);
}
}
return(ts.ToString());
}
public string GetTotalSoundProcessed()
{
TimeSpan ts = new TimeSpan(0, 0, 0);
using (MultimediaEntities db = new MultimediaEntities())
{
foreach (Sound sound in db.Sounds.ToList())
{
for (int i = 0; i < sound.SoundViews; i++)
{
ts.Add(sound.SoundDuration);
}
ts.Add(sound.SoundCurrentPosition);
}
}
return(ts.ToString());
}
public void UpdateSoundCurrentPosition(int sound_id, string curr_pos)
{
using (MultimediaEntities db = new MultimediaEntities())
{
Sound f_sound = db.Sounds.Where(x => x.FileID == sound_id).First();
TimeSpan t_s;
if (!TimeSpan.TryParse(curr_pos, out t_s))
{
f_sound.SoundCurrentPosition = new TimeSpan(0, 0, 0);
}
else
{
f_sound.SoundCurrentPosition = t_s;
}
db.Entry(f_sound).State = EntityState.Modified;
db.SaveChanges();
}
}
public List <string> GetImageInfo(int image_id)
{
List <string> image_info = new List <string>();
Models.Image f_image;
AllFile f_file;
using (MultimediaEntities db = new MultimediaEntities())
{
f_image = db.Images.Where(x => x.FileID == image_id).First();
f_file = db.AllFiles.Where(x => x.FileID == image_id).First();
}
image_info.Add(f_file.FileName);
image_info.Add(f_file.FilePath);
image_info.Add(f_file.FileSize.ToString());
image_info.Add(f_image.ImageSize);
return(image_info);
}
public int GetTotalVideosCount()
{
int[] video_extensions;
int count = 0;
using (MultimediaEntities db = new MultimediaEntities())
{
video_extensions = db.FileExtensions.Where(x => x.FileTypeID == 3).Select(x => x.FileExtensionID).ToArray <int>();
}
foreach (AllFile file in curr_files)
{
if (video_extensions.Contains(file.FileExtensionID))
{
count++;
}
}
return(count);
}
