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