public void UpdateFile(string sPath, int iMedia, int iType)
{
String sMediaPath = getMediaPath(iMedia);
String sFilePath = sPath.Substring(sMediaPath.Length + 1);
//return if file is alredy in database
foreach (DataRow row in DataBase.executeQuery("select id from mt_file where path='" + duplicateApostrof(sFilePath) + "' and media = " + iMedia).Rows)
{
return;
}
String sSeason = "";
if (iType == 2 && hasSeasones(getPreviousFolder(sPath, 1)))
{
sSeason = getPreviousFolder(sPath, 1);
}
//insert file to database
String sQuery = "insert into mt_file(id,media,path,fl_watched,season) values(" +
(getMaxId("mt_file") + 1) + "," +
iMedia + ",'" +
duplicateApostrof(sFilePath) + "','N','" +
sSeason +
"')";
DataBase.executeNonQuery(sQuery);
}
public void RefreshData()
{
String sQuery = "select id,folder,name,year,genre from mt_media";
String sWhere = "";
sWhere = " where type='" + txt_media_type.Text + "'";
if (txt_genre.Text != "")
{
sWhere += " and upper(genre)='" + txt_genre.Text + "'";
}
if (txt_naziv.Text != "")
{
sWhere += " and upper(name) like upper('%" + txt_naziv.Text + "%')";
}
if (txt_year.Text != "")
{
sWhere += " and year like '%" + txt_year.Text + "%'";
}
DataTable dt = DataBase.executeQuery(sQuery + sWhere);
BindingSource bindingSource = new BindingSource();
bindingSource.DataSource = dt;
navigator.BindingSource = bindingSource;
grid.DataSource = dt;
loadInfo();
}
void fillSeason()
{
DataTable table = DataBase.executeQuery("select distinct(season) season from mt_file where media=" + iMediaId + " order by season");
txt_season.DataSource = table;
txt_season.ValueMember = "season";
txt_season.DisplayMember = "season";
}
public void RefreshData()
{
String sQuery = "select id,path from mt_file";
String sWhere = " where media=" + iMediaId + " and season ='" + txt_season.Text + "' order by path ";
DataTable dt = DataBase.executeQuery(sQuery + sWhere);
BindingSource bindingSource = new BindingSource();
bindingSource.DataSource = dt;
navigator.BindingSource = bindingSource;
grid.DataSource = dt;
}
public String getMediaPath(int iMedia)
{
String sPath = "";
String sDrive = "";
String sQuery = "select f.path + '\\' + m.path,d.name from mt_media m,mt_folder f,mt_drive d where m.folder=f.id and f.drive = d.id and m.id=";
DataTable table = DataBase.executeQuery(sQuery + iMedia);
foreach (DataRow row in table.Rows)
{
sPath = row.ItemArray[0].ToString();
sDrive = getDrivePath(row.ItemArray[1].ToString());
}
sPath = sDrive + sPath;
return(sPath);
}
public String getFilePath(int iFile)
{
String sPath = "";
String sDrive = "";
DataTable table = DataBase.executeQuery("select f.path + '\\' + m.path + '\\' + fi.path,d.name from mt_file fi,mt_media m,mt_folder f,mt_drive d where fi.media=m.id and m.folder = f.id and f.drive=d.id and fi.id=" + iFile);
foreach (DataRow row in table.Rows)
{
sPath = row.ItemArray[0].ToString();
sDrive = getDrivePath(row.ItemArray[1].ToString());
}
if (sDrive != "")
{
sPath = sDrive + sPath;
}
else
{
sPath = "";
}
return(sPath);
}
public void loadInfo()
{
if (this.grid.CurrentCell == null)
{
return;
}
int currRow = grid.CurrentCell.RowIndex;
String sMediaName = grid.Rows[currRow].Cells["name"].Value.ToString();
String sId = grid.Rows[currRow].Cells["id"].Value.ToString();
url = "http://www.google.com/search?q=imdb+\"" + formatUrl(sMediaName) + "\"&btnI";
String sQuery = "select f.path + '\\' + m.path,d.name from mt_media m,mt_folder f,mt_drive d where m.folder=f.id and f.drive = d.id and m.id=" + sId;
DataTable dt = DataBase.executeQuery(sQuery);
String mediaPath = "";
String sDrive = "";
try
{
mediaPath = dt.Rows[0].ItemArray[0].ToString();
sDrive = getDrivePath(dt.Rows[0].ItemArray[1].ToString());
}
catch (Exception ex)
{
}
String targetDirectory = sDrive + mediaPath;
String[] fileEntries = null;;
if (targetDirectory != "")
{
fileEntries = Directory.GetFiles(targetDirectory, "*.htm*");
}
info.loadMovie(fileEntries, targetDirectory);
}
public void previewMedia()
{
if (this.grid.CurrentCell == null)
{
return;
}
int currRow = grid.CurrentCell.RowIndex;
String sMediaId = grid.Rows[currRow].Cells[0].Value.ToString();
String sFilePath = "";
int fileNo = 1;
foreach (DataRow row in DataBase.executeQuery("select count(1) from mt_file where media= " + sMediaId).Rows)
{
fileNo = int.Parse(row.ItemArray[0].ToString());
}
if (fileNo == 1)
{
foreach (DataRow row in DataBase.executeQuery("select id from mt_file where media= " + sMediaId).Rows)
{
sFilePath = getFilePath(int.Parse(row.ItemArray[0].ToString()));
}
try
{
Process.Start(@sFilePath);
}
catch
{
}
}
else if (fileNo > 1)
{
FilePreview file = new FilePreview(DataBase.ConnectionString, sMediaId);
file.ShowDialog();
}
}
public int updateMedia(string sDirectory, string sStartDirectory, int iFolderId, int iMediaType, int iStructure)
{
int iMediaId = 0;
String sPath;
try
{
sPath = sDirectory.Substring(sDirectory.IndexOf(sStartDirectory) + sStartDirectory.Length + 1);;
}
catch
{
MessageBox.Show("In starting directory exists movies witch is not in subfolders.");
return(-1);
}
String sFOlderName = sPath;
if (sPath.LastIndexOf("\\") >= 0)
{
sFOlderName = sPath.Substring(sPath.LastIndexOf("\\") + 1);
}
if (iMediaType == 2 && hasSeasones(sFOlderName))//serija koja ima sezone
{
try
{
sPath = sPath.Substring(0, sPath.LastIndexOf("\\"));
}
catch { }
}
//select media if exists end return MediaId
foreach (DataRow dr in DataBase.executeQuery("select id from mt_media where path= '" + duplicateApostrof(sPath) + "' and folder = " + iFolderId).Rows)
{
return(int.Parse(dr.ItemArray[0].ToString()));
}
String sNaziv = mediaName(sPath);
String sYear = getYear(sPath, iMediaId, iStructure);
String sGenre = getGenre(sPath, iMediaType, iStructure);
String sType = "Movies";
if (iMediaType == 2)
{
sType = "Series";
}
//insert media
iMediaId = getMaxId("mt_media") + 1;
String sQuery = "insert into mt_media(id,folder,path,name,year,genre,ratings,fl_watched,type) values(" +
iMediaId + "," +
iFolderId + ",'" +
duplicateApostrof(sPath) + "','" +
duplicateApostrof(sNaziv) + "','" +
sYear + "','" +
sGenre + "', 0 ,'N','" +
sType +
"')";
DataBase.executeNonQuery(sQuery);
return(iMediaId);
}
