public int InsertRequest(TrvReq req)
{
int val = 0;
try
{
using (ClusmextContext context = new ClusmextContext())
{
if (req.IdTrvReq > 0)
{
context.Entry(req).State = EntityState.Modified;
}
else
{
context.Entry(req).State = EntityState.Added;
}
val = context.SaveChanges();
}
}
catch (Exception ex)
{
}
return(val);
}
public TrvReq GetRequest(int id = 0)
{
TrvReq req = new TrvReq();
try
{
if (id == 0)
{
req.IdTrvReq = 0;
req.Id_Empresa = -1;
req.IdTransporte = -1;
req.IdTrvTurno = -1;
return(req);
}
else
{
using (ClusmextContext context = new ClusmextContext())
{
req = context.TrvReq.Include("TrvTransporte").Include("TrvTurno").Include("Empresas").Where(x => x.IdTrvReq == id).SingleOrDefault();
req.FPartida = req.FPartida.Date;
req.FRetorno = req.FRetorno.Date;
}
}
}
catch (Exception ex)
{
}
return(req);
}
public int ChangeStatus(TrvReq 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 TrvReq GetRawRequest(int id)
{
TrvReq req = new TrvReq();
try
{
using (ClusmextContext context = new ClusmextContext())
{
req = context.TrvReq.Where(x => x.IdTrvReq == id).SingleOrDefault();
req.FPartida = req.FPartida.Date;
req.FRetorno = req.FRetorno.Date;
}
}
catch (Exception ex)
{
}
return(req);
}