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); }