예제 #1
0
        public bool Delete(CrudRequest request)
        {
            Database.Crud dbCrud = null;

            try
            {
                dbCrud = _context.Cruds.FirstOrDefault(__crud => __crud.CrudId.Equals(request.Id));

                if (dbCrud == null || dbCrud.CrudId == 0)
                {
                    return(false);
                }

                _context.Cruds.Remove(dbCrud);

                _context.SaveChanges();

                return(true);
            }
            catch (CrudException ex)
            {
                throw new CrudException("Ocorreu um erro na Alteração. Erro: " + ex.Message);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
예제 #2
0
        public bool Create(CrudRequest request)
        {
            try
            {
                Database.Crud dbCrud = new Database.Crud()
                {
                    FullName     = request.FullName,
                    EmailAddress = request.EmailAddress,
                    PhoneNumber  = request.PhoneNumber
                };

                _context.Cruds.Add(dbCrud);
                _context.SaveChanges();

                if (dbCrud.CrudId > 0)
                {
                    return(true);
                }
            }
            catch (CrudException ex)
            {
                throw new CrudException("Ocorreu um erro no Cadastro. Erro: " + ex.Message);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(false);
        }
예제 #3
0
        public bool Edit(CrudRequest request)
        {
            Database.Crud dbCrud = null;

            try
            {
                dbCrud = _context.Cruds.FirstOrDefault(__crud => __crud.CrudId.Equals(request.Id));

                if (dbCrud == null || dbCrud.CrudId == 0)
                {
                    return(false);
                }

                dbCrud.FullName     = request.FullName;
                dbCrud.EmailAddress = request.EmailAddress;
                dbCrud.PhoneNumber  = request.PhoneNumber;

                _context.SaveChanges();

                return(true);
            }
            catch (CrudException ex)
            {
                throw new CrudException("Ocorreu um erro na Alteração. Erro: " + ex.Message);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
예제 #4
0
        public bool GetRecord(out CrudRequest Crud, CrudRequest request)
        {
            Database.Crud dbCrud = null;

            try
            {
                dbCrud = _context.Cruds
                         .FilterCruds(request)
                         .OrderBy(__crud => __crud.FullName)
                         .FirstOrDefault();

                if (dbCrud == null || dbCrud.CrudId == 0)
                {
                    throw new CrudException("O Registro solicitado não existe!");
                }

                Crud = new CrudRequest(dbCrud.CrudId, dbCrud.FullName, dbCrud.EmailAddress, dbCrud.PhoneNumber);

                return(true);
            }
            catch (CrudException ex)
            {
                throw new CrudException(ex.Message);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }