public ResultResponse <InfraccionResponse> GetByType(PapeletaVirtualDBContext _context, string type)
{
try
{
ResultResponse <InfraccionResponse> response = new ResultResponse <InfraccionResponse>();
var firstresult = _context.Infraccion.Any(x => x.Type == type);
if (firstresult)
{
var result = _context.Infraccion.FirstOrDefault(x => x.Type == type);
InfraccionResponse infraccionResponse = new InfraccionResponse {
Id = result.Id,
Type = result.Type,
Code = result.Code,
Price = result.Price,
Details = result.Details
};
response.Data = infraccionResponse;
response.Error = false;
response.Message = "Datos encontrados";
}
else
{
response.Data = null;
response.Error = true;
response.Message = "Datos no encontrados";
}
return(response);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ResultResponse <LoginAutoridadResponse> LogInAutoridad(PapeletaVirtualDBContext _context, IConfiguration _config, LoginEntity model)
{
try
{
var userAutoridad = false;
ResultResponse <LoginAutoridadResponse> response = new ResultResponse <LoginAutoridadResponse>();
userAutoridad = _context.Autoridad.Any(x => x.Username == model.Username && x.Password == model.Password);
if (userAutoridad)
{
var autoridad = _context.Autoridad.FirstOrDefault(x => x.Username == model.Username && x.Password == model.Password);
LoginTokenAutoridad(_config, autoridad, response);
}
else
{
userAutoridad = _context.Autoridad.Any(x => x.Email == model.Username && x.Password == model.Password);
if (userAutoridad)
{
var autoridad = _context.Autoridad.FirstOrDefault(x => x.Email == model.Username && x.Password == model.Password);
LoginTokenAutoridad(_config, autoridad, response);
}
if (!userAutoridad)
{
response.Data = null;
response.Error = true;
response.Message = "Usuario y/o password incorrecto";
}
}
return(response);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ResultResponse <PlacaResponse> getByPlaca(PapeletaVirtualDBContext _context, string numplaca)
{
try
{
ResultResponse <PlacaResponse> response = new ResultResponse <PlacaResponse>();
var firstresult = _context.Placa.Any(x => x.NumPlaca == numplaca);
if (firstresult)
{
var result = _context.Placa.FirstOrDefault(x => x.NumPlaca == numplaca);
PlacaResponse placaResponse = new PlacaResponse {
Id = result.Id,
CarBrand = result.CarBrand,
CarModel = result.CarModel,
ReleaseDate = result.ReleaseDate,
TransportDetails = result.TransportDetails,
NumPlaca = result.NumPlaca
};
response.Data = placaResponse;
response.Error = false;
response.Message = "Datos encontrados";
}
else
{
response.Data = null;
response.Error = true;
response.Message = "Datos no encontrados";
}
return(response);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ResultResponse <PlacaResponse> AddPlaca(PapeletaVirtualDBContext _context, PlacaEntity model)
{
try
{
PlacaResponse placaResponseforAdd;
ResultResponse <PlacaResponse> response = new ResultResponse <PlacaResponse>();
if (model == null)
{
response.Data = null;
response.Error = true;
response.Message = "Completar todos los campos";
return(response);
}
if (_context.Placa.Any(x => x.NumPlaca == model.NumPlaca))
{
response.Data = null;
response.Error = true;
response.Message = "El número de Placa ya existe";
return(response);
}
else
{
using (var ts = new TransactionScope()){
Models.Placa placa = new Models.Placa();
_context.Placa.Add(placa);
placa.CarBrand = model.CarBrand;
placa.CarModel = model.CarModel;
placa.TransportDetails = model.TransportDetails;
placa.NumPlaca = model.NumPlaca;
_context.SaveChanges();
ts.Complete();
response.Data = null;
response.Error = false;
response.Message = "Placa registrada";
}
var result = _context.Placa.FirstOrDefault(x => x.NumPlaca == model.NumPlaca);
placaResponseforAdd = new PlacaResponse {
Id = result.Id,
CarBrand = result.CarBrand,
CarModel = result.CarModel,
ReleaseDate = result.ReleaseDate,
TransportDetails = result.TransportDetails,
NumPlaca = result.NumPlaca
};
response.Data = placaResponseforAdd;
response.Error = false;
response.Message = "Placa registrada";
}
return(response);
}
catch (Exception ex)
{
throw new System.Exception(ex.Message);
}
}
public ResultResponse <string> RegisterAutoridad(PapeletaVirtualDBContext _context, AutoridadEntity model)
{
try
{
ResultResponse <string> response = new ResultResponse <string>();
char[] s = { ' ' };
string[] slastname;
if (model == null)
{
response.Data = null;
response.Error = true;
response.Message = "Complete los datos";
}
else
{
if (_context.Autoridad.Any(x => x.Email == model.Email))
{
response.Data = null;
response.Error = true;
response.Message = "El correo ya existe";
}
if (_context.Autoridad.Any(x => x.Phone == model.Phone))
{
response.Data = null;
response.Error = true;
response.Message = "El numero de telefono ya existe";
}
using (var ts = new TransactionScope()){
Models.Autoridad autoridad = new Models.Autoridad();
_context.Autoridad.Add(autoridad);
autoridad.Name = model.Name;
autoridad.Lastname = model.Lastname;
autoridad.Email = model.Email;
//autoridad.Username = model.Username;
slastname = model.Lastname.Split(s, 2, StringSplitOptions.None);
autoridad.Username = model.Name.Substring(0, 1).ToLower() + slastname[0].ToLower() + "pnp";
autoridad.Password = model.Password;
autoridad.State = ConstantHelpers.Estado.Activo;
autoridad.Phone = model.Phone;
autoridad.Cip = model.Cip;
_context.SaveChanges();
ts.Complete();
response.Data = null;
response.Error = false;
response.Message = "Registro satisfactorio";
}
}
return(response);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ResultResponse <string> AddPapeleta(PapeletaVirtualDBContext _context, PapeletaEntity model)
{
try
{
ResultResponse <string> response = new ResultResponse <string>();
if (model.IdInfractor == null)
{
response.Data = null;
response.Error = true;
response.Message = "Se necesita los datos del Infractor ";
return(response);
}
if (model.IdPlaca == null)
{
response.Data = null;
response.Error = true;
response.Message = "Se necesita los datos del vehiculo";
return(response);
}
if (model.IdInfraccion == null)
{
response.Data = null;
response.Error = true;
response.Message = "Se necesita ingresar una infraccion";
return(response);
}
using (var ts = new TransactionScope()){
Models.Papeleta papeleta = new Models.Papeleta();
_context.Papeleta.Add(papeleta);
papeleta.IdInfraccion = model.IdInfraccion;
papeleta.IdPlaca = model.IdPlaca;
papeleta.IdInfractor = model.IdInfractor;
papeleta.CreateDate = model.CreateDate;
papeleta.Photo = model.Photo;
papeleta.State = ConstantHelpers.Estado.Activo;
papeleta.Details = model.Details;
papeleta.City = model.City;
papeleta.IdAutoridad = model.IdAutoridad;
_context.SaveChanges();
ts.Complete();
response.Data = null;
response.Error = false;
response.Message = "Papeleta guardada con éxito";
}
return(response);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public PlacaController(PapeletaVirtualDBContext context)
{
_context = context;
}
public InfraccionController(PapeletaVirtualDBContext context)
{
_context = context;
}
public LoginApiController(PapeletaVirtualDBContext context, IConfiguration config)
{
_context = context;
_config = config;
}
public AutoridadApiController(PapeletaVirtualDBContext context)
{
_context = context;
}
public ResultResponse <InfractorResponse> Add(PapeletaVirtualDBContext _context, InfractorEntity model)
{
try
{
InfractorResponse infractorResponseforAdd;
//ResultResponse<string> response = new ResultResponse<string>();
ResultResponse <InfractorResponse> response = new ResultResponse <InfractorResponse>();
if (model.Dni == null)
{
response.Data = null;
response.Error = true;
response.Message = "Se necesita el numero de dni";
return(response);
}
if (model.Email == null)
{
response.Data = null;
response.Error = true;
response.Message = "Se necesita el email";
return(response);
}
if (model.Name == null)
{
response.Data = null;
response.Error = true;
response.Message = "Se necesita el nombre";
return(response);
}
if (_context.Infractor.Any(x => x.Dni == model.Dni))
{
response.Data = null;
response.Error = true;
response.Message = "El número de DNI ya existe";
return(response);
}
else
{
using (var ts = new TransactionScope()){
Models.Infractor infractor = new Models.Infractor();
_context.Infractor.Add(infractor);
infractor.Name = model.Name;
infractor.Lastname = model.Lastname;
infractor.Dni = model.Dni;
infractor.Email = model.Email;
infractor.Phone = model.Phone;
infractor.State = ConstantHelpers.Estado.Activo;
infractor.CreateDate = model.CreateDate;
_context.SaveChanges();
ts.Complete();
}
var result = _context.Infractor.FirstOrDefault(x => x.Dni == model.Dni);
infractorResponseforAdd = new InfractorResponse {
Id = result.Id,
Name = result.Name,
Lastname = result.Lastname,
Dni = result.Dni,
Email = result.Email,
Phone = result.Phone,
State = result.State,
CreateDate = result.CreateDate
};
response.Data = infractorResponseforAdd;
response.Error = false;
response.Message = "Infractor registrado con éxito";
}
return(response);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ResultResponse <InfractorResponse> GetByDni(PapeletaVirtualDBContext _context, string dni)
{
try
{
ResultResponse <InfractorResponse> response = new ResultResponse <InfractorResponse>();
var firstresult = _context.Infractor.Any(x => x.Dni == dni);
if (firstresult)
{
var result = _context.Infractor.FirstOrDefault(x => x.Dni == dni);
InfractorResponse infractorResponse = new InfractorResponse {
Id = result.Id,
Name = result.Name,
Lastname = result.Lastname,
Dni = result.Dni,
Email = result.Email,
Phone = result.Phone,
State = result.State,
CreateDate = result.CreateDate,
Papeleta = _context.Papeleta.Where(y => y.IdInfractor == result.Id).Select(
y => new PapeletaResponse {
Id = y.Id,
CreateDate = y.CreateDate,
Photo = y.Photo,
State = y.State,
Details = y.Details,
City = y.City,
IdAutoridad = y.IdAutoridad,
Infractor = _context.Infractor.Where(w => w.Id == y.IdInfractor).Select(
w => new InfractorResponse {
Id = w.Id,
Name = w.Name,
Lastname = w.Lastname,
Dni = w.Dni,
Email = w.Email,
Phone = w.Phone,
State = w.State,
CreateDate = w.CreateDate
}
).ToList(),
Infraccion = _context.Infraccion.Where(z => z.Id == y.IdInfraccion).Select(
z => new InfraccionResponse {
Id = z.Id,
Type = z.Type,
Code = z.Code,
Price = z.Price,
Details = z.Details
}
).ToList()
}
).ToList(),
Licencia = _context.Licencia.Where(y => y.IdInfractor == result.Id).Select(
y => new LicenciaResponse {
Id = y.Id,
NumLicencia = y.NumLicencia,
Class = y.Class,
Category = y.Category,
CreationDate = y.CreationDate,
ExpirationDate = y.ExpirationDate,
Restriction = y.Restriction
}
).ToList()
};
response.Data = infractorResponse;
response.Error = false;
response.Message = "Datos encontrados";
}
else
{
response.Data = null;
response.Error = true;
response.Message = "Datos no encontrados";
}
return(response);
}catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ResultResponse <AutoridadResponse> GetById(PapeletaVirtualDBContext _context, int id)
{
try
{
ResultResponse <AutoridadResponse> response = new ResultResponse <AutoridadResponse>();
var firstresult = _context.Autoridad.Any(x => x.Id == id);
if (firstresult)
{
var result = _context.Autoridad.FirstOrDefault(x => x.Id == id);
//var resultPapeleta = _context.Papeleta.FirstOrDefault(x=>x.IdAutoridad==id);
AutoridadResponse autoridadResponse = new AutoridadResponse {
Id = result.Id,
Name = result.Name,
Lastname = result.Lastname,
Email = result.Email,
Username = result.Username,
Password = result.Password,
State = result.State,
Phone = result.Phone,
Cip = result.Cip,
Papeleta = _context.Papeleta.Where(y => y.IdAutoridad == result.Id).Select(
y => new PapeletaResponse {
Id = y.Id,
CreateDate = y.CreateDate,
Photo = y.Photo,
State = y.State,
Details = y.Details,
City = y.City,
IdAutoridad = y.IdAutoridad,
Infractor = _context.Infractor.Where(w => w.Id == y.IdInfractor).Select(
w => new InfractorResponse {
Id = w.Id,
Name = w.Name,
Lastname = w.Lastname,
Dni = w.Dni,
Email = w.Email,
Phone = w.Phone,
State = w.State,
CreateDate = w.CreateDate
}
).ToList(),
Infraccion = _context.Infraccion.Where(z => z.Id == y.IdInfraccion).Select(
z => new InfraccionResponse {
Id = z.Id,
Type = z.Type,
Code = z.Code,
Price = z.Price,
Details = z.Details
}
).ToList(),
Placa = _context.Placa.Where(z => z.Id == y.IdPlaca).Select(
z => new PlacaResponse {
Id = z.Id,
CarBrand = z.CarBrand,
CarModel = z.CarModel,
ReleaseDate = z.ReleaseDate,
TransportDetails = z.TransportDetails,
NumPlaca = z.NumPlaca
}
).ToList()
}
).ToList()
};
response.Data = autoridadResponse;
response.Error = false;
response.Message = "Datos encontrados";
}
else
{
response.Data = null;
response.Error = true;
response.Message = "Datos no encontrados";
}
return(response);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
