예제 #1
0
파일: DAO.cs 프로젝트: Spectre135/CRU_v2
        private string GetSQLRowsCount()
        {
            StringBuilder sbSql = new StringBuilder();

            sbSql.Append("Select cast(count(*) as int) count from Aplikacija_view ");
            sbSql.Append(" where ").Append(ReflectPropertyInfo.GetSearchFields(new DAplikacija())).Append(" like @searchParam ");

            return(sbSql.ToString());
        }
예제 #2
0
파일: DAO.cs 프로젝트: Spectre135/CRU_v2
        private string GetSQL(string sortKey, string asceding)
        {
            StringBuilder sbSql = new StringBuilder();

            sbSql.Append("Select  * from Aplikacija_view ");
            sbSql.Append(" where ").Append(ReflectPropertyInfo.GetSearchFields(new DAplikacija())).Append(" like @searchParam ");
            //sbSql.Append(" ORDER BY ");
            //sbSql.Append(sortKey.Equals("null") ? " Datum " : sortKey + (asceding.Equals("true") ? " ASC " : " DESC "));
            //sbSql.Append(" OFFSET @pageSize*(@pageIndex-1) ROWS FETCH NEXT @pageSize ROWS ONLY;");

            return(sbSql.ToString());
        }
예제 #3
0
파일: DAO.cs 프로젝트: Spectre135/CRU_v2
        public IEnumerable <DAplikacija> GetData(string query, int pageIndex, int pageSize, string sortKey, string asceding)
        {
            try
            {
                List <DAplikacija> result = new List <DAplikacija>();

                SQLiteConnection connection = new SQLiteConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString);

                using (connection)
                {
                    connection.Open();
                    SQLiteCommand cmd;
                    using (cmd = new SQLiteCommand(this.GetSQL(sortKey, asceding), connection))
                    {
                        cmd.CommandType = CommandType.Text;
                        cmd.Parameters.AddWithValue("@searchParam", "%" + query + "%");
                        //cmd.Parameters.AddWithValue("@pageSize", pageSize);
                        //cmd.Parameters.AddWithValue("@pageIndex", pageIndex);

                        SQLiteDataReader reader = cmd.ExecuteReader();
                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                result.Add(ReflectPropertyInfo.ReflectType <DAplikacija>(reader));
                            }
                        }
                    }
                }
                return(result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                //connection.Close(); //tega ne rabimo če uporabimo using
            }
        }
예제 #4
0
파일: DAO.cs 프로젝트: Spectre135/CRU_v2
        public static IEnumerable <DSifranti> GetSifranti(string id)
        {
            try
            {
                List <DSifranti> result = new List <DSifranti>();

                SQLiteConnection connection = new SQLiteConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString);

                using (connection)
                {
                    connection.Open();
                    SQLiteCommand cmd;
                    using (cmd = new SQLiteCommand("Select * from Sifranti where id = @id", connection))
                    {
                        cmd.CommandType = CommandType.Text;
                        cmd.Parameters.AddWithValue("@id", id);

                        SQLiteDataReader reader = cmd.ExecuteReader();
                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                result.Add(ReflectPropertyInfo.ReflectType <DSifranti>(reader));
                            }
                        }
                    }
                }
                return(result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                //connection.Close(); //tega ne rabimo če uporabimo using
            }
        }