/*
* // THIS METHOD IS NO LONGER USED AND IS INSTEAD IN THE REBUILD SCRIPT
*
* // This method runs all of the procedures in the procedures.txt file.
* public static void RerunAllProcedures()
* {
* using (StreamReader sr = new StreamReader("..\\..\\config\\procedures.txt"))
* {
* while (!sr.EndOfStream)
* {
* string line = sr.ReadLine();
* using (StreamReader sr2 = new StreamReader(line))
* {
* string sql = "";
* while (!sr2.EndOfStream)
* {
* string ln = sr2.ReadLine();
* if (ln.ToLower() == "go")
* {
* Run(sql, line);
* sql = "";
* }
* else
* {
* sql += ln + ' ';
* }
* }
* if (sql != "")
* Run(sql, line);
* }
* }
* }
*
* MessageBox.Show("All procedures successfully run");
* }
*/
// Add a movie to the database
public static bool AddMovie(string MovieName, int directorId, int studioId, string date, string rating, int length)
{
try
{
Call(SqlProcedures.AddMovie(MovieName, directorId, studioId, date, rating, length));
return(true);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(false);
}
}
