public void Delete(SQLiteDatabase db)
{
// delete users
db.ExecuteNonQuery("DELETE FROM ProjectUser WHERE ProjectID=" + Id);
// delete project
db.ExecuteNonQuery("DELETE FROM Project WHERE ID=" + Id);
}
public void ChangeNotificationStatus(SQLiteDatabase db)
{
int n = Notified ? 1 : 0;
String sql = "UPDATE ProjectUser SET Notified=" + n + " where ID=" + Id;
db.ExecuteNonQuery(sql);
}
/// <summary>
/// Stores the Project into database. Returns true if the project is new.
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public bool Store(SQLiteDatabase db)
{
// make the texts safe
String t = Title.Replace("'", "''");
String m = Message.Replace("'", "''");
String a = Attachment == null ? "" : Attachment.Replace("'", "''");
if (id == 0)
{
// insert
String sql = "INSERT INTO Project (Title, Message, Attachment) VALUES ('" + t + "', '" + m + "', '" + a + "'); SELECT last_insert_rowid()";
Id = Int16.Parse(db.ExecuteScalar(sql));
return true;
}
else
{
// update
String sql = "UPDATE Project SET Title='" + t + "', Message='" + m + "', Attachment='" + a + "' WHERE ID=" + Id;
db.ExecuteNonQuery(sql);
return false;
}
}
