public async Task <bool> SendInfo(int idUser, ColaViewModel llamada)
{
bool state = false;
try
{
var Agendar = new agenda();
Agendar.idusuario = idUser;
Agendar.idpersona = llamada.idPersona;
Agendar.idproducto = 1;
Agendar.fecha = DateTime.Now.Date;
Agendar.hora = DateTime.Now.Date.TimeOfDay;
Agendar.idstate = 1;
Agendar.comentario = "Enviar Cartilla";
db.Add(Agendar);
await db.SaveChangesAsync();
state = true;
}
catch (Exception ex)
{
state = false;
}
return(state);
}
public async Task <ReplyViewModel> ChangeState([FromHeader] string auth, [FromBody] ColaViewModel llamado)
{
//Reply reply = new Reply();
int IdUser = _service.CheckToken(auth);
if (IdUser > 0)
{
if (await _service.UpdateCall(llamado))
{
reply.result = 1; reply.message = "Estado Actualizado";
}
else
{
reply.result = 0; reply.message = "No se Pudo Actualizar el Estado";
}
}
else
{
reply.result = 3;
reply.message = "Acceso no Permitido";
}
return(reply);
}
public IActionResult BorrarTicket(IndexViewModel model)
{
using (ticketDBContext db = new ticketDBContext())
{
lista = (from d in db.Colas
where d.Cola == model.cola
select new ColaViewModel
{
id = d.Id,
cola = d.Cola.Value,
ticket_id = d.TicketId.Value
}
).ToList();
if (lista.Count > 0)
{
ColaViewModel primerTicket = lista.ElementAt(0);
Colas primeroCola = new Colas();
primeroCola.Id = primerTicket.id;
primeroCola.Cola = primerTicket.cola;
primeroCola.TicketId = primerTicket.ticket_id;
db.Colas.Remove(primeroCola);
db.SaveChanges();
}
lista = (from d in db.Colas
join t in db.Ticket
on d.TicketId equals t.Id
where d.Cola == 1
select new ColaViewModel
{
id = d.Id,
cola = d.Cola.Value,
ticket_id = d.TicketId.Value,
nombre = t.Nombre
}
).ToList();
lista2 = (from d in db.Colas
join t in db.Ticket
on d.TicketId equals t.Id
where d.Cola == 2
select new ColaViewModel
{
id = d.Id,
cola = d.Cola.Value,
ticket_id = d.TicketId.Value,
nombre = t.Nombre
}
).ToList();
}
model.cola1 = lista;
model.cola2 = lista2;
return(PartialView("_ListaCola", model));
}
public async Task <ReplyViewModel> SendInfo([FromHeader] string auth, [FromBody] ColaViewModel llamado)
{
int IdUser = _service.CheckToken(auth);
if (IdUser > 0)
{
if (await _service.SendInfo(IdUser, llamado))
{
reply.result = 1; reply.message = "En Breve se Enviara la Cartilla";
}
else
{
reply.result = 0; reply.message = "No se Pudo Agendar,Intente mas Tarde";
}
}
else
{
reply.result = 0;
reply.message = "Acceso no Permitido";
}
return(reply);
}
public async Task <ReplyViewModel> CheckPeople([FromHeader] string auth, ColaViewModel llamado)
{
int IdUser = _service.CheckToken(auth);
if (IdUser > 0)
{
if (await _service.CheckPeople(IdUser, llamado))
{
reply.result = 1; reply.message = "En Breve Verificaremos la Información";
}
else
{
reply.result = 0; reply.message = "No Se Pudo Agendar,Intente mas Tarde";
}
}
else
{
reply.result = 0;
reply.message = "Acceso no Permitido";
}
return(reply);
}
//actualiza los datos de la llamada y la persona
public async Task <bool> UpdateCall(ColaViewModel pllamada)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var hoy = DateTime.Now.Date;
var llamada = db.llamados.Where(x => x.idllamado == pllamada.idLlamado).FirstOrDefault();
llamada.idstate = pllamada.idState;
llamada.intentos += 1;
llamada.hora = DateTime.Now.TimeOfDay;
db.Entry(llamada).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
var persona = db.personas.Where(x => x.idpersona == pllamada.idPersona).FirstOrDefault();
if (pllamada.idState == 3 || pllamada.idState == 5)
{
persona.lastcall = hoy;
}
else if (pllamada.idState == 4)
{
persona.lastcall = hoy;
persona.lastcom = hoy;
}
if (pllamada.noapto == true)
{
var apto = false;
persona.apto = apto;
}
else if (pllamada.noapto == false)
{
var apto = true;
persona.apto = apto;
}
if (pllamada.idState != 2)
{
if (persona.used == false)
{
persona.used = true;
}
persona.conformeos = pllamada.conformeos;
persona.aportes = pllamada.aportes;
}
if (pllamada.cambioOS != null)
{
persona.cambioos = DateTime.Parse(pllamada.cambioOS);
}
db.Entry(persona).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
await transaction.CommitAsync();
return(true);
}
catch (Exception ex)
{
transaction.Rollback();
return(false);
}
}
}
