/**
* 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;
}
