Example #1
0
        /// <summary>
        /// reads in the active, but deleted requests
        /// </summary>
        /// <returns>DataTable of deleted resuest</returns>
        public DataTable createDataTableDeletedRequests()
        {
            modelRequestRead = new RequestsModelReadIn(dbci, parent);
            table            = new DataTable();
            table.Columns.Add("Kérő neve", typeof(string));
            table.Columns.Add("Kérő területe", typeof(string));
            table.Columns.Add("Kérés dátuma", typeof(string));
            table.Columns.Add("Termék neve", typeof(string));
            table.Columns.Add("Mennyiség", typeof(int));
            table.Columns.Add("Termék kiszerelése", typeof(int));
            table.Columns.Add("Törlő neve", typeof(string));

            try
            {
                requestDeleted = modelRequestRead.getDeletedRequests();
                foreach (RequestRecordDeleted r in requestDeleted)
                {
                    table.Rows.Add(r.userKeroNev, r.userTerulet, r.keresDatum, r.termekNev, r.keresMennyiseg,
                                   r.termekKiszerel, r.keresModosNev);
                }
            }
            catch (ErrorServiceCreateDataList e)
            {
                throw new ErrorServiceRequests(e.Message);
            }
            catch (Exception e)
            {
                throw new ErrorServiceRequests("Ismeretlen hiba történt (ServRequ_DTDel) " + e.Message);
            }
            return(table);
        }