public void Create(PersonasFisicasEModel entity) { using (SqlCommand cmd = new SqlCommand("sp_AgregarPersonaFisica", _context, _transaction)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Nombre", entity.Nombre)); cmd.Parameters.Add(new SqlParameter("@ApellidoPaterno", entity.ApellidoPaterno)); cmd.Parameters.Add(new SqlParameter("@ApellidoMaterno", entity.ApellidoMaterno)); cmd.Parameters.Add(new SqlParameter("@RFC", entity.RFC)); cmd.Parameters.Add(new SqlParameter("@FechaNacimiento", entity.FechaNacimiento)); cmd.Parameters.Add(new SqlParameter("@UsuarioAgrega", entity.UsuarioAgrega)); using (var reader = cmd.ExecuteReader()) { reader.Read(); var response = new { Error = Convert.ToInt32(reader["ERROR"]), ErrorMessage = Convert.ToString(reader["MENSAJEERROR"]), }; if (response.Error < 1) { throw new Exception(response.ErrorMessage); } }; } }
public IActionResult Editar(int id) { PersonasFisicasEModel model = new PersonasFisicasEModel { Id = id }; var user = User.Identity.Name; return(View(model)); }
public void Remove(PersonasFisicasEModel entity) { using (SqlCommand cmd = new SqlCommand("sp_EliminarPersonaFisica", _context, _transaction)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@IdPersonaFisica", entity.Id)); var ss = cmd.ExecuteNonQuery(); } }
public IActionResult Update([FromBody] PersonasFisicasEModel model) { try { return(Ok(_personasFisicasBL.Update(model))); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } }
public IActionResult Create([FromBody] PersonasFisicasEModel model) { try { _personasFisicasBL.Create(model); return(Ok(new { Data = true })); } catch (Exception ex) { return(StatusCode(500, ex.Message)); } }
public void Create(PersonasFisicasEModel model) { model.Activo = true; model.UsuarioAgrega = _userService.UserLogued().Id; model.FechaRegistro = DateTime.Now; try { _unitOfWork.Repositories.PersonasFisicasRepository.Create(model); _unitOfWork.SaveChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } }
public PersonasFisicasEModel Update(PersonasFisicasEModel model) { model.Activo = true; model.FechaActualizacion = DateTime.Now; var entity = GetById(model.Id); try { if (entity == null) { throw new Exception("No se encontró el usuario " + model.Id); } _unitOfWork.Repositories.PersonasFisicasRepository.Update(model); _unitOfWork.SaveChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } return(model); }