public void SetMovieStopTime(int movieId, int userId, int stoptime) { try { QueryUpdate setStopTime = new QueryUpdate(String.Format(_setStopTime, movieId, userId, stoptime)); setStopTime.Execute(_connection); } catch (Exception ex) { Log.Error("MyMovies::SetMovieStopTime - exception err:{0} stack:{1}", ex.Message, ex.StackTrace); } }
public void SetMovieStopTimeAndResumeData(int movieId, int userId, int stoptime, byte[] resumeData, string pathName) { try { // Only store the file not the path as the next watch may be from a different machine. // Delimit the SQL string quotes. string fileName = Path.GetFileName(pathName).Replace("'", "''"); string resumeString = "-"; if (resumeData != null) resumeString = ToHexString(resumeData); string query; QueryValue exists = new QueryValue(String.Format("SELECT count(*) FROM tblResume WHERE intId={0} AND intUserId={1}", movieId, userId)); if (Convert.ToInt32(exists.Execute(_connection)) == 0) { query = String.Format("INSERT INTO tblResume (intId, intUserId, intStopTime, nvcResumeData, nvcFileName, datLastPlayed) VALUES({0},{1},{2},'{3}', '{4}', GETDATE())", movieId, userId, stoptime, resumeString, fileName); } else { query = String.Format("UPDATE tblResume SET intStopTime={0}, nvcResumeData='{1}', nvcFileName='{2}', datLastPlayed=GETDATE() WHERE intId={3} AND intUserId={4}", stoptime, resumeString, fileName, movieId, userId); } QueryUpdate update = new QueryUpdate(query); update.Execute(_connection); } catch (Exception ex) { Log.Error("videodatabase exception err:{0} stack:{1}", ex.Message, ex.StackTrace); } }
public void SetMovieWatched(int movieId, bool yes) { try { QueryUpdate update = new QueryUpdate(string.Format("UPDATE tblTitlePersonal SET bitWatched = {0} WHERE intTitle = {1}", (yes) ? 1 : 0, movieId)); update.Execute(_connection); } catch (Exception ex) { Log.Error("MyMovies::SetMovieWatched - unable to set watched status"); Log.Error(ex); } }
private void btnTestConnection_Click(object sender, EventArgs e) { try { string connection = QueryReader<int>.Connection(txtServerName.Text, txtDBInstance.Text, txtUserName.Text, txtPassword.Text); using (SqlConnection conn = new SqlConnection(connection)) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 5; cmd.CommandText = _tblResumeExists; conn.Open(); // if the table does not exist, then create it. if (System.Convert.ToInt32(cmd.ExecuteScalar()) == 0) { QueryUpdate createTable = new QueryUpdate(_createTableResume); createTable.Execute(connection); } // else check if the UserId column exists else { cmd.CommandText = _userIdExists; // if the table does not exist, then create it. if (System.Convert.ToInt32(cmd.ExecuteScalar()) == 0) { QueryUpdate createTable = new QueryUpdate(_addUserId); createTable.Execute(connection); } } } TestConnectionResult(true); } catch (SqlException sqlEx) { TestConnectionResult(false); Log.Debug("MyMovies::btnTestConnection_Click - Sql Exception '{0}'", sqlEx.Message); } catch (Exception ex) { TestConnectionResult(false); Log.Debug("MyMovies::btnTestConnection_Click - Exception '{0}'", ex.Message); } }