/** * Return a stack containing all unprocessed files */ public Stack<Ppt> GetUnprocessedFiles() { Stack<Ppt> st = new Stack<Ppt>(); string sql = "SELECT id, pptfile, jpg_export_status, jpg_export_version " + "FROM ppt_ppt " + "WHERE jpg_export_status = '0'"; // MySqlCommand cmd = new MySqlCommand(sql, myCon); // MySqlDataReader rdr = cmd.ExecuteReader(); NpgsqlCommand cmd = new NpgsqlCommand(sql, myCon); NpgsqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Ppt pptFile = new Ppt(); pptFile.id = Int32.Parse(rdr[0].ToString()); pptFile.file = rdr[1].ToString(); pptFile.exported_to_jpg = rdr[2].ToString(); st.Push(pptFile); } rdr.Close(); return st; }
/** * Update the contents of the file in the database */ public void Update(Ppt pptFile) { // Update export status. string sql = "UPDATE ppt_ppt " + " SET jpg_export_status = '" + pptFile.exported_to_jpg + "' " + " WHERE id = " + pptFile.id; //MySqlCommand cmd = new MySqlCommand(sql, myCon); NpgsqlCommand cmd = new NpgsqlCommand(sql, myCon); cmd.ExecuteNonQuery(); // Now update jpg files. this.UpdatePptJpgs(pptFile); }
private void UpdatePptJpgs(Ppt pptFile) { // Remove all old jpg images. string sql = "DELETE FROM ppt_pptjpg WHERE ppt_id = " + pptFile.id; NpgsqlCommand cmd = new NpgsqlCommand(sql, myCon); cmd.ExecuteNonQuery(); // Add each into the db again. Stack<PptJpg> st = pptFile.getJpgsFromFileSystem(); foreach(PptJpg pptJpg in st) { sql = "INSERT INTO ppt_pptjpg (filename, size, height, width, ppt_id) VALUES ('" + pptJpg.filename + "', " + pptJpg.size.ToString() + ", " + pptJpg.height.ToString() + ", " + pptJpg.width.ToString() + ", " + pptFile.id.ToString() + ")"; cmd = new NpgsqlCommand(sql, myCon); cmd.ExecuteNonQuery(); } }
public PowerPoint(Ppt ppt_arg) { this.ppt = ppt_arg; }