Example #1
0
 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);
 }
Example #2
0
 public void Insert(SQLiteDatabase db)
 {
     if (Id != 0)
     {
         throw new Exception("Already inserted");
     }
     String sql = "INSERT INTO ProjectUser (ProjectID, Login, Notified) VALUES ('" + ProjectId + "', '" + Login + "', 0); SELECT last_insert_rowid()";
     Id = Int16.Parse(db.ExecuteScalar(sql));
 }
Example #3
0
        /// <summary>
        ///  Collect users from the current page in browser
        /// </summary>
        private void TakePeople()
        {
            stText.Text = "Reading users";

            SQLiteDatabase db = new SQLiteDatabase();
            // take people
            HtmlElementCollection tdlist = browser.Document.GetElementsByTagName("td");
            foreach (HtmlElement td in tdlist)
            {
                if (td.GetAttribute("className").Equals("cf-user"))
                {
                    // there is a user login in the first image
                    HtmlElement img = td.GetElementsByTagName("img")[0];
                    String login = img.GetAttribute("alt");
                    bool found = false;
                    try
                    {
                        users.First(user => user.Login.Equals(login));
                        found = true;
                    }
                    catch { }
                    if (!found)
                    {
                        ProjectUser user = new ProjectUser();
                        user.ProjectId = activeProject.Id;
                        user.Login = login;
                        // insert into db
                        user.Insert(db);
                        // add to list
                        users.Add(user);
                    }
                }
            }

            // check 'Next page'
            HtmlElement a = browser.Document.GetElementById("PrevLink");
            if (a != null)
            {
                a.InvokeMember("Click");
                return;
            }

            // No more users
            ResetParser();
            MessageBox.Show("Done");
        }
Example #4
0
 public void ChangeNotificationStatus(SQLiteDatabase db)
 {
     int n = Notified ? 1 : 0;
     String sql = "UPDATE ProjectUser SET Notified=" + n + " where ID=" + Id;
     db.ExecuteNonQuery(sql);
 }
Example #5
0
        /// <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;
            }
        }