public void Modificar(Entidades.Ticket Ticket)
{
try
{
Entidades.Ticket t = Leer(Ticket.Cuit, Ticket.Service);
if (t.Cuit == null)
{
Crear(Ticket);
}
else
{
StringBuilder a = new StringBuilder(string.Empty);
a.Append("update Ticket set ");
a.Append("Service='" + Ticket.Service + "', ");
a.Append("UniqueId='" + Ticket.UniqueId + "', ");
a.Append("GenerationTime='" + Ticket.GenerationTime.ToString("yyyyMMdd HH:mm:ss") + "', ");
a.Append("ExpirationTime='" + Ticket.ExpirationTime.ToString("yyyyMMdd HH:mm:ss") + "', ");
a.Append("Sign='" + Ticket.Sign + "', ");
a.Append("Token='" + Ticket.Token + "' ");
a.AppendLine("where Cuit='" + Ticket.Cuit + "' and Service = '" + Ticket.Service + "' ");
Ejecutar(a.ToString(), TipoRetorno.None, Transaccion.Usa, sesion.CnnStr);
}
}
catch (Exception ex)
{
Funciones.GrabarLogTexto("Consultar.txt", ex.Message + " " + ex.StackTrace);
throw new Exception(ex.Message);
}
}
private void Copiar(DataRow Desde, Entidades.Ticket Hasta)
{
Hasta.Cuit = Convert.ToString(Desde["Cuit"]);
Hasta.Service = Convert.ToString(Desde["Service"]);
Hasta.UniqueId = Convert.ToString(Desde["UniqueId"]);
Hasta.GenerationTime = Convert.ToDateTime(Desde["GenerationTime"]);
Hasta.ExpirationTime = Convert.ToDateTime(Desde["ExpirationTime"]);
Hasta.Sign = Convert.ToString(Desde["Sign"]);
Hasta.Token = Convert.ToString(Desde["Token"]);
}
private void Crear(Entidades.Ticket Ticket)
{
StringBuilder a = new StringBuilder(string.Empty);
a.Append("Insert Ticket (Cuit, Service, UniqueId, GenerationTime, ExpirationTime, Sign, Token) values (");
a.Append("'" + Ticket.Cuit + "', ");
a.Append("'" + Ticket.Service + "', ");
a.Append("'" + Ticket.UniqueId + "', ");
a.Append("'" + Ticket.GenerationTime.ToString("yyyyMMdd HH:mm:ss") + "', ");
a.Append("'" + Ticket.ExpirationTime.ToString("yyyyMMdd HH:mm:ss") + "', ");
a.Append("'" + Ticket.Sign + "', ");
a.Append("'" + Ticket.Token + "')");
Funciones.GrabarLogTexto("Consultar.txt", "SCRIPT crear Ticket: " + a.ToString());
Ejecutar(a.ToString(), TipoRetorno.None, Transaccion.Usa, sesion.CnnStr);
}
public Entidades.Ticket Leer(string Cuit, string Service)
{
Entidades.Ticket ticket = new Entidades.Ticket();
if (sesion.Cuit.Nro != null)
{
System.Text.StringBuilder a = new StringBuilder();
a.Append("select ");
a.Append("Cuit, Service, UniqueId, GenerationTime, ExpirationTime, Sign, Token ");
a.Append("from Ticket ");
a.Append("where Ticket.Cuit='" + Cuit + "' and Service = '" + Service + "' ");
DataTable dt = (DataTable)Ejecutar(a.ToString(), TipoRetorno.TB, Transaccion.NoAcepta, sesion.CnnStr);
if (dt.Rows.Count != 0)
{
Copiar(dt.Rows[0], ticket);
}
}
return ticket;
}
public Entidades.Ticket Leer(string Cuit, string Service)
{
Entidades.Ticket ticket = new Entidades.Ticket();
if (sesion.Cuit.Nro != null)
{
System.Text.StringBuilder a = new StringBuilder();
a.Append("select ");
a.Append("Cuit, Service, UniqueId, GenerationTime, ExpirationTime, Sign, Token ");
a.Append("from Ticket ");
a.Append("where Ticket.Cuit='" + Cuit + "' and Service = '" + Service + "' ");
DataTable dt = (DataTable)Ejecutar(a.ToString(), TipoRetorno.TB, Transaccion.NoAcepta, sesion.CnnStr);
if (dt.Rows.Count != 0)
{
Copiar(dt.Rows[0], ticket);
}
}
return(ticket);
}
