public void Logout(UserSessionInfo session) { using (LoginService service = new LoginService()) { service.Logout(session.SessionToken.Id); } }
public UserSessionInfo RenewSession(UserSessionInfo session) { using (LoginService service = new LoginService()) { var newToken = service.Renew(session.SessionToken.Id); return new UserSessionInfo(session.Principal, newToken); } }
/// <summary> /// Adds a product to a user's inventory /// </summary> /// <param name="pD">Details about a product</param> /// <param name="uSi">User session information</param> /// <returns>True if the transaction is successful</returns> public bool AddProductToInventory(ProductDetails pD, UserSessionInfo uSi) { try { DBConnection.Open(); SQLcmdSP = new SqlCommand("sp_AddProductToInventory", DBConnection); SQLcmdSP.CommandType = CommandType.StoredProcedure; SQLcmdSP.Parameters.Add(new SqlParameter("@inventoryID", SqlDbType.Int, 0)); SQLcmdSP.Parameters.Add(new SqlParameter("@productID", SqlDbType.Int, 0)); SQLcmdSP.Parameters.Add(new SqlParameter("@prodQuantity", SqlDbType.Int, 0)); SQLcmdSP.Parameters.Add(new SqlParameter("@prodPrice", SqlDbType.Int, 0)); SQLcmdSP.Parameters.Add(new SqlParameter("@providerID", SqlDbType.Int, 0)); SQLcmdSP.Parameters[0].Value = uSi.InventoryID; SQLcmdSP.Parameters[1].Value = pD.ProductX.GTIN; SQLcmdSP.Parameters[2].Value = pD.Quantity; SQLcmdSP.Parameters[3].Value = pD.ProductPrice; SQLcmdSP.Parameters[4].Value = pD.ProviderID; int i = SQLcmdSP.ExecuteNonQuery(); evtWriter.writeInfo("Product " + pD.ProductX.GTIN + " successfully updated in DB"); return true; } catch (Exception exc) { evtWriter.writeError("Error adding product " + pD.ProductX.GTIN + " to DB" + Environment.NewLine + exc.Message); return false; } finally { SQLcmdSP.Dispose(); DBConnection.Close(); } }