Esempio n. 1
0
        // This method is used for Sync (WIT_CREATED,WIT_SHARED,WIT_COPIED..)
        public void saveSingleWit(Wits wit)
        {
            saveWits(wit);
            saveWitAttachments(restWit.getWitsInfo(wit.id));

        }
Esempio n. 2
0
        //Get wits details
        public Wits getWit(String witId)
        {
            Wits wit;

            try {
                sql_con = new SQLiteConnection(Common.localDatabasePath, true);
                sql_cmd = new SQLiteCommand("select * from wits where id=@id", sql_con);

                sql_cmd.Parameters.Add("@id", DbType.String);
                sql_cmd.Parameters["@id"].Value = witId;

                sql_con.Open();
                SQLiteDataReader reader = sql_cmd.ExecuteReader();

                wit = new Wits();
                while (reader.Read())
                {

                    wit.id = StringUtils.ConvertFromDBVal<string>(reader["id"]);
                    wit.name = StringUtils.ConvertFromDBVal<string>(reader["name"]);
                    wit.type = StringUtils.ConvertFromDBVal<string>(reader["type"]);
                    wit.desc = StringUtils.ConvertFromDBVal<string>(reader["desc"]);
                    wit.content = StringUtils.ConvertFromDBVal<string>(reader["content"]);

                }
            }
            catch (SQLiteException e) { throw e; }
            finally { sql_con.Close(); }
            
            return wit;

        }
Esempio n. 3
0
        // Save wits 
        public void saveWits(Wits wits)
        {
            try { 

            var workspaceInsertQuery = Resource.ResourceManager.GetString("wits_insert");
            sql_con = new SQLiteConnection(Common.localDatabasePath, true);
            sql_cmd = new SQLiteCommand(workspaceInsertQuery, sql_con);

            sql_cmd.Parameters.Add("@id", DbType.String);
            sql_cmd.Parameters["@id"].Value = wits.id;

            sql_cmd.Parameters.Add("@name", DbType.String);
            sql_cmd.Parameters["@name"].Value = wits.name;

            sql_cmd.Parameters.Add("@type", DbType.String);
            sql_cmd.Parameters["@type"].Value = wits.type;

            sql_cmd.Parameters.Add("@workspace_id", DbType.String);
            sql_cmd.Parameters["@workspace_id"].Value = wits.workspaceId;

            sql_cmd.Parameters.Add("@enterprise_id", DbType.String);
            sql_cmd.Parameters["@enterprise_id"].Value = wits.enterpriseId;

            sql_cmd.Parameters.Add("@witType", DbType.String);
            sql_cmd.Parameters["@witType"].Value = wits.witType;

            sql_cmd.Parameters.Add("@parent_id", DbType.String);
            sql_cmd.Parameters["@parent_id"].Value = wits.parentId;

            sql_cmd.Parameters.Add("@children", DbType.String);
            sql_cmd.Parameters["@children"].Value = wits.children;

            sql_cmd.Parameters.Add("@hasChildren", DbType.String);
            sql_cmd.Parameters["@hasChildren"].Value = wits.hasChildren;

            sql_cmd.Parameters.Add("@updateNumber", DbType.String);
            sql_cmd.Parameters["@updateNumber"].Value = wits.updateNumber;

            sql_cmd.Parameters.Add("@ratingCount", DbType.String);
            sql_cmd.Parameters["@ratingCount"].Value = wits.ratingCount;

            sql_cmd.Parameters.Add("@ratingAggregation", DbType.String);
            sql_cmd.Parameters["@ratingAggregation"].Value = wits.ratingAggregation;

            sql_cmd.Parameters.Add("@desc", DbType.String);
            sql_cmd.Parameters["@desc"].Value = wits.desc;

            sql_cmd.Parameters.Add("@content", DbType.String);
            sql_cmd.Parameters["@content"].Value = wits.content;

            sql_cmd.Parameters.Add("@isFavorite", DbType.String);
            sql_cmd.Parameters["@isFavorite"].Value = wits.isFavorite;

            sql_cmd.Parameters.Add("@witType", DbType.String);
            sql_cmd.Parameters["@witType"].Value = wits.witType;

            sql_cmd.Parameters.Add("@status", DbType.String);
            sql_cmd.Parameters["@status"].Value = wits.status;

            sql_cmd.Parameters.Add("@label", DbType.String);
            sql_cmd.Parameters["@label"].Value = wits.label;


            sql_con.Open();
            sql_cmd.ExecuteNonQuery();
        }
            catch (SQLiteException e) { throw e; }
            finally { sql_con.Close(); }

        }
Esempio n. 4
0
        // not implemented/used
        public List<Wits> getAllWits(String parentFolderId)
        {

            List<Wits> wits;
            try { 
            sql_con = new SQLiteConnection(Common.localDatabasePath, true);
            sql_cmd = new SQLiteCommand("select * from wits where parent_id=@parent_id", sql_con);

            sql_cmd.Parameters.Add("@parent_id", DbType.String);
            sql_cmd.Parameters["@parent_id"].Value = parentFolderId;

            sql_con.Open();
            SQLiteDataReader reader = sql_cmd.ExecuteReader();

            wits = new List<Wits>();
            while (reader.Read())
            {
                Wits wit = new Wits();
                wit.id = StringUtils.ConvertFromDBVal<string>(reader["id"]);
                wit.name = StringUtils.ConvertFromDBVal<string>(reader["name"]);

                wits.Add(wit);
            }
        }
            catch (SQLiteException e) { throw e; }
            finally { sql_con.Close(); }
            return wits;
        }