public void AnularRutaAsign(string ID, string token)
{
_token = new TokenClass();
string To = _token.TokenId;
if (To == token)
{
#region InsertString
string Insert = "UPDATE LO_Asignruta SET Status=1 WHERE Id=@ID ";
#endregion
try
{
ConnPlabal.Open();
cmdPlabal = new SqlCommand(Insert, ConnPlabal);
#region Parameters
cmdPlabal.Parameters.AddWithValue("@ID", ID);
#endregion
cmdPlabal.ExecuteNonQuery();
ConnPlabal.Close();
}
catch (Exception EX)
{
throw EX;
ErrorCatching errorCatching = new ErrorCatching();
errorCatching.ErrorCatch(EX.Message + " TRAZO:" + EX.StackTrace + " STRING:" + Insert, HttpContext.Current.Request.Url.ToString());
ConnGlasser.Close();
}
}
else
{
}
}
public void NullorCloseInventario(string ID, string token, string Action)
{
_token = new TokenClass();
string To = _token.TokenId;
if (To == token)
{
#region InsertString
string Insert = "";
if (Action == "Cerrar")
{
Insert = "UPDATE LO_inventory SET Status=1 WHERE Id=@ID ";
}
else if (Action == "Anular")
{
Insert = "UPDATE LO_inventory SET Status=3 WHERE Id=@ID ";
}
else if (Action == "Activar")
{
Insert = "UPDATE LO_inventory SET Status=0 WHERE Id=@ID ";
}
#endregion
try
{
ConnPlabal.Open();
cmdPlabal = new SqlCommand(Insert, ConnPlabal);
#region Parameters
cmdPlabal.Parameters.AddWithValue("@ID", ID);
#endregion
cmdPlabal.ExecuteNonQuery();
ConnPlabal.Close();
}
catch (Exception EX)
{
ErrorCatching errorCatching = new ErrorCatching();
errorCatching.ErrorCatch(EX.Message + " TRAZO:" + EX.StackTrace + " STRING:" + Insert, HttpContext.Current.Request.Url.ToString());
ConnGlasser.Close();
}
}
}
public bool AnularAsignUser(string ID, string token)
{
_token = new TokenClass();
string To = _token.TokenId;
bool valid = false;
if (To == token)
{
#region InsertString
string Insert = "UPDATE LO_invasignoperario SET Estado=1 WHERE Id=@ID ";
#endregion
try
{
ConnPlabal.Open();
cmdPlabal = new SqlCommand(Insert, ConnPlabal);
#region Parameters
cmdPlabal.Parameters.AddWithValue("@ID", ID);
#endregion
cmdPlabal.ExecuteNonQuery();
ConnPlabal.Close();
valid = true;
}
catch (Exception EX)
{
ErrorCatching errorCatching = new ErrorCatching();
errorCatching.ErrorCatch(EX.Message + " TRAZO:" + EX.StackTrace + " STRING:" + Insert, HttpContext.Current.Request.Url.ToString());
ConnGlasser.Close();
valid = false;
}
}
else
{
valid = false;
}
return(valid);
}
public List <DetalleInv> GetDetailInventory(string IdInventario, string Token)
{
List <DetalleInv> tmp = new List <DetalleInv>();
TokenClass _token = new TokenClass();
if (Token == _token.TokenId)
{
string consulta = "Select A.KOPR,A.Cant,A.Unidad,A.Timestamp,B.Nombre AS 'Operario',D.Nombre AS 'Bodega', D.CodBodega, D.CodSUCU, A.Id " +
"FROM PLABAL.dbo.LO_Tomainventory A, PLABAL.dbo.e_Usuario B, PLABAL.dbo.LO_Asignruta C, PLABAL.dbo.LO_rutasinvent D WITH ( NOLOCK ) " +
" WHERE A.Cod_oper=B.ID AND A.Id_Asign=C.Id AND C.ID_Inventory=@ID AND C.ID_Ruta=D.Id AND A.Estado=0";
DataTable TablaDetalle = new DataTable();
using (ConnPlabal)
{
try
{
SqlDataAdapter adaptador = new SqlDataAdapter(consulta, ConnPlabal);
adaptador.SelectCommand.Parameters.AddWithValue("@ID", IdInventario);
adaptador.Fill(TablaDetalle);
}
catch (Exception ex)
{
}
}
if (TablaDetalle.Rows.Count > 0)
{
foreach (DataRow drRAN in TablaDetalle.Rows)
{
string KOPR = drRAN["KOPR"].ToString().Trim();
string KOBO = drRAN["CodBodega"].ToString().Trim();
string KOSU = drRAN["CodSUCU"].ToString().Trim();
DetalleInv lista = new DetalleInv
{
_KOPR = KOPR,
_Cant = Convert.ToDouble(drRAN["Cant"].ToString()),
_Unidad = drRAN["Unidad"].ToString(),
_Fecha = Convert.ToDateTime(drRAN["Timestamp"].ToString()).ToShortDateString(),
_Bodega = drRAN["Bodega"].ToString().Trim(),
_CodBodega = KOBO,
_Operario = drRAN["Operario"].ToString().Trim(),
_Id = drRAN["Id"].ToString(),
};
string Select = "SELECT TOP 1 PR.NOKOPR FROM MAEPR PR WITH ( NOLOCK ) WHERE PR.KOPR=@KOPR ";
ConnGlasser.Open();
cmdGlasser = new SqlCommand(Select, ConnGlasser);
cmdGlasser.Parameters.AddWithValue("@KOPR", KOPR);
drGlasser = cmdGlasser.ExecuteReader();
drGlasser.Read();
if (drGlasser.HasRows)
{
lista._RNDDescripcion = drGlasser["NOKOPR"].ToString().Trim();
}
else
{
}
drGlasser.Close();
ConnGlasser.Close();
tmp.Add(lista);
}
}
}
else
{
}
return(tmp);
}
