public ActionResult ConsultaTiquete()
{
using (var sofiaContext = new SofiaContext())
{
ViewBag.TipoDocumento = sofiaContext.Tipo.Where(x => x.IdClaseTipo == 15).ToList().Select(x => new SelectListItem() { Text = x.Nombre, Value = x.IdTipo.ToString() });
}
return View();
}
public JsonResult ActualizarTiquete(string Tiquete)
{
try
{
using (var sofiaContext = new SofiaContext())
{
var IdUsuario = sofiaContext.Usuario.First(x => x.Nombre == HttpContext.User.Identity.Name).IdUsuario;
var IdPuntoVenta = sofiaContext.UsuarioXPuntoVenta.First(x => x.IdUsuario == IdUsuario).IdPuntoVenta;
sofiaContext.spActualizarDocumentoValorMigracion(Tiquete, IdUsuario, IdPuntoVenta);
}
return Json(new { Status = "OK" }, JsonRequestBehavior.AllowGet);
}
catch
{
return Json(new { Status = "ERROR" }, JsonRequestBehavior.AllowGet);
}
}
public ActionResult GetReservasMigradas(string Record, string Documento, string Tiquete)
{
try
{
JsonNetResult jsonNetResult = new JsonNetResult();
jsonNetResult.Formatting = Newtonsoft.Json.Formatting.Indented;
using (var sofiaContext = new SofiaContext())
{
jsonNetResult.Data = new
{
Status = "OK",
Migraciones = sofiaContext.MigracionReservasKiu.Where(x => x.RecordSofia == Record
|| x.Identificacion == Documento
|| x.Tiquete == Tiquete).ToList()
};
}
return jsonNetResult;
}
catch
{
return Json(new { Status = "ERROR" }, JsonRequestBehavior.AllowGet);
}
}
public ActionResult GetTiquetesMigrados(string IdDocumentoValor, string IdTipoDocumento, string Identificacion)
{
try
{
JsonNetResult jsonNetResult = new JsonNetResult();
jsonNetResult.Formatting = Newtonsoft.Json.Formatting.Indented;
using (var sofiaContext = new SofiaContext())
{
jsonNetResult.Data = new
{
Status = "OK",
Migraciones = sofiaContext.spMigracionTiquete(IdDocumentoValor == string.Empty ? null : IdDocumentoValor,
IdTipoDocumento == string.Empty ? null : IdTipoDocumento,
Identificacion == string.Empty ? null : Identificacion).ToList()
};
}
return jsonNetResult;
}
catch
{
return Json(new { Status = "ERROR" }, JsonRequestBehavior.AllowGet);
}
}
public ActionResult ViewHistorialDocumentoValor(string IdDocumentoValor)
{
using (var sofiaContext = new SofiaContext())
{
return PartialView("_HistorialDocumentoValor",
sofiaContext.spSeleccionarHistorialDocumentoValor(IdDocumentoValor).ToList());
}
}