public ActionResult ObtenerAjustePos(PagingInfo paginacion, FiltrosModel<PosTurnosModel> filtros, PosTurnosModel posTurnos)
{
filtros.Entidad = posTurnos;
var result = _serAju.ObtenerAjustePos(paginacion, filtros);
if (paginacion.total == 0)
{
try
{
var spPos = _serAju.SP_GenerarAjustePos(posTurnos.FECHA, Convert.ToInt32(User.Identity.Name.Split('-')[3]));
if (!spPos.success)
{
JavaScriptSerializer javaScriptSerializer2 = new JavaScriptSerializer();
string callback2 = paginacion.callback + "(" + javaScriptSerializer2.Serialize(new { success = false, msg = spPos.msg }) + ");";
//string callback1 = info.callback + "(" + json + ");";
return JavaScript(callback2);
}
else
{
result = _serAju.ObtenerAjustePos(paginacion, filtros);
}
}
catch (Exception)
{
throw;
}
}
if (filtros.Contiene == "AJUSTES_DIE")
{
result = result.Where(x => x.SG_POS.ID_COMBUSTIBLE == 2);
}
else { result = result.Where(x => x.SG_POS.ID_COMBUSTIBLE == 1); }
var formattData = result.Select(x => new
{
PRODUCTO = x.SG_POS.CODIGO + " - " + x.SG_POS.SG_COMBUSTIBLES.NOMBRE,
CODIGO = x.SG_POS.SG_COMBUSTIBLES.NOMBRE,
ID_POS = x.ID_POS,
ID_AJUSTE = x.ID_AJUSTE,
AJUSTE = x.AJUSTE
});
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
string callback1 = paginacion.callback + "(" + javaScriptSerializer.Serialize(new { Total = paginacion.total, Rows = formattData }) + ");";
//string callback1 = info.callback + "(" + json + ");";
return JavaScript(callback1);
}
public ActionResult ObtenerPosTurnos(PagingInfo paginacion, FiltrosModel<PosTurnosModel> filtros, PosTurnosModel posTurnos, bool EDITAR = false)
{
filtros.Entidad = posTurnos;
var result = _serPos.ObtenerPosTurnos(paginacion, filtros);
bool nuevo = false;
if (!EDITAR)
{
if (paginacion.total == 0)
{
try
{
var spPos = _serPos.SP_GenerarPosTurnos(posTurnos.FECHA, posTurnos.TURNO, Convert.ToInt32(User.Identity.Name.Split('-')[3]) , 0);
if (!spPos.success)
{
JavaScriptSerializer javaScriptSerializer2 = new JavaScriptSerializer();
string callback2 = paginacion.callback + "(" + javaScriptSerializer2.Serialize(new { success = false, msg = spPos.msg }) + ");";
//string callback1 = info.callback + "(" + json + ");";
return JavaScript(callback2);
}
else
{
result = _serPos.ObtenerPosTurnos(paginacion, filtros);
nuevo = true;
}
}
catch (Exception)
{
throw;
}
}
else {
try
{
var spPos = _serPos.SP_GenerarPosTurnos(posTurnos.FECHA, posTurnos.TURNO, Convert.ToInt32(User.Identity.Name.Split('-')[3]) , 1);
if (!spPos.success)
{
JavaScriptSerializer javaScriptSerializer2 = new JavaScriptSerializer();
string callback2 = paginacion.callback + "(" + javaScriptSerializer2.Serialize(new { success = false, msg = spPos.msg }) + ");";
//string callback1 = info.callback + "(" + json + ");";
return JavaScript(callback2);
}
else
{
result = _serPos.ObtenerPosTurnos(paginacion, filtros);
nuevo = true;
}
}
catch (Exception)
{
throw;
}
}
}
var formattData = result.Select(x => new
{
PRODUCTO = x.SG_POS.CODIGO + " - " + x.SG_POS.SG_COMBUSTIBLES.NOMBRE,
CODIGO = x.SG_POS.SG_COMBUSTIBLES.NOMBRE,
ID_POS = x.ID_POS,
ID_POS_TURNO = x.ID_POS_TURNO,
ENT_LITTER = x.ENT_LITTER,
SAL_LITTER = nuevo == true ? 0 : x.SAL_LITTER,
TOTAL = x.SAL_LITTER - x.ENT_LITTER
});
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
string callback1 = paginacion.callback + "(" + javaScriptSerializer.Serialize(new { Total = paginacion.total, Rows = formattData }) + ");";
//string callback1 = info.callback + "(" + json + ");";
return JavaScript(callback1);
}
