Beispiel #1
0
        // Vraag 1 klant op
        //http://www.codeguru.com/csharp/.net/returning-images-from-asp.net-web-api.htm
        public Klant Get(int id)
        {
            try
            {
                string sql = "SELECT * FROM klanten WHERE id = @Id";
                List <SqlParameter> parameters = new List <SqlParameter> {
                    new SqlParameter("id", id)
                };

                DataSet ds = dataProvider.Query(sql, parameters);

                return(DataRowToObject(ds.Tables[0].Rows[0]));
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message + " | Line: " + new StackTrace(ex, true).GetFrame(0).GetFileLineNumber().ToString());
                return(null);
            }
        }
Beispiel #2
0
        /* Vraag foto ids voor fotoserie op */
        public IEnumerable <int> GetAll(int fotoserieId)
        {
            List <int> fotoIds = new List <int>();

            try
            {
                string       sql       = "SELECT id FROM fotos WHERE fotoserie_id = @FotoserieId";
                SqlParameter parameter = new SqlParameter("FotoserieId", fotoserieId);

                DataSet ds = dataProvider.Query(sql, parameter);

                foreach (DataRow r in ds.Tables[0].Rows)
                {
                    fotoIds.Add(Convert.ToInt32(r["id"]));
                }
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.Message);
            }
            return(fotoIds);
        }
        public List <FotoProduct> GetAll()
        {
            List <FotoProduct> fotoproducten = new List <FotoProduct>();

            try
            {
                string sql = "SELECT * FROM fotoproducten";

                DataSet ds = dataProvider.Query(sql);

                foreach (DataRow r in ds.Tables[0].Rows)
                {
                    fotoproducten.Add(DataRowToObject(r));
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message, ex);
            }

            return(fotoproducten);
        }
        public IEnumerable <Fotoserie> GetAll()
        {
            List <Fotoserie> fotoseries = new List <Fotoserie>();

            try
            {
                string sql = "SELECT * FROM fotoseries";

                DataSet ds = dataProvider.Query(sql);

                foreach (DataRow r in ds.Tables[0].Rows)
                {
                    fotoseries.Add(DataRowToObject(r));
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message, ex);
            }

            return(fotoseries);
        }