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; } }
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); }
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; } }
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; } }