public int InsertTicket(TaksAdmon ticket, out int newID)
{
int val = 0;
newID = 0;
try
{
using (ClusmextContext context = new ClusmextContext())
{
if (ticket.IdTaks > 0)
{
context.Entry(ticket).State = EntityState.Modified;
}
else
{
context.Entry(ticket).State = EntityState.Added;
}
val = context.SaveChanges();
if (val != 0)
{
newID = ticket.IdTaks;
}
}
}
catch (Exception ex)
{
}
return(val);
}
public TaksAdmon GetDetails(int id)
{
TaksAdmon list = new TaksAdmon();
try
{
using (ClusmextContext context = new ClusmextContext())
{
list = context.TaksAdmon.Include("Empresas").Include("Usuarios").Include("CA_Areas").Include("TaksEstatus").Include("TaksTipo").Include("TaksPertenencia").Include("TaksComentarios").Where(x => x.IdTaks == id).SingleOrDefault();
}
}
catch (Exception ex)
{
}
return(list);
}
public int ChangeStatus(TaksAdmon ticket)
{
int val = 0;
try
{
using (ClusmextContext context = new ClusmextContext())
{
context.Entry(ticket).State = EntityState.Modified;
val = context.SaveChanges();
}
}
catch (Exception ex)
{
}
return(val);
}
public TaksAdmon GetRawTicket(int id)
{
TaksAdmon ticket = new TaksAdmon();
try
{
if (id == 0)
{
ticket.Id_Empresa = -1;
ticket.IdTaksTipo = -1;
ticket.Id_CA_Area = -1;
return(ticket);
}
using (ClusmextContext context = new ClusmextContext())
{
ticket = context.TaksAdmon.Where(x => x.IdTaks == id).SingleOrDefault();
}
}
catch (Exception ex)
{
}
return(ticket);
}