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 clearAll() { DialogResult dialog = MessageBox.Show("Do you realy want to clear all data?", "Information", MessageBoxButtons.YesNo); if (dialog == DialogResult.Yes) { DataBase.executeNonQuery("delete from mt_file"); DataBase.executeNonQuery("delete from mt_media"); DataBase.executeNonQuery("delete from mt_folder"); DataBase.executeNonQuery("delete from mt_drive"); RefreshData(); } }
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); }